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.InputsGreen BarSuper Bar Constraints: Amounts availableProfit ($/pack)To be Filled InTo be Filled In To be Filled In≤ To be Filled InProtein (cups/pack)To be Filled InTo be Filled In To be Filled In≤ To be Filled InWheat (cups/pack)To be Filled InTo be Filled In Decision Variables (integer) Amount to produceTo be Filled InTo 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! A1 Wave Nutrition23 Inputs4 Profit ($/pack)5 Protein (cups/pack)6 Wheat (cups/pack)78 Decision Variables (INTEGER)9 Amount to produce1011 Output (Total Profit)121314152526B2728293031323334353637Green Bar$90.005611сSuper Bar$120.0010818D$98.00=+SUMPRODUCT(B9:C9,B7:C7)E50481716 Wave Nutrition is a small campus shop that offers two house-made protein bars: GreenBar and Super Bar. Each bar requires protein and wheat.181920 Currently, Wave Nutrition has 50 cups of protein and 48 cups of wheat available. A21 pack of Green Bar uses 5 cups of protein and 6 cups of wheat. A pack of Super Bar uses22 10 cups of protein and 8 cups of wheat.23Green Bar has a profit of $90 per pack; Super Bar has a profit of $120 per pack.24Constraints: Amounts availableŚ50s48F=+SUMPRODUCT(B6:C6, B9:C9)Complete this template and use Solver to determine the optimal production of GreenBar and Super Bar packs that maximizes Wave Nutrition's profit? Assume thateverything produced will be sold.Solver ParametersSet Objective:To:G• MaxBy Changing Variable Cells:$B$9:$C$9Subject to the Constraints:$B$4 = 90SBS9:SCS9 integerSCS4 = 120SESS:SES6 SGS5:SGS6Select a SolvingMethod:O MinHelpHGreen BarSuper BarSB$12Make Unconstrained Variables Non-NegativeSimplex LPO Value Of:0KSolveAddChangeDeleteReset AllLoad/SaveSolving MethodSelect the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LPSimplex engine for linear Solver Problems, and select the Evolutionary engine for Solverproblems that are non-smooth.OptionsCloseL

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!

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

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!

A
1 Wave Nutrition
2
3 Inputs
4 Profit ($/pack)
5 Protein (cups/pack)
6 Wheat (cups/pack)
7
8 Decision Variables (INTEGER)
9 Amount to produce
10
11 Output (Total Profit)
12
13
14
15
25
26
B
27
28
29
30
31
32
33
34
35
36
37
Green Bar
$90.00
5
6
11
с
Super Bar
$120.00
10
8
18
D
$98.00=+SUMPRODUCT(B9:C9,B7:C7)
E
50
48
17
16 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.
18
19
20 Currently, Wave Nutrition has 50 cups of protein and 48 cups of wheat available. A
21 pack of Green Bar uses 5 cups of protein and 6 cups of wheat. A pack of Super Bar uses
22 10 cups of protein and 8 cups of wheat.
23
Green Bar has a profit of $90 per pack; Super Bar has a profit of $120 per pack.
24
Constraints: Amounts available
Ś
50
s
48
F
=+SUMPRODUCT(B6:C6, B9:C9)
Complete this template and 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.
Solver Parameters
Set Objective:
To:
G
• Max
By Changing Variable Cells:
$B$9:$C$9
Subject to the Constraints:
$B$4 = 90
SBS9:SCS9 integer
SCS4 = 120
SESS:SES6 SGS5:SGS6
Select a Solving
Method:
O Min
Help
H
Green Bar
Super Bar
SB$12
Make Unconstrained Variables Non-Negative
Simplex LP
O Value Of:
0
K
Solve
Add
Change
Delete
Reset All
Load/Save
Solving Method
Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP
Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver
problems that are non-smooth.
Options
Close
L

Expert Solution

Step 1

Given-

$W a v e N u t r i t i o n h a s 50 c u p s o f p r o t e i n a n d 48 c u p s o f w h e a t a v a i l a b l e . A p a c k o f G r e e n B a r u s e s 5 c u p s o f p r o t e i n a n d 6 c u p s o f w h e a t . A p a c k o f S u p e r B a r u s e s 10 c u p s o f p r o t e i n a n d 8 c u p s o f w h e a t . G r e e n B a r h a s a p r o f i t o f $ 90 p e r p a c k S u p e r B a r h a s a p r o f i t o f $ 120 p e r p a c k$