It was autumn, Nancy's favorite time of year-and busiest time of year, too. She works at a company that produces apple-pie filling: sweet, yet a little tart, with just a touch of cinnamon-so tasty! And with ripe apples from local suppliers being in season, her company is ramping up production. The following expectations are in place for this last quarter of the year. October November December January Sales forecast (units) 18,000 25,000 22,000 11,000 Additional information: Budgeted selling price is $3 per unit. Desired ending inventory of finished goods is 20% of next month's sales. Desired ending inventory of apples is 25% of next month's production needs for October and November, and 10% of next month's production needs for December. Desired ending inventory of spice mix is 20% of next month's production needs. Each finished unit requires 2 pounds of apples. Each finished unit requires 1/4 cup of spice mix. Cost per pound of apples is $0.40. Cost per cup of spice mix is $0.30. Estimated production for January is 11,000 units. On September 30, the company held exactly its desired levels for both DM Inventory and FG Inventory. October 19400 2 38800 November 24400 2 48800 December 19800 2 39600 Quarter 63600 2 127200 7760 9760 7920 25440 46560 58560 47520 152640 9700 i 12200 i 9900 i 31800 36860 0.40 14744 + LA CA $ 46360 0.40 18544 $ LA 37620 120840 0.40 $ 0.40 +A $ 15048 +A 48336 Spice Mix October November LA +A +A December Quarter LA $ LA