With calculations

Co. produces fizzy soft drinks. The company expects to produce 150,000 6-pack "units" in 2023 . The primary materials include carbonated water, syrup, and plastic bottles. Each 6-pack produced requires 6 bottles and 4 ounces of syrup. Co. wants to always have 42,000 bottles on hand and 30,000 ounces of syrup in target ending materials inventory. Currently, Co. has 54,000 bottles and 27,000 ounces of syrup on hand in its beginning inventory. Co. purchases bottles from a third-party supplier at a cost of $0.15 per bottle. Syrup costs $0.32 per ounce. Create a Materials Purchases Budget for next month