|
|
|
|
|
|
|
|
|
| DSC 109 Test |
Julie Bodenhamer |
|
|
|
assumptions: sales growth |
|
20% |
|
|
quarter 1 |
quarter 2 |
quarter 3 |
quarter 4 |
total for year[1] |
|
| Income[2] |
|
| Sales |
$ 97,000.00 |
$
116,400.00 |
$
139,680.00 |
$167,616.00 |
$
520,696.00 |
|
|
|
|
| Expenses |
|
| Rent |
$ 4,500.00 |
$ 4,500.00 |
$ 4,500.00 |
$ 4,500.00 |
$
18,000.00 |
|
| Salaries |
$ 3,000.00 |
$ 3,000.00 |
$ 5,000.00 |
$ 6,000.00 |
$
17,000.00 |
|
| Misc. |
$ 1,200.00 |
$ 800.00 |
$ 900.00 |
$ 900.00 |
$
3,800.00 |
|
| Total Expenses |
$
8,700.00 |
$
8,300.00 |
$
10,400.00 |
$
11,400.00 |
$
38,800.00 |
|
|
| profit |
$
88,300.00 |
$
108,100.00 |
$
129,280.00 |
$156,216.00 |
|
|
|
| average expense |
$
9,700.00 |
|
|
|
|
| type your
name in B2 |
|
| compute
total expenses for quarters 1 to 4 |
|
| convert 0.2
in I4 to the percentage format with one decimal place |
|
| Quarter 2
sales are 20% more than quarter 1, quarter 3 sales 20% more than quarter 2,
quarter 4 sales 20% more than quarter 3 |
| create a
formula for quarter 2 sales that is 20% more than quarter 1 sales |
|
| Include
absolute cell reference to 20% in I4 in your formula. |
|
| Smartfill
this formula to quarters 3 and 4 |
|
| Compute
total for year for sales, expenses, and profit |
|
| Format your
data in a professional manner |
|
| Include
name boxes for total expenses and sales |
|
| Make sure
"profit" and "total for year" data are in currency format |
|
| Include a
comment box for "total for year sales" that states "20%
increase for each quarter" |
|
| Include a
3D pie graph that shows total expenses for the year for rent, salaries and
misc. |
|
| Include
chart title: Breakdown of Expenses |
|
| Include a
shadow box around the title |
|
| Include
expense items on graph in legend |
|
| Show label
and percent on your pie graph |
|
| Explode the
misc. expense in your pie graph |
|
| Move and
resize the graph directly beneath your data |
|
| post this
document on your web page |
|
|
|
|
|
|
|
|
|
|