create a CVP Income Statement

Fixed Assets - Cost Useful Life - Product/Period Depreciation Expense Hand-operated press applies ink to the shirt 7,500 5 Product $ 125.00 Light-exposure table 1,350 10 Product $ 11.25 Dryer converyor belt that makes ink dry on shirts 2,500 10 Product $ 20.83 Computer with graphics software and color printer 3,500 4 Product $ 72.92 Display furniture 2,000 10 Period 16.67 Used cash register 500 5 Period $ 8.33 Total $ 255.00 Shirts Sold Month January February March April May June July August September October November December Maintenance Utility Costs 2000 1716 1100 2110 1720 1158 2630 1640 1171 3150 1740 1198 5000 1758 1268 5300 1818 1274 3920 1825 1205 2080 1780 1117 8000 1914 1400 6810 1860 1362 6000 1855 1347 3000 1749 1193 Index, Match, Max, Min Activity 9 Month September January Maintenance Utilities 8000 1914 1400 2000 1716 1100 1 Variable (VCU) Fixed (on high) Fixed (on low) Maintenance Utilities 0.001333333 1903.333333 1389.333333 1713.333333 1097.333333 Cost items Amount UOM Sweatshirt 10 per shirt Ink 0.75 per shirt Labor 72,000 per year Graphics Designer 500 per month Graphics Designer 0.1 per shirt Insurance and Prop Tax 2,240 annually Depreciation Factory Depreciation SG&A Rent factory 9,000 per year Rent - Office 3,000 per year Mtce - VC Mtce - FC Utilities VC Utilities FC Sales and Admin salaries 1,200 per month Sales commission 10% sales Advertising 400 per month Insurance and Prop Tax SGA 600 annually Fixed Assets - Cost Useful Life - Product/Period Depreciation Expense Hand-operated press applies ink to the shirt 7,500 5 Product $ 125.00 Light-exposure table 1,350 10 Product $ 11.25 Dryer converyor belt that makes ink dry on shirts 2,500 10 Product $ 20.83 Computer with graphics software and color printer 3,500 4 Product $ 72.92 Display furniture 2,000 10 Period 16.67 Used cash register 500 5 Period $ 8.33 Total $ 255.00 Shirts Sold Month January February March April May June July August September October November December Maintenance Utility Costs 2000 1716 1100 2110 1720 1158 2630 1640 1171 3150 1740 1198 5000 1758 1268 5300 1818 1274 3920 1825 1205 2080 1780 1117 8000 1914 1400 6810 1860 1362 6000 1855 1347 3000 1749 1193 Index, Match, Max, Min Activity 9 Month September January Maintenance Utilities 8000 1914 1400 2000 1716 1100 1 Variable (VCU) Fixed (on high) Fixed (on low) Maintenance Utilities 0.001333333 1903.333333 1389.333333 1713.333333 1097.333333 Cost items Amount UOM Sweatshirt 10 per shirt Ink 0.75 per shirt Labor 72,000 per year Graphics Designer 500 per month Graphics Designer 0.1 per shirt Insurance and Prop Tax 2,240 annually Depreciation Factory Depreciation SG&A Rent factory 9,000 per year Rent - Office 3,000 per year Mtce - VC Mtce - FC Utilities VC Utilities FC Sales and Admin salaries 1,200 per month Sales commission 10% sales Advertising 400 per month Insurance and Prop Tax SGA 600 annually