A mining company owns two mines, each of which produces three grades (high, medium, and low) of ore. The company 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 4567 6 Variable Cells 7 8 9 10 Cell Name $B$3 X1 Hours to operate Mine 1 $C$3 X2 Hourse to operate Mine 2 11 12 Constraints 13 14 Cell Name 15 $E$6 High-grade constraint LHS 16 17 $E$8 Low-grade constarint LHS $E$7 Medium-grade constarint LHS Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 280 40 93.33333333 1 3 0 0 None of the above 200 160 Final Shadow Constraint Allowable Value Price R.H. Side Increase 12 8 40 10 70 0 12 8 24 8 4 16 40 Allowable Decrease 2 1E+30 Use this sensitivity report to answer the questions below. If the (minimum) requirements increased by 2 tons for each of high-grade, medium-grade, and low-grade ore: What minimum Cost could be realized? Would the optimal solution change? The sum of percentages ≥100%, the shadow prices are not operative. Not enough information provided. Thus, we should create a new model and rerun solver to answer this question. The sum of percentages ≤ 100%, the shadow prices are operative. The minimum cost would be $840. The optimal solution will not change. The sum of percentages ≤ 100%, the shadow prices are operative. The minimum cost would be $840. The optimal solution would change.

During the campus Spring Fling, the bumper car amusement attraction has a problem of cars becoming disabled and in need of repair. Repair personnel can be hired at the rate of $20 per hour, but they only work as one team. Thus, if one person is hired, he or she works alone; two or three people work together on the same repair. One repairer can fix cars in an average time of 30 minutes. Two repairers take 20 minutes, and three take 15 minutes. While these cars are down, lost income is $40 per hour. Cars tend to break down at the rate of two per hour. Management is trying to decide how many repair persons to hire, and has asked you for cost data. What is the total hourly cost with one repair person? multiple choice $60 $∞ $140 What is the total hourly cost with two repair persons? Note: Round your answer to the nearest dollar amount.   What is the total hourly cost with three repair persons? Note: Round your answer to the nearest dollar amount.   How many repairers…

Consider the table attached below:Assuming an M/M/1 setup, a service rate of 18 customers every 10 minutes, and a traffic intensity of 0.90.Assume a probability density function characterized by the exponential distribution.i). Compute the corresponding variates.ii). How robust is the above derived density function?

Consider a Poisson queue with the following steady-state probabilities: po = 1/3, p1 = 1/2, p2 = 1/6, and pn = for n = 3,4,5, ... . What is the minimum number of stools that would accommodate all customers in the system at least 75% of the time in steady state? 3 stools O 2 stools none of the other choices O 1 stool