Please answer question 2 Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it. Click onthe image icon below and upload your screenshot file. Make sure it is big enough to read Question 1. Busch Gardens Sweets is preparing for the Halloween rush. They prepare two sizesof Peanut/Raisin Ghoulish Delight and need to calculate how many bags of deluxe and standardmixes 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 nomore than 110 bags of each type prepared.Do not forget the non-negativity constraint and remember that you cannot sell partialbags (whole numbers only).Use Excel Solver (as demonstrated in the lecture) to determine the followinga. The or timal number of Deluxe Mix toprepare.b. The optimal number of Regular Mix toprepare.c. What is the optimal profit?d. How many pounds of raisins are needed toachieve optimal profit?

A linear objective function can be optimized using the linear programming (LP), also known as linear…

Answered: Question 2. Take a screenshot (snip…

Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it. Click on the image icon below and upload your screenshot file. Make sure it is big enough to read

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Q: . (Scenario Based Question - Customer )"Good fternoon, I need to speak to a manager now, can omeone…

A: The direct line of communication involving your customers and your organization is customer service.…

Q: AM plc has a 'produce or perish' style of management. Analyse how this may have caused the…

A: Management style refers to the methodology, attitude, and conduct embraced by a supervisor or…

Q: 4. Calculate the late finishing time (backwards calculations) 5. Calculate the slack time of the…

A: Formula:

Q: What would the ROI be when using a self-service kiosk in a hotel?

A: Meaning of ROI in the hotel industry- This is where the idea of ROI or return on investment of your…

Q: Cornell method example

A: Taking notes is of the best practices followed by people at various stages for various purposes.…

Q: Give reason that why do waiting lines form even though a service system is underloaded.

A: Client care is the help you give to your buyers previously, during, and after they buy and use your…

Q: Please asnwer with your own words please use own example Question 2: Explain 'Right…

A: Channel Management: The term Channel Management is generally utilized in deals marketing or…

Q: In comparison to low-contact service models, what distinguishes high-contact models?

A: Services that have very little or no interaction between the customer and the service provider are…

Q: Question 6 Answer Question 8-10 based on the given information. Willow Brook National Bank operates…

A: Answer 6: The mean or expected number of customers that will arrive in ten minutes is 3 customers.…

Q: Which assumptions are necessary to employ the formulas given for Model 1?

A: Model one consists of a single server to serve infinite population that is distributed randomly in…

Q: What does it mean when the stopping issue is intractable?

A: In the field of computer science, stopping difficulties are challenges that occur when attempting to…

Q: a. Create a set of linear equations to describe the objective function and the constraints. b. Use…

A: Linear programming is a mathematical technique that is also used in operations management…

Q: Which of the following activities does not belong to the point-of-service stage? a) Clinical…

A: A point-of-service plan relates to a health insurance plan in which various benefits are being…

Q: Question 6. Transit Privilege/Stop-Off Service You operate a major distribution center in Seattle,…

Q: Shouldice Hospital in Canada is widely known for one thing-hernia repair! In fact, that is the only…

A: Number of bed in the hospital78Number of full-time surgeons12Number of part-time assistant…

Q: Question 2: From studying the local real estate market in the past few years, you observe that on…

A: The local real estate market is a key indicator of economic activity in a particular area, and…

Q: 5. (Scenario Based Question) Your response to Simeon's phonecall: Hello, I need to speak to a…

A: Customers feel secure using email because they have a written record of all exchanges that they can…

Q: a. Compute labor productivity under each system. Use carts per worker per hour as the measure of…

A: Let me state the given data, Before buying the new equipment:Number of workers =5Production = 80…

Question

Please answer question 2

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
a. The or timal 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?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Linear Programming Model:

VIEW

Step 2: Linear Programming Model Formulation:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Question 14 Which is NOT a characteristic of a service? Group of answer choices a. Services are intangible b. Services usually cannot be resold c. Services are easily transported d. Ownership of services usually is not transferred e. Services usually cannot be stored
(Revenue Mgmt) Donut Shop Donna's Delicious Donuts (DDD) produces 380 donuts each morning. There are 3 flavors of glaze Donna coats the donuts with: Regular Glaze, Chocolate Glaze, and Blueberry Glaze. Tommy of Tommy's Terrific Tours (TTT) called Donna and said he wants to bring his tour bus by DDD at 11:00am tomorrow. Normally, DDD has sold out of donuts by 11:00am, but Donna told Tommy she would hold back at least 30% of all donuts made that morning until the tour bus arrived. In addition, she said she would give tour customers a 20% discount off of the regular price. Donna has only enough blueberry glaze on hand to make 90 blueberry glaze donuts.lq 100 The table below shows the prices and maximum demand for the different options. Develop and solve an LP model to maximize revenues for DDD on the day the tour bus arrives. (Include Ranges.) What is her maximized amount of revenues? How many total regular glaze, chocolate glaze, and blueberry glaze donuts will she make? How many regular…
Ee 264.
5. (Scenario Based Question) Your response to Diego's Message via Monzo In-App Chat O Diego is a Spanish national who wants to open a Monzo account. They have started a chat with us in the app after their sign up has been rejected due to entering an overseas address. "I'm moving to the UK to study in 2 weeks. I need to open this account now so that I can receive payments from family in the UK and set bills up for when I arrive. If you can't do that, l'll be completely stuck with no money when T arrive!" (Write your response to the customer as if you were a COp at Monzo talking to Diego on our In-App Chat, for example "Hi Diego..."). See all of the information you need to write your answer to this question here
Who are the external customers using self-service kiosk in a hotel?
The answer to the question is incorrect
A small popular restaurant at an interstate truck stop provides priority service to truckers. The restaurant has ten tables where customers may be seated. The service time averages 40 minutes once a party is seated. The customer arrival rate is 12 parties per hour, with the parties being equally divided between truckers and non-truckers.On average, how many parties of truckers are waiting to be seated? Question 1 options: 0.27. 0.52. 0.88. 1.36. 1.75.