Linear programming for Burger Doodle

Question # 00017521 Posted By: spqr Updated on: 06/13/2014 07:53 AM Due on: 06/30/2014
Subject Mathematics Topic General Mathematics Tutorials:
Question
Dot Image
The manager of a Burger Doodle franchise wants to determine how many sausage biscuits and ham biscuits to prepare each morning for breakfast. The two types of biscuits require the following resources.

Biscuit Labor (hr.) Sausage (lb) Ham (lb) Flour (lb)
Sausage 0.010 0.10 ------- 0.04
Ham 0.024 ------- 0.15 0.04

The franchise has 6 hours of labor available each morning. The Manager has a contract with a local grocer for 30 pounds of sausage and 30 pounds of ham each morning. The manager also purchases 16 pounds of flour. The profit for a sausage biscuit is $0.60; the profit for a ham biscuit is $0.50. The manager wants to know the number of each type of biscuit to prepare each morning in order to maximize profit.

Part 1) Formulate a linear programming model for this problem.

Use (solver) in excel for the (answers, sensitivity and limits reports) as well.

Solve the linear programming model developed in the above problem for the Burger Doodle restaurant by using the computer.

a) Identify and explain the shadow prices for each of the resource constraints.

b) Which of the resource constraints profit the most and why?

c) Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausage available. Explain the sensitivity ranges.
Dot Image
Tutorials for this Question
  1. Tutorial # 00016935 Posted By: neil2103 Posted on: 06/13/2014 07:55 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Linear programming for Burger Doodle...
    Attachments
    Statistics_and_Probability_(1).doc (268 KB)
    Statistics_and_Probability.xls (24 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    sm...s1 Rating Flexible and instant services 09/07/2015

Great! We have found the solution of this question!

Whatsapp Lisa