I need this one solution as soon as poss

Table 3:| S58T Hotel Income Statement for period January 2015 Month [January 2015) Account Variance code Budget S Budget % Actual $ Actual % Variance $ (A-B) F/V Revenue Rooms $293,733.00 Revenue Food $281,623.00 Revenue Beverages $82,637.00 Revenue Functions $32,810.00 $43,277.00 Revenue Telephone $15,224.00 $12,342.00 Revenue $639.558.00 100.00% $713,612.00 100.00% Year to Date (July 2014 to Jan 2015) Revenue Rooms 2.139.200.00 52.830,484.00 Revenue Food 1.539.923.00 $1,823,833.00 Revenue Beverages 1.277 291.00 $1,229,384.00 Revenue Functions 938 362 00 $862,083.00 Revenue Telephone 73.91 1.00 $522,830.00 ISITXENOOR Class Activity Book VID Total Revenue 5,968,687.00 100.00% $7,268,614.00 100.00% $1,299,927.00 100% Budget S for Revenue Rooms per month a Number of Rooms available x forecast occupancy % x Average Room Rate x 30 days per month Forecasted Food & Beverage Sales = Number of Seats Available x Forecasted Seat Turnover Average Spend per customer x 30 days per month It is estimated that from the Total FAB sales, 70% is Food Sales and 30% is Beverage Sales. To calculate Food & Beverage Sales use the above formula and distribute 70% for Food Sales and 30% for Beverage Sales to enter in Income Statement for the month of January Budget % = (Budget 5/ Total Revenue] x 100 Budget Variance In $ = Actual - Budget