2.Supply1.604028101202.503030201503.43202010160Demand:100100100130The transportation tabie of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned?

Given data is Now, the question is to determine the value that is to be assigned to the first cell…

Supply 60 40 28 10 120 2. 50 30 30 20 150 43 20 20 10 160 Demand 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned? 2.

Supply 60 40 28 10 120 2. 50 30 30 20 150 43 20 20 10 160 Demand 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned? 2.

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

L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item Code 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 L. Houts Plastics Charlotte Inventory Levels Dollar Avg. Inventory (units) Volume 380 300 120 75 60 30 20 12 5 7 6 Value ($/unit) 3.75 4.00 2.50 1.50 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,298 % of Dollar Volume 36.39 9.10 3.18 0.70 0.75 0.42 0.55
Torrance Refinery produces approximately 23.1 Million barrels of gasoline per year. A California distributor sources its gasoline from the Torrance refinery. The annual demand for gasoline at the California distributor is 5.3 Million barrels. The cost of storing gasoline is approximately $29 per barrel (per year). The cost of placing an order to the Torrance refinery (including shipping) is $7300 per order. Orders will be received gradually instead of delivered all at once (hence EPQ). At what quantity will the total cost of procurement be the lowest? Round your answer to the nearest whole number. Do NOT include a comma. For example, answer like 103542 and NOT 103,542 Answer: 58845 Check
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,…
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item number 2349 should be classified as Item Code 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 Item number 8210 should be classified as L. Houts Plastics Charlotte Inventory Levels Avg. Inventory (units) Value ($/unit) 3.75 420 300 120 60 60 322576 20 12 4.00 2.50 1.80 1.75 2.25 1.15 2.05 2.00 2.00 3.00 Dollar Volume 1,200 300 105 23 25 % of Dollar Volume 34.72 8.68 3.04 0.67 0.71 14 18 3,456 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics).…
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
Using excel. The Metropolitan Bus Company (MBC) purchases diesel fuel from AmericanPetroleum Supply. In addition to the fuel cost, American PetroleumSupply charges MBC $250 per order to cover the expenses of deliveringand transferring the fuel to MBC’s storage tanks. The lead time for anew shipment from American Petroleum is 10 days; the cost of holding agallon of fuel in the storage tanks is $0.04 per month, or $0.48 peryear; and annual fuel usage is 150,000 gallons. MBC buses operate 300days a year.a.What is the optimal order quantity for MBC?b.Howfrequently should MBC order to replenish the gasoline supply?c.TheMBC storage tanks have a capacity of 15,000 gallons. ShouldMBC consider expanding the capacity of its storage tanks?d.What isthe reorder point?
1 3 Supply: 4 1 60 40 28 10 120 2 50 30 30 20 150 3. 43 20 20 10 160 Demand: 100 100 100 130 The transportation table of a company that sends products is given below. According to the least cost method what is the value for the first cell to be assigned ?
Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant assify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item number 2349 should be classified as Item Code 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 Item number 8210 should be classified as L. Houts Plastics Charlotte Inventory Levels Value ($/unit) 3.75 4.00 2.50 1.50 1.75 2.00 1.15 2.05 1.80 2.00 3.00 Avg. Inventory (units) 400 300 120 18822 75 60 30 20 978 Dollar Volume 6 1,200 300 105 23 25 O % of Dollar Volume 35.59 8.90 14 18 3,372 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the…
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.)
Chris usually sells 120 copies of newspaper each day and believe that sale are normally distributed, with a standard deviation of 15 papers. He pays 70 cents for each paper, which sells $1.25. For each unsold paper, he receives 30-cent credit. a) determine how many papers he should order each day b) calculate the stockout risk for that quantity.
These are three points of problems that can occur in a parcel: -Low responsiveness to unexpected distribution problems. -Distribution problems in terms of quality of service and experience for the customer. -Uncertainty in the management and delivery of packages. explains each of them