Question: 5 ) [ 3 0 points ] You have decided to entry the candy business. You are considering producing two candies: Slugger candy and Easy

5)[30 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 10,000 ounces of sugar, 2000 ounces of nuts, and 3000 ounces of chocolate. The mixture used to make Easy Out must contain at least 20% nuts. The mixture used to make Slugger candy must contain at least 10% nuts and at least 10% chocolate. Each ounce of Easy Out candy can be sold for $1.20, and each ounce of Slugger candy can be sold for $1.40.
a)[25 points] Determine how you can maximize your revenue from candy sales.
b)[5 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 6000 ounces to 14,000 ounces in increments of 1000 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 be(blue),Decision variables(red),Target cell(grey),and 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!