Microsoft Office Tutorials and References
In Depth Information
Introduction
Using a sketch of the worksheet can help you visualize its design. The sketch
of the worksheet consists of titles, column and row headings, location of data values,
calculations, and a rough idea of the desired formatting (Figure 3 – 3a). The sketch of the
3-D pie chart shows the expected contribution of each month’s operating income to the
six-month operating income (Figure 3 – 3b). The assumptions will be entered at the top
of the worksheet (Figure 3 – 3a). The projected monthly sales revenue will be entered
in row 13 of the worksheet. The projected monthly sales revenue and the assumptions
shown in Table 3 – 1 will be used to calculate the remaining numbers in the worksheet.
Figure 3 –3 (a)
Worksheet Sketch
What-If Assumptions
Bonus ZZ,ZZZ,ZZ9.00
Commission Z9.99%
Margin Z9.99%
Marketing Z9.99%
Research and Development Z9.99%
Sales Revenue for Bonus ZZ,ZZZ,ZZ9.99
Support, General, and Administrative
Z9.99%
Modern Music Shops
Six-Month Financial Projection
99/99/999
Month 1
$ZZ,ZZZ,ZZ9.99
Month 2
$ZZ,ZZZ,ZZ9.99
Month 3
$ZZ,ZZZ,ZZ9.99
Month 4
$ZZ,ZZZ,ZZ9.99
Month 5
$ZZ,ZZZ,ZZ9.99
Month 6
$ZZ,ZZZ,ZZ9.99
To t a l
$ZZ,ZZZ,ZZ9.99
Chart
Revenue
Cost of Goods Sold
Gross Margin
Expenses
Bonus
Commission
Marketing
Research and Development
Support, General, and Administrative
Total Expenses
Operating Income
$Z,ZZZ,ZZ9.99
$Z,ZZZ,ZZ9.99
$Z,ZZZ,ZZ9.99
$Z,ZZZ,ZZ9.99
$Z,ZZZ,ZZ9.99
$Z,ZZZ,ZZ9.99
$Z,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
$ZZ,ZZZ,ZZ9.99
Six-Month Financial Projection
Month 5
%
Month 4
%
Month 6
%
Month 3
%
Month 1
%
Month 2
%
Figure 3 –3 (b) 3-D
Pie Chart Sketch
 
Search JabSto ::




Custom Search