Reference no: EM131947250
Each season, MALT-UP Mountain Brewers blends micro brews for their retail membership. For a concession client prepaid for a upcoming rodeo, the Brewers were asked to create a special brew of two malt blends, Chesty nut and Bronco brew, customer wants 500 gallons of brew, which must contain at least 45% of Chest nut and at least 100 gallons Bronco-brew, customer also specified that the blend have an alcohol content of ate least %6. Chesty nut contains 10% alcohol while Bronco-brew contains 4%.
The blend is sold for $10 per gallon. Chesty nut costs $4 per gallon and Bronco brew costs $3 per gallon company wants to determine the blend that will meet the customer's requirements and maximize profit.
a. Using the 5 step LP model process chapter 2, formulate the LP model for this problem.
b. Solve the problem using the graphical method. What is optimal solution?
c. Create an Excel spreadsheet of LP model showing attention to both accuracy and presentation.
d. Use Analytic Solver platform to verify graphical solution
e. Explain comparison anything different?
d. Create Answer report (use report to answer following questions). Which constraints are binding? Which constraints show slack?
f. Create a Sensitivity Report; perform an analysis by answering questions below.
Is the optimal solution degenerate? Explain why or why not. Is the optimal solution unique? If not, identify an alternate optimal solution for the problem.
What is the highest value the objective function coefficient X_1 can assume without changing the optimal solution?
Will the current solution remain optimal if a binding constraint is increased by 5 percent? Identify and analyze the chosen constraints and Explain.
|
Display a pyramid of asterisks onscreen
: This week, you will apply what you learned in analyzing for, while, and do-while loops by writing these statements yourself. The JavaTM program
|
|
Would the bank change its decision
: Using the factor scoring (rating) method as we learned in class, which site should Security National Bank use based on the above information?
|
|
Compute the acquisition cost of each intangible asset
: Compute the acquisition cost of each intangible asset. Compute the amortization of each intangible for the current year ended December 31.
|
|
Defending against web application exploitation
: Create a plan detailing steps that should be taken to defend against SQL injection exploitation within Web applications.
|
|
Create an excel spreadsheet of lp model showing attention
: Create an Excel spreadsheet of LP model showing attention to both accuracy and presentation. Use Analytic Solver platform to verify graphical solution .
|
|
Experienced the impact of globalization-digital technologies
: However it is fair to say that each of us have experienced the impact of globalization and digital technologies.
|
|
Determine what will the account balance be
: If Bob and Judy combine their savings of $1,000 and $900, respectively, and deposit this amount into an account that pays 3% annual interest, compounded monthly
|
|
Game a sequential or simultaneous game
: What kind of game is that, is the game a sequential or simultaneous game? Is it a game of trust, mass coordination, prisoners' dilemma, etc.?
|
|
What would net income and return on assets
: What would net income and return on assets (investment) be for the year?
|