1. Business
  2. Economics
  3. this question needs to be answered using spreadsheets please include...

Question: this question needs to be answered using spreadsheets please include...

Question details

This question needs to be answered using spreadsheets. Please include the following:

- objectives and objective function(s)

- constraints

- screenshot of solver

6.6 Stocking Warehouses: Nicklaus Razor Blade (NRB) Company plans to test market a new blade next month. The blades will be stocked in their three ware- houses in the following quantities Warehouse A B C Stock (cartons 50 50 50 The carton quantities required by the distributors in the four test markets are as follows. Distributor D E F G Requirement 45 15 25 20 The unit costs (in dollars per carton) of shipping the blades from warehouses to distributors are given in the table below 10 15 (a) If the NRB Company wishes to meet the distributors requirements at the minimum total transportation cost, what is the optimal distribution plan and its cost? (b) Suppose that the policy at the NRB Company is that each distributor must be serviced by a single warehouse. What is the optimal distribution plan under this policy? (c) By how much (in percentage terms) does the single-warehouse policy inflate distribution cost?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution