Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Michaels Chocolates Stock Plan, Big Box Store Singles 6-Packs 12-Packs Profit per Item $0.08 $0.45 $0.88 Space Taken in Square Feet 0.0625 0.4 0.75 Optimal
Michaels Chocolates Stock Plan, Big Box Store | |||||
Singles | 6-Packs | 12-Packs | |||
Profit per Item | $0.08 | $0.45 | $0.88 | ||
Space Taken in Square Feet | 0.0625 | 0.4 | 0.75 | ||
Optimal Number of Each Item | 50 | 48 | 30 | ||
Totals | |||||
Total Profit per Item | $4.00 | $21.80 | $26.40 | $52.20 | |
Total Space per Item in Square Feet | 3 | 19 | 23 | 45 | 45 |
Display constrainst | 50 | 30 | 30 | ||
<= | >= | >= |
Scenario Summary | |||||
Current Values: | Maximize Profi 1 | Maximize Profit 2. | |||
Changing Cells: | |||||
$B$8 | 50 | 50 | 50 | ||
$C$8 | 48 | 30 | 48 | ||
$D$8 | 30 | 40 | 30 | ||
Result Cells: | |||||
$E$10 | $52.20 | $52.55 | $52.20 | ||
Notes: Current Values column represents values of changing cells at | |||||
time Scenario Summary Report was created. Changing cells for each | |||||
scenario are highlighted in gray. |
Using this data what information might i suggest to the company to maximize profit without raising prices? I can I use scenario to make my point?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started