Question 10 Run two sensitivity analyses of questions 9 by means of the Data Table tool available in Excel. a. In the first analysis one varies the normal processing capacity (from 24,000 to 34,000 pies) and the apple pie price (from \( 80 \% \) to \( 120 \% \) of the base apple price \( \$ 9.12 \) ) and then assesses the impact on the profit. (i) Represent the profit for different capacity limits and different apple pie prices. The apple pie price should be on the x -axis. (ii) Interpret the results. Are the processing capacity and the apple pie price b. The second sensitivity analysis evaluates the impact of the apple pie price (from \( 70 \% \) to 120\% of the base apple price \( \$ 9.12 \) ) on the different financial outcomes. Use the Data Table tool with just one input variable. Draw the related graph. Interpret the findings. Note: Create Sheet_QIOa and Sheet_QIOb containing all calculations and related graphs.
UpStudy ThothAI Solution
Quick Answer
Step-by-step Solution
Enter your question here…