P9.37 (appendix) Sales, production and purchases budgets; activity-based overhead: manufacturer George Ltd manufactures and sells two different types of coils used in electric motors. In September, Jessica LO9.11 Martin, the management accountant, compiled the following data for the upcoming annual budget. Use of direct material: Amount used per unit Direct material Light coil Heavy coil Sheet metal 4 kilograms 5 kilograms Copper wire 2 kilograms 3 kilograms Platform 1 unit Raw material prices and inventory levels: Anticipated purchase Expected inventories Desired inventories 31 Raw material price 1 January December Sheet metal $8 32 000 kilograms 36 000 kilograms Copper wire $5 29 000 kilograms 32 000 kilograms Platform $3 6 000 units 7 000 unitsDirect labour requirements and rates Product Hours per unit Rate per hour Light coil 2 $30 Heavy coil 3 $40 Manufacturing overhead: Activity Cost per unit of activity driver Material handling: Sheet metal and copper wire $0.50 per kg of raw material purchased Platforms $0.10 per unit purchased Machine related $1.50 per machine hour' Shipping $2.00 per coil shipped General manufacturing overhead $1.20 per direct labour hour ' Total annual machine hours are100 000 for light cells and 200 000 for heavy coils Finished goods inventories (in unlts}: Product Expected 1 January Deslred 31 December Light coil 20 000 25 000 Heavy coil 8 000 9 000 Soles forecast: Product Units Light coil 60 000 Heavy coil 40 000 Required: Prepare the following budgets: sales budget [in dollars) production budget (In units] direct material purchases budget (in quantities) direct material purchases budget (in dollars) direct labour budget (in dollars) manufacturing overhead budget (in dollars). 9351195094:- $130 $190