Need this linear programming model solved in excel with


Need this linear programming model solved in Excel with Excel Solver along with the sensitivity report. Please attach Excel file with excel solver solution and sensitivity report.

Max: 30x + 15y - 18a - 22.5b - 12c
S.T. x + 0.35y - A < 100 Department A
0.3x + 0.2y - B < 36 Department B
0.2x + 0.5y - C < 50 Department C
A < 10 Overtime in Department A
B < 6 Overtime in Department B
C < 8 Overtime in Department C
x, y, A, B, C > 0

Solution Preview :

Prepared by a verified Expert
Accounting Basics: Need this linear programming model solved in excel with
Reference No:- TGS02557944

Now Priced at $10 (50% Discount)

Recommended (92%)

Rated (4.4/5)