Please give solution in correct and step by step detailed format thanku Don't give solution in image format The actual delivery time from Mario's Pizza is exponentially distributed with a mean of 20 minutes. What is the probability that the delivery time will exceed 30 minutes? (Round to 3 decimals)

Please give solution in correct and step by step detailed format thanku Don't give solution in image format The actual delivery time from Mario's Pizza is exponentially distributed with a mean of 20 minutes. What is the probability that the delivery time will exceed 30 minutes? (Round to 3 decimals)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

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.
Refer to the Factory-to-Six-Customers problem and start with the original information. Each customer increases demand by 1000 units. This increased demand has to be met. Re-calculate the optimal solution. At the new solution, which of the following statements is true? A. The total shipping costs are $252,900 B. Quantity shipped from Factory 1 to Customer 1 declines by 6000 units C. Both A and B D. Neither A nor
Please show solution and formula used. Assuming the total number of students studying in the top four universities in the Philippines is approximately 158,000. And the distribution is as follows: University of the Philippines (UP) - 40% of the total number Ateneo de Manila University (ADMU) - 23,700 De La Salle University (DLSU) - 25% of the total number University of Santo Tomas - 20% of the total number And only the following number of students owns a tablet computer: 20% of UP students 85% of ADMU students 90% of DLSU students 85% of UST students What is the total market penetration of tablet computers among the students of the top four universities? What is the total market size of tablet computers in the top four universities?
Hi... I'm having trouble with the following: Min Jee wants to combine the sales data from each of the art fairs. Switch to the Combined Sales worksheet, and then update the worksheet as follows: In cell A5, enter a formula without using a function that references cell A5 in the Madison Copy the formula from cell A5 to the range A6:A8 without copying the formatting. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Chicago:Madison Copy the formula from cell B5 to the range B6:B8 without copying the formatting. Copy the formulas and the formatting from the range B5:B8 to the range C5:E8. (Hint: You can ignore the error about empty cells because Min Jee will enter the Madison sales data later.)
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
Please answer in excel format A bike company receives bike orders every week and fulfills them according to order’s type. The following table shows frequency and price of the company's products. a) Assuming each order is for only one product, simulate 12 orders using the following table. Fill out gray areas with appropriate Excel functions. NOTE: Use the random numbers shown in the table. b) Calculate average and total price.
Suppose that shipments are not allowed between warehouse 1 and store 2 or between warehouse 2 and store 3. What is the easiest way to modify the spreadsheet so that you can solve this modified problem?a) Assign arbitrarily small costs such as $0.01 to the arcs representing these flows.b) Assign arbitrarily large costs such as $999 to the arcs representing these flows.(I picked option b, which is correct) What is the optimal solution to the modified problem?
LPP: Using already existing solution in 1st pic, solve problem in 2nd pic
I need help with the constraint and how to solve the probelm on excel
You own a wheat warehouse with a capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the Table
Mark Whiskey needs to decide how many balloons to order for an upcoming citywide event. Because each store buys bottles whiskey from Mark's as a package of 500 and there are 3 potentially interested stores, demand will be 0, 500, 1000, or 1500. Mark has a decision to make: whether to order 0, 500, 1000, or 1500 units (bottles). Each unit costs Mark $6 and is sold for $10 to the stores. Any bottle that Mark does not sell will be donated. Enter in cell B8 a single formula that calculates total profit based on the inputs and intermediary inputs given. Note that profit depends not just on price and cost but also on number of bottles sold, which depends on both the order size (E5) and the demand (E4). Note that the demand and order size values of 0 in cells E5 and E4 are only there to construct a flexible profit formula (i.e., their values could be anything). Fill in the above two-way data table using Data/What-If-Analysis/Data Table. Use INDEX & MATCH functions to automatically return…
Just need help finding the sausage constraint quantity value