how do i prepare a flexible budget? can you show steps?

Company C is a walk in clinic and had 2,900 patient visits in the most recent month Planned revenue and expenses were anticipated to be: Fixed Variable Revenue $ 30.00 per visit Expenses: Personnel $ 30,200 $ 7.70 per visit Medical supplies $1,600 $ 5.20 per visit Occupancy expenses $7,400 $ 1.00 per visit Administrative expenset $3,900 $ 0.20 per visit Actual results for the month. Revenue Personnel expenses Medical supplies Occupancy expenses Administrative expenses $89,360 $53,360 $16,880 $9,940 $4,550 Prepare a flexible budget for revenue and expenses, identify favorable and unfavorable differences and explain any steps you might take to improve the financial situation