Spreadsheet
Scenario
You are helping at the Downloadable Tunes as part of your work experience. You
have been asked to solve some of their problems using your ICT skills.
You are required to develop a system for calculating the sales and profit for the
company. The system should have the following functions:
Calculating the total paid by the customers
Calculating the V.A.T
Calculating the Profit for each month.
Information: -
Below are the sales and costs for each month
Sales Costs
Jan 425 £30.00
Feb 368 £20.00
Mar 158 £20.00
Apr 208 £12.00
May 600 £10.00
Jun 587 £10.00
Jul 425 £8.00
Aug 522 £15.00
Sep 553 £20.00
Oct 584 £30.00
Nov 616 £25.00
Dec 647 £10.00
Task 1 Design and create a Spreadsheet which incorporates the above information.
Task 2 Calculate the total amount paid by customers –V.A.T
Task 3 Calculate the total V.A.T for each month. (V.A.T =20%)
Task 4 Calculate the total amount paid by the customers including V.A.T
Task 5 Calculate the profit.
Task 6 Insert a formula to work out the date
Task 7 Your spreadsheet must include +, -, *, /
Task 8 The company needs to make £3000 to break even. Anything above this is
considered a success. You need to include an IF function to show this.
Task 9 You need to include a formula to round the profit up to 2 decimal places.
Task 10 You need to include a formula to work out monthly sales.
Task 11 The user must be able to distinguish between variables and formulas.
Task 12 Enough help must be included to help a novice use your spreadsheet.
Task 13 Set text direction
Task 14 Wrap text
Task 15 Adjust column widths and add borders and shading.