2 Required information Excel Analytics 01-01 (Static) Cost Concepts (L-01-2, L01-3, L01-4) (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 Pivottables in Excel Click here for a brief tutorial on PivotCharts in Excel Click here for a brief tutorial on SUMIF in Excel. Excel Analytics 01-01 (Static) Part 1 art 1 of 12 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. nts Sopped Complete this question by entering your answers in the tabs below. eBook Reg 1A Req 18 Reg 10 ASK Calculate tpe company's total product costs and total period costs. The total products costs are The total period costs are ferences Reg 18> d. Prepare bar 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 bar will depict the total product costs and the amounts of that grand total that are categorized as direct materials, direct labor, 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 2. The total selling expense is greater than the total administrative expense The total selling expense is less than the total direct materials cost $ Account entdarbin Moing Equipamento Fabrication Equipe de Asiaty 6 Equiment depreciation Matending 7 Foment cation: Other Production in Malting 9 Production Supervision Fabric 20 Production by 11 tector Mac 12 Indirector Manding 13 indirettore 14 db Row Materials Purchasing 15 Indirect busty Control 16 indirector Packaging 17 in Molding 10 intero 19 indirectly 20 Modi 21 Fabric 22 USA 23 Pandument 24 Hindi 25 Property 26 De 27 Medicine 28 Workers' 29 Data Out Ready 5 5 5 5 5 S 5 S $ $ 5 5 5 $ 5 $ 5 5 5 5 5 5 5 5 Amount 400,000 300,000 50,000 15,000 10,000 69.000 65,000 $3,000 72.000 68,000 170,000 93,000 12.000 90,000 18.000 11.000 2.000 24.000 20.000 5.000 12.000 24,000 26.000 10.000 5.000 13000 2650 Product/ Period Product Product Product Product Product Product Product Produd Product Proda Froid Prode Pro Pro Pro Product Produit Product Product Product Product Moduit Produit Product Proda Product Cost Classifications: Manufacturing / Nonmanufacturing Fixed / Variable MOM F MOH Fond MOR Fad MOH Find MOH MOH MOH F MOH The MON Thad MOR MOH F MOH MOH F MON Var MOM V MON Vu MOH Var MON Var MONI NON MON MO Fed M Feed MOH MO $ $ $ $ $ 5 $ $ $ $ 5 $ Find Fred Fond Fred Feed Fred Pard Fored ed Fund 23 uthe: Plant lighting and other equipment 24 US Heating and cooling 25 Property insurance 26 Libility insurance 27 Medical instance 28 Workers' compensation insurance 29 Other salaries Plant manager 30 other salaries Accounting 31 Othersalas Administrative Sport 32 Other salaries Janitorial 33 other salaries Security and ground maintenance 34 Property 35 Payroles: Drect labor 36 Payrols: Other 37 Direct materials 38 Direct labor 39 Accounting manager's salary 40 Administrative office Insurance 41 Advertising 42 Depreciation on office moment 43 Het & electricity for the real 44 antrial services for administrative office 45 Salaries of accounts recewa/payableres 46 Sales commissions 47 Sales managersary 48 Supplies for at tative office 49 Comerbling Supplies SO 51 52 12.000 24,000 26,000 18,000 45,000 13,000 165,000 18.000 16.000 48.000 44.000 18.000 79.000 165.000 2,210.000 1,365.000 88.000 2.000 400.000 15.000 4.000 26,000 78.000 280,000 130.000 1,000 2,000 $ $ Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Period Period Period Period Period Period Period Period Period Pened Period Feed Foad Variable hed Variable Variable MOH MOH MON MOH MOH MOH MOH MOH MON MOH MOH MOH Direct materials Direct later Administrative Administrative Se Administrative Aditive Active Active Song Sling AME Aditive 5 $ $ $ $ $ $ $ $ $ $ 5 Find Flued hed Fred F Pod Vanabe Vre 2 Required information Excel Analytics 01-01 (Static) Cost Concepts (L-01-2, L01-3, L01-4) (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 Pivottables in Excel Click here for a brief tutorial on PivotCharts in Excel Click here for a brief tutorial on SUMIF in Excel. Excel Analytics 01-01 (Static) Part 1 art 1 of 12 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. nts Sopped Complete this question by entering your answers in the tabs below. eBook Reg 1A Req 18 Reg 10 ASK Calculate tpe company's total product costs and total period costs. The total products costs are The total period costs are ferences Reg 18> d. Prepare bar 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 bar will depict the total product costs and the amounts of that grand total that are categorized as direct materials, direct labor, 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 2. The total selling expense is greater than the total administrative expense The total selling expense is less than the total direct materials cost $ Account entdarbin Moing Equipamento Fabrication Equipe de Asiaty 6 Equiment depreciation Matending 7 Foment cation: Other Production in Malting 9 Production Supervision Fabric 20 Production by 11 tector Mac 12 Indirector Manding 13 indirettore 14 db Row Materials Purchasing 15 Indirect busty Control 16 indirector Packaging 17 in Molding 10 intero 19 indirectly 20 Modi 21 Fabric 22 USA 23 Pandument 24 Hindi 25 Property 26 De 27 Medicine 28 Workers' 29 Data Out Ready 5 5 5 5 5 S 5 S $ $ 5 5 5 $ 5 $ 5 5 5 5 5 5 5 5 Amount 400,000 300,000 50,000 15,000 10,000 69.000 65,000 $3,000 72.000 68,000 170,000 93,000 12.000 90,000 18.000 11.000 2.000 24.000 20.000 5.000 12.000 24,000 26.000 10.000 5.000 13000 2650 Product/ Period Product Product Product Product Product Product Product Produd Product Proda Froid Prode Pro Pro Pro Product Produit Product Product Product Product Moduit Produit Product Proda Product Cost Classifications: Manufacturing / Nonmanufacturing Fixed / Variable MOM F MOH Fond MOR Fad MOH Find MOH MOH MOH F MOH The MON Thad MOR MOH F MOH MOH F MON Var MOM V MON Vu MOH Var MON Var MONI NON MON MO Fed M Feed MOH MO $ $ $ $ $ 5 $ $ $ $ 5 $ Find Fred Fond Fred Feed Fred Pard Fored ed Fund 23 uthe: Plant lighting and other equipment 24 US Heating and cooling 25 Property insurance 26 Libility insurance 27 Medical instance 28 Workers' compensation insurance 29 Other salaries Plant manager 30 other salaries Accounting 31 Othersalas Administrative Sport 32 Other salaries Janitorial 33 other salaries Security and ground maintenance 34 Property 35 Payroles: Drect labor 36 Payrols: Other 37 Direct materials 38 Direct labor 39 Accounting manager's salary 40 Administrative office Insurance 41 Advertising 42 Depreciation on office moment 43 Het & electricity for the real 44 antrial services for administrative office 45 Salaries of accounts recewa/payableres 46 Sales commissions 47 Sales managersary 48 Supplies for at tative office 49 Comerbling Supplies SO 51 52 12.000 24,000 26,000 18,000 45,000 13,000 165,000 18.000 16.000 48.000 44.000 18.000 79.000 165.000 2,210.000 1,365.000 88.000 2.000 400.000 15.000 4.000 26,000 78.000 280,000 130.000 1,000 2,000 $ $ Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Period Period Period Period Period Period Period Period Period Pened Period Feed Foad Variable hed Variable Variable MOH MOH MON MOH MOH MOH MOH MOH MON MOH MOH MOH Direct materials Direct later Administrative Administrative Se Administrative Aditive Active Active Song Sling AME Aditive 5 $ $ $ $ $ $ $ $ $ $ 5 Find Flued hed Fred F Pod Vanabe Vre