Page 383 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

5 That’s it; it will add the Solver tool to your Excel Worksheet.
6 The Solver add-ins programming tool is located on the Data tab, in the Analysis group.

TASK 1: Application of Excel Solver to Get Maximize Profit of Products
This company has some constraints that must be met to produce products:
• The combined production capacity is 300 units per day.
• The company needs 50 units of Software to fill an existing order.
• The company needs 40 units of Computer to fill an expected order.
• The company needs 40 units of Networking Kit to fill an existing order.

Step 1: First, go to the Data tab on your ribbon.
• Then select Solver from the Analysis group.

368
CITS : IT & ITES - Computer Software Application - Exercise 65