Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Analysis Part 1 Facts Of Auditing

Authors: Dr. L. KAILASAM

1st Edition

1670149455, 978-1670149459

More Books

Students also viewed these Accounting questions

Question

What must a creditor do to become a secured party?

Answered: 1 week ago

Question

When should the last word in a title be capitalized?

Answered: 1 week ago