logging in or signing up Revision of models iansillett Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 402 Category: Education License: All Rights Reserved Like it (1) Dislike it (0) Added: March 14, 2008 This Presentation is Public Favorites: 0 Presentation Description No description available Comments Posting comment... Premium member Presentation Transcript Building a model for the tuck shop: Building a model for the tuck shop What we have done so far...What is a model?: What is a model? A model can mean different things You will be making a computer model A computer model uses rules to predict what will happen A spreadsheet program like Excel uses formulas for the rulesThe tuck shop model: The tuck shop model You will model two things in the tuck shop the finances, which means money spent on buying stock for the shop money coming in to the shop from selling to customers keeping track of the money to see if the shop is making a profit or a lossThe tuck shop model: The tuck shop model You will model two things in the tuck shop the stock, which means how much of each type of stock (like crisps) has been bought how much of each type of stock has been sold to customers how much of each type of stock is left (do we need to buy more?) this is called stock controlThe tuck shop model: The tuck shop model Why have a model for the tuck shop? to keep track of the stock to keep track of the spending and sales in the shop to see if we are making a profit to plan how to increase the profitStock control: Stock control Part of the model... how many bars at the start of January? how many bars sold in February? what formula was used to calculate how many bars are left at the end of March?Stock control: Stock control Part of the model... how many bars at the start of January? 0 how many bars sold in February? 52 what formula was used to calculate how many bars are left at the end of March? =D6-D7Finances: Finances Part of the model... We buy chocolate bars in boxes of 48 We sell chocolate in single bars This part of the spreadsheet model helps us work out how much each bar costs us We have also added how much we sell a bar forFinances: Finances Another part of the model... How many bars were sold in January, to have £2.50 income? What formula is in cell B14?Finances: Finances Another part of the model... How many bars were sold in January, to have £2.50 income? 25 (25 lots of 10p) What formula is in cell B14? =B7*B13Planning for the future: Planning for the future What if we put the price up? What if we found a cheaper supplier of chocolate? What would happen to our profits? These are the kind of questions we use our computer model to help answer... You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
Revision of models iansillett Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 402 Category: Education License: All Rights Reserved Like it (1) Dislike it (0) Added: March 14, 2008 This Presentation is Public Favorites: 0 Presentation Description No description available Comments Posting comment... Premium member Presentation Transcript Building a model for the tuck shop: Building a model for the tuck shop What we have done so far...What is a model?: What is a model? A model can mean different things You will be making a computer model A computer model uses rules to predict what will happen A spreadsheet program like Excel uses formulas for the rulesThe tuck shop model: The tuck shop model You will model two things in the tuck shop the finances, which means money spent on buying stock for the shop money coming in to the shop from selling to customers keeping track of the money to see if the shop is making a profit or a lossThe tuck shop model: The tuck shop model You will model two things in the tuck shop the stock, which means how much of each type of stock (like crisps) has been bought how much of each type of stock has been sold to customers how much of each type of stock is left (do we need to buy more?) this is called stock controlThe tuck shop model: The tuck shop model Why have a model for the tuck shop? to keep track of the stock to keep track of the spending and sales in the shop to see if we are making a profit to plan how to increase the profitStock control: Stock control Part of the model... how many bars at the start of January? how many bars sold in February? what formula was used to calculate how many bars are left at the end of March?Stock control: Stock control Part of the model... how many bars at the start of January? 0 how many bars sold in February? 52 what formula was used to calculate how many bars are left at the end of March? =D6-D7Finances: Finances Part of the model... We buy chocolate bars in boxes of 48 We sell chocolate in single bars This part of the spreadsheet model helps us work out how much each bar costs us We have also added how much we sell a bar forFinances: Finances Another part of the model... How many bars were sold in January, to have £2.50 income? What formula is in cell B14?Finances: Finances Another part of the model... How many bars were sold in January, to have £2.50 income? 25 (25 lots of 10p) What formula is in cell B14? =B7*B13Planning for the future: Planning for the future What if we put the price up? What if we found a cheaper supplier of chocolate? What would happen to our profits? These are the kind of questions we use our computer model to help answer...