The master budget at Western Company last period called for sales of 240,000 units at $10.00 each. The costs were estimated to be $3.00 variable per unit and $270,000 fixed. During the period, actual production and actual sales were 245,000 units. The selling price was $10.10 per unit. Variable costs were $3.75 per unit. Actual fixed costs were $270,000.

Required:

Prepare a flexible budget for Western.

WESTERN COMPANY
Flexible Budget

Box 1 & 2 choices : fixed costs/sales revenue/variable costs (and amount)

Box 3 choices: contribution margin or contribution loss (and amount)

Box 4 choices: fixed costs/ sales revenue/ variable costs (and amount)

Box 5 options: operating profit or operating loss (and amount)