Product/ Account Equipment depreciation: Molding Amount Period Cost Classifications: Manufacturing / Nonmanufacturing Fixed / Variable $ 400,000 Product MOH Fixed Equipment depreciation: Fabrication $ 300,000 Product MOH Fixed Equipment depreciation: Assembly $ 50,000 Product MOH Fixed Equipment depreciation: Materials Handling S 15,000 Product MOH Fixed Equipment depreciation: Other $ 10,000 Product MOH Fixed Production suprvision: Molding $ 60,000 Product MOH Fixed Production supervision: Fabrication $ 65,000 Product MOH Fixed Production supervision: Assembly $ 58,000 Product MOH Fixed Indirect labor: Maintenance & Repairs $ 72,000 Product MOH Fixed Indirect labor: Materials Handling $ 68,000 Product MOH Fixed Indirect labor: Engineering $ 170,000 Product MOH Fixed Indirect labor: Raw Materials Purchasing $ 93,000 Product MOH Fixed Indirect labor: Quality Control $ 38,000 Product MOH Fixed Indirect labor: Packaging & Shipping S 99,000 Product MOH Fixed Indirect materials: Molding $ 18,000 Product MOH Variable Indirect materials: Fabrication. $ 13,000 Product MOH Variable Indirect materials: Assembly $ 8,000 Product MOHI Variable Utilities: Molding $ 24,000 Product MOH Variable. Utilities: Fabrication $ 20,000 Product MOH Variable Utilities: Assembly S 6,000 Product MOH Variable Utiltiles: Plant lighting and other equipment $ 12,000 Product MOH Fixed Utilities: Heating and cooling $ 24,000 Product MOH Fixed Property insurance $ 26,000 Product MOH Fixed Liability insurance, Medical insurance $ 18,000 Product MOH Fixed $ 45,000 Product MOH Fixed Workers' compensation insurance $ 13,000 Product MOH Fixed Other salaries: Plant manager $ 165,000 Product MOH Fixed Other salaries: Accounting $ 89,000 Product MOH Fixed Other salaries: Administrative support $ 56,000 Product MOH Fixed Other salaries: Janitorial $ 48,000 Product MOH Fixed Other salaries: Security and grounds maintenance $ 44,000 Product MOH Fixed Property taxes $ 18,000 Product MOH Fixed Payroll taxes: Direct labor 79,000 Product MOH Variable Payroll taxes: Other Direct materials Direct labor Accounting manager's salary Administrative office insurance Advertising Depreciation on office equipment $ 165,000 Product MOH Fixed $ 2,220,000 Product Direct materials Variable $ 1,365,000 Product Direct labor Variable $ 88,000 Period Administrative Fixed $ 2,000 Period Administrative Fixed $ 400,000 Period Selling Fixed $ 15,000 Period Administrative Fixed Heat & electricity for the general office $ 4,000 Period Administrative Fixed Janitorial services for administrative offices $ 26,000 Period Administrative Fixed Salaries of accounts receivable/payable clerks $ 78,000 Period Administrative Fixed Sales commissions $ 480,000 Period Selling Variable Sales manager's salary S 120,000 Period Supplies for administrative office: $ 1,000 Period Selling Administrative Fixed Fixed Customer billing supplies 2,000 Period Administrative Variable 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. 4. Assume the company wants to adapt the information in the "Cost Summary" tab to prepare a contribution format income statement. Within the "Income Statements" tab of your template, and using the Sum IFS function to quantify all variable and fixed expenses: a. Prepare a contribution format income statement. (Hint: The cost of goods sold should include all direct materials, direct labor, and variable manufacturing overhead. The fixed manufacturing overhead costs should be included within the "Fixed expenses" portion of the income statement.) b. Based on the contribution format income statement, what is the contribution margin? c. Based on the contribution format income statement, what is the net operating income? Req 4A Req 4B Req 4C Prepare a contribution format income statement. (Hint: The cost of goods sold should include all direct materials, direct labor, and variable manufacturing overhead. The fixed manufacturing overhead costs should be included within the "Fixed expenses" portion of the income statement.) The cost of goods sold in this income statement is 8,000,000 Req 4A Req 4B > Req 4A Req 4B Req 4C Based on the contribution format income statement, what is the contribution margin? The contribution margin is Based on the contribution format income statement, what is the net operating income? The net operating income is Req 1A Req 18 Req 1C Calculate the company's total product costs and total period costs. The total products costs are The total period costs are Calculate the portions of the total product costs that would be classified as direct materials, direct labor, and manufacturing overhead (MOH). The total direct material cost is The total direct labor cost is The total manufacturing overhead cost is Calculate the portions of the total period costs that would be classified as selling expense and administrative expense. The total selling expense is The total administrative expense is Complete this question by entering your answers in the tabs below. Req 2A Req 28 Req 2C Calculate the company's total variable costs and total fixed costs. The total variable costs are The total fixed costs are $ 2,237,000 ( $ 2,955,000 Req 2A Req 2B Req 2C Calculate the portions of the total variable costs that would be classified as product costs and period costs. The total variable product costs are $ 1,755,000 The total variable period costs are $ 482,000