Docstoc

Working_Budget_Wales_MD.xlsx - Microsoft Training London

Document Sample
Working_Budget_Wales_MD.xlsx - Microsoft Training London Powered By Docstoc
					Event Name:              School for Startups Wales
Event Dates:             20th - 24th June 2011
No of delegates:         150 x 3 day events
Venues:                  Cardiff, Swansea and Rhyl




                                        ACTUAL COSTS THAT AW IS WORKING TO FOR ALL ELEMENTS TO ENSU
What                     Quantity       Cost           Total
PRE EVENT
Website Development
Creating Website

Doug                                1          £1,500   £1,500
Triona                              4            £350   £1,400
Ness                            2.5              £150     £375
Phil                                4            £225     £900
Erin                                2            £240     £480
Video Shoot                         1            £500     £500     £5,155

Sales and Marketing
Sales Emails - Sales
Logistics Email
Sponsor Proposals
Managing sponsors
Additional Marketing

Doug                                3          £1,500   £4,500

Triona                              4            £350   £1,400

Erin                                2            £240     £480
Nancy                           0.5              £104     £104
Vanessa                             5            £150     £750     £7,234

Application Management

Ness                                3            £250     £750
Nancy                               5            £208   £1,040


Triona                          5.5              £350   £1,925
Phil                                2            £240     £480     £4,195
EVENT COSTS
Venue Hire                                   3     £0.00      £0


Catering - 150 delegates + 10 staff
Arrival Tea and Coffee                       0     £0.00      £0
Lunch                                        0     £0.00      £0
Break 1                                      0     £0.00      £0
Break 2                                      0     £0.00      £0       £0

AV requirements
Staging                                      1     £0.00       £0
Sound
Visual
Av Technician                                                          £0

Event Film
Camera Operator per day                     2      £275     £550


Sony EX1 Camera Hire inc. Audio Equipment   2       £75     £150
Travelling                                  2      £140     £280
Editor per day                              2      £220     £440
                                                                    £1,420

Speaker Costs
Andrew Davies                               1    £3,000    £3,000
Dan Sodergren                               1    £3,000    £3,000
James Denning                               1    £1,200    £1,200   £7,200


Print and Merchandise 2 day
2m by 1m pull up banners                     2      £95      £190
Delivery of banners                          1    £15.00      £15
Stationary for activities                    0   £100.00     £100    £317

Exhibitors
Management only


Per Diems
Over night car parking for Matt & Jason     1        £0
Breakfast for team                          0        £0       £0




Lunch                                       16      £10     £160

Dinner                                      34      £24     £816     £976
Travel
Triona and Megan initial meeting     4 £28.5             £114

Megan's recce - Cardif & Swansea     1          £105     £105
Megan's recce - North Wales          1           £74      £74
Petro for camera crew's car        550          £0.50    £275

Taxi fare                           24           £20     £480
London Paddington to Cardiff         7           £52     £364
Cardiff to Paddington                5           £22     £110
Cardiff to Paddington                1
Cardiff to Swansea                   5            £7      £36
Cardiff to Swansea                   1
Swansea to Rhyl                      5           £61     £306
Rhyl to London Paddington            3           £62     £185
Rhyl to Milton Keynes                1           £43      £43
Manchester to Cardiff                1           £20      £20
Ely to London                        1           £27      £27
Rhyl to Manchester                   1           £20      £20     £2,157

Accommodation
Doug                                 4           £52     £208
Alex & Triona                        1           £71      £71
Megan & Intern                       4           £52     £208
Mike                                 1           £71      £90
Dan                                  4           £52     £208
James                                1           £71      £71
James                                2           £75     £150
Andrew                               4           £52     £208
Matt                                 1           £71      £71
Jason                                1           £71      £71
Fiona                                1           £71      £71     £1,427

People Time for Event Costs

Alex                                5.5         £250    £1,375

Megan                              16.5         £150    £2,475
Onsite Days
Doug                                 5         £1,500   £7,500
Tri                                  2          £350     £700
Alex                                 2          £250     £500
Intern                               5           £36     £182
Mike                                 2           £70     £140
Megan                                5          £150     £750    £13,622
POST EVENT PACKAGES

