BUExcel business questions – Description
Rubric for Assignment 5
Problem 2 (24 points)
You need to modify the spreadsheet provided to include the VXP computers. Then you need to find the new optimal solution. I will look at the optimal number of computers to produce and at the value of the objective function. (12 points).
b. Round the values of the optimal number of computers from part a. Is the solution still feasible? Basically check if the number of hours used is still less than the number of hours available (6 points).
If the rounded solution was not feasible, look for integer values closed to the ones obtained on part a (by trial and error), until you find an optimal combination that maximizes the value of the objective function AND is feasible. (6 points).
Problem 11 (24 points)
Change the maximum sales constraint to a minimum sales constraint and use Solver to find the optimal solution (6 points) Do not forget to provide your spreadsheet showing your results.
What do you find? In particular, are all the constraints satisfied? (6 points)
The optimal solution satisfies all constraints
Now, make the values in row 23 one quarter of their current values and rerun Solver (provide this new worksheet) (6 points). What do you find? In particular, are all the constraints satisfied? (6 points)
Problem 19 (22 points)
First, include two more months so that the planning horizon is now 8 months. You have to assume and values for the production costs, production capacity, demand and storage capacity for months 7 and 8 (for example you can just use the values of these variables in month 6). Has this modification changed the optimal production in month 1 (from the book this was 5,000) (11 points). Do not forget to provide your spreadsheet showing your results.
Second, reduce the planning horizon to 4 months. Has this modification changed the optimal production in month 1 (from the book this was 5,000) (11 points). Do not forget to provide your spreadsheet showing your results.
The post BUExcel business questions first appeared on .
