Sarah and her fiancé are planning for their wedding. Distribution of the number of guests coming to the party is normal with the mean 100 and the standard deviation 10. They need to determine how many guests to book for food from a caterer. The caterer makes the following charges: $50 for each guest that is booked in advance; $90 for each guest who is not booked in advance but shows up on the wedding day. The caterer does not offer any refund even if some booked guests may not show up. If Sarah and her fiancé book 90 guests in advance with the caterer, what is the probability of stock out? If Sarah and her fiancé book 100 guests in advance with the caterer, what is the expected number of meals to be wasted?

Sarah and her fiancé are planning for their wedding. Distribution of the number of guests coming to the party is normal with the mean 100 and the standard deviation 10. They need to determine how many guests to book for food from a caterer. The caterer makes the following charges: $50 for each guest that is booked in advance; $90 for each guest who is not booked in advance but shows up on the wedding day. The caterer does not offer any refund even if some booked guests may not show up. If Sarah and her fiancé book 90 guests in advance with the caterer, what is the probability of stock out? If Sarah and her fiancé book 100 guests in advance with the caterer, what is the expected number of meals to be wasted?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
Hello! I need help solving this with the NEWSVENDOR equation/model. I'm stuck :-( Sarah and her fiancé are planning for their wedding. Distribution of the number of guests coming to the party is normal with the mean 100 and the standard deviation 10. They need to determine how many guests to book for food from a caterer. The caterer makes the following charges: $50 for each guest that is booked in advance; $90 for each guest who is not booked in advance but shows up on the wedding day. The caterer does not offer any refund even if some booked guests may not show up. What is the optimal number of guests to book in advance? How much Sarah can save by booking the optimal quantity from a) in advance? What is the expected number of guests that will come to their wedding
Joe is selling Christmas trees to pay his college tuition.He purchases trees for $10 each and sells them for $25each. The number of trees he can sell is normally distributedwith a mean of 100 and standard deviation of 30. How manytrees should Joe purchase?
The interContinental Hotel at Tsim Sha Tsui has 100 total rooms available for Dec 31. There are two types of customers, business customers and leisure customers. InterContinental charges a high rate of $300/night and a low rate of $120/night. High-rate guests do not need pre-booking and has time flexibilities; low-rate guests need pre-booking. Assume business customers always take the high rate option and leisure customers always take the low rate option. Leisure customers always book far earlier before business customers and there are sufficient leisure customers. Which of the following actions would increase the optimal protection level for business customers? Increase both the high and low rates by a factor of two Decrease the high rate from $300 to $200 Decrease both the high and low rates by half O Decrease both the high and low rates by $20 O Increase both the high and low rates by $20
Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.
A hotel near the university always fills up on the evening before football games. History has shown that when the hotel is fully booked, the number of last-minute cancellations has a mean of 5 and standard deviation of 3. The average room rate is $130 and customers need to pay when they make the reservation. When the hotel is overbooked, its policy is to find a room in a nearby hotel and to pay for the room for the customer and this usually costs the hotel approximately $200 since rooms booked on such late notice are expensive. How many rooms should the hotel overbook?
13) Which of the following method is used for calculating Time value of Money? a. Future Value b. All of the options c. Annuity method d. Present value
An automotive warehouse stocks a variety of parts that are sold at neighborhoodstores. One particular part, a popular brand of oil filter, is purchased by thewarehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based on warehouse for $1.50 each. It is estimated that the cost of order processing andreceipt is $100 per order. The company uses an inventory carrying charge based ona 28 percent annual interest rate.The monthly demand for the filter follows a normal distribution with mean280 and standard deviation 77. Order lead time is assumed to be five months.Assume that if a filter is demanded when the warehouse is out of stock, then thedemand is back-ordered, and the cost assessed for each back-ordered demand is$12.80. Determine the following quantities:a. The optimal values of the order quantity and the reorder level.b. The average annual cost of holding, setup, and stock-out associated…
Boston Company use a special part in manufacturing of its finished products. The unit cost thisspecial part is $ 35, and details of its manufacturing cost is as follows. The $35 unit productcost of this part is based on average 25,000 number of parts produced each year.An outside supplier has offered to supply the 25,000 parts at a cost of $30 per part. The specialequipment used to manufacture the above part. This equipment can only be used formanufacturing of this part and if not used it has no resale value.The total amount of general factory overhead, which is allocated based on direct labor-hours,would be unaffected by this decision because it is fixed cost..Suggest the management whether to stop producing internally and buy them from theoutside supplier?Description CAD Direct Materials 10Direct Labor 6Variable overheads…
I need assistance with Chapter 15 Problem 7. I keep getting an it incorrecrt despite calculating the sum and dividing everything by the quanitity. Thank you