pls help on this with excel format

PORTFOLIO QUESTIONS Question Three Truecor Electronics produces two types of coils used in generators. In November 2020, Jessie Higgins, the financial controller, compiled the following data: Sales forecast for 2021 (all units to be shipped in 2021): Product Light coil Heavy coil. Units 60,000 40,000 Price $120 170 Raw material prices and inventory levels Expected inventories, Raw material January 1, 2021 Sheet metal 32,000 kg Copper wire 29.000 kg Platforms 6,000 units Desired inventories, December 31, 2021 36,000 kg 32.000 kg 7,000 units Anticipated purchase price $8 5 3 Use of raw materials: Amount used per unit Light coil Heavy coil Raw material Sheet metal Copper wire Platforms 5 kg 2 kg NA 3 kg 1 unit Direct labour requirements and rates: Rate Hours per unit 2 3 Product Light coil Heavy coil per hour $15 20 Finished goods inventory (in units): Product Light coil Heavy coil Expected, January 1, 2021 20,000 8,000 Desired, December 31, 2021 25,000 9,000 Production overhead: Overhead cost item Purchasing and material handling Depreciation, utilities and inspection Shipping General production overhead Activity-based budget rate $0.25 per kg of sheet metal and copper wire purchased $4.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct labour hour REQUIRED: Using EXCEL prepare the following budgets for 2021: a) Sales budget (in dollars) b) Production budget in units) c) Raw-material purchases budget (in quantities and dollars) d) Direct labour budget (in dollars) e) Production overhead budget in dollars). PORTFOLIO QUESTIONS Question Three Truecor Electronics produces two types of coils used in generators. In November 2020, Jessie Higgins, the financial controller, compiled the following data: Sales forecast for 2021 (all units to be shipped in 2021): Product Light coil Heavy coil. Units 60,000 40,000 Price $120 170 Raw material prices and inventory levels Expected inventories, Raw material January 1, 2021 Sheet metal 32,000 kg Copper wire 29.000 kg Platforms 6,000 units Desired inventories, December 31, 2021 36,000 kg 32.000 kg 7,000 units Anticipated purchase price $8 5 3 Use of raw materials: Amount used per unit Light coil Heavy coil Raw material Sheet metal Copper wire Platforms 5 kg 2 kg NA 3 kg 1 unit Direct labour requirements and rates: Rate Hours per unit 2 3 Product Light coil Heavy coil per hour $15 20 Finished goods inventory (in units): Product Light coil Heavy coil Expected, January 1, 2021 20,000 8,000 Desired, December 31, 2021 25,000 9,000 Production overhead: Overhead cost item Purchasing and material handling Depreciation, utilities and inspection Shipping General production overhead Activity-based budget rate $0.25 per kg of sheet metal and copper wire purchased $4.00 per coil produced (either type) $1.00 per coil shipped (either type) $3.00 per direct labour hour REQUIRED: Using EXCEL prepare the following budgets for 2021: a) Sales budget (in dollars) b) Production budget in units) c) Raw-material purchases budget (in quantities and dollars) d) Direct labour budget (in dollars) e) Production overhead budget in dollars)