GP
Lollll
Excel111.doc|
Excel |
|
|||||
|
Assignment 1 |
|
|||||
|
|
|
|
|
|
|
|
|
1a. Create the following spreadsheet. All numeric amounts should be edited into the |
|
|
||||
|
Currency format. (Net Profit = Total Income - Total Expenses). Bold face the Total |
|
|||||
|
Lines and Total Column. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Acme Industries |
|
|||||
|
1232 Acme Avenue |
|
|||||
|
Toledo, OH 43606 |
|
|||||
|
|
|
|
|
|
|
|
|
Yearly Income Statement |
|
|||||
|
Quarters |
|
|||||
|
|
|
|
|
|
|
|
|
Item |
First |
Second |
Third |
Fourth |
Total |
|
|
|
|
|
|
|
|
|
|
INCOME: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales Income |
10,523.50 |
13,459.25 |
17,752.00 |
11,543.50 |
xx |
|
|
Labor Income |
7,983.34 |
11,208.00 |
15,438.34 |
10,654.54 |
xx |
|
|
Total Income |
xx |
xx |
xx |
xx |
xxx |
|
|
|
|
|
|
|
|
|
|
EXPENSES: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Store Rental |
1,500.00 |
1,500.00 |
1,500.00 |
1,500.00 |
xx |
|
|
Telephone |
750.00 |
754.87 |
789.66 |
875.78 |
xx |
|
|
Utilities |
435.56 |
431.56 |
444.58 |
487.99 |
xx |
|
|
Advertising |
600.00 |
600.00 |
600.00 |
600.00 |
xx |
|
|
Insurance |
250.00 |
250.00 |
250.00 |
250.00 |
xx |
|
|
Materials |
2,430.34 |
2,039.55 |
2,583.34 |
2,324.43 |
xx |
|
|
Payroll |
7,837.33 |
7,837.33 |
7,837.33 |
7,837.33 |
xx |
|
|
Misc. Services |
342.78 |
298.39 |
384.33 |
483.22 |
xx |
|
|
|
|
|
|
|
|
|
|
Total Expenses |
xx |
xx |
xx |
xx |
xx |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Profit |
xx |
xx |
xx |
xx |
xx |
|
