Dalton Beverages manufactures its own soda pop bottles. The bottles are made from polyethylene terephthalate (PET), a lightweight yet strong plastic Dalton uses as much PET recycled rebin pellets in its bottles as it can both because using recycled PET helps Dalton to meet its sustainability goals and because recycled PET is less expensive than virgin PET Dalton is continuing to search for ways to reduce its costs and its impact on the environment. PET plastic is melted and blown over soda bottle moulds to produce the bottles. One idea Dalton's engineers have suggested is to retrofit the soda bottle moulds and change the plastic formulation slightly so that 25% less PET plastic is used for each bottle. The average kilograms of PET per soda bottle before any redesign is 0.012 kg. The cost of retrofitting the soda bottle moulds will result in a one-time charge of $59,276, while tho plastic reformulation will cause the average cost per kilogram of PET plastic to change from $2.00 to $2.10 Daltor's management is analyzing whether the change to the bottle moulds to reduce PET plastic usage should be made. Management expects the following number of soda bottles to be used in the upcoming year Click the icon to view additional information.) Reguitements Requirement 1. Using the onginal 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 yoar in total Start by preparing the direct materials budget through the total quantity needed, and then complete the budget (Round all answers to the nearest number. For the quantity of direct materials needed per unit, enter round your answer to three decimal places X.XXX. Use parentheses or a minus sign for beginning inventory balances. Round cost per kilogram to the nearest cent.) Dalton Beverages Data table Units to Quantit Quantity Plus Des Quarter 1 Quarter 2 Quarter Quarter 4 Number of soda pop bottles to be produced 2,200.000 2.400.000 2.500.000 3.100.000 For the upcoming year management expects the beginning inventory of PET to be 7.920 kilograms, while ending inventory (before any redesign) is expected to be 11,680 kilograms. During the first three quarters of the year, management wants to keep the ending inventory of PET at the end of each quarter equal to 30% of the following quarter's PET needs Total qual