Answered step by step
Verified Expert Solution
Question
1 Approved Answer
https://vandalsuidaho-my.sharepoint.com/:x:/g/personal/vane4988_vandals_uidaho_edu/Ecxy4e93PmNDgYY_V-br1TsBbYPDBUibRMwldobRvG5OGw?e=dDL4Rc this is the link to access the spread sheet This column captures the value of the left hand value of each Objective Function constraint.
https://vandalsuidaho-my.sharepoint.com/:x:/g/personal/vane4988_vandals_uidaho_edu/Ecxy4e93PmNDgYY_V-br1TsBbYPDBUibRMwldobRvG5OGw?e=dDL4Rc
this is the link to access the spread sheet
This column captures the value of the left hand value of each Objective Function constraint. Each cell has a embedded formula. $740,000 In the Network design class, we discussed this simple network problem. This problem with two plants P1 and P2, two warehouses W1 and W2, and three markets C1, C2 and C3 network has been set up using Linear Programming Transportation Model in the MS Excel. The cost data has been provided as well. Plant 2 has an annual capacity of 60,000 units and the demand at C1, C2 and C3 is 50,000, 100,000, and 50,000 respectively. a) In the highlighted cell B8, where the result shows $740,000. Please describ what exactly are the cost included in the objective function. How to set up this cell using the Excel function and cell reference shown in the above picture. Please spell out the excel function in detail. (Use this space to answer the question) b) In the high lighted Cell L15 where the result shows 60000 , please explain what this cell means and how to set this cell using the Excel function and cell reference. Please spell out the excel function in detail. (Use this space to answer the question)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