Please help me out with this spreadsheet

Is everything in order with George's project? George should go ahead as planned or not, and why? ( and please answer these two questions)

This is emergent, please!

Assignment 10- Case Study George is a budding impresario. He has written a play, and applied for grants, and was awarded project grants by the Toronto Arts Council, and the Ontario Arts Council ($12,000 each). He has found a theatre to book, negotiated with designers, actors, stage managers, and potential sponsors. He has come up with a budget that balances and will even pay him (though he will not be able to quit his day job yet). George's budget is in schedule one. George has planned 6 weeks of theatre rental (5 for rehearsal and one for the show run). He will have 5 performances over a single weekend at the end of May (Friday night, Saturday and Sunday matinees, and Saturday and Sunday evenings). The theatre holds 500 people, and George plans to sell tickets at $25 each. George knows that conservative budgets are safer, so he is only budgeting for 50% ticket sales ($31,250) over the 5 shows, which means if he is able to sell more tickets, he may make a profit that he can put to his next production. The theatre rent is $10,000 for the 6 weeks, and George must pay half (non-refundable) at the time of booking. The theatre includes all front-of-house and ticketing costs. It sells the tickets on George's behalf, and 30 days after the close of the last performance, forwards the sale money to George minus the other half of the rental. George will fundraise for individual donations, which he expects will raise $12,000. He has set- up a go-fund-me campaign, and donations have already started trickling in (mostly from very supportive friends and family, but also from the public). He expects $10,000 to come in gradually leading up to the show, and another $2000 to be donated by patrons who attend the performance. For staff, George is acting as the Artistic-Director and the Managing Director combo- as many ambitious people trying to start their own project do. He is also the director of the play, and is doing all the fundraising himself, because he doesn't have money to spend on that. Luckily, rehearsals don't start until April, so he has a lot of lead time to work on the fundraising. He is planning to pay himself $1000 per month for ten months starting now (September) and ending June- the month after the show. He got the OAC grant in September and expects the TAC grant in October (as promised by the approval letter), so the money is there to get him going on the project. He has another part-time job, so he has enough to live on. The play requires 4 actors, and he has hired all Equity (an actor's union) members who must be paid at least $1000 per week, and they must be paid every week during rehearsals and performances, by Thursday. This adds up to $24,000. He has also hired an Equity Stage Manager, who has the same rules, but is hired one week earlier get everything organized. He has hired a lighting/sound designer for $3000. The local design union requires that George pay half the contract amount on contract signing, and the other half on opening night. The play is set in current times, in a young person's apartment, so George did not hire a set or costume designer, thinking he could put together something himself, using things from home, but he budgeted $1000 for incidental materials.In light of everything he is already doing, George realized he is not good at marketing, and won't have time to do a good job of it on his own, so he is hiring a local marketing firm for $10,000, to help him get the word out, and make sure he hits his box office targets. It is not a low fee, but it includes all advertising purchases and printing costs. The firm requires a 30% deposit by January to start the work, and the remaining 70%% is due the week before opening in May. He has built in a $2000 contingency (which is almost 3% of the project) in case revenues are a little low or expenses are a little high. Even with that built in, conservative ticket sales, and all hard costs that cannot increase unexpectedly, George has a projected surplus of $250. He thinks everything looks great and nothing can go wrong. It is September now, and he plans to sign the venue and designer contracts and pay the deposits. Should he? Your Assignment Is everything in order with George's project? Submit an excel spreadsheet supporting your answer, and at the bottom of the spreadsheet write whether you think George should go ahead as planned or not, and why (but in one or two sentences- NOT an essay).Schedule 1: George's Budget GEORGE'S SHOW BUDGET BUDGET REVENUES EARNED REVENUE Single Tickets $ 31,250 TOTAL- EARNED REVENUE $ 31,250 PRIVATE SECTOR FUNDING Donations 5 12,000 TOTAL: PRIVATE SECTOR FUNDING $ 12,000 PUBLIC SECTOR REVENUE DAC Project 5 12,000 TAC Project $ 12,000 TOTAL: PUBLIC SECTOR REVENUES $ 24,000 TOTAL REVENUS 5 67,250 EXPENSES ARTISTIC FEES George-AD/MD Combo 5 10,000 Actors $ 24,000 TOTAL ARTISTIC FEES $ 34,000 PRODUCTION Stage Manager 5 7,000 Lighting/Sound Design 3,000 TOTAL PRODUCTION 5 10,000 PROGRAMMING Space Rental and Front of House $ 10,000 Production Materials 1,000 TOTAL PROGRAMMING $ 11,000 MARKETING Marketing Direct Costs $ 10,000 TOTAL MARKETING $ 10,000 CONTINGENCY 2,000 TOTAL EXPENSES $ 67,000 NET INCOME S 250Choirs United- 2020 Festival Budget BUDGET 19-20 BUDGET 20-21 NOTES REVENUE CONCERT TICKET SALES Evening Concerts Afternoon Concert Late Night concerts 3 day passes 1 day pass TOTAL CONCERT TICKET SALES Program Advretising Merchandise Sales TOTAL OTHER EARNED REVENUE PRIVATE SECTOR REVENUES Individual Donations Festival Sponsorships Foundation Contributions TOTAL PRIVATE SECTOR REVENUES PUBLIC SECTOR REVENUES FEDERAL REVENUES Canada Council Project Grant Ontario Arts Council Project Grant Canadian Heritage Project Grant TOTAL PUBLIC SECTOR REVNUES TOTAL REVENUE EXPENSES ARTISTIC EXPENSES Evening Choir Performance Fees Afternoon Choir Honorariums Music Royalties TOTAL ARTISTIC EXPENSES PRODUCTION EXPENSES Technicians professional fees- for the Church matinees TOTAL PRODUCTION EXPENSES PROGRAM EXPENSES Evening concert hall rental Matinee Church rental Pub concert rental fee AV Equipment- for the Church matinees Piano rental for Pub Recording Ticket/pass Processing Fees Program Printing TOTAL PRODUCTION EXPENSES PROJECT MARKETING EXPENSES website Professional Fees- Publicist Professional Fees- Designer Production Fees (Printing] Advertising Purchase Distribution TOTAL PROJECT MARKETING EXPENSES STAFF EXPENSE Administractive Project Manager ADMINISTRATIVE EXPENSES Office Supplies (for this program) Merchandise Costs TOTAL ADMINISTRATIVE COSTS TOTAL EXPENSES NET INCOME