Busch Gardens Sweets is preparing for Spring Break. They prepare two sizes of Peanut and Raisin...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Busch Gardens Sweets is preparing for Spring Break. They prepare two sizes of Peanut and Raisin Delight and need to calculate how many bags of deluxe and standard mixes they can produce. The deluxe mix takes 1 pound of raisins and 0.6 of a pound of peanuts. The standard mix takes 0.5 of a pound of raisins and 0.4 of a pound of peanuts. The shop has 90 pounds of raisins and 60 pounds of peanuts. The profit on the deluxe mix is $3.20 and the standard mix profit is $2.50. The owner wants no more than 100 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 ; a. The optimal number of Deluxe Mix to prepare (15 points). b. The optimal number of Standard Mix to prepare (15 points). c. What is the optimal profit? Include the formula using actual numeric values, NOT cell location. (25 points) d. How many pounds of raisins are needed to achieve optimal profit? (15 points) e. How many pounds of peanuts are needed to achieve optimal profit? (15 points) f. If the profit on the deluxe bags was increased to $4, would the number of deluxe bags increase or decrease? By how many? (15 points) Busch Gardens Sweets is preparing for Spring Break. They prepare two sizes of Peanut and Raisin Delight and need to calculate how many bags of deluxe and standard mixes they can produce. The deluxe mix takes 1 pound of raisins and 0.6 of a pound of peanuts. The standard mix takes 0.5 of a pound of raisins and 0.4 of a pound of peanuts. The shop has 90 pounds of raisins and 60 pounds of peanuts. The profit on the deluxe mix is $3.20 and the standard mix profit is $2.50. The owner wants no more than 100 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 ; a. The optimal number of Deluxe Mix to prepare (15 points). b. The optimal number of Standard Mix to prepare (15 points). c. What is the optimal profit? Include the formula using actual numeric values, NOT cell location. (25 points) d. How many pounds of raisins are needed to achieve optimal profit? (15 points) e. How many pounds of peanuts are needed to achieve optimal profit? (15 points) f. If the profit on the deluxe bags was increased to $4, would the number of deluxe bags increase or decrease? By how many? (15 points)
Expert Answer:
Answer rating: 100% (QA)
To solve this problem using Excel Solver follow these steps a S... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date:
Students also viewed these accounting questions
-
Eagle Stationery & Supplies Company sells jumbo highlighters at $160 per highlighter. The costs associated with each highlighter are as follows: Direct materials $65 Direct labour $42 Variable...
-
For the element with stresses as shown below, find: a. The magnitudes and directions of major and minor principal stresses b. The shear and normal stresses acting on a horizontal plane as shown below...
-
A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe mix and how many bags of standard mix of Peanut/Raisin Delite to put up. The deluxe mix has 2/3...
-
Consider a static (one-period), closed economy with one representative consumer, one rep- resentative firm, and a government. The level of capital K and government expenditures G in the economy are...
-
In the commercial preparation of aluminum, aluminum oxide, Al2O3, is electrolyzed at 1000C. (The mineral cryolite is added as a solvent.) Assume that the cathode reaction is Al3+ 3e Al How many...
-
Accusport Inc. has decided to expand its operations to owning and operating golf courses. The following is an excerpt from a conversation between the chief executive officer, Tucker Thorup, and the...
-
Compute payback period-unequal cash inflows (Learning Objective 2) Refer to the Allegra Data Set. Calculate the DVR project's payback period. If the DVR project had a residual value of \(\$...
-
Game Depot is a retail store selling video games. Sales are uniform for most of the year but pick up in June and December both because new releases come out and because consumers purchase games in...
-
Help? Attachment below Cv c v h b b b n n n n n be b n bob b b b b n j j j j j. J j I I I I. J j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j h h h he hh h h h h h h h h h h h h h h h h...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Weber Company purchased a mining site for $500,000 on July 1, 2009. The company expects to mine ore for the next 10 years and anticipates that a total of 100,000 tons will be recovered. The...
-
Discuss two examples of how research and development (R&D) is enabling green and/or sustainable manufacturing of engineering products.
-
What do you understand by the term "labour incentive"? Explain how Rowan Plan of computing labour incentives is different from Taylor's Differential Piece rate System. Discuss how a worker will gain...
-
1.A business sells one product.The product sells for $300 per unit and the variable costs are $210 per unit.The fixed costs are $900,000.The business expects sales revenue of $4,000,000. Calculate...
-
At the end of September 201X, investor Paul has a $25 million bond portfolio that he can only sell in two months. He wants to protect his portfolio against interest rate risk by November 30, 201X. In...
-
Directions: Evaluate the logarithms. log, 243 log, 343 log 16 4 log 16
-
Condren Incorporated reported the following results from lastyear's operations: Sales Variable expenses Contribution marginFixed expenses Net operating income Average operating assets At thebeginni 2...
-
What do you think?
-
Lower of Cost and Net Realizable Value} OBJECTIVE 5 Garcia Company's inventory at the end of the year was recorded in its accounting records at \(\$ 17,800\). Due to technological changes in the...
-
The stockholders equity section of Waterbury Linen Mills, Inc., as of December 31, 20x6, was as follows: A review of the stockholders equity records of Waterbury Linen Mills, Inc., disclosed the...
-
When Yahoo! Inc. reported in early 2004 that its first quarter earnings had doubled from the previous year, its stock price jumped 10 percent to $53 per share. At the same time, the company announced...
Study smarter with the SolutionInn App