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 the manufacturing overhead. The manufacturing overhead rate applied for 2022 is based on budgeted direct labour hours for the year.

The firm expects the cost per unit for both beginning and ending inventories of finished products to be identical.

	Factory 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
Total	$ 580, 830

Required:

Prepare 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