Question: 5 ) [ 3 0 points ] You have decided to entry the candy business. You are considering producing two candies: Slugger candy and Easy
points You have decided to entry the candy business. You are considering producing two candies: Slugger candy and Easy Out candy, both of which consist solely of sugar, nuts, and chocolate. At present, you have in stock ounces of sugar, ounces of nuts, and ounces of chocolate. The mixture used to make Easy Out must contain at least nuts. The mixture used to make Slugger candy must contain at least nuts and at least chocolate. Each ounce of Easy Out candy can be sold for $ and each ounce of Slugger candy can be sold for $
a points Determine how you can maximize your revenue from candy sales.
b points Use SolverTable to determine how changes in the amount of sugar available change the optimal amount of Slugger produced, the optimal amount of Easy Out produced and the optimal total revenue. In particular, let the amount of sugar available vary from ounces to ounces in increments of ounces and track the changes in the optimal amounts of Slugger and Easy Out produced and the optimal total revenue. Components in the model: Inputs should beblueDecision variablesredTarget cellgreyand use constraints like
and please answer all questions using Microsoft excel, solver, and a model.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
