Spreadsheets - Microsoft Excel (15%) Using your knowledge of spreadsheet software, using formulas and functions where...

 

  

 

Transcribed Image Text:

Spreadsheets - Microsoft Excel (15%) 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 band's 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. Your spreadsheet might look something like this: Your spreadsheet might look something like this: GE Page Layout Home Insert Draw D26 1 2 3 Items 4 5 Income 6 Ticket Sales 7 Concessions AutoSave 8 Merchandise 9 Autographs 10 A 11 Subtotal income 12 13 Expenses 14 Band Member Salaries 15 Sound/Lighthing Salaries 16 Arena Lease 17 Food Services 18 19 Subtotal Expenses 20 21 Gross Income 22 Subtract Entertainment Tax 23 Net Income 24 Subtract Total Expenses 25 Total Profit 26 27 Maximum Monthly Expenses 28 Minimum Monthly Expenses 29 Average Monthly Expenses Average Monthly Income B C MyBand-Saved to my Mac Formulas Data Review View Developer Tell me January February D March E H My Band's 2022 Budget by Joe Student, Student Number July August April May June 1 1 September Share M October November December a g Comments N Year 0 One mark deduction for each of the following: • Improper filename • Inconsistent margin settings • Spelling and/or grammar errors • Missing your name and/or your Student Number General: • Assignments must be done on your own Microsoft account/licensed product or you will receive zero marks. • Assignments must be submitted in the proper file format or you will receive zero marks. Assignments are not to be emailed to the Professor or Teaching Assistants. You get one submission and one submission only in Blackboard. Assignments not found in Blackboard will receive a mark of zero. Spreadsheets - Microsoft Excel (15%) 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 band's 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. Your spreadsheet might look something like this: Your spreadsheet might look something like this: GE Page Layout Home Insert Draw D26 1 2 3 Items 4 5 Income 6 Ticket Sales 7 Concessions AutoSave 8 Merchandise 9 Autographs 10 A 11 Subtotal income 12 13 Expenses 14 Band Member Salaries 15 Sound/Lighthing Salaries 16 Arena Lease 17 Food Services 18 19 Subtotal Expenses 20 21 Gross Income 22 Subtract Entertainment Tax 23 Net Income 24 Subtract Total Expenses 25 Total Profit 26 27 Maximum Monthly Expenses 28 Minimum Monthly Expenses 29 Average Monthly Expenses Average Monthly Income B C MyBand-Saved to my Mac Formulas Data Review View Developer Tell me January February D March E H My Band's 2022 Budget by Joe Student, Student Number July August April May June 1 1 September Share M October November December a g Comments N Year 0 One mark deduction for each of the following: • Improper filename • Inconsistent margin settings • Spelling and/or grammar errors • Missing your name and/or your Student Number General: • Assignments must be done on your own Microsoft account/licensed product or you will receive zero marks. • Assignments must be submitted in the proper file format or you will receive zero marks. Assignments are not to be emailed to the Professor or Teaching Assistants. You get one submission and one submission only in Blackboard. Assignments not found in Blackboard will receive a mark of zero.

Answer rating: 100% (QA)

1 Competitive strategy of Joliet Memorial Stadium Porter has defined 3 competitive strategy for comp... View the full answer