$ $ $ $ $ $ $ $ $ $ $ $ $ $ S $ $ Account quipment depreciation: Molding quipment depreciation: Fabrication quipment depreciation: Assembly quipment depreciation: Materials Handling quipment depreciation: Other roduction suprvision: Molding roduction supervision: Fabrication roduction supervision: Assembly ndirect labor: Maintenance & Repairs ndirect labor: Materials Handling ndirect labor: Engineering ndirect labor: Raw Materials Purchasing ndirect labor: Quality Control : direct labor: Packaging & Shipping ndirect materials: Molding direct materials: Fabrication direct materials: Assembly tilities: Molding tilities: Fabrication tilities: Assembly tilties: Plant lighting and other equipment tilities: Heating and cooling roperty insurance ability insurance Tedical insurance orkers' compensation insurance ther salaries: Plant manager ther salaries: Accounting : ther salaries: Administrative support ther salaries: Janitorial ther salaries: Security and grounds maintenance roperty taxes ayroll taxes: Direct labor ayroll taxes: Other irect materials irect labor ccounting manager's salary Amount 400,000 300,000 50,000 15,000 10,000 60,000 65,000 58,000 72,000 68,000 170,000 93,000 38,000 99,000 18,000 13,000 8,000 24,000 20,000 6,000 12,000 24,000 26,000 18,000 45,000 13,000 165,000 89,000 56,000 48,000 44,000 18,000 79,000 165,000 2,220,000 1,365,000 88,000 Cost Classifications: Manufacturing / Product / Period Nonmanufacturing Fixed / Variable Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Variable Product MOH Variable Product MOH Variable Product MOH Variable Product MOH Variable Product MOH Variable Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Fixed Product MOH Variable Product MOH Fixed Product Direct materials Variable Product Direct labor Variable Period Administrative Fixed $ $ $ $ $ $ $ $ $ $ $ S $ $ $ $ $ $ $ $ $ Pivot Table Charts SumIF Cost Summary Income Statements + B D E F G $ $ $ $ $ $ $ Product Product Product Product Product Product Product Product MOH MOH MOH MOH MOH MOH MOH Direct materials Fixed Fixed Fixed Fixed Fixed Variable Fixed Variable $ Variable 30 Other salaries: Accounting 31 Other salaries: Administrative support 32 Other salaries: Janitorial 33 Other salaries: Security and grounds maintenance 34 Property taxes 35 Payroll taxes: Direct labor 36 Payroll taxes: Other 37 Direct materials 38 Direct labor 39 Accounting manager's salary 40 Administrative office insurance 41 Advertising 42 Depreciation on office equipment 43 Heat & electricity for the general office 44 Janitorial services for administrative offices 45 Salaries of accounts receivable/payable clerks 46 Sales commissions 47 Sales manager's salary 48 Supplies for administrative office 49 Customer billing supplies 50 89,000 56,000 48,000 44,000 18,000 79,000 165,000 2,220,000 1,365,000 88,000 2,000 400,000 15,000 4,000 26,000 78,000 480,000 120,000 1,000 2,000 Product Period Period $ $ $ $ $ $ $ $ $ $ $ $ Fixed Fixed Period Period Period Period Period Period Direct labor Administrative Administrative Selling Administrative Administrative Administrative Administrative Selling Selling Administrative Administrative Fixed Fixed Fixed Fixed Fixed Variable Fixed Period Period Fixed Variable Period 51 52 53 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 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. 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 Req 2c Calculate the company's total variable costs and total fixed costs. The total variable costs are The total fixed costs are Complete this question by entering your answers in the tabs below. Req 2A Req 2B Req 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 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 20 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