Learned Corporation has provided the following information:

Cost per UnitCost per PeriodDirect materials$5.00Direct labor$3.60Variable manufacturing overhead$1.20Fixed manufacturing overhead$29,250Sales commissions$0.40Variable administrative expense$0.30Fixed selling and administrative expense$9,750

Required:

a. For financial reporting purposes, what is the total amount of product costs incurred to make 6,500 units?

b. For financial reporting purposes, what is the total amount of period costs incurred to sell 6,500 units?

c. If the selling price is $22.50 per unit, what is the contribution margin per unit sold?(Round your answer to 2 decimal places.)

d. If 7,500 units are produced, what is the total amount of direct manufacturing cost incurred?

e. If 7,500 units are produced, what is the total amount of indirect manufacturing costs incurred?

I need a excel table that has the answers to :

total product ( manufacturing ) cost

total period (nonmanufacturing) cost

contribution margin per unit

total direct manufacturing cost

total indirect manufacturing cost