Margie's Creations Manufactures Ceramic Figurines Required:

Prepare a Flexible Budget for the Three Sales

Margie's Creations manufactures ceramic figurines.In planning for the coming year,the budget committee is considering three different sales targets: 6,000 figurines,7,000 figurines,and 8,000 figurines.Figurines sell for $39 each.The standard cost information for one figurine is as follows:
$\begin{array}{lr}\text { Direct materials } & \$ 6 \\\text { Direct labor } & \$ 10 \\\text { Variable overhead } & \$ 4 \\\text { Variable operating costs } & \$ 2 \\& \\\text { Annual expected fixed overhead cost } & \$ 4,000 \\\text { Annual expected fixed operating costs } & \$ 42,000\end{array}$
Required:

Prepare a flexible budget for the three sales levels under consideration.