Question5.

Create a traditional Income Statement assuming a volume of 1,800 units. For the cost of goods sold, please use the per unit cost you calculated in #2. You do not have to prepare any additional schedules. I would use a similar format to exhibit 16-8 on page 737 or from your lecture notes. I recommend that you list out all operating expenses (period costs) identified in Q1. Do not use just Selling and General/Administrative Expenses for your categories. Points will be lost by not listing out all period costs. You can ignore interest and income tax expense. These numbers should be linked toQ1

(Question 1. . Please identify and calculate totals for the following classifications on ALL costs listed on the first page: variable and fixed costs; product and period costs. The schedule should contain numbers for each area on a yearly basis. For the variable cost, also show them on a per unit basis. (must be calculated based on 1800 units above)

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,000

General requirements: 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!!!