Hey Beverages manufactures its own soda pop botes. The bottles are made from polyethylene tereph (PET), a lightweight yet strong plastic Riley uses as much PET recycled resin pellets in its bottles as it can, both because using racycled PET helps Riley to meet its sustainability goals and because recycled PET is less expensive than virgin PET (Click the icon to view more information.) Rey's management is analyzing whether the change to the botte molds to reduce PET plastic usage should be mada. Management expects the following number of soda bottles to be used in the upcoming year (Click the icon to view the number of soda bottles) Read t Requirement 1. Using the original data (before any redesign of soda bottles), prepare a direct materials budget to calculate the cost of PET purchases in each quarter for the upcoming year and for the year in total Start by preparing the direct materials budget through the total quantity needed, then complete the budget Riley Beverages Direct Materials Budget For quarters 1 through 4 Units to be produced Mutiply by Beginning inventory of direct mater Quantity of PET needed for production Pu Desired ending inventory Total quantity needed Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year