A manufacturing company ABC Ltd. makes 2 components identified as C12 and D57. Budgetary data for 2022 are as follows:

	Finished Components
	C12	D57
Requirement for each finished component:
RM 1	10 pounds	8 pounds
RM 2	0	4 pounds
RM 3	2 pounds	1 pounds
Direct Labour	2 hours	3 hours
Product Information
Sales Price	$150	$220
Sales (Units)	12,000	9,000
Estimated Beginning Inventory (Units)	400	150
Desired Ending Inventory (Units)	300	200

		Direct Materials Information
	RM 1	RM 2	RM 3
Cost per pound	$ 2.00	$ 2.50	$ 0.50
Estimated Beginning Inventory (pounds)	3,000	1,500	1,000
Desired Ending Inventory (pounds)	4,000	1,000	1,500

The firm expects the average wage rate to be $25 per hour in 2022.

The company uses direct labour hours to apply one of the factory wide manufacturing overhead which is applied at the rate of 30% of the Direct Labour Cost.

The firm expects additional cost as follows.

	Overhead Information
Indirect material - variable	$ 10,000
Miscellaneous supplies and tools - variable	5,000
Indirect labour - variable	40,000
Supervision - fixed	120,000
Payroll taxes and fringe benefits - variable	250,000
Maintenance costs - fixed	20,000
Maintenance costs - variable	10,080
Depreciation - fixed	71,330
Heat, light, and power - fixed	43,240
Heat, light, and power - variable	11,000
	5,80,650

Required:

An Excel spreadsheet that contains the following schedules or statements for 2022

1. Sales Budget (do not do a cash receipts schedule)
2. Production Budget
3. Direct Materials Purchases Budget (units and dollars) (do not do a cash disbursement schedule)
4. Direct Labour Budget
5. Manufacturing Overhead Budget