Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION
The relevant output cells are the four 2014 cells in the Summary of Key Results section. Run Scenario
Manager to gather the data in a report. When you finish, print the spreadsheet with the input for any one of
the scenarios, print the Scenario Manager summary sheet, and then save the spreadsheet file for the last time.
Assignment 2B: Documenting Your Recommendations in a Memorandum
Use Microsoft Word to write a brief memorandum documenting your analysis and conclusions. You can
address the memo to your banker. Observe the following requirements:
￿
Set up your memo as described in Tutorial E.
￿
In the first paragraph, briefly state the business situation and the purpose of your analysis.
￿
Next, provide the answers to your four questions.
￿
State your recommendation: should the company provide health insurance?
￿
Support your statements graphically, as your instructor requires. Your instructor may ask you to
return to Excel and copy the Scenario Manager summary sheet results into the memo. (See
Tutorial C for details on this procedure.) Your instructor might also ask you to create a
summary table in Word based on the Scenario Manager summary sheet results. (This procedure
is described in Tutorial E.)
Your table should resemble the format shown in Figure 7-9.
Scenario
2014 Net Income
2014 Cash on
Hand
2014 Debt Owed
2014 Return on
Sales
Prob-No
Prob-Yes
Poss-No
Poss-Yes
Worst-No
Worst-Yes
Opt-No
Opt-Yes
FIGURE 7-9
Format of table to insert in memo
ASSIGNMENT 3: GIVING AN ORAL PRESENTATION
Your instructor may ask you to summarize your analysis and recommendations in an oral presentation. If so,
assume that your banker wants the presentation to last 10 minutes or less. Use visual aids or handouts that
you think are appropriate. See Tutorial F for tips on preparing and giving a presentation.
DELIVERABLES
Assemble the following deliverables for your instructor:
1. Printout of your memo
2. Spreadsheet printouts
3. Electronic media such as a USB key or CD that contains your Word memo and Excel
spreadsheet file
Staple the printouts together with the memo on top. If you have more than one .xlsx file on your
electronic media, write your instructor a note that identifies your model
s .xlsx file.
Search JabSto ::




Custom Search