• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Modelling Assignment- The school tuck shop

Extracts from this document...


Modelling Assignment- The school tuck shop Statement of the problem I am going to investigate the sales in a school tuck shop so I can maximize the products by changing the selling price. I am going to set up the model by using Microsoft excel and preparing a spreadsheet to put my data in. For each model, I will put the product, cost price, selling price, profit per item, sales and the overall profit, which is the most important that I am looking for. I will compare my results with the real data, and decide whether my results fit with the real data. If then I find that my model is not good enough, I will have to change some of my rules from my model. E.g.- change the selling price to coincide with the cost price etc. I will then be able to see if my model reflects the real data more closely. Annotated Hard Copies This is the original data from PART 1 of my modelling assessment. In this part, I had to find out the profit made per item, (mars, crisps, spira), record the original sales, the actual profit made for each product and the overall profit made by the tuck shop. ...read more.


�0.10 �0.37 �0.27 73 �19.71 �0.10 �0.38 �0.28 69 �19.32 �0.10 �0.39 �0.29 65 �18.85 �0.10 �0.40 �0.30 61 �18.30 �0.10 �0.41 �0.31 57 �17.67 �0.10 �0.42 �0.32 53 �16.96 �0.10 �0.43 �0.33 49 �16.17 I have found out that the best selling price when I increase the price is at 33p, as I get an overall profit of �20.47. This is my formula for this section on crisps. PRODUCT COSTPRICE SELL PRICE PROFIT P.ITEM SALES OVERALL PROFIT Crisps 0.1 0.23 =C47-B47 129 =E47*D47 0.1 =C47+0.01 =C48-B48 =E47-4 =E48*D48 0.1 =C48+0.01 =C49-B49 =E48-4 =E49*D49 0.1 =C49+0.01 =C50-B50 =E49-4 =E50*D50 0.1 =C50+0.01 =C51-B51 =E50-4 =E51*D51 0.1 =C51+0.01 =C52-B52 =E51-4 =E52*D52 0.1 =C52+0.01 =C53-B53 =E52-4 =E53*D53 0.1 =C53+0.01 =C54-B54 =E53-4 =E54*D54 0.1 =C54+0.01 =C55-B55 =E54-4 =E55*D55 0.1 =C55+0.01 =C56-B56 =E55-4 =E56*D56 0.1 =C56+0.01 =C57-B57 =E56-4 =E57*D57 0.1 =C57+0.01 =C58-B58 =E57-4 =E58*D58 0.1 =C58+0.01 =C59-B59 =E58-4 =E59*D59 0.1 =C59+0.01 =C60-B60 =E59-4 =E60*D60 0.1 =C60+0.01 =C61-B61 =E60-4 =E61*D61 0.1 =C61+0.01 =C62-B62 =E61-4 =E62*D62 0.1 =C62+0.01 =C63-B63 =E62-4 =E63*D63 0.1 =C63+0.01 =C64-B64 =E63-4 =E64*D64 0.1 =C64+0.01 =C65-B65 =E64-4 =E65*D65 0.1 =C65+0.01 =C66-B66 =E65-4 =E66*D66 0.1 =C66+0.01 =C67-B67 =E66-4 =E67*D67 Now I try to find the best profit maker if I reduce the price of crisps, my range is given from 23p to 0.3p. ...read more.


PRODUCT COST PRICE SELL PRICE PROFIT P.ITEM SALES OVERALL PROFIT SPIRA 0.18 0.23 =C94-B94 76 =E94*D94 0.18 =C94-0.01 =C95-B95 =E94-4 =E95*D95 0.18 =C95-0.01 =C96-B96 =E95-4 =E96*D96 0.18 =C96-0.01 =C97-B97 =E96-4 =E97*D97 0.18 =C97-0.01 =C98-B98 =E97-4 =E98*D98 0.18 =C98-0.01 =C99-B99 =E98-4 =E99*D99 0.18 =C99-0.01 =C100-B100 =E99-4 =E100*D100 0.18 =C100-0.01 =C101-B101 =E100-4 =E101*D101 0.18 =C101-0.01 =C102-B102 =E101-4 =E102*D102 0.18 =C102-0.01 =C103-B103 =E102-4 =E103*D103 0.18 =C103-0.01 =C104-B104 =E103-4 =E104*D104 0.18 =C104-0.01 =C105-B105 =E104-4 =E105*D105 0.18 =C105-0.01 =C106-B106 =E105-4 =E106*D106 0.18 =C106-0.01 =C107-B107 =E106-4 =E107*D107 0.18 =C107-0.01 =C108-B108 =E107-4 =E108*D108 0.18 =C108-0.01 =C109-B109 =E108-4 =E109*D109 0.18 =C109-0.01 =C110-B110 =E109-4 =E110*D110 0.18 =C110-0.01 =C111-B111 =E110-4 =E111*D111 0.18 =C111-0.01 =C112-B112 =E111-4 =E112*D112 0.18 =C112-0.01 =C113-B113 =E112-4 =E113*D113 0.18 =C113-0.01 =C114-B114 =E113-4 =E114*D114 This is my final profit table. It shows the new prices that I have found to be the best, and also shows the profit made. If you compare this table to the first, we can see that the new prices have really made a difference on the intake of profit. The profit was not high for spira, as there were not as many salesfor this product. Product Costprice(p) SellPrice(p) Profit Mars 14p 32p 20.16 Crisps 10p 33p 20.47 Spira 18p 30p 5.76 Overall profit 46.39 This pie chart shows the percentage of profit intake. The results of my profit investigaion show that genrally increasing the price of a product, you will have more profit. this was ...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

See related essaysSee related essays

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

  1. Is it feasible to open a Nail and Beauty Bar in Brookfield, Middlesbrough?

    treatment in order to determine to what level stocks would need to be held. Objective 4 - To determine how many days a week and at which times the Bar will attract the most customers, to enable opening times to be planned around the optimum demand times.

  2. Spreadsheet Report for Tuck Shop

    I would then find out how many products were bought and sold from the 'product information data'. I would then use formulas to work out the total of each product bought and sold, and the over all price bought and sold for all products.

  1. Introduction to Business Assignment

    Like GE, Sainsburys also have sub divisions or Subsidiary companies that they own. For example the other activities that they operate or run besides Groceries, include a chain of Sainsbury's Banks, Shaw's, JS Development and Sainsbury's Property Development. Their Companies 1.6 Shaw's Supermarkets Inc.

  2. Peacocks - case study

    The peacocks company has to be registered to the company's house before running. To do this the following has to be submitted: A memorandum of association This sets out the company's name, where the registered office is situated, and the company's objectives.

  1. As a student at Challney High School for Boys, my task is to decide ...

    The owner may not be good at running the business and then the business would collapse. 4) If the owner becomes very ill or dies it would be very difficult to maintain the running of the business. 2) Partnerships A partnership is a business which has between 2 and

  2. D&D 1 Maths Coursework - Apple Pie Investigation.

    Costs There are generic costs associated with both of the pies, such as the cost of baking them or transporting them. These can be simplified down to an additional 27p on each of the pies made, regardless of whether it is a sweet or fruity pie.

  1. Finance and Cash Flow Assignment.

    finance through it as there isn't any profit which is being retained. This source of finance in my opinion cannot realistically be an option of raising finance for Coulla for expansion because she has shown 'a net loss over the past two years' which shows that there is not much

  2. Looking at The Body Shop as an example of a franchiser.

    The Body Shops website will have all the information I need. I will discover how a franchise works and how they are controlled in my textbooks. Due to my visit to the factory I will witness their operation first hand, this will give me my own personal opinion.

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