Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
Tips on Project Case Analysis: Boat Marina
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
Questions 6: For the month of June, what are the average sales for each product category and product within each category? For the month of June, what are the total sales for each
product category and product within each category?
Suggestions:
· Pivot Table will be useful to calculate the average sales by product category and within-category product (e.g., description)
· Relevant information is from “Reservation” worksheet and “Property” Worksheet
· Before you try to Sales $ should be calculated based on the existing data:
Sales $=([EndDate]-[ResDate]+1) * RentalPrice
· To get a month name rather than a number, you use the TEXT function, =TEXT(cell reference,”mmmm”) – returns a full month name, as January – December
Question 9. For the month of June, prepare a pie chart comparing the revenue by property category.
Suggestions:
Similar to the question above, that rental revenue is equivalent to the sales $ you calculated from Question 6. You can run the Pivot table to get the summary data and then create the pie chart.
