Units to be produced Quantity of direct materials needed per unit Quantify of PET needed for production Plus: Desired ending inventory Total quantity needed Less: Beginning inventory of direct materiais Quantity to purchase Cost per kilogram Total cost of direct material purchases Dudiey Beverages manufactures its own soda pop botties. The bottles are made from polyethylene terephthalate (PET), a lightweight yet strong plas much PET recycled resin pellets in its bottles as it can, both because using recycled PET helps Dudley to meet its sustainability gosis and because re expensive than virgin PET. Dudley is continuing to search for ways to reduce its costs and its impact on the environment. PET plastic is melted and blown over soda bottie mould Data table ohtly so that 20% less potte moulds will resul fo $2.20 gement expects the For the upcoming year, management expects the beginning inventory of PET to be 1,250 kilograms, while ending inventory (before any redesign) is expected to be 1,700 kilograms. During the first three quarters of the year, management wants to koep the ending inventory of PET at the end of each quarter equal to 10% of the following quarter's PET needs. Dudiey Beverages manutactures its own soda pop bottles. The bottes are made from polyethylone terephthalate (PET), a ightweight yet strong plastic. Dudley uses as much PET recycled resin pellets in its botties as it can, both because using recycled PET helps Dudiey bo meet its sustainobilty goals and because recycled PET is less expensive than virgin PET. Dudley is continuing to search for ways to reduce ats costs and its impact on the emvironment. PET plastic is melled and biown cier soda bottle moulds to produce the bottes. One idea Dudley's engineers have suggested is to retrofit the sods bottle moulds and change the plastic formulabion slghtly so that 20 \% less PET plastic is used for each bottle. The average kilograms of PET per soda boltio before any redesign is 0.005kg. The cost of retrofiting the soda bottle moulds wil result in a one-time charge of $18,000, while the plastic reformulation will cause the average cost per kilogram of PET plastic fo change feom $2.00 to $2.20 Dudeys management is analyzing whether the change to the botte moutis to reduce PET plastic usage should be mado. Management expects the following number of soda bottles to be used in the upcoming year (Click the icon to view additional information). Requirement 1. Using the criginal data (betore any codesign of soda boties), prepare a direct materials budget to calculate the cost of PET purchases in each qua ter for the upcoming year and for the year in total Start by preparing the direct materals budget through the totat quantay needed, and then complete the budget. (Round all answorn to the neareat number. For the guantity of direct materials needed per unit, enter round your answer to three decimal places XxXX. Use parentheses or a minus sign for beginning inventory