Part II. On Transportation Method A tile company distributes white bathroom tiles which are produced in 3 manufacturing plant: A, B, C, which are limited to monthly production of 3,000; 2750; and 3,750 boxes of tiles respectively. The company's bathroom tiles are sold to four (4) major distributors of tiles (1, 2, 3 & 4). The monthly requirements are as follows: 1500, 2000, 3000 and 3,500 boxes of tiles respectively. The cost of shipping from each manufacturer to each distributor are as follows: Plant A Plant B Plant C D1= 15/box D1= 21 /box D1= 14 /box D2=18 D3=22 D4=26 D2=25 D2=19 D3=16 D3=20 D4=24 D4=23

Part II. On Transportation Method A tile company distributes white bathroom tiles which are produced in 3 manufacturing plant: A, B, C, which are limited to monthly production of 3,000; 2750; and 3,750 boxes of tiles respectively. The company's bathroom tiles are sold to four (4) major distributors of tiles (1, 2, 3 & 4). The monthly requirements are as follows: 1500, 2000, 3000 and 3,500 boxes of tiles respectively. The cost of shipping from each manufacturer to each distributor are as follows: Plant A Plant B Plant C D1= 15/box D1= 21 /box D1= 14 /box D2=18 D3=22 D4=26 D2=25 D2=19 D3=16 D3=20 D4=24 D4=23

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

13.6. The Ambrosia Bakery makes cakes for freezing and subsequent sale. The bakery, which operates five days a week, 52 weeks a year, can produce cakes at the rate of 116 cakes per day. The bakery sets up the cake-production operation and produces until a predetermined number (Q) has been produced. When not producing cakes, the bakery uses its personnel and facilities for producing other bakery items. The setup cost for a production run of cakes is $700. The cost of holding frozen cakes in storage is $9 per cake per year. The annual demand for frozen cakes, which is constant over time, is 6000 cakes. Determine the following: a. Optimal production run quantity (Q) b. Total annual inventory costs c. Optimal number of production runs per year d. Optimal cycle time (time between run starts) e. Run length in working days
Milling companies have loads of requirements for their warehouses 1, 2, and 3 from their clients A, B, and C. Identify which among the stepping stone and MODI distribution methods proves to be cost-saving for the company. (Please provide solutions and explanation)
Please do not give solution in image format thanku 1) Determine which shipping alternative would be most economical to ship 80 boxes of parts when each box has a price of $200 and holding costs are 30 percent of price, given this shipping information: overnight, $300, two-day, $260, six-day, $180.
Please help to solve step by step.
Explain Fixed–Order Quantity Model w i t h S a f e t y Stock?
Please help to solve step by step.
Problem 20-36 (Algo) Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 3,910 mufflers Ordering cost $ 75 per order Standard deviation of daily demand 6 mufflers per working day Service probability 87 % Item cost $ 27.00 per muffler Lead time 2 working days Annual holding cost 36 % of item value Working days 230 per year Review period 18 working days a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level_________________ b. If the…
14. 12 The purchasing manager for the Atlantic Steel Company must determine a policy for ordering coal to operate 12 converters. Each converter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has determined that the ordering cost is $80 per order and the cost of holding coal is 20% of the average dollar value of inventory held. The purchasing manager has negotiated a contract to obtain the coal for $12 per ton for the coming year. a. Determine the optimal quantity of coal to receive in each order. (Ans: 1200 tons) b. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost of the coal). (Ans: TC= $2880) c. If 5 days of lead time are required to receive an order of coal, how much coal should be on hand when an order is placed? (Ans= R=300 tons)
Subject: calculus
121 (page 6 of 20) 6-SUPPLY CHAIN AND LOGISTICS MANA Which of the following is not one of the Order Management System Elements in the main elements of Logistics Information Systems? Lutfen birini seçin O a Assembling the order Ob Control of stocks Oc Assignment of the product to the customer Od Biling O e Credit limit control S&raki sayfa W R
Problem 16-12 (Algo) Your company assembles five different models of a motor scooter that is sold in specialty stores in the United States. The company uses the same engine for all five models. You have been given the assignment of choosing a supplier for these engines for the coming year. Due to the size of your warehouse and other administrative restrictions, you must order the engines In lot sizes of 700 units. Because of the unique characteristics of the engine, special tooling is needed during the manufacturing process for which you agree to reimburse the supplier. Your assistant has obtained quotes from two reliable engine suppliers and you need to decide which to use. The following data have been collected: Requirements (annual forecast) Weight per engine Order processing cost Inventory carry cost ORDER QUANTITY 1 to 1,499 units/order 1,500 to 2,999 units/order 3,000+ units/order Note: Assume that half of lot size is in Inventory on average (700/2=350 units). Two qualified…
9. The Sta. Maria Bar buys draft beer by the barrel from a local distributor. The bar has an annual demand of 900 barrels, which it purchases at a price of $205 per barrel. The annual carrying cost is $24.60, and the cost per order is $160. The distributor has offered the bar a reduced price of $190 per barrel if it will order a minimum of 300 barrels. What is the cost difference if the bar takes the discount?