Post event survey
Megan                                              1                150      £150
Tri                                              0.5                350      £175
Ness                                               1                150      £150        £475




TOTAL                                                                      £44,178    £44,191
Contingency                                        5              £442     £2,209      £2,209
TOTAL                                                                      £46,387    £46,399
                                                                          £54,505 £54,519

TOTAL AGREED BY WA                           75000.00
Total cost                                    £46,387                     £44,191 without 5% contingency included
                                                      with 5%
                                                      contingency
Difference                                    £28,601 included            £30,809
Profit %                                      38.13%                      41.08%



S4S Team
Doug                                              13            £1,500 £19,500
Alex                                             7.5              £200     £1,500
Tri                                              2.5              £333       £833
Ness                                             6.5              £200     £1,300
Megan                                           22.5              £150     £3,375
Nancy                                            5.5              £208     £1,144
Phil                                               6              £225     £1,350
                                                                                £0    £29,002



                                                        If you need to split the ranges up,
There are 3 parts to the sumif                          you'll have =SUMIF(range1,
function: (see cell B144)                               condition1,
the first is the cell range that holds the              sumrange1)+SUMIF(range2,
information on the condition that you                   condition2, sumrange2). SEE cells g144
wish to sum on                                          to g151 for detail
The second holds the condition itself
(the cell containing the name)
the third is the cell range that holds
the numbers to add up.
AT AW IS WORKING TO FOR ALL ELEMENTS TO ENSURE WE HIT TARGET PROFIT
                  Comments



                  Sales and application
                  Writing the content for website and sales? - half day for video
                  shoot
                  Collating and creating wireframes and content
                  research and copy writing, setting up eventbrite
                  Building the website - application process,
                  Design the website
                  Doug to film an intro to the programme




                  Content for proposals, email content, writing content for
                  programme

                  Attending any sponsorship meetings, writing content/ copy

                  Designing emails, website, headers for documents, ppt's etc
                  0.5 for helping to source any content
                  Managing sponsors, sending emails and helping Tri



                  Email selected delegates to confirm their attendance (1 day
                  per event = 3)
                  To review and select delegates from applications (5)
                  Write the criteria (1) Content for application website page
                  (0.5) Confirm selected delegates (2) + (2) trouble shooting
                  days
                  Build the application process on website (2)
WA paying for and organising venues



WA paying for catering




WA hiring AV




Cost are for filming Cardiff only




Includes DVD delivery & archiving




2 x banners specifically for Douglas Richard Pty Ltd
DELIVERY
paper, envelopes and additional stuff




Included
Included expect Monday and Thursday - x 10 crew for
Monday (Doug, Alex, Mike, Intern, Megan, 3 x Speaker, 2 x
Camera) - 6 x crew for Thursday (Doug, Megan, Intern, 3 x
speakers)
6 x crew for 4 dinners (includes dinner on train on Friday) +
10 x crew for dinner on Monday
4 x single tickets - cheaper than return
2 x single tickets to visit Cardiff and Swansea + 2 x single
ticket to visit North Wales


Based on 550 miles for round trip for camera crew
2 x taxi each way per venue + 2 x taxi from train station to
hotels
Doug, Alex, Triona, James, Andrew, Mike and Fiona
Alex, Triona, James, Mike and Fiona
James' ticket
Doug, Dan, Andrew, Megan and Shevaun
James
Doug, Dan, Andrew, Megan and Shevaun
Doug, Andrew and Megan
Shevaun
Dan - buying his own ticket and claiming the expense
James - buying his own ticket and claiming the expense
Dan



Doug x single for 4 nights
Alex & Triona staying one night in Cardiff
Megan & Intern twin share for 4 nights
Mike is staying one night in Cardiff


James is staying 1 nights in Cardiff
James staying extra night in Cardiff and 1 in Swansea


Matt is staying one night in Cardiff
Jason is staying one night in Cardiff
Fiona is staying one night in Cardiff



Average of 0.5 day per week over 11 weeks leading up to the
programme
Average of 1.5 day per week over 11 weeks leading up to the
programme




£3.64 per hour - 10 hours per day = £36.4 per day
         Emailed to the delegates the day after the event and again 6 months after the event
         Collating and formatting results
         Developing survey questions
         Create link to survey and email surveys to delegates




         Exc VAT
         In cvAT



without 5% contingency included




         Estimated doug's actual wage is £1500 per day




                        DO CHECK THE CELL RANGES!




         YOU MIS-SPELT "Doug" in cell A144 "Doug " i.e. with a space
         - they must be identical.
         The condition range and the sum range must have the same
         number of rows!
Supplier   PO NO.   Paid
event and again 6 months after the event




                                            9.00
                                            7.50
                                            2.50
                                            6.50
                                           22.50
                                            5.50
                                            6.00
Event Name:                           School for Startups Wales
Event Dates:                          20th - 24th June 2011
No of delegates:                      150 x 3 day events
Venues:                               Cardiff, Swansea and Rhyl




                                                     ACTUAL COSTS THAT AW IS WORKING TO FOR ALL ELEMENTS TO ENSU
What                                  Quantity       Cost            Total
PRE EVENT
Website Development
Creating Website
Doug                                             1            £1,500      £1,500
Triona                                           4                £350    £1,400
Ness                                         2.5                  £150     £375
Phil                                             4                £225     £900
Erin                                             2                £240     £480
Video Shoot                                      1                £500     £500    £5,155

Sales and Marketing
Sales Emails - Sales
Logistics Email
Sponsor Proposals
Managing sponsors
Additional Marketing
Doug                                             3            £1,500      £4,500
Triona                                           4                £350    £1,400
Erin                                             2                £240     £480
Nancy                                        0.5                  £104     £104
Vanessa                                          5                £150     £750    £7,234

Application Management
Ness                                             3                £250     £750
Nancy                                            5                £208    £1,040

Triona                                       5.5                  £350    £1,925
Phil                                             2                £240     £480    £4,195

EVENT COSTS
Venue Hire                                       3                £0.00      £0


Catering - 150 delegates + 10 staff
Arrival Tea and Coffee                       0          £0.00      £0
Lunch                                        0          £0.00      £0
Break 1                                      0          £0.00      £0
Break 2                                      0          £0.00      £0       £0

AV requirements
Staging                                      1          £0.00       £0
Sound
Visual
Av Technician                                                               £0

Event Film
Camera Operator per day                     2           £275     £550


Sony EX1 Camera Hire inc. Audio Equipment   2            £75     £150
Travelling                                  2           £140     £280
Editor per day                              2           £220     £440
                                                                         £1,420

Speaker Costs
Andrew Davies                               1         £3,000    £3,000
Dan Sodergren                               1         £3,000    £3,000
James Denning                               1         £1,200    £1,200   £7,200


Print and Merchandise 2 day
2m by 1m pull up banners                     2           £95      £190
Delivery of banners                          1         £15.00      £15
Stationary for activities                    0        £100.00     £100    £317

Exhibitors
Management only


Per Diems
Over night car parking for Matt & Jason     1             £0
Breakfast for team                          0             £0       £0


Lunch                                       16           £10     £160

Dinner                                      34           £24     £816     £976

Travel
Triona and Megan initial meeting            4 £28.5              £114
Megan's recce - Cardif & Swansea            1           £105     £105
Megan's recce - North Wales                 1            £74      £74
Petro for camera crew's car    550     £0.50    £275
Taxi fare                       24      £20     £480
London Paddington to Cardiff     7      £52     £364
Cardiff to Paddington            5      £22     £110
Cardiff to Paddington            1
Cardiff to Swansea               5       £7      £36
Cardiff to Swansea               1
Swansea to Rhyl                  5      £61     £306
Rhyl to London Paddington        3      £62     £185
Rhyl to Milton Keynes            1      £43      £43
Manchester to Cardiff            1      £20      £20
Ely to London                    1      £27      £27
Rhyl to Manchester               1      £20      £20     £2,157

Accommodation
Doug                             4      £52     £208
Alex & Triona                    1      £71      £71
Megan & Intern                   4      £52     £208
Mike                             1      £71      £90
Dan                              4      £52     £208
James                            1      £71      £71
James                            2      £75     £150
Andrew                           4      £52     £208
Matt                             1      £71      £71
Jason                            1      £71      £71
Fiona                            1      £71      £71     £1,427

