Modelling Assignment- The school tuck shop
- Words:
- 3103
- Submitted:
- Thu Jul 11 2002

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














