Halifax Harbour Divers provides diving services such as underwater ship repairs to clients in the harbour and nearby south shore. The company$$s planning budget for May appears below:

Halifax Harbour Divers

Flexible Budget

For the Month Ended May $31$

Budgeted diving$-$hours $($q$)250$

Revenue $($$$430\mathrm{.}00$q$)$ $ $107,500$

Expenses:

Wages and salaries $($$$11,800+$ $$120\mathrm{.}00$q$)41,800$

Supplies $($$$4\mathrm{.}00$q$)1,000$

Insurance $($$$4,000)4,000$

Miscellaneous $($$$510+$ $$1\mathrm{.}44$q$)870$

Total expense $55,820$

Net operating income $ $51,680$

During May, the company$$s actual activity was $240$ diving$-$hours.

Required:

Prepare a flexible budget for May.