Analysis
My task is to design a spreadsheet that can be used by a school tuck shop, which can be used to find the following:
* Income
* Expenditures
* Stock amounts
* Popularity of products
* The selling price of stock
* Profit made
* Wages of employees
* Whether to order more stock
The spreadsheet can be used as a model to predict all of these things throughout the three school terms. The product popularity can be used to see what products are most popular and unpopular in the different seasons. This can then be used to order in more or less of a certain product to get maximum profit. The spreadsheet has been designed to calculate the how much profit you make on each item and how much overall after expenses such as electricity and wages have been paid. IF formulas have been used to tell the owner when he/she needs to buy in more of a certain product.
By using the relevant information from the spreadsheet, chart can be made. The popularity of items could be shown on the charts. The spreadsheet is set up so that if you change a certain variable, all of the calculations are updated and you are able to predict what will happen. For example:
* If VAT rose to 20% on one week
* If Electricity costs went up by £3
* If national insurance rose by 3%
* If TAX rose by 5%
* If certain stock doesn't sell
I will use these examples as tests to test out the model spreadsheet.
This is what processing is required for my spreadsheet:
. Two IF functions
2. Two different formulae
3. Two arithmetic functions
4. Two different types of charts/graphs
5. Cell formats (column width and height)
6. Ranking and sorting
Creating the first spreadsheet layout
For spreadsheets Autumn week 1 to Summer week 3 you will need this layout in each and the following formulae.
expenditure
product type
product name
number sold last week
number in stock from last week
crisps
walkers ready salted
walkers smokey bacon
chocolate bar
dream
whisper
aero
snickers
mars bar
kit kat
twix
sweets
skittles original
polos original
refresher bar
sour skittles
drinks
pepsi bottled
fanta bottled
bottled water
My task is to design a spreadsheet that can be used by a school tuck shop, which can be used to find the following:
* Income
* Expenditures
* Stock amounts
* Popularity of products
* The selling price of stock
* Profit made
* Wages of employees
* Whether to order more stock
The spreadsheet can be used as a model to predict all of these things throughout the three school terms. The product popularity can be used to see what products are most popular and unpopular in the different seasons. This can then be used to order in more or less of a certain product to get maximum profit. The spreadsheet has been designed to calculate the how much profit you make on each item and how much overall after expenses such as electricity and wages have been paid. IF formulas have been used to tell the owner when he/she needs to buy in more of a certain product.
By using the relevant information from the spreadsheet, chart can be made. The popularity of items could be shown on the charts. The spreadsheet is set up so that if you change a certain variable, all of the calculations are updated and you are able to predict what will happen. For example:
* If VAT rose to 20% on one week
* If Electricity costs went up by £3
* If national insurance rose by 3%
* If TAX rose by 5%
* If certain stock doesn't sell
I will use these examples as tests to test out the model spreadsheet.
This is what processing is required for my spreadsheet:
. Two IF functions
2. Two different formulae
3. Two arithmetic functions
4. Two different types of charts/graphs
5. Cell formats (column width and height)
6. Ranking and sorting
Creating the first spreadsheet layout
For spreadsheets Autumn week 1 to Summer week 3 you will need this layout in each and the following formulae.
expenditure
product type
product name
number sold last week
number in stock from last week
crisps
walkers ready salted
walkers smokey bacon
chocolate bar
dream
whisper
aero
snickers
mars bar
kit kat
twix
sweets
skittles original
polos original
refresher bar
sour skittles
drinks
pepsi bottled
fanta bottled
bottled water