[The following information applies to the questions displayed below.]Crispin Companys 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.

Excel Analytics 01-01 (Static) Part 1 Required: 1. Go to the "Cost Summary" tab. Using Pivotrable and Chats a. Calciatace the company? lotal product costs and total period costs: b. Calculate the portions of the tetal product costs that would be clessiffed as drect materias, derect labos, and manulacturing overhesa (MOM). c. Calculase the portions of the teeal period costs that would be classfied as setirig espentse and administrinive especse. Compiete this guestion by entering yeur answers in the tabs below, Ealculate the compamy's tetal product tosts and total perise costs. d. Prepare a by chart that includes a total of two bars. The first bar will depict the total period costs and the amounts of that grand total that are categorized as selling expenses and administrative expenses. The second bor will depict the total product costs and the amounts of that grand total that are categorized as direct materials, direct iabor, and manufacturing overhead (MOH). Which of the following statements are true according to this bar chart. (You may select more than one answer. Single click the box: with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) The direct labor is the smallest amount of the three product costs. The total selling expense is greater than the total administrative expense. The total selling expense is less than the total direct materials cost. [The following infarmation appoucs to the questions disployed below] Crisgin Company's sales from last year were $8 mision. The company maintans oo beglaning or ending invertores. It has assembled alt of its costs from last year and would the your assistance in sorting these costs into verious categories. dopicting them graphically and preparing traditional and contribution format income statements: Click here to downiaad the Excot temalate. which wou will use to ansver the auestans thet fofon. Clikk here for a brief tutoriat an Pivortables in Eucel. Cllck here tor a baief tutoriat on. PlvotCbais in ixce. Click bete for a briet tutorial on Sumbic in Excel Excel Analytics 01-01 (Static) Part 1 Required: 1. Go to the "Cost Summary" tab, Using PivotTable and Charts: a. Colculate the campany's total product costs and total period costs. b. Calculate the poctions of the total product costs that would be classified as direct materiak, direct iaboc, and manufacturing overhead (MOT-2) c. Calculate the partions of the total period costs that would bo classined as seiling expense and administrative erpense Complete this duestion by entering your answers in the tabs below. Calcueste the compam's total product costs and total period costs. Crispin Company's sales from last year were $8 milion. The compony maintains no beginning or ending inventories, it has assembled air of its costs from last year and would like your assistance in sorting these costs into vanoia categories. depicting them graphically, and preparing traditional and contribution format incanse statements: Cickhere to download the Excel template. which you wili use to answer the avestions that follow. Cicki here for a brief tutorial an. Fivolables in . Ixcel. Click hete for a brief tutorial an. ProtCllats in Excel. click berefor a bief tutonal on SuMIf in. Excel Excel Analytics 01-01 (Static) Part 1 Required: 1. Go to the "Cost Surmary" tab. Using Pivotiable 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 classilied as direct materiais direct labos, and manufacturing overhead (MOH). c. Caiculate the portions of the total period costs that would be clossifled as seling exgense and administrative expense. Complete this question by entering your answers in the tabs below. Calculate the portions of the total product costs that would be ciassined as direct mateials, direct labor, and manufacturting tverhead (MOH). (The following information applies to the questions dispiayod berow] Crispin Company's sales from last year were- $8 milition. The compony maintains no beginning or ending inventories it has assembied all of its costs from lastyeor and would like your assistance in sorting these costs into variaus categories. depicting them grophically, and preparing traditional and contribution format income statements. Click bere to dawaiood the Excel template. Which you will use to answer the avestions that follows Click here tor a bilaf tutorial on Plvottaties in Ereel. Clikk here for a brief tutorial on. Plvotchacti in Excel Click here for a beief tutorial on SUMif ia Excel Excel Analytics 01.01 (Static) Part 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. Cakculate the portions of the total product costs that would bo classifed as direct materias, direct labot, and manufacturing owethead ( MOH ) c. Calculate the portions of the total period costs that would be classified as selling eapense and adminatrative expense Complete this question by entering your answers in the tabs below. Calculate the portions of the total pericd costs that would be classified as selling expense and admingtrative eypenve