Company’s sales from last year were $8 million. The company maintains no beginning or ending inventories. It has assembled all of its costs from last year and would like your assistance in sorting these costs into various categories, depicting them graphically, and preparing traditional and contribution format income statements. (Using Excel) 

1. Go to the “Cost Summary” tab. Using PivotTable and Charts: 

a. Calculate the company’s total production costs and total period costs. 

b. Calculate the portions of the total product costs that would be classified as direct materials, direct labor, and manufacturing overhead (MOH). 

c. Calculate the portions of the total period costs that would be classified as selling expense and administrative expense.