50.1K

Verified Solution

Link Copied!

ign and low of ore mpany has a contract to supply a smelting company with at least 12 tons of high grade ore at least 8 tons of medium grade ore and at least 24 tons of low grade ore Each hour of operation mine 1 produces 6 tons of high grade ore 2 tons of medium grade ore and 4 tons of low grade ore Each hour of operation mine 2 produces 2 tons of high grade ore 2 tons of medium grade ore and 12 tons of low grade ore It costs 200 per hour to operate mine 1 and 160 per hour to operate mine 2 How many hours should each mine be operated so as to meet the contractual obligations at the lowest total operating cost D 1 Microsoft Excel 16 0 Sensitivity Report 2 Worksheet 2 xlsx solution 3 Report Created 10 26 2019 7 20 34 PM 4 5 6 Variable Cells 7 8 9 10 11 12 Constraints 13 14 Cell Name B 3 X1 Hours to operate Mine 1 C 3 X2 Hourse to operate Mine 2 Cell Name E 6 High grade constraint LHS SE 7 Medium grade constarint LHS 15 16 17 E 8 Low grade constarint LHS OOO Low grade High grade and Medium grade Medium grade Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease High grade and Low grade 1 3 Use this sensitivity report to answer the questions below What constraints are binding at that optimal solution 12 8 40 0 0 Final Shadow Constraint Allowable Value Price R H Side Increase 200 160 10 70 0 12 8 280 40 93 33333333 24 8 4 16 Allowable Decrease 40 2 1E 30

Answer & Explanation Solved by verified expert

See Answer