NEL Ch 1 Required information Excel Analytics 02-01 (Static) Cost Concepts [LO2-2, LO2-3, LO24 The following informations to the questions displayed below) Crap Company's sales from last year were 58 million. The company maintains no beginning or ending inventores It has assembled all of its costs from last year and would like your assistance in these costs into various Categories depicting them graphically and preparing traditional and contribution format income statements Click here to download the Excel tema, which you woestifoto Click here for brettolo Pivot Tables in Excel Giochere for a brief calon Charts in Excel Click here foco bichokon SUMIE Excel TE Excel Analytics 02-01 (Static) Part 1 Required: 1. Go to the Cost Summary" tab. Using Pivot Table and Charts 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 . Calculate the portions of the total period costs that would be classified as seling expense and administrative expense. Complete this question by entering your answers in the tabs below. Reg 1A Reg 13 Reg 10 Calculate the company's total product costs and total period costs. The total products costs are The total period costs are Red IA Reg 1B Reg 1C Calculate the portions of the total product costs that would be classified as direct materials, direct labor overhead (MOH). The total direct material cost is The total direct labor cost is The total manufacturing overhead cost is