• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4
5. 5
5
6. 6
6
7. 7
7
8. 8
8
9. 9
9
10. 10
10
11. 11
11
12. 12
12
13. 13
13
14. 14
14
15. 15
15
16. 16
16
17. 17
17
18. 18
18
19. 19
19
20. 20
20
21. 21
21
22. 22
22
23. 23
23
24. 24
24
25. 25
25
26. 26
26
27. 27
27

# Spreadsheet Report for Tuck Shop

Extracts from this document...

Introduction

Middle

The 'Quantity Stored' needed a simple SUM formula to work out the quantity of products owned with minus the quantity sold. I used the formula =SUM(C5-D5) I then copied the formula down to the other cells in the 'Quantity Stored' column. Using the formula =SUM(C5-D5) I used an If function for the 'Quantity Lost', it tells you whether or not there are any products lost by showing either 'YES' or 'NO'. The formula is: =IF(D5<'Product Information (week 1)'!E5,"YES","NO") The formula is saying that if E5 on the 'Product Information' (week 1)' sheet (Quantity Sold) is less than D5 (on 'Product Information' week 2) the cell should show 'YES' and if it isn't it should show 'NO'. This is correct because the stored food only lasts for one week, so if the amount sold in week 2 is less than the amount stored it is lost. If Statement formula =IF(D5<'Product Information (week 1)'!E5,"YES","NO") I have now finished Sheets 1 and 4(Product Information Sheets 2 and 5 (Product Expenses) I entered the column headings shown below. I also labelled the sheet 'TUCK SHOP' and typed in the week and date, but first I had to format the cell by right clicking on it and selecting 'Format cells'. I also wrote 'Week 1' to indicate which week it is. I formatted a cell for the date and entered it in like I have shown before. I changed the back ground of rows, merged cells for the title and froze panes the same way as I have shown before. I formatted some cells (like I have shown before) in the columns from 'General' to 'Currency' and selected the currency to be '� English (United Kingdom)'. I then entered the data, for 'Price bought each' and 'Price sold each' which I collected from Mrs Smith. I now had to use a formula to work out the 'Total money spent on buying products' To do this I needed to times the 'Price bought each' with 'Quantity Bought' on the 'Product Information' sheet (sheet 1). ...read more.

Conclusion

The only differences were that the data was from week 2 and the chart title was changed to 'Profit and Loss of Products'. The chart for week 2 is shown below. Bar chart to show the profit and loss of products in week 2 Formulas and functions The formulas and functions that I have used in this spread sheet are: * Sum - There are a total of 215 (115 subtraction formulae, 92 multiplication formulae, 8 addition formulae) * Average - There is one average formula * IF - There are a total of 71 IF statements and there are 2 main different ones (ADD MORE) and SUBTRACTION (How will the data be manipulated by formulas and functions?) (borders)(comment on formatting cell sizes) (percentage formula)(errors) Formulas and functions The formulas and functions that I have used in this spread sheet are: * Sum - subtraction formulas, multiplication formulas, and addition formulas) * Average * IF (Add more) Graphs I have created 4 charts using the chart wizard, they are: * Profit and Loss graph (Week 1) * Total of Products Sold (Week 1) * Profit and Loss graph (Week 2) * Total of Products Sold (Week 2) The 'Profit and Loss graph' for both weeks is a bar chart showing the profit (positive number) and loss (negative number) of each different product. It is colour coded and has a key; each colour represents a particular product, for e.g. navy blue is for 'Coca Cola (bottle)'. The 'Y' axis shows the amount of profit or loss in pounds. The 'Total of Products Sold' for both weeks is a pie chart showing which and the amount of products that make up the total money received for both weeks. The pie chart is colour coded and contains a key to show which colour represents a product. What if... queries I have used 5 different If queries they are: * =IF('Product Expenses (week1)'!E11>'Product Expenses (week1)'!D11,"PROFIT","LOSS") This is used to calculate whether or not there was a total profit or loss for each product in week 1. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Structures, Objectives & External Influences section.

## Found what you're looking for?

• Start learning 29% faster today
• 150,000+ documents available
• Just £6.99 a month

Not the one? Search for your essay title...
• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month

# Related AS and A Level Structures, Objectives & External Influences essays

They will also agree to obey the rules so the risk will be slightly reduced. Furthermore of looking at the risk of injury we have chosen Mr. Sharp to supervise our event as he is qualified to give first aid.

2. ## Ownership and finance for my business. The business I am doing is a clothes ...

All charities are voluntary organizations, but not all voluntary organizations in England and Wales are charities. For a voluntary organization to be a charitable organization or charity, its overall goals, sometimes called the "purposes" of the organization, must be charitable.

1. ## Outback Steakhouse has always had a formula for success. From its tiny beginnings in ...

Today's restaurant patrons expect great food and top quality service from the restaurants they visit. In addition to this, they long for an experience, a type of transportation from the hustle and bustle of the real world. At the end of the night, the check should be the souvenir of an exciting excursion.

2. ## 'Will It Make A Profit?'

> Penetration Pricing - this involves setting a lower price for the product when it is launched rather than a high price, with the aim of achieving a large, if not dominant market share. > Cost plus pricing - this is when a price is fixed by adding a percentage profit margin to the cost of production of the product.

1. ## Peacocks - case study

owner interest in a business, thereby allowing the owner to recover his or her investment. The agreement also fosters the continuation of the business by not allowing the departing owner's interest to fall into the hands of outsiders' persons who may not be qualified to run the business or who may be incompatible with the remaining owners.

2. ## Investigating Business. Tesco PLC. I will be describing the aims and objectives of ...

Work level 5 is about responsible for the performance of Tesco as a whole. Requires the ability to lead and direct others, and to make major decisions. Work level 6 is about creating the purpose, values and goals for Tesco plc.