You will use the data in the Cost Summary tab to create a PivotTable and PivotChart...

 

Transcribed Image Text:

You will use the data in the "Cost Summary" tab to create a PivotTable and PivotChart to address Question 1. Make sure that your PivotTable and PivotChart are in the new sheet titled "Question 1." Required: 1. Go to the "Cost Summary" tab. Using PivotTable and Charts: a. Calculate the company's total product 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. Complete this question by entering your answers in the tabs bel Req 1A Req 1B Req 1C Calculate the company's total product costs and total period costs. The total products costs are The total period costs are You will use the data in the "Cost Summary" tab to create a PivotTable and PivotChart to address Question 1. Make sure that your PivotTable and PivotChart are in the new sheet titled "Question 1." Required: 1. Go to the "Cost Summary" tab. Using PivotTable and Charts: a. Calculate the company's total product 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. Complete this question by entering your answers in the tabs bel Req 1A Req 1B Req 1C Calculate the company's total product costs and total period costs. The total products costs are The total period costs are