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 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,760 cases $ 240 150 cases 100 cases 2 hours $ 10 per hour $ 8 $ 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