Using your knowledge of spreadsheet software, using formulas and functions where appropriate, make a spreadsheet for the following Band.

You are the manager of a famous band. It is up to you to manage your bands income as well as account for its expenses.

Create a budget for your band over two years: 2022 and 2023

• Your revenues every month should include at least 4 sources of income: ticket sales, concessions, clothing royalties and one or more that you think up.
• Your expenses every month should include at least 6 types of costs: band member salaries, sound/lighting technician salaries, arena lease, food services and two (2) or more you will choose.
• Sports and Entertainment Taxes must be subtracted from your Gross Income (12% for income up to $20,000,000 and 15% for income over $20,000,000)

Create 2 charts indicating where your money is being spent (expenses).

• One will be for the year 2022 Expenses using a pie chart (in percentages).
• One will be comparing the year 2022 Expenses and the year 2023 Expenses using a line graph (in dollars).

Criteria:

• Your income needs to add up to $100,000,000 for year 2022.
• Your expenses are $75,000,000 for year 2022. You may divide the expenses the way you like but be realistic!
• All expenses will go up 6% for the year 2023. But your income will only go up 4% for the year 2023.
• Revenue section should have a subtotal.
• Expenses section should have a subtotal.
• There should be a Gross Income, Taxes and Net Income displayed
• Each yearly budget should have a separate column for each month.
• You should have 3 work sheets labelled: 2022 Budget, 2023 Budget and Reports (which will contain the 2 charts).
• Using a function, determine the minimum and maximum monthly expenses.
• Using a function, determine the average monthly income and expenses.
• Under the year column, total up each items amount.

Are the values within the highlighted box correct? which value do I use to calculate average monthly income

File Home Insert Page Layout Formulas Data Review View Help Comments Share Calibri AutoSum 11 - PA == a Wrap Text General HE 47 FO Fill Paste X Cut LG Copy format Painter Clipboard 5 BIU Insert Delete Format $ -% 3-23 Sensitivity Merge & Center Conditional Formatas Call Formatting Table Styles Clear Sort & Find & Filter Select Eciting Analyze Dala Font Alignment Number 5 Analysis Seristivity D23 X for c D E F H 1 M N 0 0 P Q 5 - 3,500,000 900,000 1,700,000 2,000,000 3,500,000 800,000 1,400,000 3,000,000 3,500,000 1,200,000 1,600,000 4,000,000 3,500,000 3,500,000 3,500,000 3,500,000 1,000,000 1,100,000 800,000 700,000 1,300,000 1,650,000 1,350,000 1,700,000 1,000,000 2,000,000 3,500,000 3,500,000 1,500,000 3,500,000 1,300,000 700,000 2,000,000 3,500,000 3,500,000 3,500,000 1,000,000 1,200,000 600,000 1,300,000 1,000,000 1,300,000 1,000,000 1,000,000 1,000,000 3,000,000 a 100,000 3,700,000 10,300,000 6,800,000 8,250,000 9,150,000 7,400,000 7,500,000 6,800,000 6,700,000 8,400,000 B 4 Incore 5 Ticket Sales 3,500,000 6 Concessions 1,100,000 7 Clothing Royalties 1,300.000 8 TV and Radio Royalties 6,000,000 9 10 Subtotal income 11,900,000 11 12 Expenses 13 Band Member Salaries 3,000,000 14 Sound/Lighting Tech Salaries 600,000 15 Arena lease 1,000,000 16 Food Services 450,000 17 Public Liability Insurance 1,500,000 18 Security 600.000 19 20 Subtotal Expenses 7,150,000 21 22 Gross income 100,000,000 23 Entertainment Tax 12000000 24 Net Income 88,000,000 25 Subtract Total Expenses 75,000,000 26 Total Profits 13,000,000 27 28 Maximum Monthly Expenses 8,050,000 29 Minimum Monthly Expenses 4,550,000 30 Average Monthly Expenses 6,250,000 31 Averare Monthly income Sheet1 + Heady ft Accessibility: Good to go 1 : 2,000,000 200,000 1,000,000 470,000 900,000 500,000 2,500,000 300,000 1,000,000 450,000 900,000 550,000 4,500,000 450,000 1,000,000 550,000 900,000 650,000 3,255,000 400,000 1,000,000 410,000 900,000 525,000 2,800,000 350,000 1,000,000 490,000 900,000 500,000 2,200,000 200,000 1,000,000 475,000 900,000 450,000 2,300,000 250,000 1,000,000 425,000 900,000 400,000 4,100,000 450,000 1,000,000 600,000 900,000 650,000 3,900,000 400,000 1,000,000 1,700,000 200,000 1,000,000 450,000 900,000 300,000 500,000 3,000,000 400,000 1,000,000 600,000 900,000 550,000 900,000 600,000 5,070,000 5,700.000 8,050,000 6,490,000 6,040,000 5,225,000 5,275,000 7,700,000 4,550,000 7.300.000 6,450,000 FI u D + 100% % 1-26 PM Saturday F 2022-03-05 Type here to search O E Desktop 6C A AC3 ENG )