Calibri (Body) 11 AA Wrap Text General 101 III te BIU V A- Merge & Center $ % 668 6 Account Equipment depreciation Molding Equipment depreciation Fabrication Equipment depreciation: Assembly Equipment depreciation Material Handling Equipment depreciation. Other Production suprision Molding Production supervision Fabrication Production wpervision Assembly Inicitect labor: Maintenance Repairs Indirect labor Material Handling Indirect labor: Engineering Indirect labor Raw Materials Purchasing section Quality Control 6 Indirect labo Packaging & Shipping 27 Indirect materiale Molding 28 indirectas Fabrication 39 direct material Ambly 20 : Molding 21 Utos Fabrication 22 Utilities by 23 antighting and other equipment 24 Heating doing 25 Property in 26 inance 27 Medical 28 Works.compensation ince 29 Others Plant 30 Acco 31 Other Admite 12 Other to 33 Other Secondominante 34 Property 95 Protect 36 Foto 37 Dratis 30 Octwo 30 Accounting 40 41 Advertising 5 $ $ $ $ 5 5 $ $ $ 5 5 $ S 5 5 $ 5 $ $ 5 $ 5 5 $ $ $ 5 5 5 5 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 19.000 56.000 48.000 14,000 1.000 79,000 165.000 3,220.000 1.365.000 8.000 2.000 000 Cost Classifications: Manufacturing / Product / Period Nonmanufacturing Fixed / Variable Product MOH Fixed Product MOH Fax Product MOH Fund Product MOH Fred Product MOH Product MOH Fixed Product MOH Product MOH Fored Product MOH Rad MOH Product Fund Product MOH F Product MOH Red Product MOH F Product MOH Fed Product MOM Vara Product MOH Variable Product MOH Variable Product MOH Var Product MOH Variable Product MOH Product MO Found Produd MOH Red Product MOH Fue Product MOH Product UN Product MOH Product MON Product MOH Product UO ad 5 Product Product Product Product Produs Produ Period MOM MOH MON MW 5 Durat V Portable Charts Sud Cost Summary SC LO B I Calibri (Body) 11 A A Wrap Text General il % Paste BIU Merge & Center $ %) 37 D E $ $ $ S $ $ $ $ 400,000 15,000 4,000 26,000 78,000 480,000 120,000 1,000 2,000 Period Period Period Period Period Period Period Period Period Selling Administrative Administrative Administrative Administrative Selling Selling Administrative Administrative Fixed Fixed Fixed Fixed Fixed Variable Fixed Fixed Variable SA Advertising 2 Depreciation on office equipment 3 Heat & electricity for the general office 4 Janitorial services for administrative offices Salaries of accounts receivable/payable clerks 6 Sales commissions -7 Sales manager's salary & Supplies for administrative office 9 Customer billing supplies SO 51 52 53 54 55 56 57 58 59 GO 61 62 63 64 65 66 62 68 69 70 71 22 73 74 75 76 77 78 79 80 81 Pivot Table Charts SumIE Cast Summan 18 C B D E F F G A Crispin Company Traditional Format Income Statement $ 8,000,000 $ 8,000,000 Sales 5 Cost of goods sold 6 Gross margin 7 Selling and administrative expenses: 8 Selling 9 Administrative 10 Net operating income $ $ 8,000,000 8,000,000 8.000.000 12 13 Crispin Company 14 Contribution Format Income Statement 15 Sales $ 16 Variable expenses 17 Cost of goods sold 18 Variable selling 19 Variable administrative 5 20 Contribution margin 5 21 Fixed expenses 22 Find manufacturnigoverhead 23 Fixed selling 24 Find udministrative 25 Net operating income 26 27 26 Fill in 29 Auto-Calc 30 31 1090.000 34 35 36 38 39 41 income Statements 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 28 Reg 20 Calculate the portions of the total variable costs that would be classified as product costs and period costs. Calibri (Body) 11 AA Wrap Text General 101 III te BIU V A- Merge & Center $ % 668 6 Account Equipment depreciation Molding Equipment depreciation Fabrication Equipment depreciation: Assembly Equipment depreciation Material Handling Equipment depreciation. Other Production suprision Molding Production supervision Fabrication Production wpervision Assembly Inicitect labor: Maintenance Repairs Indirect labor Material Handling Indirect labor: Engineering Indirect labor Raw Materials Purchasing section Quality Control 6 Indirect labo Packaging & Shipping 27 Indirect materiale Molding 28 indirectas Fabrication 39 direct material Ambly 20 : Molding 21 Utos Fabrication 22 Utilities by 23 antighting and other equipment 24 Heating doing 25 Property in 26 inance 27 Medical 28 Works.compensation ince 29 Others Plant 30 Acco 31 Other Admite 12 Other to 33 Other Secondominante 34 Property 95 Protect 36 Foto 37 Dratis 30 Octwo 30 Accounting 40 41 Advertising 5 $ $ $ $ 5 5 $ $ $ 5 5 $ S 5 5 $ 5 $ $ 5 $ 5 5 $ $ $ 5 5 5 5 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 19.000 56.000 48.000 14,000 1.000 79,000 165.000 3,220.000 1.365.000 8.000 2.000 000 Cost Classifications: Manufacturing / Product / Period Nonmanufacturing Fixed / Variable Product MOH Fixed Product MOH Fax Product MOH Fund Product MOH Fred Product MOH Product MOH Fixed Product MOH Product MOH Fored Product MOH Rad MOH Product Fund Product MOH F Product MOH Red Product MOH F Product MOH Fed Product MOM Vara Product MOH Variable Product MOH Variable Product MOH Var Product MOH Variable Product MOH Product MO Found Produd MOH Red Product MOH Fue Product MOH Product UN Product MOH Product MON Product MOH Product UO ad 5 Product Product Product Product Produs Produ Period MOM MOH MON MW 5 Durat V Portable Charts Sud Cost Summary SC LO B I Calibri (Body) 11 A A Wrap Text General il % Paste BIU Merge & Center $ %) 37 D E $ $ $ S $ $ $ $ 400,000 15,000 4,000 26,000 78,000 480,000 120,000 1,000 2,000 Period Period Period Period Period Period Period Period Period Selling Administrative Administrative Administrative Administrative Selling Selling Administrative Administrative Fixed Fixed Fixed Fixed Fixed Variable Fixed Fixed Variable SA Advertising 2 Depreciation on office equipment 3 Heat & electricity for the general office 4 Janitorial services for administrative offices Salaries of accounts receivable/payable clerks 6 Sales commissions -7 Sales manager's salary & Supplies for administrative office 9 Customer billing supplies SO 51 52 53 54 55 56 57 58 59 GO 61 62 63 64 65 66 62 68 69 70 71 22 73 74 75 76 77 78 79 80 81 Pivot Table Charts SumIE Cast Summan 18 C B D E F F G A Crispin Company Traditional Format Income Statement $ 8,000,000 $ 8,000,000 Sales 5 Cost of goods sold 6 Gross margin 7 Selling and administrative expenses: 8 Selling 9 Administrative 10 Net operating income $ $ 8,000,000 8,000,000 8.000.000 12 13 Crispin Company 14 Contribution Format Income Statement 15 Sales $ 16 Variable expenses 17 Cost of goods sold 18 Variable selling 19 Variable administrative 5 20 Contribution margin 5 21 Fixed expenses 22 Find manufacturnigoverhead 23 Fixed selling 24 Find udministrative 25 Net operating income 26 27 26 Fill in 29 Auto-Calc 30 31 1090.000 34 35 36 38 39 41 income Statements 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 28 Reg 20 Calculate the portions of the total variable costs that would be classified as product costs and period costs