Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Apron Outfitters is a manufacturer of aprons, jackets, and vests for a variety of occupations, including golf caddies, chefs, and carpenters. Assume that Apron Outfitters
Apron Outfitters is a manufacturer of aprons, jackets, and vests for a variety of occupations, including golf caddies, chefs, and carpenters. Assume that Apron Outfitters needs to schedule shipments of aprons from its three manufacturing plants to its four warehouses. The company has generated the following model using Solver AddIn Excel.
A data sheet for network transportation problems. The first table for cost per unit delivery has plants and in the first columns and warehouses through in columns through The values for each plant are as follows: Plant : Plant : Plant : The first table for recommended shipping model has plants and in the first columns and warehouses through in columns through Ship in column and capacity in column The values are as follows: Plant : Plant : Plant : Total Received: warehouse ; warehouse ; warehouse ; warehouse Demand: warehouse ; warehouse ; warehouse ; warehouse Total Total cost $; warehouse $; warehouse $; warehouse $; warehouse $
The table has columns for cell, name, final value and reduced cost. The data in the table is: $D$ Plant Warehouse $E$ Plant Warehouse $F$ Plant Warehouse $G$ Plant Warehouse $D$ Plant Warehouse $E$ Plant Warehouse $F$ Plant Warehouse $G$ Plant Warehouse $D$ Plant Warehouse $E$ Plant Warehouse $F$ Plant Warehouse $G$ Plant Warehouse
Using the model results, answer the following questions:
Required:
What is the total cost of the recommended shipping model?
How does total capacity compare to demand?
How many units need to be shipped from Plant to Warehouse
How much does cost need to change for Plant to ship to Warehouse
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started