Operation and management
leosdesire
exampleoftheassignment.docx
Assignment 3
Walsh Juice Company - Construct a spreadsheet and find the optimal solution with SOLVER
Contrary to what the Walsh problem says, there are 1,800 tons of grapes available in each of the 3 vinyards and the product need is 1,100 tons of each of the 3 products.
Solution
Excel screenshot showing formulas used:
Excel screenshot with the results:
Excel limits report screenshot:
Excel sensitivity report:
Answer report screenshot:
