undefined

A restaurant has the following 12 month record of sale revenue and wage costs: Month Sales Revenue Wage Costs January February $24,900 $24,200 $11,300 $11,100 March April May June July August September October November December $25,600 $24,200 $34,000 $46,200 $53,300 $44,000 $34,200 $30,400 $28,200 $27,000 $11,200 $11,400 $13,200 $18,600 $21,600 $16,100 $15,100 $12,800 $11,200 $13,000 Adjustments to the base information shown: Included in July wages is a lump sum retroactive wage increase of $1,800 which would not normally be part of July wage cost In December, the restaurant catered a special Christmas function that brought in $3,400 in sales revenue and cost the restaurant an additional $900 in wages The December wage figure also included $1,400 in Christmas bonuses to the staff A) Use the regression analysis method to calculate the fixed cost component of monthly wages Fixed Costs = (sum Y sum X2) - (sum X) sum XY) n (sum X2) - (sum X)2 A restaurant has the following 12 month record of sale revenue and wage costs: Month Sales Revenue Wage Costs January February $24,900 $24,200 $11,300 $11,100 March April May June July August September October November December $25,600 $24,200 $34,000 $46,200 $53,300 $44,000 $34,200 $30,400 $28,200 $27,000 $11,200 $11,400 $13,200 $18,600 $21,600 $16,100 $15,100 $12,800 $11,200 $13,000 Adjustments to the base information shown: Included in July wages is a lump sum retroactive wage increase of $1,800 which would not normally be part of July wage cost In December, the restaurant catered a special Christmas function that brought in $3,400 in sales revenue and cost the restaurant an additional $900 in wages The December wage figure also included $1,400 in Christmas bonuses to the staff A) Use the regression analysis method to calculate the fixed cost component of monthly wages Fixed Costs = (sum Y sum X2) - (sum X) sum XY) n (sum X2) - (sum X)2