Please see attachment

Document Preview:

125000 120000 74250 93000 412250 40000 50000 31000 33000 154000 25000 20000 10000 18000 73000 11250 9000 4500 8100 32850 43750 35000 17500 31500 127750 120000 114000 63000 90600 387600 5000 6000 11250 2400 24650 0.04 0.05 0.15151515151515152 2.5806451612903226E-2 5.9793814432989693E-2 4500 5000 1500 11000 7000 3000 1500 1000 12500 23500 1150 2.7895694360218315E-3 100000 80000 45000 60000 285000 1.25 1.5 1.65 1.55 1.4464912280701754 1.2 1.425 1.4 1.51 1.36 55000 24750 5000 10000 10000 23000 127750 2011 101147 20200 121347 235000 14000 2011 115035 20099.999999999996 135135 238000 15000 2011 104787 19600 124387 240000 14400 2011 118541 19500 138041 265000 15680 2011 120031 20000 140031 266000 17000 2011 125487 20400 145887 274500 19500 2011 124555 20500 145055 275000 20000 2011 130412 20350 150762 285000 20100 2011 145030 20050 165080 287000 24000 2011 128115 19950 148065 278000 19801 2011 127150 20600 147750 275000 19999 2011 126225 20620 146845 271250 19850 2012 99450 20500 119950 232000 15000 2012 111999 20280 132279 234000 15500 2012 112568 20560 133128 233000 15500 2012 108787 20560 129347 231000 14850 2012 118050 20158 138208 266000 16500 2012 124532 20176 144708 269000 19500 2012 131254 20192 151446 284000 19999 2012 130555 20490 151045 286000 20000 2012 149001 20532 169533 290000 25000 2012 125633 20574 146207 274500 19850 2012 124131 20490 144621 273250 19787 2012 124665 20562 145227 271450 19899 REVENUE COSTS Direct Materials Direct Labor Fringe Benefits on Direct Labor TOTAL COST GROSS MARGIN Manufacturing Overhead Basic Hydration Intensity Post Workout Sales Total GROSS MARGIN RATIO Unit Price: Unit Cost: PERFORMANCE DRINKS – MONTHLY PROFIT REPORT Indirect Labor Fringe Benefits on Indirect Labor Utilities Processing Equipment – Depreciation Preventative Maintenance Information Technology Monthly Charge PERFORMANCE DRINKS – MONTHLY MFG OHD COST…