take xx=82 dnt use excel A company has four factories manufacturing the same commodity, which are required to betransported to meet the demands in four warehouses. The supplies and demands as also thecost per transportation from factory to warehouse in Rs. per unit of product are given in thefollowing table.WarchousesFactorySupply (units)WYA25+XX55+XX40+XX60+XX6035+XX60+XX50+XX40+XX14036+XX45+XX26+XX66+XX150D35+XX30+XX41+XX50+XX50Demand (units)90100120140a) Derive an optimal strategy of transportation of goods from factories to warehouses andassess the optimal cost. XX = last two digits of your roll no.b) If a new transporter agrees to transport goods from factory C to warehouse W at a unit costof Rs. 50, analyse the impact of this on your current optimal solution.

The objective is to minimize the cost. Let X11 = Cost of transportation from Factory A to warehouse…

Answered: a) Derive an optimal strategy of…

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

What is the meaning of -1 "ij m = K¡Yi, for i = 1, 2, n? %3D %3D .... j=1 For each facility, the total quantity sent out cannot exceed its capacity, and no quantity is shipped if the facility is not open. For each facility, the total quantity sent out cannot exceed its capacity. For each facility, no quantity is shipped if the facility is not open. The total quantity sent from facility i cannot exceed its capacity, and no quantity is shipped if facility i is not open.
Let xj be the number of units allocated to supply-destination pair i (supply) and j (demand). If we use VAM as an initialization technique, which of the following supply- destination pairs will be allocated first? Destination 1 2 3 Supply 1 15 13 7 Source 2 11 17 5 3 9. 11 9. 3 Demand 3 Activa
Consider the supply : Last year, the retailer’s weekly variance of demand was 200 units.The variance of orders was 500, 600, 750, and 1,350 units for theretailer, wholesaler, distributor, and manufacturer, respectively.(Note that the variance of orders equals the variance of demandfor that firm’s supplier.)a) Calculate the bullwhip measure for the retailer.b) Calculate the bullwhip measure for the wholesaler.c) Calculate the bullwhip measure for the distributor.d) Calculate the bullwhip measure for the manufacturer. e) Which firm appears to be contributing the most to the bull-whip effect in this supply chain?
Mr. Meadows Cookie Company makes a variety of chocolate chip cookies inthe plant in Albion, Michigan. Based on orders received and forecasts of buying habits, it is estimated that the demand for the next four months is 850, 1,260, 510, and 980, expressed in thousands of cookies. During a 46-dayperiod when there were 120 workers, the company produced 1.7 million cookies. Assume that the number of workdays over the four months are respectively26, 24, 20, and 16. There are currently 100 workers employed, and there is nostarting inventory of cookies.a. What is the minimum constant workforce required to meet demand over thenext four months?b. Assume that cI 5 10 cents per cookie per month, cH 5 $100, and cF 5 $200.Evaluate the cost of the plan derived in part (a).c. Formulate as a linear program. Be sure to define all variables and include therequired constraints.d. Solve for the optimal solution
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.
"A chipboard company has 4 factories, Mazatenango, Retalhuleu, Escuintla and Xela. It has four major distributors of its chipboards, which are distributor 1, distributor 2, distributor 3 and distributor 4: Mazatenango Retalhuleu Escuintla Xela DEMAND D1 10 16 19 12 350 D2 12 10 18 15 300 D3 15 22 10 10 250 D4 20 10 12 20 200 SUPPLY 150 150 350 250 1) Formulate the problem as a transportation problem, solve it with the three methods and find the optimal cost for this problem. methods and find the optimal cost for this transportation problem. (remember to go through all possible routes). IN THIS CASE USE MINIMUM TRANSPORTATION COST - LEAST COST METHOD
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…
d-Term Exam)_BUS 384 (page 15 of 20) 2316036-SUPPLY CHAIN AND LOGISTICS MANAG Soru 15 Logistics firms or divisions deliver goods from places of lower value to the customer to places where they Cevap are of higher value, which of the following does it provide? kaydedildi 5,00 üzerinden içaretlenmiş Lütfen birini seçin O a Ownership benefit P Soruyu igaretle Ob Structure benefit Oc Space benefit Od Shape benefit O e Time benefit Seçimimi Temızle Onceki sayfa Sonraki sayfa O O ||>
Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) Probability
Problem 20-10 (Algo) You are a newsvendor selling 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 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. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)
Greenwood Maps le/193342/discussions/topics/171826/View M Inbox (2,132) - langfordk X Haribo has manufactured gummy bears, since 1920. Those bears are currently made in 16 plants around the world. Starting in 2020, those gummy bears will also be made in the US when Haribo opens a new plant in Wisconsin. Worldwide, about 100 million gummy bears are made by Haribo per day. The ingredients in gummy bears are sugar, glucose syrup, starch, flavoring, food coloring, citric acid, and gelatin. MAR 2023 Intersession - GX Gummy bears are made in a special machine called a starch mogul. A flat gummy bear mold tray is filled with powered starch. (The flat tray is why gummy bears are flat on the backside.) A hot, liquid gummy bear mixture is poured into the tray. The tray is cooled overnight and then the gummy bears are removed and the process starts over with the now emptied tray with more of the gummy bear mixture. Gummy bears are package by machine into a variety of package sizes. The Haribo…
In the last 12 months the quantities shown inTable 1 of light vehicles of a brand "R" were sold in the national territory.The selling price of each R vehicle is 12590€. The production cost(including raw material cost) of one is 7730€. The company usesown transportation to transport the vehicles worth 420€, andgiven the distance to the factory, takes on average, 8days, with a standard deviation of 2 days. Storage until saleis estimated at 150€/unit.year. The companyfinancial loans at an annual rate of 2.2%. Consider that ayear has 264 working days.a) Determine the economic order quantity.b) Consider that a service level of 85% (Z=1.036) is to be ensured using a continuous reviewinventory management policy of continuous review. Determine:i. The order point.ii. The economic order quantity considering stock-outs. Month Sales Month Sales 1 2235 7 3078 2 3206 8 2366 3 4298 9 1966 4 3309 10 2149 5 3640 11 2387 6 4038 12 2492

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS