Play and Stay Manufacturing(P&S) has a factory that produces cabinetry for the RV and marine market. The company has other product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we will assume the following average costs The following information highlights P&S Manufacturing's cost structure for 2020.

The materials include $2,800 for the wood and other materials on a per job basis.

It requires 24 hours of labor on average for the cabinetry. The hourly rate is $11.

The sales price will be set at a markup of 80%.

The company estimates that it will have 43,200 direct labor hours in total for the cabinets.

It assumes 1800 units are sold on average per year.

A breakdown of estimated yearly costs related to the cabinetry follows:

Salaries- office & administrative $ 500,000

Salaries for factory personal $ 350,000

Office Rent $ 150,000

Factory Rent $ 30,000

Office utilities and Misc office expenses(based on units sold) $ 15,000

Sales travel(based on units sold) $ 24,000

Insurance - office $ 12,000

Depreciation - office equipment $ 40,000

Depreciation for factory equipment $ 70,000

Advertising $ 20,000

Sales commissions(based on units sold) $ 50,000

Factory Property taxes $ 25,000

Maintenance for factory equipment $ 80,00

General requiremens:

A schedule will be created for each of the following questions. Use a new worksheet (not workbook) to answer each question. You can combine Q6 and Q7 in one sheet for comparison purposes. All schedules should be included in excel. Your spreadsheets must contain formulas and referring numbers. Not using formulas will result in a minimum one letter-grade reduction. Linking the schedules is required. Your spreadsheet must be professional and include the following items: report titles, formatted numbers, single and double underlines, and correct spelling. Every number should be labeled clearly so the reader understands what numbers represent. If you are unsure about the format, please review the textbook for a similar report or ask!!!

Question 2.

2. Determine the average cost of manufacturing one unit given the volume expected to be sold every year and assuming the MOH costs are allocated based on the direct labor hours per unit. Please show all calculations and round to the nearest dollar. Calculate the sales price based on your cost calculation. I would recommend that you calculate the MOH per unit first. You should calculate an Overhead rate.