Below the cells, list Total Manufacturing Cost for Last month, Cost Per Helmet Last Month, Anticipated Costs of Raw Materials for the Current Month, Anticipated Costs of Utilities for the Current Month, Projected Total Manufacturing Cost for the Current Month, and Projected Cost Per Helmet for the Current Month.

(The firm's factory currently manufactures 10,000 of the same item per month)

(There is a projected 8 percent increase of raw materials used in the products)

(A 3 percent decrease in utilities with all other costs expected to be the same).

The firm's managers request a spreadsheet for the costs of last month.

(The already completed spreadsheet is from another part of the question that I had to make and it is the firm's expenses for last month in dollar amounts).

Direct Materials Amount 75000 Raw Materials Used in Helmets 75000 7 Direct Labor Amount 53000 Wages for Assembly Line Workers 53000 Manufacturing Overhead 0 20100 9000 1500 900 3 Miscellaneous Materials (glue, thread, etc..1100 5700 400 1500 Rent on Factory Equipment Insurance on Factory Building Utility Costs for Factory Factory Manager's Salary Property Taxes on Factory Building Depreciation on Factory Building 4 7 Period Costs 25,100 Supplies for General Office Depreciation on Office Equipment Advertising for Helmets Sales Commisions 300 800 14000 10,000 0