reupload for blurry images.

F7 x x Crispin Company Traditional Format Income Statement $ 8,000,000 S 8,000,000 Sales 5 Cost of goods sold 5 Gross margin Selling and administrative expenses: 3 Selling 3 Administrative 0 Net operating income S 8,000,000 2 3 Crispin Company 4 Contribution Format Income Statement 5 Sales 8,000,000 6 Variable expenses: 7 Cost of goods sold 8 Variable selling 19 Variable administrative $ 20 Contribution margin S 8,000,000 21 Fixed expenses: 2 Fixed manufacturnig overhead 13 Fixed selling 24 Fixed administrative 25 Net operating income S 8.0.0.0.0.0.0 26 27 28 Fill in 29 Auto-Calc 31 32 33 Pivot Table Charts Sumir Cost Summary Income Statem Home insert Page Layout Formulas Data Review View 24 Utilities: Heating and cooling Account Amount Equipment depreciation: Molding $ 400,000 Equipment depreciation: Fabrication $ 300,000 Equipment depreciation Assembly $ 50,000 Equipment depreciation: Material Handling $ 15,000 Equipment depreciation: Other $ 10,000 Production prvidion Molding $ 60,000 Production supervision: Fabrication $ 65,000 Production parvision: Assembly 3 58,000 Indirect labor: Maintenance & Repairs $ 72,000 Indirect labor: Material Handling $ 68,000 Indirect Isbor: Engineering $ 170,000 Indirect labor: Raw Materials Purchasing $ 33.000 Indirect labor: Quality Control $ 38.000 Indirect Isbor Packaging & Shipping $ 33.000 Indirect materials: Molding $ 18,000 Indirect materiale: Fabriction $ 13,000 Indirect materiale: Assembly $ 8,000 Utilities: Molding $ 24,000 Utilities: Fabrication $ 20,000 Utilities: Assembly $ 6,000 Lusilties: Plant lighting and other equipment $ 12,000 Utilities: Heating and cooling $ 24,000 Property insurance S 26,000 Liability insurance $ 18,000 Medical insurance $ 45,000 Workers' compensation insurance $ 13,000 Other lies: Plant manager $ 165,000 Other salaries: Accounting $ 83,000 Other salaries: Administrative support $ Other salaries: Janitorial $ 48,000 Other salaries: Security and grounds maintenance $ 44,000 Property taxes $ 18,000 Payroll taxed: Direct labor $ 73,000 Payroll twee: Other $ 165,000 Direct misle $ 2,220,000 Direct lobor $ 1,365,000 Accounting manager's salary $ 88,000 Administrative office insurance $ 2,000 Advertising $ 400,000 Depreciation on office equipment 15,000 Hest electricity for the general office $ 4,000 Janitoris vices for administrative offices $ 26,000 Salorio of counts receivable payable clerk $ 78,000 les commission $ 480.000 Soles mange's lary $ 120,000 $ Supplies for sinistrative office 1000 Customer billing Pupplied $ 2,000 Product ? Period Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product 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 Period Period Nonmanufact MOM MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MON MOH MOH MON MOH MOH MOH MOH MOH MOH MOH Direct materials Direct labor Administrative Administrative Selling Administrative Administrative Administrative Administrative Selling Selling Administrative Administrative Fixed ? Variable Fixed Fixed Fixed Fred Fixed Fixed Fired Fud Fixed Fixed Find Find Fixed Fixed Variable Variable Variable Variable Variable Variable Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Variable Fixed Vulable Variable Fixed Fixed Fixed Fixed Fixed Fixed Fixed Variable Fixed Fored Variable 56,000 Pivot Table Charts Sumir Cost Summary : Income Statements Type here to search Amount $ 400,000 $ 300,000 $ 50,000 $ 15,000 $ 10,000 $ 60,000 $ 65,000 58,000 $ 72,000 $ 68,000 $ 170,000 $ 33,000 $ 38.000 $ 39,000 $ 18,000 $ 13,000 $ 8,000 $ 24,000 $ 20,000 $ 6,000 t $ 12,000 $ 24,000 $ 26,000 $ 18,000 $ 45,000 $ 13,000 $ 165,000 3 83,000 $ 56,000 $ 48,000 tenance 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 Clarks $ 78,000 $ 480.000 $ 120,000 $ 1,000 $ 2,000 e Charts F7 x x Crispin Company Traditional Format Income Statement $ 8,000,000 S 8,000,000 Sales 5 Cost of goods sold 5 Gross margin Selling and administrative expenses: 3 Selling 3 Administrative 0 Net operating income S 8,000,000 2 3 Crispin Company 4 Contribution Format Income Statement 5 Sales 8,000,000 6 Variable expenses: 7 Cost of goods sold 8 Variable selling 19 Variable administrative $ 20 Contribution margin S 8,000,000 21 Fixed expenses: 2 Fixed manufacturnig overhead 13 Fixed selling 24 Fixed administrative 25 Net operating income S 8.0.0.0.0.0.0 26 27 28 Fill in 29 Auto-Calc 31 32 33 Pivot Table Charts Sumir Cost Summary Income Statem Home insert Page Layout Formulas Data Review View 24 Utilities: Heating and cooling Account Amount Equipment depreciation: Molding $ 400,000 Equipment depreciation: Fabrication $ 300,000 Equipment depreciation Assembly $ 50,000 Equipment depreciation: Material Handling $ 15,000 Equipment depreciation: Other $ 10,000 Production prvidion Molding $ 60,000 Production supervision: Fabrication $ 65,000 Production parvision: Assembly 3 58,000 Indirect labor: Maintenance & Repairs $ 72,000 Indirect labor: Material Handling $ 68,000 Indirect Isbor: Engineering $ 170,000 Indirect labor: Raw Materials Purchasing $ 33.000 Indirect labor: Quality Control $ 38.000 Indirect Isbor Packaging & Shipping $ 33.000 Indirect materials: Molding $ 18,000 Indirect materiale: Fabriction $ 13,000 Indirect materiale: Assembly $ 8,000 Utilities: Molding $ 24,000 Utilities: Fabrication $ 20,000 Utilities: Assembly $ 6,000 Lusilties: Plant lighting and other equipment $ 12,000 Utilities: Heating and cooling $ 24,000 Property insurance S 26,000 Liability insurance $ 18,000 Medical insurance $ 45,000 Workers' compensation insurance $ 13,000 Other lies: Plant manager $ 165,000 Other salaries: Accounting $ 83,000 Other salaries: Administrative support $ Other salaries: Janitorial $ 48,000 Other salaries: Security and grounds maintenance $ 44,000 Property taxes $ 18,000 Payroll taxed: Direct labor $ 73,000 Payroll twee: Other $ 165,000 Direct misle $ 2,220,000 Direct lobor $ 1,365,000 Accounting manager's salary $ 88,000 Administrative office insurance $ 2,000 Advertising $ 400,000 Depreciation on office equipment 15,000 Hest electricity for the general office $ 4,000 Janitoris vices for administrative offices $ 26,000 Salorio of counts receivable payable clerk $ 78,000 les commission $ 480.000 Soles mange's lary $ 120,000 $ Supplies for sinistrative office 1000 Customer billing Pupplied $ 2,000 Product ? Period Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product Product 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 Period Period Nonmanufact MOM MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MOH MON MOH MOH MON MOH MOH MOH MOH MOH MOH MOH Direct materials Direct labor Administrative Administrative Selling Administrative Administrative Administrative Administrative Selling Selling Administrative Administrative Fixed ? Variable Fixed Fixed Fixed Fred Fixed Fixed Fired Fud Fixed Fixed Find Find Fixed Fixed Variable Variable Variable Variable Variable Variable Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Fixed Variable Fixed Vulable Variable Fixed Fixed Fixed Fixed Fixed Fixed Fixed Variable Fixed Fored Variable 56,000 Pivot Table Charts Sumir Cost Summary : Income Statements Type here to search Amount $ 400,000 $ 300,000 $ 50,000 $ 15,000 $ 10,000 $ 60,000 $ 65,000 58,000 $ 72,000 $ 68,000 $ 170,000 $ 33,000 $ 38.000 $ 39,000 $ 18,000 $ 13,000 $ 8,000 $ 24,000 $ 20,000 $ 6,000 t $ 12,000 $ 24,000 $ 26,000 $ 18,000 $ 45,000 $ 13,000 $ 165,000 3 83,000 $ 56,000 $ 48,000 tenance 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 Clarks $ 78,000 $ 480.000 $ 120,000 $ 1,000 $ 2,000 e Charts