Wave Nutrition is a small campus shop that offers two house-made protein bars: Green Bar and Super Bar. Each bar requires protein and wheat. Wave Nutrition has 50 cups of protein and 48 cups of wheat available. A pack of Green Bar uses 5 cups of protein and 6 cups of wheat. A pack of Super Bar uses 10 cups of protein and 8 cups of wheat. Green Bar has a profit of $90 per pack; Super Bar has a profit of $120 per pack. Use Solver to determine the optimal production of Green Bar and Super Bar packs that maximizes Wave Nutrition's profit. Assume that everything produced will be sold. Inputs Green Bar Super Bar Constraints: Amounts available Profit ($/pack) To be Filled In To be Filled In To be Filled In ≤ To be Filled In Protein (cups/pack) To be Filled In To be Filled In To be Filled In ≤ To be Filled In Wheat (cups/pack) To be Filled In To be Filled In Decision Variables (integer) Amount to produce To be Filled In To be Filled In Output (Total Profit) Answer: To be Filled In Please replicate the above image/template in excel (colors and formatting don't matter) and paste a picture of the Solver window you used to solve for "Total Profit" (the solution the question is after). For the "constraints box" you can switch the sign if it is more convenient. I will post what I have as my answer, but I am not confident and would like help - thanks!
Wave Nutrition is a small campus shop that offers two house-made protein bars: Green Bar and Super Bar. Each bar requires protein and wheat.
- Wave Nutrition has 50 cups of protein and 48 cups of wheat available.
- A pack of Green Bar uses 5 cups of protein and 6 cups of wheat.
- A pack of Super Bar uses 10 cups of protein and 8 cups of wheat.
- Green Bar has a profit of $90 per pack; Super Bar has a profit of $120 per pack.
Use Solver to determine the optimal production of Green Bar and Super Bar packs that maximizes Wave Nutrition's profit. Assume that everything produced will be sold.
Inputs | Green Bar | Super Bar | Constraints: Amounts available | ||||
Profit ($/pack) | To be Filled In | To be Filled In | To be Filled In | ≤ | To be Filled In | ||
Protein (cups/pack) | To be Filled In | To be Filled In | To be Filled In | ≤ | To be Filled In | ||
Wheat (cups/pack) | To be Filled In | To be Filled In | |||||
Decision Variables (integer) | |||||||
Amount to produce | To be Filled In | To be Filled In | |||||
Output (Total Profit) | |||||||
Answer: | To be Filled In |
Please replicate the above image/template in excel (colors and formatting don't matter) and paste a picture of the Solver window you used to solve for "Total Profit" (the solution the question is after). For the "constraints box" you can switch the sign if it is more convenient. I will post what I have as my answer, but I am not confident and would like help - thanks!
Given-
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images