YEAR 10 AIT Spreadsheet Assignment Gourmet Pizza Shop
You have recently opened a Gourmet Pizza Shop. As part of a plan to improve your business you are keeping a detailed record of pizza sales for each pizza. All the pizzas are “Gourmet” and are a standard size. The Pizzas all cost $17.95. The cost of ingredients for each Pizza is 40% of the retail price.
Design your spreadsheet on paper first and include:
Spreadsheet title
row labels
column labels
ALL formula
Make allowance for a date
Include any functions that you consider may be important, example: average sales, max or min numbers of pizzas sold over the week
Create a spreadsheet template.
Name it appropriately
Print it out displaying the formula
Use this template to create spreadsheets from the test data provided
Create charts for both weeks (make sure to format charts with all relevant headers and axis’s labelled)
Create a stacked column chart to show sales of all pizzas over the week,
Create a pie chart showing the percentage that each pizza contributes to overall sales
Gourmet Pizza Shop
You have recently opened a Gourmet Pizza Shop. As part of a plan to improve your business you are keeping a detailed record of pizza sales for each pizza. All the pizzas are “Gourmet” and are a standard size. The Pizzas all cost $17.95. The cost of ingredients for each Pizza is 40% of the retail price.
ALL THE FILES NEEDED CAN BE DOWNLOADED BELOW.
Gourmet Pizza Shop