For this question you will complete your answer in Excel. When you are finished, upload your response by clicking "Browse My Computer".

Use the information below to answer the questions that follow:

Month	Procedures	Electricity
Jan	1,000	4,500
Feb	800	3,500
Mar	700	3,025
Apr	900	3,250
May	950	3,300
Jun	1,000	4,400
Jul	1,100	4,200
Aug	1,250	4,800
Sep	1,200	5,000
Oct	1,050	4,500
Nov	1,100	4,250
Dec	900	3,200

Separate the fixed and variable components.

Are the number of procedures a good cost driver and why?

Assuming 1,000 procedures next month, what would be the projected total cost of electricity?

Use regression in Excel to solve this problem. Once you have completed your calculations,