12:36 Il 21% case-2 - Saved (A) A local Motel has provided you with the following information and has asked you to determine how much revenue must be generated to achieve the desired profit objective and what is the Motel's breakeven sales in $ and occupancy %. Average Room Rate $79.95 Motel Rooms Available 160 Operational Days Open 360 Fixed Costs 380,000 Desired Profit Objective 60,000 Variable Cost Per $21.25 Occupied Room (B) The local Motel in A above has provided you with the following additional information and has asked you to calculate the single and double room rate. Single Room Occupancy 75% Double Room Occupancy 25% Annual Occupancy % 65% Spread between single 11.00 (C) A College's food operation has provided you with the following information and has asked you to determine how many meals must be sold to provide the desired annual profit. Average Meal Price $5.25 Fixed Costs 62,500 Desired Profit 35,750 Variable Cost Per Meal $2.95 (D) A motel has provided you with the following information and has asked you to determine the variable cost per room. Revenue 725,000 Fixed Costs 395,000 Desired Profit 175,000 Average Room Rate $75.25 (E) A local Pub & Grill has provided you with the following information and has asked you to determine how much revenue must be generated to achieve the desired profit objective. Fixed Costs 230,000 Desired Profit 47,750 Variable Cost Per Meal 62.5% (as a % of sales) REQUIRED: *Calculate the requirement for each objective the objective. *Provide a formal schedule to present the required results *Make sure you provide brief detail on how you arrived at key numbers