solution

While Simon is happy with the pie prices, volumes of pies sold and contributions of the individual four pie types, he notices that his production capacity is limited to 24,000 pies. For each additional pie to be produced he incurs a $ 0.85te cost, known as the overtime processing cost. Again, see Question 2 or Question 8 for the value of e. a. By means of an appropriate IF statement implemented in an excel sheet (that you will label Sheet_99) find the new total cost processing. The usual processing cost will be renamed as “normal processing cost” opposed to the overtime processing cost which occurs when the capacity limit of 24,000 pies is exceeded. b. Find the new ingredient costs, total cost, contributions and the profit.