Conduct a product profitability analysis

Jan Feb March April May Total 112 7 0 119 137 21 6 164 113 15 0 128 143 33 1 177 135 10 1 148 155 18 8 179 296 7 0 1009 21 18 699 15 0 998 33 2 907 10 2 1048 18 12 Dec Inputs for Revenue & Costs No of Classes Group Classes Private Classes Salt Stretch Classes Total No of Classes No of Client Visits Group Classes Private Classes Salt Stretch Classes Revenue per client Visit Group Classes Private Classes Salt Stretch Classes Instructor Fee per class Studio Size (Sft) Rent per SA (5) Revenue Group Private Salt Stretch Total Revenue Rent per class for Salt Cave Costs Instructors' Fee Studio Rent Salt Cave Rent Shared Services MBS Transportation Total Costs 10 130 70 60 1900 5.89 10 130 70 60 1900 5.89 15 130 70 60 1900 5.89 15 130 70 60 1900 5.89 21 130 70 60 1900 5.89 21 130 70 60 1900 5.89 2980 910 0 3870 30 10090 2730 1260 14080 30 10485 1950 0 12435 30 14970 4290 140 19400 30 19047 1300 140 20487 30 22008 2340 840 25188 30 79560 13520 2380 95460 7140 11191 0 3500 875 0 21918.5 9840 11191 180 3500 875 0 24798.5 7680 11191 0 3500 87.5 0 22458.5 10620 11191 30 3500 87.5 0 25428.5 8760 11191 30 3500 87.5 700 24268.5 10740 11191 180 3500 875 700 26398.5 54780 67146 420 21000 525 1400 145271