THIS NEEDS TO BE IN THE EXCEL FORMAT (ON THE BOTTOM). NO OTHERFORMAT IS ACCEPTABLE. ALSO, MAKE SURE YOU READ THE ENTIRE QUESTION.THIS IS MY 3RD TIME POSTING THIS SO PLEASE ONLY ANSWER IF YOU CANDO IT IN THE EXCEL FORMAT.
This Needs To Be In The Excel Format On The Bottom No Other Format Is Acceptable Also Make Sure You Read The Entire 1 (279.01 KiB) Viewed 32 times
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. ● 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). ● 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) ● Criteria: One will be comparing the year 2022 Expenses and the year 2023 Expenses using a line graph (in dollars). ● 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:
Home D26 1 2 3 Items 4 5 Income 6 Ticket Sales 7 Concessions 8 Merchandise 9 Autographs 10 AutoSave OFF NAP Insert Draw Page Layout x✓ fx 11 Subtotal Income 12 A 13 Expenses 14 Band Member Salaries ◄ 15 Sound/Lighthing Salaries 16 Arena Lease 17 Food Services 18 19 Subtotal Expenses 20 21 Ready Gross Income Subtract Entertainment Tax 22 23 24 25 126 27 Maximum Monthly Expenses 28 Minimum Monthly Expenses Average Monthly Expenses 29 130 Average Monthly Income 31 32 Net Income Subtract Total Expenses Total Profit 2022 Budget B January C 2023 Budget C Formulas Data February D March Reports + MyBand - Saved to my Mac April Review View E F G H My Band's 2022 Budget by Joe Student, Student Number May Developer Tell me June July I August J September K L B E Share M October November December Comments N a op Year + 100% O
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!