[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.

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
[SOLVED] FYRE Festival was a fraudulent “luxury music festival” founded by Billy McFarland.
Get a 15% Discount on this Paper
Order Now

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.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyCoursebay
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Social Work and Human Services
Excellent Work!!!!
Customer 452587, November 29th, 2021
Ethics
thank you
Customer 452493, March 15th, 2021
Other
GREAT
Customer 452813, June 25th, 2022
Management
Great job
Customer 452643, October 31st, 2021
English 101
thank you
Customer 452483, February 27th, 2021
Nursing
Always perfect! Thank you!!!
Customer 452453, April 15th, 2021
Criminal Justice
always great!
Customer 452465, February 23rd, 2021
Social Work and Human Services
Excellent
Customer 452587, July 28th, 2021
Other
NICE
Customer 452813, June 30th, 2022
Nursing
Always on time and a life saver for sure!!!!!!!!!!!!
Customer 452453, October 22nd, 2021
Social Work and Human Services
Excellent Work
Customer 452587, November 22nd, 2021
Nursing
This is great! Thank you
Customer 452679, December 16th, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
NEW

Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now