• 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

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. System requirements analysis

    Explain what each macro does and include a copy of the code. If your system design does not include macros, give a full explanation of your use of data validation and cell and worksheet protection. If you have used some alternative software (e.g.

  2. Coursework 1A

    The physical catalogue from the 'Gadget Shop' can be seen included in the previous folder along with my three draft catalogues. Also, thanks to the 'Mick Jagger Centre' catalogue, I was able to see that many music related catalogues include some form of tour schedule in them.

  1. IT A1

    In the Gradient Colour section I clicked on two colours. I chose pink and purple. In the Shading Styles I changed it to Diagonal Up and clicked on a Variant, then clicked ok and then Apply to All.

  2. I have been assigned with the task of identifying what influences the sale price ...

    Collecting data In order to complete this assignment and to investigate the factors that affect the price of a used car I shall need to obtain some data. The data that I shall use has been readily prepared. Using the data that has been provided I shall chose two factors, which I shall investigate.

  1. I am investigating into Price

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

  2. Adam Property Maintenance - System analysis.

    given any specific tasks and which location the engineers will operating in each day. Then the job log list can be produced as shown below: Name: Peter Date: 09/10/02 TIME/COMP JOB ADDRESS JOB DESCRIPTION PHONE NUM 9-12 57 Hindhead Gardens, Middx UNF 5NF Toilet Handle is broken repair/replace +living room

  1. Develop a spreadsheet application for the Ibis Hotel.

    This caused Ibis Hotel many problems such as when typing and an error would occur the whole document has to be re-written. * There is also a main problem with using typewriters at Ibis Hotel, as many standard letters have to be sent to many visitors or mainly the staff at Ibis.

  2. Analysis of stock ordering for Henley Ice cream Parlour.

    12. What is the information used for? It is used to put together an order for the shop. 13. How reliable and accurate is the data? Not very accurate as tubs of ice cream may have been put in the wrong box, boxes may be counted twice or not counted at all.

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