3 4 Supply: 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 ?

3 4 Supply: 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 ?

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

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
Any Company buys and resells a wide range of personal care products. Their ongoing challenges, like many of their competitors include shipping time for purchases, optimizing use of their storage space, and shipping time for sales to their customers. The company’s control over shipping time for purchases is limited. Their choice of suppliers has more impact on shipping time than any encouragement they can offer to those suppliers. Any Company uses multiple warehouses. Some are owned by the company, others are leased. The company uses contract shippers, FedEx/UPS, and the US Postal Service. Your task is to identify at least 4 KPIs you think will be relevant for Any Company to understand and improve their inventory management. Identify the data necessary for your KPIs as specifically as possible. You may use any KPIs we have mentioned in class or from the labs. Feel free to use others or to create your own. Your response does not need to include a description of graphs you might…
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must ensure that numbers are correct for stock on-hand and then phone in a new order. The total cost involved to place an order is about $5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days. What is the economic order quantity? Note: Round your answer to the nearest whole number. What is the reorder point? Note: Use Excel's NORM.S.INV() function to find the z value. Round z…
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever a new stock is ordered, a buyer must ensure that numbers are correct for stock on-hand and then phone in a new order. The total cost involved to place an order is about $5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. The lead time to get the order in seven days.a. What is the economic order quantity?b. What is the reorder point?
Daily demand for a type of sandwich sold at DoorRed Cafe (DRC) is normally distributed with a mean of 65 and a standard deviation of 27. DRC orders the sandwiches from a wholesaler (everyday morning before 5:30 AM) at a wholesale price of $4 per sandwich and sells them at a retail price of $7 per sandwich. Pursuant to the contract between DRC and its wholesaler, the transportation cost is currently borne by the wholesaler. The wholesaler does not take back any unsold sandwiches. However, DRC can sell any unsold inventory at a discounted price of $3 after 5:00 PM every day. d) Now suppose that the contract between DRC and its wholesaler expires and pursuant to the new contract, if DRC orders more than 56 sandwiches (anything more than or equal to 57), the transportation cost is no longer borne by the wholesaler and DRC will have to pay $30 for transportation. If DRC orders less than or equal to 56, the transportation cost for DRC is still zero. What is DRC’s optimal order quantity for…
In the fashion retail industry transshipment is the flow of the products from a retail location to another one to satisfy the demand at the receiver location. Sender only sends a product if it has excess inventory to its demand and it occurs to rebalance the inventory among retail locations. Assume that there is a retailer with I stores. There are O products nominated for transshipment. The available inventory rio, i = 1,2, ..., I, o = 1,2, ..., 0, and demand levels dio, i = 1,2, ..., I, o = 1,2, ..., 0, for all O, stores are known. Moreover, the sales prices of these products are known and are the same in all stores, po, o = 1,2, ... 0. There is a transportation cost when a product is sent from a store to another, Cij, i, j = = 1, 2, ... D which is independent for the type of the product. Assume that if a product o is transshipped from store i, all its available inventory, i.e., rio, must be sent to a single store, thus, partial transshipment is not allowed. However, a store can…
s/ CarriersEdge x O Home - Longview Logistics - Carr X carriersedge.com/ce/driver_home.html In the United States, how long are you permitted to use paper logs after an ELD malfunction? O 30 days O 8 days O 14 days 7. 8. In both Canada and the United States, you cannot drive after you have accumulated hours of on-duty time in a day. O 11 O 14 O 13 O 16 You are driving in the United States and have just completed 10 consecutive hours off-duty. You begin your day at 9:00 am by completing an inspection for one hour. At 10:00 am, you start driving. How many hours can you drive before you must take a 30-minute break? O 8 hours O 10 hours 11 hours 9. You are waiting for roadside assistance. How do you log the waiting time? O Off-duty O Driving O Sleeper berth O On-duty not driving 10. In Canada, you must take 10 hours off-duty in every 24-hour period and 8 of those hours must be consecutive. How can you take the other two hours off- duty during your 16-hour workshift? O You must take an…
Three suppliers A, B and C, each produce road grit which has to be delivered to council depots W, X, Y and Z. The stock held at each supplier and the demand from each depot is known. The cost, in pounds, of transporting one lorry load of grit from each supplier to each depot is also known. This information is given in the table. Suppliers Depot W Depot X Depot Y Depot Z Stock (Lorry Loads) Supplier A 180 110 130 290 14 Supplier B 190 250 150 280 16 Supplier C 240 270 190 120 20 Demand (Lorry Loads) 11 15 14 10 50 Use VAT method to supply out all the stocks
A company is using a carrier to deliver goods to a major customer. The annualdemand is $2,500,000, and the average transit time is 10 days. Another carrier promises to deliver in 7 days. What is the reduction in transit inventory?
Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is about $5. RW i gures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year.Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days.a. What is the economic order quantity?b. What is the reorder point?
In the following scenario, what will your stockout costs be if you have 200 hammers in stock and you have orders of 80, 60, 50, 30, 120 You are a wholesaler selling hammers. You have a carrying cost for each hammer left in inventory of $.30 per unit, ordering cost of $60 per order placed, and a stockout cost of $30 per customer who is not fully satisfied and $3 per hammer for any orders not fulfilled (lost sales). Orders placed arrive in the sixth week after the week in which the order is placed. Smallest orders are filled first. $480 $1,080 $660 $450 $300
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