help!!

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. 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. 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. Although all 6-pack of hot cross buns sell for $4.00, the cost of producing the different hot cross buns varies. 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. Jonathan wants to make sure the bakery bakes the amount of each kind of hot cross buns that the bakery can sell. 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. (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. For the following questions, please refer to the sensitivity analysis report below. 1 Microsoft Excel 16.0 Sensitivity Report Worksheet: [Question 1.xlsx]Normal 4 Variable Cells Cell Name Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 3000 0 2 1 16.30 2.5 1E+30 7 58510 Number of packs, Traditional Hot Cross Buns 6-pack # SC510 Number of packs, Extra Soft Fruitless Hot Cross Buns 6-pack 6700 O 0.5 9 SD510 Number of packs, Cadbury Hot Cross Bus 6-pack 4900 0 15 0.375 18+30 10 58511 Advertising in dollars (5), Traditional Hot Cross Buns 6-pack 500 0 4 5 16.30 1000 O 4 18+30 3 11 SCS11 Advertising in dollars (5), Extra Soft Fruitless Hot Cross Buns pack SD511 Advertising in dollars (5), Cadbury Hot Cross Bus 6-pack 12 500 0 16+30 13 14 Constraints 15 Final Shadow Constraint Allowable Allowable Value Price RM. Side Increase Decrease 16 Cell Name 17 58517 selling amount of Traditional Hot Cross Buns 6-pack LHS 500 2 1E+30 3000 500 700 16 700 $8518 selling amount of Extra Soft Fruitless Hot Cross Buns 6-pack LM5 2.5 11+30 6700 19 58519 selling amount of Cadbury Hot Cross Buns 6-pack LHS 900 1.5 900 18-30 4900 20 $8520 promotion budget LHS 2000 14 2000 1E+30 500 21. 500 500 5 500 500 22 S8521 promotional requirements for Traditional Hot Cross Bons 6-pack LHS 58522 promotional requirements for Extra Soft Fruitless Hot Cross Buns 6-pack (MS 58523 promotional requirements for Cadbury Hot Cross Buns 6-pack LHS 1000 500 18-30 500 500 21 500 500 500 0 3