Question

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,450 cases 240 150 cases 100 cases 2 hours 10 per hour $ $ 6 $ 220,000 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? Answer is not complete.

please solve all the empty spaces even the correct ones so I can understand the way thanks

Answer 1

A. Prodution required in units = Unit sales + Target inventory at the end of the quarter - Beginning inventory in units = 1,450 + 100 - 150 = 1,400 units

B. Variable manufacturing cost per case = $ ( 20 + 8 + 6 ) = $ 34

C.

Variable manufacturing costs
Direct labor ( 1,400 units @ $ 20)	$ 28,000
Direct materials ( 1,400 units @ $ 8)	11,200
Variable manufacturing overhead ( 1,400 units @ $ 6)	8,400
Total variable manufacturing costs	47,600
Fixed overhead costs	220,000
Total cost of finished goods manufactured	$ 267,600
Units manufactured	1,400
Manufacturing cost per unit	$ 191.14

D. Projected ending inventory value = $ 191.14 x 100 units = $ 19,114