Question: PLEASE FILL OUT EXCEL FORM that is presented Problem 3. You have decided to enter the candy business. You are considering producing two types of
PLEASE FILL OUT EXCEL FORM that is presented
Problem 3. You have decided to enter the candy business. You are considering producing two types of 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 candy must contain at least 20% nuts . The mixture used to make Slugger candy must contain at least 10% nuts and 10% chocolate. Each ounce of Easy Out candy can be sold for $1.20, and each ounce of Slugger candy for $1.40. Create a model to determine how to maximize your revenue from candy sales. Selling price of candies (per ounce) Slugger Easy Out Available Production plan (amounts of inputs into each candy) Slugger Easy Out Total used Sugar Nuts Chocolate Produced Nut lower bounds Slugger Easy Out 10% 20% Chocolate lower bound Slugger 10% Nut constraints Chocolate constraint Slugger Easy Out Slugger Actual totals Required Total revenue Please solve in EXCEL and show all formulas, thank you
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
