• 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

    Task 7 Investigation of a clinical system Many medical practices use a clinical system to carry out appointment bookings. A clinical system is more complex than the system you have built. Booking appointments is just one of the functions these systems perform.

  2. Coursework 1A

    Further explanation of this is in the 'Clip Art Inclusion' Section It is for this reason that I amalgamated both IT with non-IT sources when coming up with my ultimate catalogue design, so that I could get the best of both.

  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 am investigating into Price

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

  1. 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

  2. Develop a spreadsheet application for the Ibis Hotel.

    * Validation checks are carried out automatically by the database. The software that will be used While doing this course I will need many software packages to transcribe all of the data on the computer. The software that is mainly going to be used by me is word processing program

  1. 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.

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

    On screen in every file in the system, the interface should be the same as possible. The toolbars will be at the bottom of the screen and they will include names of function and pictures on buttons, to make the system simple to use.

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