The Wentworth Company, Estimating Its Sales to Be 40,000 Units

Essay

The Wentworth Company, estimating its sales to be 40,000 units for the upcoming period, prepared the following static budget:
The owner of the business is not so sure about the 40,000 unit sales volume and has requested additional budgets.Required:
In the table provided, prepare two additional budgets, one at 90% of the static budget volume level and one at 110% of the static budget volume level. $\begin{array}{|l|cc|}\hline \text { Units: } & & 40,000 \\\hline \text { Sales } & \$ & 400,000 \\\hline{\text { Less variable costs: }} \\\hline \text { Manufacturing costs } & & 140,000 \\\hline \text { Selling and administrative costs } & & 80,000 \\\hline \text { Contribution margin } & \$ & 180,000 \\\hline {\text { Less fixed costs: }} \\\hline \text { Manufacturing costs } & & 44,000 \\\hline \text { Selling and administrative costs } & & 34,000 \\\hline \text { Net income } & \$ & 102,000 \\\hline\end{array}$