Question
Communion Corp. plans to sell its juice glasses at $60 per unit. This product sells best during March. As a result, its peak sales occur
- Communion Corp. plans to sell its juice glasses at $60 per unit. This product sells best during March. As a result, its peak sales occur in the first quarter of each year. Expected sales for the first four months of 2020 are:
Budgeted Sales units:
January | 2,000 units |
February | 4,500 units |
March | 6,000 units |
April | 5,000 units |
Total | 17,500 units |
In addition, expected sales in May are 5,000 units.
Communion Corp. expects that it will meet all future sale requirements by maintaining an ending inventory equal to 20% of the month's budgeted sales volume. The labour budget assumes that two hours of direct labour are necessary to produce each unit of finished goods and the hourly wage rate is $10.
Past experience shows that the company collects 60% of a month's sales in the month of sale and 40% is collected in the following month. Accounts receivable of $60,000 at the end of December 2019 and are expected to be collected in full in January 2020. Bad debts are negligible and can be ignored.
In completing parts (a) through (d), prepare proper budget schedules. For part ( e ), make sure to show your work.
- From the data above, calculate budgeted sales in dollars.(3 marks)
- Prepare a production budget (units) for the period (four months).(4 marks)
- Prepare the direct labour budget expected to help Communion Corp. meet its production levels.(4 marks)
- Prepare the Schedule of cash collections from sales, by month and in total. (4 marks)
- From data above, if the company prepares a budgeted balance sheet as of April 30, computethe accounts receivable balance as of that date. (5 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started