[SOLVED] FYRE Festival was a fraudulent “luxury music festival” founded by Billy McFarland.

I don’t know how to handle this Excel question and need guidance.

FYRE Festival was a fraudulent “luxury music festival” founded by Billy McFarland, CEO of Fyre Media Inc, and rapper Ja Rule, and created with the intent of promoting the company’s Fyre app for booking music talent. The festival was scheduled to take place on the Bahamian island of Great Exuma. You were hired to be Fyre’s accountant and manage all revenue and expenses for the festival, as well as determining the feasibility of the event.

1. Open the Fyre.xlsx workbook downloaded from the Project 1 module and save it as PANTHERID – Fyre Festival.xlsx (e.g. 1234567 – Fyre Festival.xlsx).
2. Documentation Worksheet
   1. In the Documentation worksheet, enter your name in cell B4 and the date in cell B5.
   2. Format the date in B5 as the Long Date format.
   3. Select cell A1 and change it to use font Arial Bold and size 36. Select only the word ‘FYRE’ and change its color to Orange, Accent 2.
   4. Select cell A2 and change it to use font Arial Bold and size 20.
   5. Use the format copier and copy the style of A1 and A2 to all other worksheets. Make fine adjustments to colors so they all look the same in the end.
   6. In the Documentation worksheet, select the range A4:B6, add All Borders and font size 14. Right-align column B. Bold the values in column A of the table.
   7. Make column A 10 characters wide and column B 70 characters wide.
   8. Select A1:B1 and merge cells.
   9. Select A1:B6 and add a white background.
   10. Add a background image to the worksheet. Use the file background.png.
3. Expenses Worksheet
   1. Go to the Expenses Calculate the price of Food & Catering based on the units purchased and the unit prices in the Food & Catering Prices table in K6. Enter the calculated values in D7:D11.
   2. Calculate the Grand Total of all the money spent on Food & Catering and enter the value in D12.
   3. Repeat steps 1 and 2 for Lodging & Villas using the pricing reference table in K16.
   4. Calculate the Grand Total of all other expense areas (Transportation, Artists & Performers, Marketing, Infrastructure) in the Expenses worksheet.
   5. Select cell B5 and change the text color to Orange, Accent 2, Bold it and change the font size to 14.
   6. In range B6:D6, change the background color to Gold, Accent 4.
   7. In range B12:D12, Bold the text and change the background color to Gold, Accent 4, Lighter 60%, and add All Borders.
   8. Copy the style of range B5:D6 and apply to all other tables in this worksheet.
   9. Copy the style of range B12:D12 and apply to all other tables that contain a Grand Total row in this worksheet.
4. Ticket Sales Worksheet
   1. Go to the Ticket Sales Calculate the total tickets sold per region in column O.
   2. Calculate the monthly total tickets sold in rows 15, 27, and 39.
   3. Calculate the running total of tickets sold in rows 16, 28, and 40.
   4. In cells O15, O27, and O39, calculate the grand total of the number of tickets sold for each category.
   5. Select and copy cells B5:N5 and paste them in B42:N42.
   6. Type the Bold label Grand Monthly Total in cell B43.
   7. In cells C43:N43, calculate the Grand Monthly Total by adding the Monthly total of each ticket category (Standard, Premium, VIP), for each month.
   8. For the range C7:N14, add conditional formatting to highlight the top 10% of cells in Green Fill With Dark Green Text and the bottom 10% in Light Red Fill With Dark Red Text.
   9. Repeat the same steps above for the ranges C19:N26 and C31:N38. Once done, edit the rules to change the threshold of all rules to 5% instead of 10%.
5. Revenue Worksheet
   1. In the Revenue worksheet, reference the total tickets sold for each category and region in the range C7:E14.
   2. Insert two new rows below row 15.
   3. In B15, write the word “TOTAL”.
   4. In C15:E15, calculate the revenue of ticket sales of each category based on the pricing table in I5.
   5. Select the range C7:E14 and add data bars through conditional formatting.
   6. In cell B16, add the label “Monthly Sales”.
   7. In Cell C16, Insert sparklines of type column, using as data source the range C43:N43 in the Ticket Sales Worksheet. Merge the range C16:E16.
   8. In range B6:E16, add All Borders.
   9. Use the Accounting Number Format for the numeric values in the Fyre Cash and Donations tables.
   10. In range B5:E6, copy the styles applied to the table titles and headings in the Expenses
   11. In range B15:E15, copy the styles applied to the table Grand Totals in the Expenses Make sure to keep the accounting format for dollar amounts.
   12. Apply the same table heading styles to all other tables in this worksheet.
6. Financial Report Worksheet
   1. In the Financial Report worksheet, in cell C6, calculate the total ticket sales revenue of all ticket categories by referring to the amounts in the Revenue
   2. In cell C7, calculate the total Fyre Cash revenue by referring to values in the Revenue
   3. In cell C8, calculate the total donations by referring to values in the Revenue
   4. In cell C9, calculate the total gross revenue of the festival by adding the revenue from the cells above it.
   5. In cell C11, refer to the total Food & Catering expense in the Expenses
   6. In cells C12:C16, repeat the step above for all other expense categories.
   7. In cell C17, calculate the total expenses for the festival by adding the expenses in the cells above it.
   8. In cell C19, calculate the profit/loss of the festival by subtracting expenses from the revenue.
   9. Select the non-adjacent range B5:C9, B11:C17, B19:C19 and add All Borders.
   10. Copy the same table heading styles found in the Expenses and Revenue worksheets and apply it to range B4:C5.
   11. Copy the same Grand Total styles found in the Expenses worksheet and apply it to ranges B9:C9, B17:C17, B19:C19.
   12. Increase the font size of B19:C19 to 18.
   13. Add a Pie Chart referencing data in the range B6:C8. Change the title of the chart to Revenue and snap the upper left corner to D5 and lower right corner to F17, so it aligns with the data table next to it.
   14. Add another Pie Chart referencing data in the range B11:C16. Change the title of the chart to Expenses and snap the upper left corner to G5 and lower right corner to L17. Change the position of the legend to be on the right of the chart.
   15. Add chart elements to both pie charts to display percentages for each pie slice. Position them on the Outside End.
   16. Change the title style of both pie charts to Bold and use the Orange, Accent 2 Make the chart background Gold, Accent 4, Lighter 60%.
7. Save the workbook.
8. Upload it to Canvas.