Exercise 23.3 (Algo) Production Budgets (LO23-4, LO23-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 1,350 cases 240 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 150 cases i 100 cases 2 hours 10 per hour. Direct material cost per case $ 8 $ 6 Variable manufacturing overhead cost per case Fixed overhead costs for the upcoming quarter $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 invertory value for this particular tile design? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare NuFloor's manufacturing cost budget. (Round your cost per unit answer to 2 decimal places.) Variable manufacturing costs: $ Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D What is NuFloor's budgeted variable manufacturing cost per case? Total variable cout per case Comprese uns question by entering your answers in the tabs below. Required A Required B Required C Required D. Using this information, develop NuFloor's sales forecast in dollars and its schedule of production in units. Budgeted sales (in dollars) Planned production (cases) Required B > 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 Required D What is the projected ending inventory value for this particular tile design? (Round your intermediate calculations to 2 decimal places and final answer to the nearest dollar amount.) Ending inventory value * Total variable manufacturing costs Total cost of finished goods manufactured