Homework answers / question archive / he owner of the Queensland Restaurant would like to determine the fixed and variable components of the restaurant's utility expenses

he owner of the Queensland Restaurant would like to determine the fixed and variable components of the restaurant's utility expenses

Accounting

Share With

he owner of the Queensland Restaurant would like to determine the

fixed and variable components of the restaurant's utility expenses. The owner believes that the variable component of the utilities cost is driven by the number of meals served. 


     Meals served     Utilities cost 
January 3,600 P1,560 
February 2,000 P1,060 
March 2,900 P1,350 
April 3,500 P1,500 
May 3,900 P1,580 
June 2,100 P1,250 
July 1,900 P1,100 
August 1,000 P 850 
September 1,250 P 990 
October 1,400 P 880 
November 2,600 P1,180 


Required: 
[a] Plot the data on a graphing paper. 
[b] Using the scattergraph method, derive a cost formula for utilities cost. 
[c] Use your cost formula to predict the utilities cost if 5,200 meals are served.