Question: PART-3: OFFLINE EXCEL SOLVER QUESTIONS- Upload answer file including Excel file on Canvas. 11 points. 1. Reckitt Benckiser has four production plants (P1, P2, P3,

PART-3: OFFLINE EXCEL SOLVER QUESTIONS- Upload answer file including Excel file on Canvas. 11 points. 1. Reckitt Benckiser has four production plants (P1, P2, P3, P4), from which it ships Lysol brand products to its two national warehouses (W1, W2). From these warehouses it feeds the supply chain of a major retailer through six cross dock distribution centers (D1, D2, D3, D4, D5, D6). The shipping costs between these locations, plant capacity and the weekly supply demand data are shown below: Supply Capacity Shipping Cost W1 W2 $24 $31 Weekly Demand Shipping Cost W1 W2 P1 10000 D1 2700 8 7 P2 4500 $21 $12 D2 3900 10 4 P3 2000 $26 $28 D3 950 9 6 P4 4000 $ 13 $26 2150 4 10 D5 1450 7 7 D6 2800 10 8 (1) Solve the network distribution problem via linear programming using MS- Solver (ii) From a strategic perspective what management recommendations do you have for plant P3. (iii) The CFO provides additional data about the plant production costs as $125, $125, $112, and $120 per case for plants P1 to P4. How does this data affect your answer in (ii) (iv) If the W1 warehouse has a maximum distribution capacity of 3500 cases/week how does the solution in (i) change

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I need help with part vi. "PRODUCTION COST". because is not the same as Shipping cost. I can not only add $3 in P2. OFFLINE QUESTIONS - Upload answer file including Excel file on Canvas. 1. Weber has...

how do do find the Central Method answer for question 1? Questions 1. ( Pts) Now, we are considering building a new warehouse to accommodate total production volume from those four existing...

Questions 2. [5 pm] More , we are considering atransportation plan with current exisdng automobiles .The marketing department divided a marketinto the ve segments as follows: NY, Houston, Dallas, LA...

Questions 2. (5 pts) Now, we are considering a transportaon plan with current existing automobiles. The marketing department divided a market into the ve segments as follows: NY, Houston, Dallas, LA...

Ice-amole is trying to develop a new product, asparagus flavored ice cream, called "Ice-sparagus." Ice-amole needs to show its investors that the new product is likely to provide profits that exceed...

Pecision 1 : Marketing - Advertising Placement PUT INTO EXCEL SOLVER!!!!!!!!!!!!!!!!!! This can be solved using Linear Programming. Here's how to approach it: Define Decision Variables: , Let W =...

Mexico City Bank of Commerce and Industry is a busy bank . Due to different customers needs, it needs to assign a different number of tellers at the counter at different time s of each day . The...

Instructions In Assignment 1. you needed to solve Question 5 using both LINGO and the Excel Solver. In Assignments 2 to 6 inclusive, you will be asked only to use either LINGO or the Excel Solver....

Please answer the part EFGH. thanks! Question 5. (22 points) OPTIMAL PRODUCT MIX AND WHAT-IF QUESTIONS AU Electronics manufactures is the supplier of components C1, C2 and C3 for the production of...

1. How could Jim use a letter of credit to ensure that he will be paid for the products he exports? 2. Jim has discussed the possibility of expanding his export business through a second sporting...

Given the thermochemical equation 2Na+(aq) + SO42(aq) ( Na2SO4(s)H = 819.8 kJ How much energy is absorbed when 55.9 g of Na+(aq) are reacted?

Janice Jacobs is planning for her retirement. She knows what assets and liabilities she has now and expects to have in the future. She knows what her spending patterns are likely to be and adjusted...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...