| Jana Decker |
|
|
|
|
|
|
|
| DSC 109 Test |
|
|
|
|
assumptions: sales growth |
0.2 |
|
|
|
quarter 1 |
quarter 2 |
quarter 3 |
quarter 4 |
total for year |
|
|
| Income[1] |
|
|
| Sales |
$97,000.00 |
$116,400.00 |
$139,680.00 |
$167,616.00 |
$201,139.20 |
|
|
|
| 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 |
$162,339.20 |
|
|
|
|
| average
expense |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
