Operational Analysis QUESTION 1 ABC Hotel is a 390-room economy hotel in downtown St. Louis. After taking physical inventory of the laundry chemicals on May 31st, the assistant controller found that: In the Main Storeroom 15 cases of detergent at $90 each 15 cases of neutralizer at $65 each 16 cases of softener at $31 each 7 pails of bleach at $7.50 each 1 bucket of starch at $13.50 each In the Laundry Room 5.75 cases of detergent 2.25 cases of neutralizer 8.50 cases of softener 0.50 pails of bleach 0.25 buckets of starch The beginning inventory for laundry supplies on May 1st was $6,051.75. Purchase of laundry chemicals on May 9 th totaled $890.15. The hotel sold 9,067 rooms for the month at an average daily rate of $65.10. Please calculate the laundry chemical cost percentage for the month. Please round all answers to two decimal places. First please calculate total ending inventory $___ QUESTION 2 Please use the information in Question 1 to calculate the cost of laundry supplies used. Round all answers to two decimal places. Cost of laundry supplies used $___ QUESTION 3 Please use the information in Question 1 to calculate the monthly rooms revenue. Round all answers to two decimal places. Monthly rooms revenue $___ QUESTION 4 Please use the information in Question 1 to calculate the laundry cost percentage. Round all answers to two decimal places. Laundry cost percentage ___% QUESTION 5 Calculate the net food cost percentage for the Food department of a hotel for the month of May. The total food sales revenue for May was $191,118. The following information has been gathered: beginning inventory on May 1st was $6,932 purchases in May totaled $12,883 food transferred from main storeroom was $61,315 food transferred to other outlet was $114 entertainment and promotion checks totaled $2,010 management signed checks were $691 documented food spoilage was $139 food for employee meals was $5,795 happy hour hors d'oeuvres was $2,040 ending inventory on May 31st was $6,318 To earn full credit, please calculate these amounts. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts: First calculate gross cost of food sales $___ QUESTION 6 Please use the information from Question 5 to calculate the amount to transfer from mail storeroom. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts: Transfer from mail storeroom $___ QUESTION 7 Please use the information from Question 5 to calculate the amount to transfer to the other outlet. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts. Transfer to other outlet $___ QUESTION 8 Please use the information from Question 5 to calculate the amount in entertainment and promotion checks. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts: Entertainment & promotion checks $___ QUESTION 9 Please use the information from Question 5 to calculate the amount in management signed checks. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts. Management signed checks $___ QUESTION 10 Please use the information from Question 5 to calculate the amount of food spoilage. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts. Food spoilage $ ___ QUESTION 11 Please use the information from Question 5 to calculate the amount in Employees' meals. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts. Employees' meals $___ QUESTION 12 Please use the information from Question 5 to calculate the amount in happy hour hors d'oeuvres. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts: Happy hour hors d'oeuvres $ ___ QUESTION 13 Please use the information from Question 5 to calculate the amount in net cost of food sales. Except as indicated below, answers are whole numbers. Be sure to include a minus sign (-) for any negative amounts. Net cost of food sales $___ QUESTION 14 Please use the information from Question 5 to calculate the amount in food cost percentage. Except as indicated below, an- swers are whole numbers. Be sure to include a minus sign (-) for any negative amounts. Food cost percentage (round to two decimal points) ___% QUESTION 15 A 345-room hotel's food and beverage department recorded food revenue of $3,460,397.5 and beverage revenue of $1,483,027.5. The cost of sales was 27.3% of F & B revenue, and the departmental expenses were 43.2% of F & B revenue. What is the gross profit percentage for the hotel's F&B department? Gross profit percentage for the hotel's F&B department (round to one decimal point) ___%. QUESTION 16 Determine the gross room rate if the Gross Room Rate increases by 15% in year 2 (round to two decimal points). YEAR 1 YEAR 2 Gross Room Rate $245.00 $ ___ Direct Costs (35% of GRR) $85.75 Net Room Rate $159.25 Expenses (Fixed) $60.00 Net Profit $99.25 Profit Margin 40.51% QUESTION 17 Please refer to the table in question 16, calculate the direct costs in year 2 if the Gross Room Rate increases by 15% (round to two decimal points). QUESTION 18 Please refer to the table in question 16, calculate the net room rate in year 2 if the Gross Room Rate increases by 15% (round to two decimal points). QUESTION 19 Please refer to the table in question 16, calculate the fixed expenses in year 2 if the Gross Room Rate increases by 15% (round to two decimal points). QUESTION 20 Please refer to the table in question 16, calculate the net profit in year 2 if the Gross Room Rate increases by 15% (round to two decimal points). QUESTION 21 Please refer to the table in question 16, calculate the Profit Margin in year 2 if the Gross Room Rate increases by 15% (round to two decimal points). QUESTION 22 Reference your answers from questions 16-21 (the table you filled out) to answer the following: In dollar term, how much did Net Profit increase in year 2? Net profit increased $___ in dollar terms from year 1 (Round to two decimal places) QUESTION 23 Reference your answers from questions 16-21 (the table you filled out) to answer the following: In percentage term, how much did Net Profit increase in year 2? Net profit increased ___% in percentage terms from year 1. (Round to two decimal places) QUESTION 24 Reference your answers from questions 16-21 (the table you filled out) to answer the following: In relative term, how much did profit margin increase in year 2? Profit margin increased ___% from year 1 (Round to two decimal points.) QUESTION 25 Reference your answers from questions 16-21 (the table you filled out) to answer the following: What would the Gross Room Rate need to be if a Profit Margin of 50% is required? The Gross Room Rate would need to be $___ for the Profit Margin to increase to 50%. (Round to two decimal points.)