People Time for Event Costs
Alex                            5.5    £250    £1,375
Megan                          16.5    £150    £2,475
Onsite Days
Doug                             5    £1,500   £7,500
Tri                              2     £350     £700
Alex                             2     £250     £500
Intern                           5      £36     £182
Mike                             2      £70     £140
Megan                            5     £150     £750    £13,622

POST EVENT PACKAGES

Post event survey
Megan                            1      150     £150
Tri                             0.5     350     £175
Ness                             1      150     £150      £475
TOTAL                                               £44,178   £44,191
Contingency                5                £442    £2,209     £2,209
TOTAL                                               £46,387   £46,399
                                                   £54,505 £54,519

TOTAL AGREED BY WA   75000.00
Total cost            £46,387                      £44,191 without 5% contingency included
                              with 5%
                              contingency
Difference            £28,601 included             £30,809
Profit %              38.13%                       41.08%



S4S Team
Doug                       9            £1,500 £13,500
Alex                     7.5                £200    £1,500
Tri                     10.5                £333    £3,497
Ness                     8.5                £200    £1,700
Megan                   22.5                £150    £3,375
Nancy                    5.5                £208    £1,144
Phil                       6                £225    £1,350
                                                        £0    £26,066
AW IS WORKING TO FOR ALL ELEMENTS TO ENSURE WE HIT TARGET PROFIT
                 Comments



                 Sales and application
                 Writing the content for website and sales? - half day for video shoot
                 Collating and creating wireframes and content
                 research and copy writing, setting up eventbrite
                 Building the website - application process,
                 Design the website
                 Doug to film an intro to the programme




                 Content for proposals, email content, writing content for programme
                 Attending any sponsorship meetings, writing content/ copy
                 Designing emails, website, headers for documents, ppt's etc
                 0.5 for helping to source any content
                 Managing sponsors, sending emails and helping Tri



                 Email selected delegates to confirm their attendance (1 day per event = 3)
                 To review and select delegates from applications (5)
                 Write the criteria (1) Content for application website page (0.5) Confirm selected delegates
                 (2) + (2) trouble shooting days
                 Build the application process on website (2)



                 WA paying for and organising venues
WA paying for catering




WA hiring AV




Cost are for filming Cardiff only




Includes DVD delivery & archiving




2 x banners specifically for Douglas Richard Pty Ltd
DELIVERY
paper, envelopes and additional stuff




Included
Included expect Monday and Thursday - x 10 crew for Monday (Doug, Alex, Mike, Intern,
Megan, 3 x Speaker, 2 x Camera) - 6 x crew for Thursday (Doug, Megan, Intern, 3 x
speakers)
6 x crew for 4 dinners (includes dinner on train on Friday) + 10 x crew for dinner on
Monday



4 x single tickets - cheaper than return
2 x single tickets to visit Cardiff and Swansea + 2 x single ticket to visit North Wales
Based on 550 miles for round trip for camera crew
2 x taxi each way per venue + 2 x taxi from train station to hotels
Doug, Alex, Triona, James, Andrew, Mike and Fiona
Alex, Triona, James, Mike and Fiona
James' ticket
Doug, Dan, Andrew, Megan and Shevaun
James
Doug, Dan, Andrew, Megan and Shevaun
Doug, Andrew and Megan
Shevaun
Dan - buying his own ticket and claiming the expense
James - buying his own ticket and claiming the expense
Dan



Doug x single for 4 nights
Alex & Triona staying one night in Cardiff
Megan & Intern twin share for 4 nights
Mike is staying one night in Cardiff


James is staying 1 nights in Cardiff
James staying extra night in Cardiff and 1 in Swansea


Matt is staying one night in Cardiff
Jason is staying one night in Cardiff
Fiona is staying one night in Cardiff



Average of 0.5 day per week over 11 weeks leading up to the programme
Average of 1.5 day per week over 11 weeks leading up to the programme




£3.64 per hour - 10 hours per day = £36.4 per day




Emailed to the delegates the day after the event and again 6 months after the event
Collating and formatting results
Developing survey questions
Create link to survey and email surveys to delegates
         Exc VAT
         In cvAT



without 5% contingency included




         Estimated doug's actual wage is £1500 per day
Supplier   PO NO.   Paid

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:11/27/2011
language:English
pages:24