NEED AN ANSWER! ASAP

1. Operational Issue. The Profit and Loss Statement's variables and computation (October 1-31, 2020) A. Room Revenue: Galaxy Hotel is a newly renovated hotel with a total of 450 rooms, each room has a rack rate or average room rate of PHP 5300. All rooms have a projected 30% expense rate. B. Restaurant Sales: B.1 Compute for the cost of typical ham and cheese sandwich (2 sliced of loaf bread, 1 sliced ham, 1 sliced cheese, 20grams mayonnaise) given the following costs per item used: Loaf bread at P56.00/pack (a pack contains 22 slices) Ham at P89.00/pack (10pcs/pack) Sliced cheese at P65.00 (spcs/pack) Mayonnaise at P55.00/bottle (330g/bottle) Sandwich wrapper P25.00/50 pcs Note: Transaction count per guest it at 115/day; Mark up at least 300% on top of the food cost C. Wage/ salary: a. Manila rate of PHP537.00 per day, COLA of P10.00/ day b. 10 Restaurant Staff C. 10 Housekeeping Staff d. 3 Front Office Staff e. 1 FO Manager- Php 25,000/month f. 1 Executive Housekeeper-P30,000/ month g. 1 Dinning Supervisor-P20,000/month h. 2 Chef De Partie -P29,950/month i SSS should be ER; Phil health-Employer's Share only D. Sales and Marketing: a. Typically, 14 feet high and 48 feet wide for Billboard (Php30/ sqft: 5 billboards) b. AVP per month at P145,000.00 C. Brochures (300 pcs at P95 per page) E. Utilities Expense a. Telephone Bills @ P90,000.00 b. Gas Bill @ P45,000.00 C. Electricity Expenses @ P800,000.00 d. Water Charges @ P375,000.00 D E G Galaxy Hotel Projected Profit and Loss Statement October 1-31, 2020 Projected Revenue Room Sales Food/Restaurant Sales 100% Projected Expenses Room Cost/Expense Food Cost Wages/Salary Sales and Marketing Utilities and Expense #DIV/01 #DIV/0! Projected Income Food Restas Wory and in U PL