Question: just answer the first question The Simon Pie Company generates profit from combining two purchasing ingredients (fruit and frozen dough) into apple pies, processing the

just answer the first question
The Simon Pie Company generates profit from combining two purchasing ingredients (fruit and frozen dough) into apple pies, processing the pies (cooking, packaging, delivery, etc.), and selling them to local grocery stores. The company's founder Samuel Simon intends to build an Excel model to explore his options. Question 1: a. Explain the influence diagram below. b. What are the decision variables; the parameters, the exogenous variables and the endogenous ones? Profit Revenue Total Cost Processing Cost Ingredient Cost Required Ingredient Quantities Pies Demanded Ple Price Unit Pie Processing Cost Unit Cost Filling Unit Cost Dough Fixed cost Question 2: Mr. Simon collects the following details about his company's operations: Pie price = $ 10 Pie demanded & sold (per week, in thousands) = 18 Unit pie processing cost (per pie) = $ 2.05 Unit cost fruit filling (per pie) = $ 3.48 Unit cost dough (per pie) - S 0.30 Fixed cost = $ 12 a. Calculate by hand the financial results relevant to Mr. Simon, say: revenue, processing cost, ingredients cost, total cost and profit, assuming that there is no tax. b. Create an excel sheet (labeled Sheet_92) modeling Simon Pie Company's profit model
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
