(4 points) On which day do we expect the plant to break even and start earning a profit? Explain your answer and give a reference to the cell(s) in Excel you used to make your conclusion.
Total Production Total Monthly Daily Estimated Average Cost per Average Profit per Gallon (gallons of paint) Cost Production Daily Cost Marginal Cost Gallon(Problem 3) (Problem3) 0 0 $125,632.00 1 8035 $150,425.86 8035 $24,793.86 $3.09 $18.72 -$8.72 2 16521 $177,436.62 8486 $27,010.76 $3.18 $10.74 -$0.74 3 25018 $204,631.09 8497 $27,194.47 $3.20 $8.18 $1.82 4 31883 $226,765.69 6865 $22,134.60 $3.22 $7.11 $2.89 5 40231 $253,844.26 8348 $27,078.57 $3.24 $6.31 $3.69 6 48105 $279,487.51 7874 $25,643.25 $3.26 $5.81 $4.19 7 55989 $305,951.98 7884 $26,464.47 $3.36 $5.46 $4.54 8 64021 $331,867.40 8032 $25,915.42 $3.23 $5.18 $4.82 9 72227 $359,231.72 8206 $27,364.32 $3.33 $4.97 $5.03 10 80013 $385,165.38 7786 $25,933.66 $3.33 $4.81 $5.19 11 86072 $405,536.56 6059 $20,371.18 $3.36 $4.71 $5.29 12 96004 $439,193.15 9932 $33,656.59 $3.39 $4.57 $5.43 13 104125 $466,820.93 8121 $27,627.78 $3.40 $4.48 $5.52 14 112231 $494,627.56 8106 $27,806.63 $3.43 $4.41 $5.59 15 120076 $521,911.25 7845 $27,283.69 $3.48 $4.35 $5.65 16 128143 $549,739.32 8067 $27,828.07 $3.45 $4.29 $5.71 17 135822 $576,587.92 7679 $26,848.60 $3.50 $4.25 $5.75 18 144001 $605,366.58 8179 $28,778.66 $3.52 $4.20 $5.80 19 152024 $633,979.57 8023 $28,612.99 $3.57 $4.17 $5.83 20 159979 $662,131.80 7955 $28,152.23 $3.54 $4.14 $5.86 21 168108 $691,290.29 8129 $29,158.49 $3.59 $4.11 $5.89 22 176225 $720,594.31 8117 $29,304.02 $3.61 $4.09 $5.91 23 184001 $748,344.72 7776 $27,750.41 $3.57 $4.07 $5.93 24 192035 $778,215.61 8034 $29,870.89 $3.72 $4.05 $5.95 25 199984 $807,459.69 7949 $29,244.08 $3.68 $4.04 $5.96 26 207915 $836,920.55 7931 $29,460.86 $3.71 $4.03 $5.97 27 217109 $871,086.74 9194 $34,166.19 $3.72 $4.01 $5.99 28 223978 $896,549.13 6869 $25,462.39 $3.71 $4.00 $6.00 29 232106 $927,512.48 8128 $30,963.35 $3.81 $4.00 $6.00 30 239901 $957,402.43 7795 $29,889.95 $3.99 $6.01
Day
0 1
2 3 4
6
7
8
9
0
2 3 4 S 6
7
8
9 0 1 2 3