The email application used by Jim’s office is sending emails with viruses attached to them to user’s computers. What step should
1 answer:
You might be interested in
Answer:
Refer to the explanation
Explanation:
Number of Mobiles=x1
Number of Workstations=x2
Constraints:
50x1 + 70x2 <= 1,60,000
250x1 + 700x2 <= 12,000,000
x1 >= 0 x2 >= 0
Objective function N(x1, x2) = 7800000000 x1 + 7200000000 x2
Excel formulae:
G17 = D9 * E7 + F9 * G7
G18= D10 * E7 * F10 * G7
G19= E7
G20= G7
G21= I17 * E7 + I18 * G7 (This will yield the Maximum)
And E7 and G7 will be the solution.
Set up your sheet as shown in the diagram and apply the formulas.
Access the tool and select solver. Upon opening the Solver dialog, confirm ‘Assume Linear model’ and ‘assume non-negative’. Click to solve the model and keep the solution.
