Saved

Exercise $23\mathrm{.}3($Algo$)$ Production Budgets $($LO$23-4,$ LO$23-5)$

NuFloor Manufacturing produces floor tiles. The managers at NuFloor are trying to develop budgets for the upcoming quarter. The following data have been gathered for a particular tile design:

Projected unit sales

Selling price per case

Inventory at the beginning of the quarter

Target inventory at the end of the quarter

Direct labor hours needed to produce one case

Direct labor wages

Direct material cost per case

Variable manufacturing overhead cost per case

Fixed overhead costs for the upcoming quarter

$1,630$ cases

$$240$

$150$ cases

$100$ cases

$2$ hours

$$10$ per hour

$$8$

$$6$

$$220,000$

Required:

a$.$ Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units.

b$.$ What is NuFloor's budgeted variable manufacturing cost per case?

c$.$ Prepare NuFloor's manufacturing cost budget.

d$.$ What is the projected ending inventory value for this particular tile design?

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

Required A

Required B

Required $C$

Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units.

$\backslash$table$[[$Budgeted sales $($in dollars$),],[$Planned production $($cases$),]]$