Spreadsheet In-Class Lab Exercise |
|
|
|
|
|
|
Your Dear
Uncle Schlocko has offered to advance you $5,000 to start your own home
office. |
|
All he asks
is that you name the type of business (see below) and that you show how |
|
you plan to
expend the money. (You must use it all in the first three months of
operation.) |
|
|
Fill in here… Your Name… |
|
|
|
|
|
|
|
|
Type of Business… |
|
|
|
|
|
|
Allocate
the dollars below and fill in formulas to compute totals and percentages. |
|
(Amounts
indicated are suggested amounts - your expenditures may vary from these
amounts.) |
|
|
|
Startup |
|
|
|
|
|
|
Costs |
Jan |
Feb |
March |
Totals |
|
Furniture |
|
|
|
Desk ($175) |
|
|
|
Chair ($90) |
|
|
|
Lamp ($30) |
|
|
|
File Cabinet ($120) |
|
|
|
Wiring ($10) |
|
|
|
|
|
|
Supplies |
|
|
|
Wastebasket ($6) |
|
|
|
In/Out Baskets ($4) |
|
|
|
Blotter ($20) |
|
|
|
File Folders ($8) |
|
|
|
Paper (ream, $3) |
|
|
|
Envelopes (50, $1.70) |
|
|
|
Tape (roll, $1) |
|
|
|
Stapler ($4) |
|
|
|
Fasteners ($3) |
|
|
|
Pens ($4) |
|
|
|
|
|
|
Other |
|
|
|
Rent ($600/mo) |
|
|
|
Phone ($150/mo) |
|
|
|
Electricity ($80/mo) |
|
|
|
Computer ($45/mo) |
|
|
|
Internet ($20/mo) |
|
|
|
Advertising ($100/mo) |
|
|
|
|
|
|
Total |
|
|
|
|
|
|
|
Percent |
|
|
|
|
|
|
|
|
|
|
|
|
|
|