Question: Complete the following table Do not enter dollar signs or commas in the input boxes. Use the negative sign for negative values. Round all answers


Complete the following table Do not enter dollar signs or commas in the input boxes. Use the negative sign for negative values. Round all answers to 1 decimal place. Vertical common size Horizontal analysis Difference % change Sales revenue August Sept 2005 2006 Room service $13,500 $12,000 $ % % % Dining room $76,100 $68,600 $ % % % Bar-Lounge $4,900 $4,200 $ % % % Coffee shop $53,400 $48,600 $ % % % Banquets $66,500 $70,600 $ % % % Total Sales revenue $214,400 $204,000 $ % % % Cost of sales $-74,700 $-71,600 $ % % % Gross profit $139,700 $132,400 $ % % % Operating expenses Wages and salaries $71,300 $67,000 $ % % % Employee benefits $13,200 $11,700 $ % % % Linen and laundry $3,200 $2,900 $ % % % China, Glassware & tableware $4,900 $4,600 $ % % % Misc operating cost $4,300 $4,100 $ % % % Operating supplies $8,400 $7,300 $ % % % Total operating expenses $105,300 $97,600 $ % % % Departmental operating income $34,400 $34,800 $ % %
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
