• 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
• Level: GCSE
• Subject: ICT
• Word count: 2003

# Model Price Chart.

Extracts from this document...

Introduction

Task 5: Model Price Chart For this task I will have to produce a model price chart in a spread sheet format to figure out the most appropriate prices to charge for each of the products being sold by Holly Grove High School. They need to maintain enough profit to fund sports day without charging an extortionate amount for the drinks, and this chart is intended to help this. I need to produce a system in which the decision concerning the prices can be easily resolved. The school have noticed that different amounts of drinks are sold during different weather conditions, and so have asked me to account for this by calculating the most suitable prices for each type of weather. I will have to keep the following factors in mind when creating the price chart: * It will have to show the minimum profit available to the school * The price chosen using the chart much cover the total cost of Sports Day * We must account for the money given by Helmcroft Hall and the ice cream van, and deduct it from the over all profit total. * There must be 5 different spreadsheets, one for each weather condition with the prices altered accordingly. * It must be easily updated for use in the following years * The prices chosen must be payable (i.e. ...read more.

Middle

To make sure that the spreadsheet is easy to understand and clear to read, I will make a sample chart to accustom myself with the system. Firstly, I will have to work out the total amount of money being spent on Sports day so I will then know the minimum amount that will have to be raised. I can then account for the sponsoring and any other money coming in other than from the refreshments etc. Then I can calculate the cost of the drinks to the school, and use the information given to me on the predicted sales in the varying weather conditions, hopefully resulting in 5 different total costs. This will show the minimum amount of money to be raised whilst ensuring the school makes a small profit. I will then have to work out the most apt price for the cold drink while the hot drinks are 60p as long as it is no more than 60p, as previously mentioned. The amount of cold drinks purchased will obviously be depending on the weather as more people will be expected to buy cold drinks in hot weather etc, so I will vary the price because of this for each type of weather. I will do this by using the other information and seeing which cost stops the school losing money. Next, I will do the same but with the price of a hot drink being 55p. ...read more.

Conclusion

I then worked out the profit made on the drinks, and then deducted the fixed cost of the day to see what overall profit if any, was being made in that circumstance. I decided to increase my price by �0.01 each time to compare the results and continued raising my price until it reached �0.60. I did the same to the cold drinks results as I did to the hot drinks results, I multiplied the price charged for the cold drinks by the total number of cold drinks sold for each type of day. Task 5: Evaluation I believe that my model price chart fits with the required criteria: * It will have to show the minimum profit available to the school * The price chosen using the chart much cover the total cost of Sports Day * We must account for the money given by Helmcroft Hall and the ice cream van, and deduct it from the over all profit total. * There must be 5 different spreadsheets, one for each weather condition with the prices altered accordingly. * It must be easily updated for use in the following years * The prices chosen must be payable (i.e. they need to be integers) * The chart should ensure that no money is lost and not too much is gained. * The price range of a hot drink must be 55p - 60p * The cost of a cold drink must not exceed 60p I worked out the suitable prices for both drinks and the profit made in each weather condition. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

1. ## System requirements analysis

If you have used some alternative software (e.g. Access), speak to your teacher about how to complete this section of the coursework. Task 6 Evaluation of your system 6.1 Explanation of a non-ICT system (A02.32) * Provide a detailed description of how the receptionist's requirements could be met by using and non-ICT system.

2. ## Performance Charts - The aim of this task is to produce a simple chart ...

INSTRUCTIONS To complete the task, fulfilling the analysis criteria, there are several steps that must be taken to reach the final product. These are: * After opening Microsoft Excel, the data provided on file must be pasted into the spreadsheet.

1. ## Financial Model to help organise the year eleven prom

This causes a problem because if anything changes they will have to repeat the whole lot of sums over and over and over again. However, they have asked for a deposit of �5.00 from each pupil that feels that he/she will go.

2. ## Gantt Chart Basics.

If today's date were May 13, Task A would be behind schedule, Task B ahead and Task C right on schedule. The events marked by '-M-' are milestones. Using Excel to Make Gantt Charts You can use Microsoft Excel to make Gantt charts that are easy to update and maintain.

1. ## I am investigating into Price

| | | | | | | | | 25 45 10 000 ? � < 14 999 | | | | | | | | 9 54 15 000 ? � < 19 999 | | | | | | 7 61 20 000 ?

2. ## ICT Job Applications - Enric&amp;amp;eacute;'s Tapas Bar.

4 'Save As' box appears. 5 Message box appears, confirming that the letter has been saved. This macro makes the system work more efficiently by reducing the procedures the user has to go through. This reduces the probability of making a mistake, which is time consuming to correct.

1. ## Theatre Model

So this model will be cost effective. Also using a model I can see if I changed a variable or input how would it affect my overall income. For example 'What if I paid the cleaners less?' or 'What if I raised the prices of tickets?'

2. ## Ict - Improvement Of The Sports Day Programme

The Data Needed To Produce The Output The data needed to produce the output is specified in the booklet and is as follows. * The data for the school crest is on a Alison Goldsmiths computer so can be given through email or disk.

• Over 160,000 pieces
of student written work
• Annotated by
experienced teachers
• Ideas and feedback to