• VOOM has four warehouses 1, 2,3, and 4. VOOM needsto supply 200 Tons to Retailer P, 200 Tons to Retailer Q,and 200 tons to Retailer R. The cost of delivery fromeach warehouse to retailers is provided in the followingtable. While each warehouse has an inventory of 500tons they can supply, R requires that every warehousesupplies at least 25 tons to R. There is a specialarrangement between Warehouse 4 and R whichrequires that Warehouse 4 has to supply exactly 55tons to R. On the other hand, P can take up to 150 tonseach from warehouses 1 and 2.• •Use linear programming to provide VOOM with a planto keep their transportation cost minimal. Deliverycost/ton($)PQRWarehouse1 $ 14.00 $ 30.00 $ 20.00Warehouse2 $ 30.00 $ 40.50 $ 15.003 $ 18.50 $ 20.00 $ 24.00WarehouseWarehouse 4 $15.50 $ 12.50 $ 28.00

For this question, I will prepare the spreadsheet model, Then, I will solve this spreadsheet model…

Answered: VOOM has four warehouses 1, 2,3, and 4.…

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

the members of an instamural softball team decided to get cutom t-shirts made. there arer two screening shoops in town that they can choose from wave graphic charges a setup fee of $22 and then each shirt is $7. The shirt shack doesnt charge a setup fee but each shirt is $9. if for some bizarre reason the team decided to only order three shirts question 1. the goal to find the # of shirts for which the two shops would charge the same. a. wright a equation that describes the cost c of buying x shirts from the shirt shack b. wright an equation thsat describes the cost C of buying x shirts from wave graphics c. now you have a sytem of equations with each shop by making a table of values number of x shirts are 3,6,9,12,15 whats the cost for each one shack and cost of wave graphic for each one?
1. a. Define following: iv. Cycle Inventory v. Level of Product Availability vi. Reverse Logistics vii. Honey Combing
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?
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)
Finance Mrs Banks baked some curry puffs. She packed them into boxes of 7 and had 3 curry puffs left. If she had 39 boxes of curry puffs, how many of them did she bake?
TT Beverage Co. is a distributor of beer, wine and soft drinks product. From amain warehouse located in Magusa, TRNC, TT supplies nearly 1000 retail stores withbeverage products. The beer inventory, which constitutes about 40% of the company’stotal inventory, averages approximately 50 000 cases. With an average cost per case ofapproximately 8MU, TT estimates the value of its beer inventory to be 400 000 MU.The warehouse manager has decided to do a detailed study of inventory costsassociated with Sergio Beer, the # 1 selling TT beer. The purpose of the study is toestablish the “how-much to order,” and “when to order” decisions for Segio Beer thatwill result in the lowest possible cost.The manager found that the demand is constant and 2 000 cases/week.The cost ofholding for the TT beer inventory is 25% of the value of the inventory.(Note that definding the holding cost as a % of the value of the product isconvenient, because it is easily transferable to other products)TT is paying 32…
Ikagami Retail receives shipments of a particular product from Booker Store and PaulEnterprises. Let x = number of units of product received from Booker Store y = number of units of products received from Paul Enterprises Requirement: a. Write an expression for the total number of units of products received by Ikagami Retail.b. Shipments from Booker Store cost P20 per unit, and shipments from Paul Ent cost P25 per unit. Develop an objective function representing the total cost of shipments to Ikagami.c. Assuming a monthly demand at Ikagami is 5,000 units, develop a constraint that requires 5,000 units to be shipped to Ikagami.d. No more than 4,000 units can be shipped from Booker, and no more than 3,000 from Paul. Develop constraints to model this situation.e. Of course, negative amounts cannot be shipped. Combine the objective function and constraints developed to state a mathematical model for satisfying the demand at Ikagami at minimum cost.
Ikagami Retail receives shipments of a particular product from Booker Store and PaulEnterprises. Let x = number of units of product received from Booker Store y = number of units of products received from Paul Enterprises Requirement: a. Write an expression for the total number of units of products received by Ikagami Retail.b. Shipments from Booker Store cost P20 per unit, and shipments from Paul Ent cost P25 per unit. Develop an objective function representing the total cost of shipments to Ikagami.c. Assuming a monthly demand at Ikagami is 5,000 units, develop a constraint that requires5,000 units to be shipped to Ikagami.
Problem 12-5 (Algo) Garden Varlety Flower Shop uses 810 clay pots a month. The pots are purchased at $3.30 each. Annual carrying costs per pot are estimated to be 20 percent of cost, and ordering costs are $15 per order. The manager has been using an order size of 1,750 flower pots. a.What additional annual cost is the shop incurring by staying with this order size? (Round your optimal order quantity to the nearest whole number. Round all other intermediate calculations and your final answer to 2 decimal places.) Additional annual cost b.Other than cost savings, what benefit would using the optimal order quantity yield (relative to the order size of 1,750)? (Use the rounded order quantity from Part a. Round your final answer to the nearest whole percent.) About % of the storage space would be needed.
After applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
Supply Chain Coordination problem Zamatia makes sunglass at a cost of $35 and sells them to UmbraVisage (UV) for $75. UV sells them for $115 and salvages left over inventory for $25 per unit. Demand is Normal with mean 250 and standard deviation 125. a. What should be the optimal ordering quantity for UV? b. What is the total supply chain profit (UV & Zamatia) given the ordering quantity computed in a? c. What should be the optimal ordering quantity to maximize the total supply chain profit (UV and Zamatia)?
1. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the EOQ. 2. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the total carrying cost. 3. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the total ordering cost. 4. Maxmin Trading Company buys 1,000 pcs of chair per month. The cost per chair is Php500 and ordering cost is Php400. The inventory carrying cost is estimated at 10% of the price of the chair. Determine the number of orders required per year. 5. Minmax Processing Company has an average requirement of 5 boxes of…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

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

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS