Question: do it on your own excel file and show me the way Question 9 While Simon is happy with the pie prices, volumes of pies

do it on your own excel file and show me the way
do it on your own excel file and show me the way
Question 9 While Simon is happy with the pie prices, volumes of pies sold and contributions of the individual four pic types, he notices that his production capacity is limited to 24,000 pies. For each additional pie to be produced he incurs a S 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_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. Question 9 While Simon is happy with the pie prices, volumes of pies sold and contributions of the individual four pic types, he notices that his production capacity is limited to 24,000 pies. For each additional pie to be produced he incurs a S 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_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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!