PR $9-37($Algo$)$ Completion of Budget Schedules $($LO $9-3,9-5,9-6)$

Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager.

$\backslash$table$[[$April$,19,000$ desk$-$and$-$chair sets$],[$May$,21,000$ desk$-$and$-$chair sets$],[$June$,24,000$ desk$-$and$-$chair sets$]]$

Each desk$-$and$-$chair set requires $11$ board feet of pine planks and $1\mathrm{.}2$ hours of direct labor. Each set sells for $$55.$ Pine planks cost $$\mathrm{.}50$ per board foot, and the division ends each month with enough wood to cover $10$ percent of the next month's production requirements. The division incurs a cost of $$23$ per hour for direct$-$labor wages and fringe benefits. The division ends each month with enough finished$-$goods inventory to cover $20$ percent of the next month's sales.

Required:

Complete the following budget schedules.

Sales budget.

Production budget $($in sets$).$

Raw$-$material purchases.

Direct$-$labor budget.

Complete this question by entering your answers in the tabs below.

Required $1$

Required $2$

Required $3$

Sales budget:

$\backslash$table$[[,$April,May,June$],[$Sales $($in sets$),,19,000,,,],[$Sales price per set,$$,55,,,],[$Sales revenue,$$,1,045,000,$$$,0,$$