Operation and management
Assignment 3
Walsh Juice Company - Construct a spreadsheet and find the optimal solution with SOLVER
Walsh Juice Problem
Walsh Juice Problem
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: