The final product $($bags of chips$)$ requires two direct materials: sweet potatoes and packaging. $4$ pounds of raw potatoes are required for each one$-$pound bag of potato chips. Management desires to have materials on hand $($i$.$e$.,$ pounds of potatoes$)$ at the end of each month equal to $20$ percent of the following month's production needs. The beginning materials inventory, July $2024,$ is expected to be $44,560$ pounds. Potatoes cost $$1\mathrm{.}20$ per pound.

Packaging material is purchased by the roll and $100$ bags of chips are produced from each roll. The packaging is made from biodegradable, organic plant fiber that extends the shelf life of the potato chips while preserving its freshness. Management desires to have packaging on hand at the end of each month equal to $15$ percent of the following month's production needs. The beginning inventory of packaging $($i$.$e$.,$

rolls of packaging material$)$ in July $2024$ is expected to be $84$ rolls. Packaging is expected to cost $$18$ per roll.

Note, budgeted production in October is required in order to complete the direct materials budget for September. Also, use the @ROUNDUP function to round up to the nearest whole number of pounds of potatoes and number of rolls of packaging both for desired ending inventory and material to purchase. Further, because two direct materials are required for production $-$ potatoes and rolls of packaging $-$ you will need a separate schedule for each direct material, Prepare a Direct Materials budget.