Hello! Need help on this Ch. 14 SAM Project 1A

Band's Budget Projected Income and Expenses 4/15/20 Expenses Year-End Summary Income Total $ 54,845 Monthly Average 4,570 Monthly Maximum 13,567 Monthly Minimum th the Steady Income Spring Summer Regular Shows $ 4,200 $ - Festivals $ - $ 4,000 Parties $ 2,000 $ 6,000 Day Jobs $ 1,500 $ - $ $ $ $ Fall 4,200 2,000 2,000 1,500 Winter $ 4,200 $ $ 2,000 $ 1,500 $ Feb Mar Apr May Oct Nov Dec Jun 0.00 4,000 6,000 Jul 0.00 4,000 6,000 Aug 0.00 4,000 6,000 Sep 4200.00 2,000 2,000 1,500 1,741 1.74E+03 2.75E+02 1,139 1.14E+03 4.50E+02 3,421 1.34E+04 8.00E+02 3,567 1.36E+04 8.00E+02 1,284 1.13E+04 8.00E+02 9.70E+03 2.75E+02 0.00E+00 2.75E+02 Monthly Summary Jan Regular Shows Festivals Parties Day Jobs Merchandise 1,177 Total Income 1.18E+03 Food 2.75E+02 Studio Time 300 Studio Engineer 1,000 Practice Space 360 Recording Equipment 400 CD Production Documentarian Crew and Technicians Accommodations Marketing 300 Travel/Entertainment 200 Total Expenses Net Cash Flow 1,081 1.08E+03 2.75E+02 300 1,000 360 275 1,735 1.74E+03 2.75E+02 300 1,000 360 75 0.00E+00 2.75E+02 300 1,000 360 0.00E+00 2.75E+02 300 1,000 360 75 360 75 5,745 360 75 360 75 130 75 360 75 5,745 75 2,000 2,200 1,900 3,500 - 75 5,745 2,100 3,500 2,500 500 600 2,500 1,800 3,500 2,500 20 580 3,400 1,750 1,250 650 380 80 150 90 40 60 50 240 500 190 400 250 230 140 540 210 310 7 In addition to working day jobs, the band performs at various venues for different amounts of money throughout the year. They also earn income by selling merchandise at their shows and on their website. During the summer, they will be taking time off from their day jobs and their steady gig as a house band to play several festivals, and to supplement their income, they will play more parties than usual. IPTR Excel 2016 | Chapter 14: SAM Project la Complete the income section of the Band Budget worksheet as described below: a. b. In cell B14, enter an absolute reference to cell F7. In cell B15, enter an absolute reference to cell F8. In cell B16, enter an absolute reference to cell F9. In cell B17, enter an absolute reference to cell F10. Copy the formulas you entered in the range B14:B17 to the range C14:F17 and the range K14:M17. e. 9. Apply the Blue-Gray, Accent 5, Lighter 80% fill color (9th column, 2nd row o the Theme Colors palette) to the range D19:M19. Apply the Accounting format with the $ symbol and zero decimal places to the ranges B14:M14 and B19:M20. (Hint: Depending on how you perform this, the number format may appear as Custom.) 10. The band has estimated the expenses for recording their album, playing their summer tour, and making a documentary, and now needs to know how much they will be paying each month. In cell B31, create a formula using the SUM function to calculate the total expenses for January based on the range B20:B30. Copy the formula you just created in cell B31 to the range C31:M31. 11. Apply the Orange, Accent 2, Lighter 80% fill color (6th column, 2nd row of the Theme Colors palette) and add a Top and Thick Bottom Border to the range B31:M31. 12. Next, the band wants to compare their income and expenses so that they can figure out where and how to adjust their plan, if necessary. In cell B32, enter a formula without using a function to calculate the net cash flow for the month of January. The formula should subtract the value in cell B31 from the value in cell B19. Copy the formula you just created in cell B32 to the range C32:M32. Band's Budget Projected Income and Expenses 4/15/20 Expenses Year-End Summary Income Total $ 54,845 Monthly Average 4,570 Monthly Maximum 13,567 Monthly Minimum th the Steady Income Spring Summer Regular Shows $ 4,200 $ - Festivals $ - $ 4,000 Parties $ 2,000 $ 6,000 Day Jobs $ 1,500 $ - $ $ $ $ Fall 4,200 2,000 2,000 1,500 Winter $ 4,200 $ $ 2,000 $ 1,500 $ Feb Mar Apr May Oct Nov Dec Jun 0.00 4,000 6,000 Jul 0.00 4,000 6,000 Aug 0.00 4,000 6,000 Sep 4200.00 2,000 2,000 1,500 1,741 1.74E+03 2.75E+02 1,139 1.14E+03 4.50E+02 3,421 1.34E+04 8.00E+02 3,567 1.36E+04 8.00E+02 1,284 1.13E+04 8.00E+02 9.70E+03 2.75E+02 0.00E+00 2.75E+02 Monthly Summary Jan Regular Shows Festivals Parties Day Jobs Merchandise 1,177 Total Income 1.18E+03 Food 2.75E+02 Studio Time 300 Studio Engineer 1,000 Practice Space 360 Recording Equipment 400 CD Production Documentarian Crew and Technicians Accommodations Marketing 300 Travel/Entertainment 200 Total Expenses Net Cash Flow 1,081 1.08E+03 2.75E+02 300 1,000 360 275 1,735 1.74E+03 2.75E+02 300 1,000 360 75 0.00E+00 2.75E+02 300 1,000 360 0.00E+00 2.75E+02 300 1,000 360 75 360 75 5,745 360 75 360 75 130 75 360 75 5,745 75 2,000 2,200 1,900 3,500 - 75 5,745 2,100 3,500 2,500 500 600 2,500 1,800 3,500 2,500 20 580 3,400 1,750 1,250 650 380 80 150 90 40 60 50 240 500 190 400 250 230 140 540 210 310 7 In addition to working day jobs, the band performs at various venues for different amounts of money throughout the year. They also earn income by selling merchandise at their shows and on their website. During the summer, they will be taking time off from their day jobs and their steady gig as a house band to play several festivals, and to supplement their income, they will play more parties than usual. IPTR Excel 2016 | Chapter 14: SAM Project la Complete the income section of the Band Budget worksheet as described below: a. b. In cell B14, enter an absolute reference to cell F7. In cell B15, enter an absolute reference to cell F8. In cell B16, enter an absolute reference to cell F9. In cell B17, enter an absolute reference to cell F10. Copy the formulas you entered in the range B14:B17 to the range C14:F17 and the range K14:M17. e. 9. Apply the Blue-Gray, Accent 5, Lighter 80% fill color (9th column, 2nd row o the Theme Colors palette) to the range D19:M19. Apply the Accounting format with the $ symbol and zero decimal places to the ranges B14:M14 and B19:M20. (Hint: Depending on how you perform this, the number format may appear as Custom.) 10. The band has estimated the expenses for recording their album, playing their summer tour, and making a documentary, and now needs to know how much they will be paying each month. In cell B31, create a formula using the SUM function to calculate the total expenses for January based on the range B20:B30. Copy the formula you just created in cell B31 to the range C31:M31. 11. Apply the Orange, Accent 2, Lighter 80% fill color (6th column, 2nd row of the Theme Colors palette) and add a Top and Thick Bottom Border to the range B31:M31. 12. Next, the band wants to compare their income and expenses so that they can figure out where and how to adjust their plan, if necessary. In cell B32, enter a formula without using a function to calculate the net cash flow for the month of January. The formula should subtract the value in cell B31 from the value in cell B19. Copy the formula you just created in cell B32 to the range C32:M32