Business Finance – Accounting Chart Assignment

 
Chart Assignment 

Using your forecast from the previous assignment create the following charts:
• A column chart for Occupancy % for January 1st -7th
o Chart Title should be “January Occupancy 1st-7th”
o Category x axis should be “Date”
o Category y axis should be “Occupancy %”
o Remove Legend (if applicable)
o Include the “Value” as a data label 
o Save the chart as a new sheet called “Chart 1”
• A pie chart comparing Transient Rooms Revenue, Group Rooms Revenue and Food & Beverage Revenue totals for Jan 3rd.
o Chart Title should be Revenue Sources
o Category Labels should be Transient Rooms Revenue, Group Rooms Revenue and Food & Beverage Revenue.
o Include “Value” & “Percentage” as data labels 
o Save the chart as a new sheet called “Chart 2”
• A line chart comparing Transient Room Rate and Group Room Rate for Jan 1st–7th.
o Chart Title should be “Room Rate Analysis”
o Category x axis should be “Date”
o Category y axis should be “Rate”
o Change Series 1 label to “Transient”
o Change Series 2 label to “Group”
o Category x axis labels should be 1 thru 7
o Include “Value” as a data label
o Save chart as a new sheet called “Chart 3”

Save your file as “Chartsfirstlastname” 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Practice1 INPUT DATA Forecasted annual sales growth 10% COGS/SALES 55% SG&A/SALES 20% DEPRECIATION/Gross PPE 8% INTEREST RATE 10% TAX

Practice1 INPUT DATA Forecasted annual sales growth 10% COGS/SALES 55% SG&A/SALES 20% DEPRECIATION/Gross PPE 8% INTEREST RATE 10% TAX RATE 35% CASH/SALES Plug ACCOUNT RECEIVABLE/SALES 35% INVENTORY/SALES 85% ACCOUNTS PAYABLE/SALES 14% OTHER CURRENT LIAB/SALES 25% GROSS PPE 70% of sales if Sales <=45000 27000+0.7(Sales-40000) if 45000< Sales <= 50000 38500+0.3(Sales-50000)