Decker Beverages manufactures its own juice bottles. The bottles are made from polyethylene terephthalate (PET), a lightweight yet strong plastic. Decker uses as much PET recycled resin pellets in its bottles as it can, both because using recycled PET helps Decker to meet its sustainability goals and because recycled PET is less expensive than virgin PET. i (Click the icon to view more information.) Decker's management is analyzing whether the change to the bottle molds to reduce PET plastic usage should be made. Management expects the following number of juice bottles to be used in the upcoming year: (Click the icon to view the number of soda bottles.) Read the requirements. Requirement 1. Using the original data (before any redesign of juice 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. Decker Beverages Direct Materials Budget For quarters 1 through 4 Quarter 1 Quarter 2 Units to be produced 2300000 2800000 Quarter 3 Quarter 4 3000000 2000000 Year 10100000 Multiply by: Quantity of direct materials needed per unit .16 .16 .16 .16 .16 368000 448000 480000 320000 1616000 Quantity of PET needed for production Plus: Desired ending inventory Total quantity needed Decker Beverages manufactures its own juice bottles. The bottles are terephthalate (PET), a lightweight yet strong plastic. Decker uses as m pellets in its bottles as it can, both because using recycled PET helps I sustainability goals and because recycled PET is less expensive than (Click the icon to view more information.) Data table Requirement 1. Using the original data (before any redesign of juice b Quarter 1 Quarter 2 2,800,000 Quarter 3 Quarter 4 3,000,000 2,000,000 Number of juice bottles to be produced...... 2,300,000 For the upcoming year, management expects the beginning inventory of PET to be 36,800 kilograms, while ending inventory is expected to be 32,530 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 10% of the following quarter's PET needs. More info Print Done - Decker is continuing to search for ways to reduce its costs and its impact on the environment. PET plastic is melted and blown over juice bottle molds to produce the bottles. One idea Decker's engineers have suggested is to retrofit the juice bottle molds and change the plastic formulation slightly so that 20% less PET plastic is used for each bottle. The average kilograms of PET per juice bottle before any redesign is 0.16 kg. The cost of retrofitting the juice bottle molds will result in a one-time charge of $1,034,694, while the plastic reformulation will cause the average cost per kilogram of PET plastic to change from $4.00 to $4.20. Print Done Requirements 1. Using the original data (before any redesign of juice 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. 2. Assume that the company retrofits the juice bottle molds and changes the plastic formulation slightly so that less PET plastic is used in each bottle. Now 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 for this possible scenario. - 3. Compare the cost of PET plastic for Requirement 1 (original data) and for Requirement 2 (making change to using less PET.) What is the direct material cost savings from making the change to using less PET? Compare the total of those savings to the cost of retrofitting the juice bottle molds. Should the company make the change? Explain your rationale. Get more help Print Done