Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT
FIGURE 9-11
The Page Setup dialog box
ASSIGNMENT 2: USING THE WORKBOOK FOR DECISION SUPPORT
You have built a series of worksheets to capture each manager
s proposal for the Sales and Operations plan,
along with your own optimized plan. You will now complete the case by using your solutions and Answer
Reports to gather the data needed to make the hiring decisions, and by documenting your recommendations
in a memorandum.
Assignment 2A: Using Your Workbook to Gather Data
Use your consolidated workbook and the printouts you created in Assignment 1B to develop a summary table of
results that you will place in your memo. The easiest way to make this table is to create a new worksheet in
your workbook, and then copy and paste the table into your memo. The table format is shown in Figure 9-12.
FIGURE 9-12
Format of table to be used in memo
A 3-D column chart of the total cost will add visual impact to your presentation. You can insert the
chart in the same worksheet as the table, as shown in Figure 9-13. To start a chart, select your four model
headings (cells C4 to F4), and then hold down the Ctrl key to select the four Total Cost cells (cells C12 to
F12). Next, click the Insert tab on the Ribbon. In the Charts group, click Column, and then select 3-D
Column from the menu.
A 3-D column chart is placed in the worksheet. Click it to select it, and reposition the chart beneath your
table. Enter an appropriate title for the chart. You can watch the chart values become columns as you fill in
the Total Cost cells. In Figure 9-13, the value in cell C12 is not the correct solution for the Chase Plan total
cost. It was entered to illustrate the graph as it was being built.
 
Search JabSto ::




Custom Search