The master budget at Windsor, Inc., last period called for sales of 90,000 units at $36 each. The costs were estimated to be $15 variable per unit and $900,000 fixed. During the period, actual production and actual sales were 92,000 units. The selling price was $36.45 per unit. Variable costs were $17.70 per unit. Actual fixed costs were $900,000.
Required:
Prepare a sales activity variance analysis. (Leave no cells blank - be certain to enter "0" wherever required. Input all amounts as positive values. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.)
- Flexible Budget
- (based on actual
- of 92,000 units) Sales Activity
- Variance Master Budget
- (based on budgeted
- 90,000 units)
- Sales revenue $ $ $
Less:
Variable manufacturing costs
Contribution margin $ $ $
Less:
Fixed costs
Operating profits $ $ $