Hi plz show the excel formulas thank you

64 As the newly appointed Director of the Australian Tiddlywinks Championships you have been researching probable revenues and costs so that you can prepare an Income and Expenditure Forecast. The event will run over three days (Friday, Saturday and Sunday). The duration of the event will be 8 hours per day and the total number of competitors for the three (3) days will be 256 competitors (128 in the men's draw and 128 in the women's drawer). The type of event will be a championship knockout tournament: Round Matches 1st 2nd 32 3rd 16 4th 8 Qtr Final 4 Semi Final 2 Final 1 Don't forget that there is one draw for men and one draw for women. You have ascertained the following information about probable costs and revenues: 1. Venue Costs The venue will cost $300 per day. However there is an extra cost for lighting and the use of the venue's sound system. These costs are as follows: The venue lighting cost $10.00 per hour. The sound system will cost $60.00 per day. 2. Trophies will awarded as follows: Men's Competition, 1st place, 2nd place, 3rd place, 4th place, 5th place . Women's Competition, 1st place, 2nd place, 3rd place, 4th place, 5th place You are informed that 1st place trophy will cost $50, 2nd place - $40, 3rd place - $30, 4th place - $25 and 5th place - $20. 3. Hospitality for dignitaries and officials will cost $20 per day per person, and the total number of persons to cater for is expected to be 20 per day. G9 X fax . B D E F G H 1 1 2 3 $ 3 4 Venue Hire Lighting Cost Sound System Cost per day per hour per day Qty days hours days Total $ $ $ . Total Venue Hire 4. 5 6 7 8 9 10 11 8 A B D E F G . 1 Cost ea. Qty Required Women Total Cost Men 3 4 5 2 3 4 5 Total 0 $ 0 $ 0 $ 0 $ 0 $ 1st place 2nd place 3rd place 4th place 5th place 6 7 8 9 10 11 Total $ B D E G A 1 Hospitality 2 Persons Cost/day Total/ Day Days Total 3 Catering 0 4 5 6 N.B. The event will run on Friday, Saturday and Sunday (3 days). 7 8 9 00 64 As the newly appointed Director of the Australian Tiddlywinks Championships you have been researching probable revenues and costs so that you can prepare an Income and Expenditure Forecast. The event will run over three days (Friday, Saturday and Sunday). The duration of the event will be 8 hours per day and the total number of competitors for the three (3) days will be 256 competitors (128 in the men's draw and 128 in the women's drawer). The type of event will be a championship knockout tournament: Round Matches 1st 2nd 32 3rd 16 4th 8 Qtr Final 4 Semi Final 2 Final 1 Don't forget that there is one draw for men and one draw for women. You have ascertained the following information about probable costs and revenues: 1. Venue Costs The venue will cost $300 per day. However there is an extra cost for lighting and the use of the venue's sound system. These costs are as follows: The venue lighting cost $10.00 per hour. The sound system will cost $60.00 per day. 2. Trophies will awarded as follows: Men's Competition, 1st place, 2nd place, 3rd place, 4th place, 5th place . Women's Competition, 1st place, 2nd place, 3rd place, 4th place, 5th place You are informed that 1st place trophy will cost $50, 2nd place - $40, 3rd place - $30, 4th place - $25 and 5th place - $20. 3. Hospitality for dignitaries and officials will cost $20 per day per person, and the total number of persons to cater for is expected to be 20 per day. G9 X fax . B D E F G H 1 1 2 3 $ 3 4 Venue Hire Lighting Cost Sound System Cost per day per hour per day Qty days hours days Total $ $ $ . Total Venue Hire 4. 5 6 7 8 9 10 11 8 A B D E F G . 1 Cost ea. Qty Required Women Total Cost Men 3 4 5 2 3 4 5 Total 0 $ 0 $ 0 $ 0 $ 0 $ 1st place 2nd place 3rd place 4th place 5th place 6 7 8 9 10 11 Total $ B D E G A 1 Hospitality 2 Persons Cost/day Total/ Day Days Total 3 Catering 0 4 5 6 N.B. The event will run on Friday, Saturday and Sunday (3 days). 7 8 9 00