A Manufacturer made one product Tiles. Sales for the period consists of the following information: Month $ November 100,000 December 350,000 January 300,000 February 250,000 March 300,000 Balance brought down was $40,000 Purchases of Raw Material: January $ 60,000; February 55,000; and March 60,000. Purchase equipment $10,000 to be paid for in February; Salary for each month $10,000; Electricity $4000 per month; Rent $12,000 each, Depreciation $5000. Income tax for the year paid in March $3000. All Sales are done on credit and collection are collected every quarter. Collection schedule as follows; 60 percent in the month of sale 30 percent in the month following sale and 20 percent two months following sale. You are required to prepare B. the Cash Budget for the first Quarter 2021
A Manufacturer made one product Tiles. Sales for the period consists of the following information: Month $ November 100,000 December 350,000 January 300,000 February 250,000 March 300,000 Balance brought down was $40,000 Purchases of Raw Material: January $ 60,000; February 55,000; and March 60,000. Purchase equipment $10,000 to be paid for in February; Salary for each month $10,000; Electricity $4000 per month; Rent $12,000 each, Depreciation $5000. Income tax for the year paid in March $3000. All Sales are done on credit and collection are collected every quarter. Collection schedule as follows; 60 percent in the month of sale 30 percent in the month following sale and 20 percent two months following sale. You are required to prepare B. the Cash Budget for the first Quarter 2021
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter2: Basic Cost Management Concepts
Section: Chapter Questions
Problem 22E: Ellerson Company provided the following information for the last calendar year: During the year,...
Related questions
Question
![A Manufacturer made one product Tiles. Sales for
the period consists of the following information:
Month $
November 100,000
December 350,000
January 300,000
February 250,000
March 300,000
Balance brought down was $40,000
Purchases of Raw Material: January $ 60,000;
February 55,000; and March 60,000.
Purchase equipment $10,000 to be paid for in
February; Salary for each month $10,000;
Electricity $4000 per month; Rent $12,000 each,
Depreciation $5000. Income tax for the year paid
in March $3000.
All Sales are done on credit and collection are
collected every quarter.
Collection schedule as follows; 60 percent in the
month of sale
30 percent in the month following sale and 20
percent two months following sale.
You are required to prepare
B. the Cash Budget for the first Quarter 2021](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5f07a2d3-1a4c-44eb-ab08-cc9c573acde5%2Fb63eaa5a-2c43-46b2-84fa-19c95e070e8e%2Fpsbq12d_processed.jpeg&w=3840&q=75)
Transcribed Image Text:A Manufacturer made one product Tiles. Sales for
the period consists of the following information:
Month $
November 100,000
December 350,000
January 300,000
February 250,000
March 300,000
Balance brought down was $40,000
Purchases of Raw Material: January $ 60,000;
February 55,000; and March 60,000.
Purchase equipment $10,000 to be paid for in
February; Salary for each month $10,000;
Electricity $4000 per month; Rent $12,000 each,
Depreciation $5000. Income tax for the year paid
in March $3000.
All Sales are done on credit and collection are
collected every quarter.
Collection schedule as follows; 60 percent in the
month of sale
30 percent in the month following sale and 20
percent two months following sale.
You are required to prepare
B. the Cash Budget for the first Quarter 2021
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College