H Microsoft Excel 16.0 Sensitivity Report Worksheet: [Question 1.Normal Variable Cells Cell Name 7 58510 Number of packs, Traditional Hot Cross Buns 6-pack SC510 Number of packs, Extra Soft Fruitless Hot Cross Buns 6-pack $0510 Number of packs, Cadbury Hot Cross 6700 0 Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 3000 0 2 1 11+30 2.5 1E+30 05 15 0.375 15-30 4 5 11.30 1E+30 3 3 11+30 6-pack 4900 0 10 500 0 11 $8511 Advertising in dollars (5), Traditional Hot Cross Buns 6-pack SCS11 Advertising in dollars (5), Extra Soft Fruitless Hot Cross Buns 6-pack 50511 Advertising in dollars (5), Cadbury Hot Cross Buns 6-pack 1000 O 12 500 0 4 13 14 Constraints 16 Cell Name Final Shadow Constraint Allowable Allowable Value Price R.M. For the following questions, please refer to the sensitivity analysis report below. (i) Formulate a linear programming (LP) model to determine how many 6-packs of the hot cross buns of each kind should be baked, and how do you suggest that Jonathan should allocate the promotional budget if it wants to maximise profits for the bakery? (8 marks) The LP model has been solved, and the sensitivity analysis report has been generated. A budget of $2,000 has been approved for promoting the three kinds of hot cross buns, and at least $500 must be spent advertising each kind of hot cross buns. Jonathan wants to make sure the bakery bakes the amount of each kind of hot cross buns that the bakery can sell. It costs Jonathan's Bakery $2.00 to bake a Traditional Hot Cross Buns 6-pack, $1.50 to bake an Extra Soft Fruitless Hot Cross Buns 6-pack and $2.50 to bake a Cadbury Hot Cross Buns made with Cadbury Chocolate 6-pack.
Although all 6-pack of hot cross buns sell for $4.00, the cost of producing the different hot cross buns varies.
Ecrisper hot corners plus#
Jonathan (the owner of the local bakery) estimates that the bakery can sell 500 6-pack of its Traditional Hot Cross Buns plus 5 extra 6-packs for every dollar it spends on promoting this product 700 6-packs of the Extra Soft Fruitless Hot Cross Buns plus 6 extra 6-packs for every dollar spent promoting this product and finally, 900 6-packs of the Cadbury Hot Cross Buns made with Cadbury plus 8 extra 6-packs for every dollar spent promoting this product this year. A popular local bakery in Reservoir, Jonathan's Bakery, bakes three kinds of hot cross buns: Traditional Hot Cross Buns 6-pack, Extra Soft Fruitless Hot Cross Buns 6-pack and Cadbury Hot Cross Buns made with Cadbury Chocolate 6-pack.
Transcribed image text: Easter is just around the corner! Hot cross buns are traditionally eaten over the Easter religious Christian holiday to symbolise the crucifixion of Jesus on Good Friday on the cross.
0 kommentar(er)
