Tulip MMC produces doors in different regions and has 5 shops across the country.Given the different shipping costs which warehouse should serve which customer in order to minimize costs?Put your total shipping costs in the green cellNo negative numbers. Do not exceed capacity. Meet the demandwarehouseLocationBaku (Ci)GanjaLankaranQabalaUcarTotalTotalMonthyCapacityBakuGanjaLankaranQabalaUcarTotal cost = ?6105109103606103000Shop 1Shop 2Shop 3MonthyDemand(Di)540440500520600Shop 4Shop 5Total 2600Cost to ship one door from Warehouse I to Customer j (Tij)Shop 1 Shop 2 Shop 3 Shop 4 Shop 54.53.53.28.56.547.52.53.751010.568.56.86.55.77.52.89.57.27.46.32.27.110.5

Find the Given details below: Given details: Warehouse Location Customer Shop 1 Shop 2 Shop…

Tulip MMC produces doors in different regions and has 5 shops across the country. Given the different shipping costs which warehouse should serve which customer in order to minimize costs? Put your total shipping costs in the green cell No negative numbers. Do not exceed capacity. Meet the demand warehouse Location Baku (Ci) Ganja 610 Lankaran 510 Qabala Ucar Total Total Monthy Capacity Baku Ganja Lankaran Qabala Ucar Total cost = ? 910 360 610 3000 Monthy Demand (Di) Shop 1 540 Shop 2 440 Shop 3 500 Shop 4 520 Shop 5 600 Total 2600 Cost to ship one door from Warehouse I to Customer j (Tij) Shop 1 Shop 2 Shop 3 Shop 4 Shop 5 4.5 3.5 3.2 8.5 6.5 4 5 6.8 6.3 6.5 2.2 7.1 7.5 2.5 3.7 10.5 6 8.5 5.7 7.5 2.8 9.5 7.2 7.4 10.5

Tulip MMC produces doors in different regions and has 5 shops across the country. Given the different shipping costs which warehouse should serve which customer in order to minimize costs? Put your total shipping costs in the green cell No negative numbers. Do not exceed capacity. Meet the demand warehouse Location Baku (Ci) Ganja 610 Lankaran 510 Qabala Ucar Total Total Monthy Capacity Baku Ganja Lankaran Qabala Ucar Total cost = ? 910 360 610 3000 Monthy Demand (Di) Shop 1 540 Shop 2 440 Shop 3 500 Shop 4 520 Shop 5 600 Total 2600 Cost to ship one door from Warehouse I to Customer j (Tij) Shop 1 Shop 2 Shop 3 Shop 4 Shop 5 4.5 3.5 3.2 8.5 6.5 4 5 6.8 6.3 6.5 2.2 7.1 7.5 2.5 3.7 10.5 6 8.5 5.7 7.5 2.8 9.5 7.2 7.4 10.5

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

