Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The companys planning budget for May appears below:

Puget Sound Divers Planning Budget For the Month Ended May 31
Budgeted diving-hours (q)		300
Revenue ($470.00q)	$	141,000
Expenses:
Wages and salaries ($11,000 + $124.00q)		48,200
Supplies ($6.00q)		1,800
Equipment rental ($2,100 + $22.00q)		8,700
Insurance ($3,900)		3,900
Miscellaneous ($530 + $1.50q)		980
Total expense		63,580
Net operating income	$	77,420

During May, the companys actual activity was 290 diving-hours.

Required:

Prepare a flexible budget for May.