Required information [The following information applies to the questions displayed below) Crispin 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. Click here to download the Excel template which you will use to answer the questions that follow. Click here for a brief tutorial on Pivot Tables in Excel Click here for a brief tutorial on PivotCharts in Excel Click here for a brief tutorial on SUMIE in Excel. 2. Using PivotTable and Charts: a. Calculate the company's total variable costs and total fixed costs. b. Calculate the portions of the total variable costs that would be classified as product costs and period costs. c. Calculate the portions of the total fixed costs that would be classified as product costs and period costs. Complete this question by entering your answers in the tabs below. Req 2A Req 28 Reg 2C Calculate the company's total variable costs and total fixed costs. The total variable costs are The total fixed costs are R2A Req 2B> Prey 1 of 2 Next > [The following information applies to the questions displayed below.) Crispin 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. ok Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a brief tutorial on Pivot Tables in Excel Click here for a briefitutorial on PivotChants in Excel. Click here for a brief tutorial on SUMIF in Excel 2. Using PivotTable and Charts: a. Calculate the company's total variable costs and total fixed costs. b. Calculate the portions of the total variable costs that would be classified as product costs and period costs. c. Calculate the portions of the total fixed costs that would be classified as product costs and period costs. Complete this question by entering your answers in the tabs below. Reg 2A Reg 2b Reg 20 Calculate the portions of the total variable costs that would be classified as product costs and period costs. The total variable product costs are The total variable period costs are dyed below) Crispin 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. Click here to download the Excel template, which you will use to answer the questions that follow Click here for a brief tutorial on PivotTables in Excel. Click here for a brief tutorial on PivotCharts in Excel Click here for a brief tutorial on SUMIF in Excel 2. Using PivotTable and Charts: a. Calculate the company's total variable costs and total fixed costs. b. Calculate the portions of the total variable costs that would be classified as product costs and period costs. c. Calculate the portions of the total fixed costs that would be classified as product costs and period costs. Complete this question by entering your answers in the tabs below. Reg 2A Req 2B Reg 2C Calculate the portions of the total fixed costs that would be classified as product costs and period costs. The total fixed product costs are The total fixed period costs are Red 2C The total fixed product costs are The total fixed period costs are