Solver HW Equation Writing Question

Questions ArchiveCategory: Data AnalyticsSolver HW Equation Writing Question
Audrey Nolte asked 3 years ago

I am a little thrown off by the equation I am supposed to write for the total profit in the Wood Walker problem on the solver homework, mainly because cost/unit is included in this problem and not in the Hot Tubs problem, and yet they are both asking for Total Profit. Traditionally, profit is revenue – costs, but I do not see a separate revenue column. Are we supposed to do like, # Made * Sales Price – cost/unit for this one rather than just doing SUMPRODUCT for the profit/unit and # made?

1 Answers
James Gaskin answered 3 years ago

Profit is sales price minus cost. It is already calculated for you in Column B. So now you just need to sumproduct the number made and the profit per unit. 

Your Answer

12 + 15 =