The Orchestra presents a series of concerts throughout the year. Budgeted fixed costs total $300,000 for the concert season; variable costs are expected to average $5 per patron. The orchestra uses flexible budgeting.
A. Prepare a flexible budget that shows the expected costs of 8,000, 8,500, and 9,000 patrons.
B. Construct the orchestra's flexible budget formula.
C. Assume that 8,700 patrons attended concerts during the year just ended, and actual costs were: variable, $42,000; fixed, $307,500. Evaluate the orchestra's performance by computing variances for variable costs and fixed costs.
This solution prepares flexible budget and evaluates performance using variances in the attached Excel file.