Using the sample data below: 1. What are two ways you can calculate the total ca
ID: 391084 • Letter: U
Question
Using the sample data below:
1. What are two ways you can calculate the total capacity in the example above?
2. What formula would you use to calculate the average cost per unit of capacity in the example
above?
3. What formula would you use to identify which location has the highest cost per unit of capacity?
4. Why would you use the SUMPRODUCT function?
5. What are the steps needed to create a capacity constraint in an optimization model using solver
in Excel?
6. What is unmet demand used for in an optimization model using Solver in Excel? How would you
set up to check unmet demand in Solver in Excel?
7. What is a binary constraint used for in Solver in Excel?
expain and write the formula
1 Location Capacity Cost 2 Baltimore 187,650 3 Memphis 224,100 4 Wichita 5 Cheyenne2 6 Salt Lake 31 2,200 275,000Explanation / Answer
Answering the first 4 questions:
1. Two ways in which total capacity can be calculated in excel are:
2. Formula to be used to calculate the average cost per unit of capacity:
3. Formula to be used to identify which location has the highest cost per unit of capacity:
4. Sumproduct function can be used to get the sum of the multiplied array of values. In the given case it will first multiply the capacity with the cost for each location and then return an overall sum for the total cost incurred across locations with varying capacities.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.