Needed to be solved correclty in 30 minutes and get the thumbs up please show neat and clean work please provide correct solution LP Center of GravityDataLocationXYCost17413211453931544924Total213057SimplificationCreate an LP to find the optimal locations of the two centers by making sure the transportation cost isminimized. To simplify your task, assume that the centers can only be placed in a range from [5,4] to[7,7]. ROP With Variable Demand and Lead TimeDataRisk of Stock OutAssume the maximum risk of stock out we wishto take is 1%. What is the ROP?Average demand per week = 200Stdv of demand per week = 50Average lead time in weeks = 3Stdv of lead time in weeks = 2Service level: 95%Safety stock will become:Lead time and demand are normally distributedNew ROP =ROP With VariabilityService level90%95%99%99.9%Note: 1 Service level = stockout riskKey Z-ValuesZ-value1.281.652.333.08

since coordinate values are possible to be in decimals, we will use GRG non linear method.…

LP Center of Gravity Data Location X Y Cost 1 7 4 13 2 1 14 5 3 9 3 15 4 4 9 24 Total 21 30 57 Simplification Create an LP to find the optimal locations of the two centers by making sure the transportation cost is minimized. To simplify your task, assume that the centers can only be placed in a range from [5,4] to [7,7].

LP Center of Gravity Data Location X Y Cost 1 7 4 13 2 1 14 5 3 9 3 15 4 4 9 24 Total 21 30 57 Simplification Create an LP to find the optimal locations of the two centers by making sure the transportation cost is minimized. To simplify your task, assume that the centers can only be placed in a range from [5,4] to [7,7].

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

Reorder PointConsider an economic order quantity case where annual demand D = 1,000 units, economic order quantity Q = 200 units, the desired probability of not stocking out P = .95, the standard deviation of demand during lead time σL = 25 units, and lead time L = 15 days. Determine the reorder point. Assume that demand is over a 250-workday year.
The injection molding department of a company uses an average of 30 gallons of special lubricanta day. The supply of the lubricant is replenished when the amount on hand is 170 gallons. It takesfour days for an order to be delivered. Safety stock is 50 gallons, which provides a stockout risk of9 percent. What amount of safety stock would provide a stockout risk of 3 percent? Assumenormality.
2) Daily demand for a product is normally distributed with a mean of 100 and a standard deviation of 12. The lead time is normally distributed with a mean of 5 days and a standard deviation of 1.5 days. a) What is the ROP to satisfy a %90 probability of not stocking out? b) What is the safety stock? c) What is the probability of stocking out if the manager has decided not to keep any safety stock? What is the Z value, and what is the probability?
Furnco sells secretarial chairs. Annual demand isnormally distributed, with mean of 1,040 chairs and standarddeviation of 50.99 chairs. Furnco orders its chairs from itsflagship store. It costs $100 to place an order, and the leadtime is two weeks. Furnco estimates that each stockoutcauses a loss of $50 in future goodwill. Furnco pays $60 foreach chair and sells it for $100. The annual cost of holdinga chair in inventory is 30% of its purchase cost.a Assuming that all demand is backlogged, what arethe reorder point and the safety stock level? b Assuming that all stockouts result in lost sales, de-termine the optimal reorder point and the safety stock level.
A product's demand in cach period follows a Normal distribution with mean of 50 and standard deviation of 6. The order up to level S is 225. Lead time is 3 periods. What is the Expected On hand Inventory? Show all formulas used. calculations and results. What is the stock out probability ? Show all formulas used, calculations and results.
A hospital must order the drug Porapill from DaisyDrug Company. It costs $500 to place an order and $30 toreview the hospital’s inventory of the drug. Annual demandfor the drug is N(10,000, 640,000), and it costs $5 to holdone unit in inventory for one year. Orders arrive one monthafter being placed. Assume that all shortages are backlogged.a Estimate R and the number of orders per year thatshould be placed.b Using the answer in part (a), determine the optimal(R, S) inventory policy. Assume that the shortage costper unit of the drug is $100.
The amount of denim used daily by the Southwest ApparelCompany in its manufacturing process to make jeans isnormally distributed with an average of 4000 yards ofdenim and a standard deviation of 600 yards. The lead timerequired to receive an order of denim from the textile mill is a constant 7 days. Determine the safety stock and re-order point if the company wants to limit the probability of a stockout and work stoppage to 5%.
Given this information:Lead-time demand 600 poundsStandard deviation of lead time demand 52 pounds (Assume normality.)Acceptable stockout risk during lead time 4 percenta. What amount of safety stock is appropriate?b. When should this item be reordered?c. What risk of stockout would result from a decision not to have any safety stock?
The Suregrip Tire Company carries a certain type of tire with the following characteristics:Average annual sales = 600 tiresOrdering cost = $40 per orderCarrying cost = 25 percent per yearItem cost = $50 per tireLead time = 4 daysStandard deviation of daily demand = 1 tirea. Calculate the EOQ.b. For a Q system of inventory control, calculate the safety stock required for service levels of 85, 90, 95, 97, and 99 percent. excelc. Construct a plot of total inventory investment versus service level.d. What service level would you establish on the basis of the graph in part c? Discuss.
6. Leaky Pipe, a local retailer of plumbing supplies, faces demand for one of its SKUs at a constant rate of 17,000 units per year. It costs Leaky Pipe $5 to process an order to replenish stock and $2.00 per unit per year to carry the item in stock. Stock is received 12 working days after an order is placed. No backordering is allowed. Assume 365 working days a year. d. The demand during lead time is _____ units. (Enter your response rounded to the nearest whole number.) e. The reorder point is ______ units. (Enter your response rounded to the nearest whole number.) f. The inventory position immediately after an order has been placed is _____ units. (Enter your response rounded to the nearest whole number.)
ou are a newsvendor selling the San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of the San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. How many copies of the San Pedro Times should you buy each morning and what is the probability that you will run out of stock? Use Excel's NORM.S.INV() function to find the z value.
XYZ Company must order tires from its warehouse. It costs $10550 to place an order and to review the inventory level. Annual tire sales are normally distributed with mean 20000 and variance 4,000,000. It costs $10 per year to hold a tire in inventory, and each order arrives two weeks after being placed. The Company uses periodic review (R, S) policy. What is the review interval R (in years), estimated using EOQ.? Select one: a. 1.027 O b.0.1083 c. 0.2297 d. 0.1624 e. 0.3248