Question: For this problem, you will continue to work with Example L.8.2 regarding the paint mixing plant. a) (4 points, In Excel) In column G, calculate
For this problem, you will continue to work with Example L.8.2 regarding the paint mixing plant. a) (4 points, In Excel) In column G, calculate the average cost per gallon of paint mixed for the paint factory. b) (4 points, In Excel) Assume that paint is sold for $10 a gallon. In Column H, calculate the average profit per gallon of paint. c) (4 points) Suppose its actually a 31 day month. Based on your calculations, do you expect the average cost per unit to increase or decrease for the last day of the month? Explain your answer and give a reference to the cell(s) in Excel you used to make your conclusion
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
