Spreadsheet template by lanyuehua

VIEWS: 4 PAGES: 7

									Name of pizza:

Cost to produce your pizza

Ingredients                                   Cost




                                    Total:

                             Selling price:

                        Profit per pizza:


Cost of advertising campaign

Promotional item                              Quantity    Cost             Total




                                                                  Total:

                                                          Within budget?


How many pizzas will you need to sell to make a profit?


Number of pizzas sold
Profit per pizza
Total profit made

Cost of promotional campaign

Total profit/loss
National




Mail Shot




Billboards
Magazine
Ingredients to choose from   Cost to make
Authentic thin crust L       £        8.00
Authentic thin crust M       £        7.00
Authentic thin crust S       £        6.00
Deep Pan L                   £        8.00
Deep Pan M                   £        7.00
Deep Pan S                   £        6.00
Stuffed crust (add)          £        1.00
Each topping (single)        £        0.50
Each topping (double)        £        0.75




Promotional item costs
TV:




Local Newspaper:
National Newspaper:


                   £18,245.00 per day for a full page colour
                               advertisement




Mail Shots (If you wanted to send flyers around):




Billboards:



                      1 x billboard for a month costs £2000
Magazine:




     1 advert in a magazine is £2300.00

								
To top