Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Package is to include the following budgets; 1. Sales budget for each quarter and for the year 2. Production budget for each quarter and for
Package is to include the following budgets; | |||||||||||
1. Sales budget for each quarter and for the year | |||||||||||
2. Production budget for each quarter and for the year | |||||||||||
3. Purchasing Budget for each quarter and for the year | |||||||||||
4. Direct labour budget for each quarter and for the year | |||||||||||
5. Manufacturing overhead budget for each quarter and for the year | |||||||||||
6. Selling and Administration budget | |||||||||||
7. Work sheets for Collections and Disbursements | |||||||||||
8. Budgeted Income Statement | |||||||||||
9. CVP Income Statement | |||||||||||
10. Budgeted Cash Statement | |||||||||||
11. Budgeted Balance Sheet | |||||||||||
Additional details: | |||||||||||
Fine Office Company produces two products P100 and P200 | |||||||||||
Sales price per P100 is | $750 | ||||||||||
Sales price per P200 is | $820 | ||||||||||
There are | 800 | units from P100 in finished goods inventory at the end of 2020 with a value of $ | units from P200 at the end | ||||||||
of 2020 value | 3,00,000 | . At the end of each quarter, Fine Office Company requires ending inventory to be equal to | |||||||||
The required ending inventory for Dec. 31, 2021 are | 600 | units for P100 and | |||||||||
Each P100 unit uses | 75 | sq. ft. of steel during the manufacturing process. The cost of steel for 2021 is estimated to be $ | |||||||||
Each P200 unit uses | 95 | sq. ft. of steel during the manufacturing process. | |||||||||
Fine Office Company currently has | 30,000 | sq. ft. | of steel in the beginning inventory. At | ||||||||
the end of each quarter, Fine Office Company wants to have | 60,000 | ||||||||||
inventory. | |||||||||||
Each product requires | 6 | machine hours and | 3 | direct labour hrs to produce. | |||||||
Direct Labour costs $ | 21 | per direct labour hour. | |||||||||
Fine Office Company allocates manufacturing overhead costs based on the estimated machine | |||||||||||
hours. Estimated manufacturing overhead cost for 2021 are $ | 9,45,000 | ||||||||||
For each quarter, it is estimated that | 40 | % of sales will be cash and | |||||||||
% will be credit sales. Of the credit sales, 80% pay in the quarter of the sale and 20% pay in the | |||||||||||
following quarter. Credit sales from Q4 2020 were | $13,00,000 | ||||||||||
Direct labour costs and manufacturing overhead costs are paid for in cash in the quarter they | |||||||||||
occurred. | |||||||||||
Assume operating expenses occur evenly throughout the year and are all paid in cash. | |||||||||||
For each quarter, | 70 | % of material purchases are paid for in cash in the quarter of | |||||||||
the purchase and | 30 | % are paid in the following quarter. Purchases of materials from | |||||||||
Q4 2020 were | $15,00,000 | ||||||||||
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