Reference no: EM13964954
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.
https://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.
|
How are the two variables mathematically related
: Using the data in the table calculate the regression equation, including the slope and intercept terms, R squared, and the SE of the regression (SE of the estimate).
|
|
Variety of unpackaged dried fruit and nut items
: MixedNutsis a store that sells a variety of unpackaged dried fruit and nut items. The current amounts of supplies of each item are listed in the following table:
|
|
A jeans manufacturer operates twin plants-
: A jeans manufacturer operates twin plants- one in Juarez, Mexico and the other in El Paso, Texas. The Juarez plant cuts fabric for the jeans, and the El Paso plant assembles the pieces into finished jeans. In a given year, the Juarez plant ships $40 ..
|
|
What is one advantage of running a logit regression
: Which of the two specifications fits the data better? How can you tell? What is one advantage of running a logit regression instead of estimating a linear probability model with OLS?
|
|
Problem regarding the resource constraints profit
: a) Identify and explain the shadow prices for each of the resource constraints. b) Which of the resource constraints profit the most and why?
|
|
The game is simultaneous because the goalie
: The game is simultaneous because the goalie must choose before seeing where the kick is going. Here's a matrix - assume the values are payoffs for the kicker for doing one thing and for the goalie doing another (like they're probabilities of beating..
|
|
A production function only uses one input labor
: A production function with constant returns to scale can exhibit diminishing marginal product of its inputs.Suppose a production function only uses one input, labor. If production displays constant returns to scale, then it does not exhibit diminish..
|
|
Arizona plumbing-widgetco
: Arizona Plumbing, which makes, among other products, a full line of bathtubs must decide which of its factories should supply which of its warehouses.
|
|
Determine the specific volume of the mixture
: A psychrometer gives a wet bulb and a dry bulb temperature of 19.7°C and 25°C respectively. Solving the problem without the psychrometric chart determine
|