create a manufacturing overhead budget for the year ending December $312023$ and provide all the details in a spreadsheet on Excel. use the information below as needed:

The first two steps of the manufacturing process are highly automated, so the only employees are three supervisors, who are trained to operate the equipment and make repairs as required. The supervisors work shifts, allowing the plant to operate for longer hours during the busier months. They are also responsible for managing the employees who work in the finishing department. There is no labour component to the manufacturing process

The combined unit variable overhead manufacturing rate for forming and assembly is $$6\mathrm{.}50,$ consisting of: Utilities$--$$$3\mathrm{.}00$; Indirect Materials$--$$$1\mathrm{.}00$; Plant maintenance$--$$$1\mathrm{.}50$; environmental fee$--$$$0\mathrm{.}70$; and Other$--$$$0\mathrm{.}30.$

Fixed Manufacturing Overhead costs for the entire year are as follows: Training and development $ $43,620$

Supervisor$$s salary $269,400$

Depreciation on equipment $178,800$

Insurance $69,000$

Other $117,600$

$ $678,420$ Total

$$ The annual insurance premium is paid at the beginning of September each year. There should be no change in the premium from last year.

$$ All other $$cash$-$related$$ fixed manufacturing overhead costs are incurred evenly over the year and paid as incurred.

$$ Cordon uses the straight$-$line method of depreciation.

the units to be produced are below