Textbook is Optimization Modeling with Spreadsheets. 3rd edition. Baker. Please provide spreadsheet with calculations in answer to exercise 6.6. I don't want to try to follow your notes or decipher your handwriting.

EXERCISES 223 66 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 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 distributors are given in the table below. The unit costs (in dollars per carton) of shipping the blades from warehouses to D E F G 8 B 9 5 10 15 12 6 8 5 3 6 dimo (a) If the NRB Company wishes to meet the distributor's 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? abro (c) By how much in percentage terms) does the single-warehouse policy Reservation Scheduling: Roth Auto Rentals, a car rental company special- inflate distribution cost? peak demand period occurs on the weekend, when Roth may not have enough izing is SUVs, is making up a schedule for the next weekend's demands. The 67 have been logged in are