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

Similar questions

Methodology for scaning of exiting services?
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
Define Quality of Service (QoS) in the context of WANs.
(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.
1. what is private about the private box service? how does the service work?
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
Please give Service classification?
Who are the external customers using self-service kiosk in a hotel?
The answer to the question is incorrect
P1
(10 Points) Eat well is a small drive through fast food restaurant, staffed by anefficient employee John, is located in a super mall area. Customers arrive at thecounter at an average of one every 15 minutes, and the customer arrival followsa Poisson distribution. John takes at most 10 minutes to process each foodorder.a) What is average number of customer being served at any time?b) The expected number of customers waiting to be served.c) Compute the average time customer wait in the system.d) Compute the average time customer wait in the line.e) What percentage of time is John Idle?