• 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

    * In particular, explain any limitations presented by the software that you used to build your system. 6.3 Improvements to your system, and what you have learnt (A02.29, A02.30, A02.32, A03.15, A03.13, A03.14) * List and explain the main changes you have made to your system during its development.

  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

    So it helps them out a little. Furthermore it will give them a little more money so they can continue their research for more venues, catering firms, music and decorations etc. They can try and get previous problems sorted as well.

  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. Different types of technology How I use ICT at home and at school

    It gives me access to see what everyone else is doing, what the latest gossip is and actually feel like a normal social person. It gives me a social life even though I don't actually participate in social events. Another big advantage of Facebook is its ability to reconcile with

  2. I am investigating into Price

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

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

    This means that the user can use the job application system more efficiently. Mail merge macro: Mail merge macro Procedure Description 1 Mail merges active record 2 Prints the mail merged letter as new document 3 Message box appears, confirming that the letter has printed out.

  2. 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?'

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