Reference no: EM13123542
Linear programming for Burger Doodle
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.
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.
|
Encourage economic growth for the typical firm
: Using the Internet, library and/or other resources, research and briefly explain 2-3 methods currently being used to encourage economic growth for the typical firm in Hong Kong and for the typical firm in Singapore.
|
|
Which employees within organization likely be good source
: Why might we want to develop these initial expectations prior to beginning our analytical procedures?
|
|
Graph and simultaneous equations
: Accurately and neatly graph and label each of the equations and estimate the point of intersection of the two lines.
|
|
Explain how does sarah have to include in her gross income
: Another client gave her a check for $750 on December 31, 2011, but after the bank had closed. Both the $500 and $750 checks cleared the next year. Explain how much does Sarah have to include in her gross income for 2011?
|
|
Which of the resource constraints profit the most and why
: Which of the resource constraints profit the most and why? Identify the sensitivity ranges for the profit of a sausage biscuit and the amount of sausage available. Explain the sensitivity ranges.
|
|
Find critical value using one tailed t test
: Suppose a one tailed t test is being applied to find out if the population mean is less than $120. The level of significance selected is 0.01 and 26 bank accounts were sampled.
|
|
Estimating the company future revenues
: Assume you are reviewing a company's annual report. In addition to actual revenues reported in the income statement, what other information disclosed would give you help in estimating this company's future revenues?
|
|
Draw marginal revenue and marginal cost curves
: Derive, and show on a table, Sony's total and marginal revenue for all possible output levels. From this, draw Sony's demand, marginal revenue and marginal cost curves
|
|
Determining linear function and distance
: If it is 300 miles from Chicago to St. Louis in a car traveling a constant speed of 60 mph, how do I write a linear function that expresses the distance to be traveled to reach St. Louis, s, as a function of time, t?
|