Could you help me to receive the answer the following 1 question? Excel format is preferable.

The following is the financial condition for this company;

1.Please identify the following classifications for 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 900 units above)

Blue Ridge Manufacturing 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 Blue Ridge Manufacturing's cost structure for 2020.

• The materials include $2,200 for the wood and other materials on a per job basis.
• It requires 20 hours of labor on average for the cabinetry.The hourly rate is $10.
• The sales price will be set at a markup of 85%.
• The company estimates that it will have 18,000 direct labor hours in total for the cabinets.
• It assumes 900 units are sold on average per year.

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

Salaries- office & administrative

$ 520,000

Salaries for factory personal

$320,000

Office Rent

$ 125,000

Factory Rent

$30,000

Utilities and Misc office expenses(based on units sold)

$20,000

SalesTravel(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)

$45,000

Factory Property taxes

$15,000

Maintenance for factory equipment

$80,000

Thank you,

Masa