Help me fast so that I will give Upvote. Question 2: The Cost-Less Corp. supplies its four retail outlets from its four plants. The shipping cost pershipment from each plant to each retail outlet is given below.Unit Shipping CostRetail Outlet:134Plant1$500$600$400$200220090010030033004002001004200100300200Plants 1, 2, 3, and 4 make 10, 20, 20, and 10 shipments per month, respectively. Retail outlets 1, 2, 3, and4 need to receive 20, 10, 10, and 20 shipments per month, respectively.The distribution manager, Randy Smith, now wants to determine the best plan for how many shipments tosend from each plant to the respective retail outlets each month. Randy's objective is to minimize the totalshipping cost. Formulate this problem as a transportation problem on a spreadsheet and then use Solver toobtain an optimal solution.

Let me state the given data, Plant /Retail…

The distribution manager, Randy Smith, now wants to determine the best plan for how many shipments to send from each plant to the respective retail outlets each month. Randy's objective is to minimize the total shipping cost. Formulate this problem as a transportation problem on a spreadsheet and then use Solver to obtain an optimal solution.

The distribution manager, Randy Smith, now wants to determine the best plan for how many shipments to send from each plant to the respective retail outlets each month. Randy's objective is to minimize the total shipping cost. Formulate this problem as a transportation problem on a spreadsheet and then use Solver to obtain an optimal solution.

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

Explain inventory position (IP)?
Q1/Test the examples of the solution to the following transport issue using the rate distribution method (never U1=0 For two tables only) using a less expensive way to find the primary basic solution? Factory Dealer Supply 1 A 2 2 1000 B 4 700 3 2 900 Requirement 900 800 500 400 41 3, 4, 1, 6, 2)
Problem 20-14 (Algo) Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every six weeks to take orders. Because the orders are shipped directly from Italy, they take five weeks to arrive. Charlie's Pizza uses an average of 160 pounds of pepperoni each week, with a standard deviation of 26 pounds. Charlie's prides itself on offering only the best-quality ingredients and a high level of service, so it wants to ensure a 99 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round Intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Amount of pepperoni's…
Question 2: Metro Tech buys three components from a local wholesaler. The annual demand for components A, B, and C is 500, 3000, and 6000 units respectively. The agreed purchase price is $20, $15, and $10per unit for A, B, and C respectively for each product. The holding cost is estimated to be 20% per year. The ordering cost consists of handling and trucking costs. The handling cost is $100 for each type of component regardless of the number of items ordered. In addition to the handling cost, Metro Tech must pay a trucking cost of $500 for each delivery regardless of the total number of components in the order. Currently, all three items are being ordered independently using EOQ models. A proposal has been made to combine the ordering of the three items to save on trucking costs. Analyze the current and the prosed scenario and show the results below. Input Data: Demand items/year Item Cost in $/item Holding Cost as %/year Ordering Cost $/order # of Orders/ year Economic Order Quantity…
Question 2 Adopting new technologies into logistics enables companies to plan, forecast, and replenish inventories and keep up with customer demands. The application of information technology in logistical approaches helps businesses improve delivery time and accuracy. Besides new technology adoption to support inventory purchasing, further elaborate on any FIVE (5) considerations between social and environmental factors in the purchasing
Define the Bullwhip effect?
Problem 3-14 (Algo) Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) 4,150 4,25e 3,950 4, 350 4,95e 4,650 5,25e 4,850 5,35e 5,65e 6,25e 5,95e January February March Аpril Мay June July August September October November December a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round Intermedlate calculatlons. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors…
Question 2 Prince Electronics, a manufacturer of consumer electronic goods, has five distribution centers in different regions of the country. For one of its products, a highspeed modem priced at $340 per unit, the average weekly demand at each distribution center is 70 units. Average shipment size to each distribution center is 400 units, and average lead time for delivery is 2 weeks. Each distribution center carries 2 week's supply as safety stock but holds no anticipation inventory. On average, how many dollars of pipeline inventory will be in transit to each distribution center? $________________________ (Enter your response as an integer.) How much total inventory (cycle, safety, and pipeline) does Prince hold for all five distribution centers? __________________________units. (Enter your response as an integer.)
Q 7. Explain the importance of multi-channel marketplace models.
In _____,the seller pays all or part of the actual freight charges and does not pass them on to the buyer. Question 47 options: a) uniform delivered pricing b) basing-point pricing c) freight absorption pricing d) free on board origin pricing
Question 48 Producers use intermediaries because they create greater efficiency in making goods available to target markets. O True O False
Question 6 (ABC Analysis) Use the information provided below and classifies the inventory items according to the ABC classification. Item: Annual demand: Unit Price N$: 1 1000 0.50 2 100 250 3 50 1000 4 50 800 5 300 50 6 500 10 7 500 7