Big Bend Co Prepare a Flexible Budget for Big Bend Co

Big Bend Co.fixed budget for the year is shown below:
$\begin{array}{lr}\text { Sales (50,000units) }&&\$ 1,300,000\\\text { Cost of goods sold: }\\\text { Direct materials } & \$ 150,000 \\\text { Direct labor } & 450,000 \\\text { Overhead (includes } \$ 2 \text { per unit } & \underline { 240,000}& \underline { 840,000}\\ \text { variable overhead) } \\ \text { Gross profit } &&\$ 460,000\\\\\\\text { Selling expenses: }\\\text { Selling expenses: }\\\text { Sales commissions(all variable) } & 60,000 \\\text { Rent (all fixed) } & 40,000 \\\text { Insurance (all fixed) } & 35,000 \\\text { eneral and administrative expenses: } & \\\text { Salaries (all fixed) } & 72,000 \\\text { Rent (all fixed) } & 54,000 \\\text { Depreciation (all fixed) } & \underline {31,000}& \underline { 292,000 }\\\text { Net income from operations }&&\underline { \$ 168,000}\\\end{array}$ Prepare a flexible budget for Big Bend Co.that shows a detailed budget for its actual sales volume of 42,000 units.Use the contribution margin format.