Question 9 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.85 \) cost, known as the overtime processing cost. a. By means of an appropriate IF statement implemented in an excel sheet (that you will label Sheet_Q9) 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.
UpStudy ThothAI Solution
Quick Answer
Step-by-step Solution
Enter your question here…