ppt课件-chapter2-spreadsheetmodeling.pptVIP

DSC 3120 DSc 3120 * * Slides 2b: How to create an Influence Diagram: start with a performance measure variable. Further decompose each of the intermediate variables into more related intermediate variables. Decompose this variable into two or more intermediate variables that combine mathematically to define the value of the performance measure. Continue this process until an exogenous variable is defined (i.e., until you define an input decision variable or a parameter). TVC TFC Unit VC Revenue Demand Price Total Cost Profit Advertising An Example Influence Diagram performance measure variable Profit Start here: Decompose this variable into the intermediate variables Revenue and Total Cost Example: Simon Pie Profit Revenue Total Cost Now, further decompose each of these intermediate variables into more related intermediate variables ... Model Construction Based on the previous Influence Diagram, create the equations relating the variables to be specified in the spreadsheet. Profit Revenue Total Cost Profit = Revenue – Total Cost Profit Revenue Pie Price Pies Demanded Revenue = Pie Price * Pies Demanded Fixed Cost Processing Cost Ingredient Cost Profit Total Cost Total Cost = Processing Cost + Ingredients Cost + Fixed Cost Processing Cost = Pies Demanded * Unit Pie Processing Cost Processing Cost Total Cost Pies Demanded Unit Pie Processing Cost Profit Ingredients Cost = Qty Filling * Unit Cost Filling + Qty Dough * Unit Cost Dough Ingredient Cost Profit Total Cost Unit Cost Filling Unit Cost Dough Required Ingredient Quantities Profit Revenue Total Cost Pies Demanded Pie Price Unit Pie Processing Cost Fixed Cost Processing Cost Ingredient Cost Unit Cost Filling Unit Cost Dough Required Ingredient Quantities Simon’s Initial Model Input Values Pie Price Pies Demanded and sold Unit Pie Processing Cost ($ per pie) Unit Cost, Fruit Filling ($ per pie) Unit Cost, Dough ($ per pie) Fixed Cost ($000’s per week) $8.00 16 $2.05 $3.48 $0.30 $12 To represent this