Assignment
Use the MS Excel Solver to analyze the situation described in the file below by answering each of the questions. Submit your solution document here. They should include:
Your MS Excel spreadsheet containing the completed LP model
An MS Word document responding to each question in full, including images of your spreadsheet model and the filled-out Solver dialog window supporting your conclusions and recommendations
Please comment on the solution you find. Does it make sense? Does anything about it interest or surprise you?
M2 Individual LP Assignment.xlsx
Here’s a simple example of the SUMPRODUCT() function being used with 2-dimensional arrays: SUMPRODUCT Example with 2D Arrays.xlsx
The most common mistake people make when using SUMPRODUCT() is instead of entering two arrays (ranges) as the arguments of the function, they enter just one range that includes both arrays. Unfortunately, rather than return an ERROR (so the user is made aware of their mistake), SUMPRODUCT() defaults to the second array being all ‘1’s. In effect then, the function in this case simply sums all the entries in the combined array; and the user may not even realize they’ve made a mistake!