Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how

image text in transcribed

Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizes of Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standard mixes they can produce. The deluxe mix takes 0.9 of a pound of raisins and 0.4 of a pound of peanuts. The standard mix takes 0.7 of a pound of raisins and 0.6 of a pound of peanuts. The shop has 100 pounds of raisins and 70 pounds of peanuts. The profit on the deluxe mix is $1.80 and the standard mix profit is $1.60. The owner wants no more than 110 bags of each type prepared. Do not forget the non-negativity constraint and remember that you cannot sell partial bags (whole numbers only). Use Excel Solver (as demonstrated in the lecture) to determine the following (60 points, 15 points each): a. The optimal number of Deluxe Mix to prepare. b. The optimal number of Regular Mix to prepare. c. What is the optimal profit? d. How many pounds of raisins are needed to achieve optimal profit?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Ricky W. Griffin

11th edition

111196971X, 978-1111969714

More Books

Students also viewed these General Management questions