Purchase Solution

Linear programming for Burger Doodle

Not what you're looking for?

Ask Custom Question

This must all be done in Excel. (Very Important) I have also put a link of an example problem for the first part. This how I would like it formatted. Please take a look at it for reference.
http://documents.saintleo.edu/docs/AVP/MBA550/MBA550_ch9.mp4

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.

Purchase this Solution

Solution Summary

The linear programming for Burger Doodle is examined. The two types of biscuits which are required for resources are provided.

Purchase this Solution


Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.