S&N wants to determine the number of steel sheets to produce in order to maximize monthly profit.
Let A,B,C,and D denote the number of units of model A,B,C,and D to be produced,respectively.
-Using Solver,determine the number of hours used in the rolling department.
A)175.076 hours
B)302.294 hours
C)225.000 hours
D)330.000 hours

Question

S&N wants to determine the number of steel sheets to produce in order to maximize monthly profit.
Let A,B,C,and D denote the number of units of model A,B,C,and D to be produced,respectively.
-Using Solver,determine the number of hours used in the rolling department.
A)175.076 hours 
B)302.294 hours 
C)225.000 hours 
D)330.000 hours

Quizplus · Accepted Answer

Solver is a Microsoft Excel add-in program you can use for what-if analysis. It finds an optimal value for a formula in one cell—subject to constraints, or limits, on the values of other formula cells on a worksheet. Without specific details of the problem setup (objective function, constraints, etc.), it's impossible to solve directly here. However, assuming the question is based on a specific scenario where Solver was used to determine the number of hours used in the rolling department, and given the options, if C) 225.000 hours is presented as the correct answer, it implies that within the context of that scenario, Solver found 225.000 hours to be the optimal solution based on the constraints and objective function provided in the problem setup.

S&N Wants to Determine the Number of Steel Sheets to Produce