We can use excel solvar to set up the linear programming problem as shown -
Then set up the solver as shown -
Note that you can access 'Solver' from 'Data' tab as shown above.
This should give you following output -
X = 90 and Y = 75.
Thus, maximum profit = Z = 3(90) + 2(75)
= $420
Now, if you want only diet alternative profit, so set X = 0, to set up the LP as -
Now, this would give you the output -
X | Y | ||
0 | 120 | ||
Profit | 0 | 240 | 240 |
T | 0 | 240 | 240 |
S | 0 | 360 | 360 |
So, you produce 120 cases of diet coke which gives you a maximum profit of -
Z = 240
Thus, last option is correct.
_____________________________
Use the following information to answer the next few questions: The production manager for the Coory...
MC Qu.60 The operations manager for the Blue Moon Brewing... The operations manager for the Blue Moon Brewing Co. produces two beers: Lite (L) and Dark (D). Two of his resources are constrained: production time, which is limited to 8 hours (480 minutes) per day, and malt extract (one of his ingredients), of which he can get only 675 gallons each day. To produce a keg of Lite beer requires 2 minutes of time and 5 gallons of malt extract,...
1. (32 pts, total) Use the following information for the next 6 questions. The "rushing fireball" is a motile prokaryote. It was originally isolated from a marine (ocean) environment. It does not fix carbon dioxide. It uses sugars and proteins as sources of energy, and it can oxidize elemental sulfur (S) or organic compounds for metabolism. It has a single cellular membrane surrounded by protein only. A graph comparing generations/doublings per day (vertical axis) with temperature (horizontal axis in degrees...
Case Study for Care Plan Assignment: fill each attached column with its appropriate answer, use the below scenario. A retired 69-year-old man "Mr. Casey" with a 5-year history of type 2 diabetes. Although he was diagnosed 5 years ago he had symptoms indicating hyperglycemia for 2 years before diagnosis. His fasting blood glucose values of 118–127 mg/dl, which was explained to him as “borderline diabetes.” He also states he has had past episodes of nocturia with large pasta meals and...
Case Study for Care Plan Assignment: fill each attached column with its appropriate answer, use the below scenario. A retired 69-year-old man "Mr. Casey" with a 5-year history of type 2 diabetes. Although he was diagnosed 5 years ago he had symptoms indicating hyperglycemia for 2 years before diagnosis. His fasting blood glucose values of 118–127 mg/dl, which was explained to him as “borderline diabetes.” He also states he has had past episodes of nocturia with large pasta meals and...
Case Study for Care Plan Assignment: fill each attached column with its appropriate answer, use the below scenario. A retired 69-year-old man "Mr. Casey" with a 5-year history of type 2 diabetes. Although he was diagnosed 5 years ago he had symptoms indicating hyperglycemia for 2 years before diagnosis. His fasting blood glucose values of 118–127 mg/dl, which was explained to him as “borderline diabetes.” He also states he has had past episodes of nocturia with large pasta meals and...
Case Study for Care Plan Assignment: fill each attached column with its appropriate answer, use the below scenario. A retired 69-year-old man "Mr. Casey" with a 5-year history of type 2 diabetes. Although he was diagnosed 5 years ago he had symptoms indicating hyperglycemia for 2 years before diagnosis. His fasting blood glucose values of 118–127 mg/dl, which was explained to him as “borderline diabetes.” He also states he has had past episodes of nocturia with large pasta meals and...
Read about Cokes strategy in Africa in the article below and discuss the ethics of selling soft drinks to very poor people. Is this an issue that a company like Coke should consider? Africa: Coke's Last Frontier Sales are flat in developed countries. For Coke to keep growing, Africa is it By Duane Stanford Piles of trash are burning outside the Mamakamau Shop in Uthiru, a suburb of Nairobi, Kenya. Sewage trickles by in an open trench. Across the street,...
1. Which of the following is not considered a nutrient a Vitamin B. Water c.Carbohydrate (d) Alcohol e Mineral 2. For which of the following causes of death does a person's diet play a part? a. Lung disease (6) Cancer Chronic lower respiratory diseases d. Infections of the blood e AIDS 3. Researchers repeatedly report that people who consume a variety of foods such as fruits, vegetables, legumes, nuts, and whole grains have reduced risks of which of the following...
Please use own words. Thank you. CASE QUESTIONS AND DISCUSSION > Analyze and discuss the questions listed below in specific detail. A minimum of 4 pages is required; ensure that you answer all questions completely Case Questions Who are the main players (name and position)? What business (es) and industry or industries is the company in? What are the issues and problems facing the company? (Sort them by importance and urgency.) What are the characteristics of the environment in which...
SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the company's new line of single-serve coffee pods or to await results from the product's launch in the United States. Key strategic decisions include choosing the target market to focus on and determining the value proposition to emphasize. Important questions are also raised in regard to how the new product should be branded, the flavors to offer, whether Kraft should use traditional distribution channels or...