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

Introduction

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.

Middle

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

Conclusion

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. Introduction to Business Assignment

    Through increased asset values, reduced capital expenditure and enhanced levels of service, SPC will generate financial benefits from the under-exploited supermarket portfolio. Since February 2000, in excess of �566 million has been raised through the development of innovative 'sale and leaseback' schemes.6 Based on the information mentioned above, it can

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

  2. Peacocks - case study

    The fish will be then sold on for processing at the secondary stage. The secondary sector deals with manufacturing, processing, construction, and assembly. This relates to manufacturers of consumer and industrial goods. A paper mill, a carpet factory, and a house builder are all found in this sector.

  1. Ownership and finance for my business. The business I am doing is a clothes ...

    where as a larger company would. Partnerships Partnerships are businesses owned by twenty or more people. A contract called a deed of partnership is normally made. This states the type of partnership it is, how much capital each party has contributed, and how profits and losses will be shared.

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

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

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

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