Task SP1
- Open a new Excel Spreadsheet
- Enter the Title "Business Spreadsheet" into cell A1
- Enter the data as shown below
| |
A |
B |
C |
D |
E |
| 1 |
Business Spreadsheet |
|
|
|
|
| 2 |
|
|
|
|
|
| 3 |
Staffing Budget |
|
|
|
|
| 4 |
|
|
|
|
|
| 5 |
Job Role |
Monthly Salary |
Number |
|
|
| 6 |
Company Director |
4500 |
1 |
|
|
| 7 |
Manager |
3000 |
4 |
|
|
| 8 |
Accountant |
2200 |
2 |
|
|
| 9 |
Web Designer |
1500 |
2 |
|
|
| 10 |
|
|
|
|
|
- Use column D to calculate the total salary cost - Label this column Total
- The total wage is calcualted by multiplying the monthly salary by the number of staff
- Copy this down for all job roles
- Enter SP1 into the HEADER of the spreadsheet
- Save the spreadsheet at BUSINESS_MODEL
- Add your name to the FOOTER and print it out
Task SP2
- Add a formula at the bottom of column D to show the Overall Total
| |
A |
B |
C |
D |
E |
| 1 |
Business Spreadsheet |
|
|
|
| 2 |
|
|
|
|
|
| 3 |
Staffing Budget |
|
|
|
|
| 4 |
|
|
|
|
|
| 5 |
Job Role |
Monthly Salary |
Number |
Total |
|
| 6 |
Company Director |
4500 |
1 |
=B6*C6 |
|
| 7 |
Manager |
3000 |
4 |
=B7*C7 |
|
| 8 |
Accountant |
2200 |
2 |
=B8*C8 |
|
| 9 |
Web Designer |
1500 |
2 |
=B9*C9 |
|
| 10 |
|
|
|
=sum(D6:D10) |
|
- Set the size of the Title "Business Spreadsheet" to 24 Point Arial
- Make each of the other headings stand out using BOLD
- Format the salaries in column B to currency
- Enter SP2 into the HEADER of the spreadsheet
- Save the spreadsheet at SP2
- Add your name to the FOOTER and print it out
Task SP3
- Add the OTHER COSTS below the Sraffing Budget as shown
| |
A |
B |
C |
D |
E |
| 1 |
Business Spreadsheet |
|
|
|
| 2 |
|
|
|
|
|
| 3 |
Staffing Budget |
|
|
|
|
| 4 |
|
|
|
|
|
| 5 |
Job Role |
Monthly Salary |
Number |
Total |
|
| 6 |
Company Director |
£4,500 |
1 |
=B6*C6 |
|
| 7 |
Manager |
£3,000 |
4 |
=B7*C7 |
|
| 8 |
Accountant |
£2,200 |
2 |
=B8*C8 |
|
| 9 |
Web Designer |
£1,500 |
2 |
=B9*C9 |
|
| 10 |
|
|
|
=sum(D6:D10) |
|
| 11 |
|
|
|
|
|
| 12 |
Other Costs |
|
|
|
|
| 13 |
Item |
Montly cost |
Annual Cost |
|
|
| 14 |
Utilities |
500 |
|
|
|
| 15 |
Telephone |
300 |
|
|
|
| 16 |
Office Rental |
1000 |
|
|
|
| 17 |
|
|
|
|
|
- The cost of calculating the annual cost is found by multiplying the montly cost by 12. Add a formula to calcualte the annual cost of the untilities
- Copy the formula down the rest of the column
- Add a foumula to find the total of the annual other costs
- Format the salaries in column B to currency
- Make sure all headings are shown in bold
- Enter SP3 into the HEADER of the spreadsheet
- Save the spreadsheet at SP3
- Add your name to the FOOTER and print it out
Task SP4
| |
A |
B |
C |
D |
E |
| 1 |
Business Spreadsheet |
|
|
|
| 2 |
|
|
|
|
|
| 3 |
Staffing Budget |
|
|
|
|
| 4 |
|
|
|
|
|
| 5 |
Job Role |
Monthly Salary |
Number |
Total |
|
| 6 |
Company Director |
£4,500 |
1 |
=B6*C6 |
|
| 7 |
Manager |
£3,000 |
4 |
=B7*C7 |
|
| 8 |
Accountant |
£2,200 |
2 |
=B8*C8 |
|
| 9 |
Web Designer |
£1,500 |
2 |
=B9*C9 |
|
| 10 |
|
|
|
=sum(D6:D10) |
|
| 11 |
|
|
|
|
|
| 12 |
Other Costs |
|
|
|
|
| 13 |
Item |
Montly cost |
Annual Cost |
|
|
| 14 |
Utilities |
£500 |
=B14*12 |
|
|
| 15 |
Telephone |
£300 |
=B15*12 |
|
|
| 16 |
Office Rental |
£1000 |
=B16*12 |
|
|
| 17 |
|
|
=sum(C14:C17) |
|
|
| 18 |
|
|
|
|
|
| 19 |
TOTAL ANNUAL SALARY |
=D10*12 |
|
|
|
| 20 |
|
|
|
|
|
| 21 |
OVERALL ANNUAL COSTS |
=B19 +C16 |
|
|
|
| 22 |
|
|
|
|
|
- The cost of calculating the TOTAL ANNUAL SALARY is found by multiplying the TOTAL MONTHLY SALARY by 12.
Add a formula to calcualte the annual cost of the SALARIES
Add the sub-title TOTAL ANNUAL SALARY
- The OVERALL ANNUAL COSTS is calculated by adding the TOTAL ANNUAL SALARY to the TOTAL EXTRA COSTS
Add a formula to calcualte the annual cost of the OVERALL ANNUAL COSTS
Add the sub-title OVERALL ANNUAL COSTS
- Format the necessary cells to currency
- Make sure all headings are shown in bold
- Enter SP4 into the HEADER of the spreadsheet
- Save the spreadsheet at SP4
- Add your name to the FOOTER and print it out
|