Reference no: EM13836381
XYZ Foods Inc. has a contract to produce 3000 pounds of trail mix for a convention. Ingredients available and cost per pound are peanuts ($2.50), raisons ($2.25), dried bananas ($1.50), dried cranberries ($3), and pretzel sticks ($1). There are 1000 pounds of peanuts available, 1400 pounds of pretzel sticks, 460 pounds of raisons, 400 pounds of bananas, and 500 pounds of cranberries.
The mix should contain at least 25% peanuts and at most 50% pretzel sticks. Bananas must be at least 10% the mix and raisons + cranberries must be at least 15% of the mix.
The company wants to minimize the cost of producing the 3000 pounds of trail mix. The company also wants to be able to easily modify the model - such as to increase the 3000 pounds to 3200 pounds without having to modify a bunch of constraints. (so for example, for the maximum 50% pretzel sticks, do not just use X5<=1500 - write the constraint in terms of the other variables)
Create the required Linear Programming model, and solve using Lingo. Write a complete managerial report, using the format in your syllabus. In the results section, answer the following questions (please number your answers)
1. How many pounds of each ingredient should be used to minimize the total cost of producing 3000 pounds of the mix, and what is the total cost?
2. Are any of the reduced costs for any of the ingredients greater than 0? Interpret.
3. If XYZ can increase the amount of ingredient availability, which should they try to increase? Explain using the dual prices.
4. If we could change one of the minimum or maximum percentage constraints, which would lower the cost of the mix the most? Explain using the dual prices.
Submission instructions:
You are to submit a single word document using the assignment link. Do not send me lingo files! Copy and paste your lingo output to an appendix. Your document will consist of
1. A managerial report - using the format in your syllabus
2. Appendix A - your Linear Programming model
Appendix B - your Lingo output
|
Restrictions increase the stability of the banking system
: Why did the federal government until recently put restrictions on interstate banking? Did those restrictions increase the stability of the banking system? What are some events that have changed the ability of the banks in U.S. to branch between state..
|
|
Uses to exercise some control over the fed
: Why was the Federal Reserve System set up with twelve regional Federal Reserve Banks rather than one central bank, as in other countries? What is the primary tool that Congress uses to exercise some control over the Fed?
|
|
How many city-pairs does it serve
: A network carrier serves 39 spoke cities from a single hub. How many city-pairs does it serve? This same airline adds a 40th spoke city to its network using a 100 seat capacity aircraft. On a flight from this 40th spoke to the hub, how many passenger..
|
|
What are the profit-maximizing prices and quantities
: Duopolists A and B face the following demand curves: QA = 100 - 2PA + 5PB and QB = 120 - 3PB + 4PA. If both firms have zero marginal cost, what are the profit-maximizing prices and quantities?
|
|
Which would lower the cost of the mix the most
: How many pounds of each ingredient should be used to minimize the total cost of producing 3000 pounds of the mix, and what is the total cost? Are any of the reduced costs for any of the ingredients greater than 0? Interpret. If XYZ can increase the ..
|
|
Who want to go into law school or pursue
: For those of you who want to go into Law School or pursue a Master's degree in CJ this will give you some insight for looking up a case and understanding the background of the case
|
|
Utility function-non-labour income decreased
: Woody's utility function is U(C, R)= C- (12-R)^2, where C is his consumption and R is the amount of leisure he has per day. He has 16 hours a day to divide between work and leisure. He has an income of 20$ a day from non-labour sources. If Woody can ..
|
|
Discuss benefit and challenge in an aging working population
: Discuss the benefits & challenges in an aging working population. Specifically identify here (3) indirect health effects and three (3) direct health effects associated with an aging workforce.
|