Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING A SPREADSHEET FOR DECISION SUPPORT
￿
Each Changing Cell must be an integer greater than or equal to zero
you cannot buy half
an ad.
￿
Your total spending on advertising cannot exceed the limit specified in the Constants
section.
worksheet to use with Solver. When Solver finds a
solution, it will replace the historical advertising media selections with the new optimized selections. To
create a copy of the spreadsheet in the same workbook, right-click the tab at the bottom of the worksheet.
In Figure 8-6, note that the worksheet is named Kuhlmans
Next, you should make a copy of your
historical
Historical. Select Move or Copy from the menu.
FIGURE 8-6
Selecting the Move or Copy command
When the Move or Copy dialog box appears (see Figure 8-7), click Create a copy, click the (move to end)
option, and then click OK.
FIGURE 8-7
Move or Copy worksheet dialog box
s name followed by a (2). Right-click
the name tab to rename the worksheet (see Figure 8-8). In this example, the worksheet was renamed
Kuhlmans
The new copy of the worksheet will appear with the old worksheet
Solver.
FIGURE 8-8
Renaming the copied worksheet
 
Search JabSto ::




Custom Search