Pls solve this question correctly in 5 min i will give u like for sure Question # 1 Teresa Cohan is attempting to perform an inventory analysis on one of her most popular products. Annual demand for this product is 5,000 units; unit cost $200; carrying cost is considered to be approximately 10% of the unit price. Order costs for her company typically run nearly $30 per order and lead time averages 10 days. Discounted unit cost of Rs. $150 (carrying cost remain the same) for more than 300 units is also being offered. (Assume a 50-week year. a)What is economic order quantity? b)What is the reorder point? c)What is the total carrying + ordering cost? d)What is optimal number of orders per year? e)Would you recommend availing the discount?
***** The company Marombeiro is a commercial representative of a food supplement widely consumed in gyms. The average daily demand for the product is 1,500 units and a standard deviation of 300 units. Average shipping time is 5 days. Of course, if the order is placed at the end of the week, it may take a little longer to receive the shipment, so the standard deviation of the delivery time is 2 days. The unit has a value of R$ 50.00 per unit in stock, an order cost of R$ 50.00 and an annual maintenance fee of 20%. Suppose Company Marombeiro wants to change the service to 99%. How many days of safety stock the company will have. ( )5.12 days ( )5.67 days ( )5.33 days ( )4.77 days
Determine which shipping alternative would be most economical to ship 70 boxes of parts when each box has a price of $250 and holding costs are 27 percent of price, given this shipping information: overnight, $400, two-day, $280, six-day, $190. (Round your intermediate calculations to 2 decimal places.)
Tradewinds Imports is an importer of ceramics from overseas. It has arranged to purchase a particular type of ceramic pottery from a Korean artisan. The artisan makes thepottery in 120-unit batches and will ship only that exactamount. The transportation and handling cost of a shipment is $7600 (not including the unit cost). The importerestimates its annual demand to be 1400 units. What storageand handling cost per unit does it need to achieve in orderto minimize its inventory cost?
Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 1,100 valves; order cost is $10 per order; and annual inventory holding costs are $7.55 per unit. D D Vendor A Quantity 1-14 15-24 25-99 100-199 200-399 400+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor C Vendor D Vendor A D Vendor B Vendor B Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 MacBook Air O Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00 Next
.How are service level and inventory level dependent on each other? How would factors like lead time and lot size impact different types of inventory?
Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 800 valves; order cost is $7 per order; and annual inventory holding costs are $2.15 per unit. D Vendor A units at a time from Vendor C Vendor B Quantity 1-14 15-24 25-99 100-199 200-399 400+ Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order (enter your response as a whole number). Vendor A Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor D Vendor B Quantity 1-24 25-99 100-199 200-399 400+ Price $34.75 34.00 32.80 31.60 30.50 Vendor C Quantity 1-49 50-149 150-299 300+ Price $34.50 33.75 32.50 31.10 Vendor D Quantity 1-149 150-299 300+ Price $34.25 33.00 31.00
Chris Sandvig Irrigation, Inc., has summarized the price list from four potential suppliers of an underground control valve. See the table below. Annual usage is 700 valves; order cost is $10 per order; and annual inventory holding costs are $7.55 per unit. Vendor A Quantity 1-9 10-14 15-49 50-99 100-299 300+ Price $35.00 34.75 33.55 32.35 31.15 30.75 Vendor B Quantity 1-14 15-49 50-99 100-299 300+ Price $34.75 34.00 32.80 31.60 30.50 Vendor C Quantity 1-24 25-74 75-199 200+ Vendor C Vendor B Vendor D Price $34.50 33.75 32.50 31.10 Which vendor should be selected and what order quantity is best if Sandvig Irrigation wants to minimize total cost? Chris Sandvig Irrigation should order units at a time from (enter your response as a whole number). Vendor A Vendor D Quantity 1-74 75-199 200+ Price $34.25 33.00 31.00
Southern Markets, Inc., is considering the use of ABC analysis to focus on the most critical SKUs in its inventory. Currently, there are approximately 20,000 different SKUs with a total dollar usage of $10,000,000 per year.a. What would you expect to be the number of SKUs and the total annual dollar usage for A items, B items, and C items at Southern Markets, Inc.?350 PART 2 Managing Customer Demandb. The following table provides a random sample of the unit values and annual demands of eight SKUs. Categorize these SKUs as A, B, and C items.SKU Code Unit Value Demand (Units)A104 $2.10 2,500D205 $2.50 30X104 $0.85 350U404 $0.25 250L205 $4.75 20S104…
b) Describe briefly about; i. Inventory, and Inventory cost ii. The purpose to have sales and operations planning c) Give at least ONE (1) example of; i. Product categorized as dependant demand ii. Product categorized as independent demand d) World Cycle is a centre for a new Malaysian made bicycle. It cost the company RM 1200 to order each bicycle from the manufacturer with handling cost of RM 100 for each unit. The company estimates the total annual demand will be 3000 units with a constant demand rate through-out the year. The store policy is never to have stock of the bicycle since it takes within minutes to receive it after placement order from a local warehouse. The company is open for business every day except public holidays. Malaysian public holidays, including Saturday and Sunday are 120 days a year. Determine; i. Optimal order quantity per order ii. Minimum total annual inventory costs iii. The number of orders per year iv. The working days between orders
Discuss the ABC inventory classification system and indicate it's benifits?
Grand Styles Furniture Store is overstocked in (has excess inventory of) one type of chair, Based on the Price-Demand Relationship, what advice would you provide to the store manager to deal with this problem? Please use no more than 2 bullet points for your answer.