Reference no: EM131151658
Jimbo Mountain Winery blends fine wines for local restaurants. One of its customers has requested a special blend of two burgundy wines, call them A and B. The customer wants 500 gallons of wine and it must contain at least 100 gallons of A and be at least 45% B. The customer also specified that the wine have an alcohol content of at least 12%. Wine A contains 14% alcohol while wine B contains 10%. The blend is sold for $10 per gallon. Wine A costs $4 per gallon and B costs $3 per gallon. The company wants to determine the blend that will meet the customer's requirements and maximize profit.
a. Create an EXCEL spreadsheet of LP model showing attention to both accuracy and presentation
b. Use Analytic Solver Platform to verify graphical solution (b). Explain comparison—anything different?
c. Create Answer report [use report to answer following questions]
1. Which constraints are binding?
2. Which constraints show slack?
c. Create a Sensitivity Report; perform an analysis by answering questions below.
1. Is the optimal solution degenerate? Explain why or why not.
2. Is the optimal solution unique? If not, identify an alternate optimal solution for the problem.
3. What is the highest value the objective function coefficient X1 can assume without changing the optimal solution?
4. Will the current solution remain optimal if a binding constraint is increased by 5 percent? Identify and analyze the chosen constraint and Explain.
|
Describe the main advantages the flipkart
: Flipkart is an Indian eCommerce giant. Describe the main advantages the Flipkart or similar eCommerce companies have over their Brick-and-Mortar (physical presence business) competitors. Describe 4-5 ways Flipkart may be pricing its products differen..
|
|
Explain the company product marketing strategy
: A company makes seasonal merchandises that are initially sold at premium prices at its retail stores. During the season it announces “sales” several times and reduces the prices by 10-20% each time. Finally, it sells the remaining products at 60-80% ..
|
|
Explain the need to control knowledge in any organization
: Explain the need to control “Knowledge” in any organization. Describe various areas of the knowledge that needs to be controlled. Consider an example of a business in an industry vertical other than IT/Computers, and describe how the “knowledge manag..
|
|
Manufacturing chemicals for other industries
: Consider a company with a global presence that is manufacturing chemicals for other industries and household applications. The company wants to develop a new chemical product for industrial applications. The Engineering Manager in this company need t..
|
|
Create a sensitivity report
: Jimbo Mountain Winery blends fine wines for local restaurants. One of its customers has requested a special blend of two burgundy wines, call them A and B. The customer wants 500 gallons of wine and it must contain at least 100 gallons of A and be at..
|
|
Required safety stock inventory
: Using the Wal-Mart DemoPreview the documentView in a new window, what happens to the Required Safety Stock inventory when the periodic review interval is changed to quarterly, i.e., 12 weeks versus 4 weeks? What happens when it is changed to weekly, ..
|
|
Defend others rights to justice-freedom and opportunity
: At what stage do people identify with people different than themselves and start to defend others rights to justice, freedom and opportunity (The Bill of Rights)? Can you provide an example of someone or a group that has defended other peoples rights..
|
|
What is the business model for MOOCs
: What is the business model for MOOCs? What should a business school do to adapt? what are the options? what are the threats and opportunities for a text publisher like Wiley? What changes will they have to make to be relevant?
|
|
What role does the federal open market committee
: The monetary system in any economy facilitates trade and allows people to trade more efficiently, as compared to a barter economy. What are the requirements for something to be considered money? Why does the dollar have value? What does the money sup..
|