Crawford Beverages manufactures its own soda pop bottles. The bottles are made from polyethylene terephthalate (PET), a

Question:

Crawford Beverages manufactures its own soda pop bottles. The bottles are made from polyethylene terephthalate (PET), a lightweight yet strong plastic. Crawford uses as much PET recycled resin pellets in its bottles as it can, both because using recycled PET helps Crawford to meet its sustainability goals and because recycled PET is less expensive than virgin PET.

Crawford 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 molds to produce the bottles. One idea Crawford's engineers have suggested is to retrofit the soda 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 soda bottle before any redesign is 0.005 kg. The cost of retrofitting the soda bottle molds will result in a one-time charge of $24,000, while the plastic reformulation will cause the average cost per kilogram of PET plastic to change from $2.50 to $2.60.

Crawford'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 soda bottles to be used in the upcoming year:

Crawford Beverages manufactures its own soda pop bottles. The bottles

For the upcoming year, management expects the beginning inventory of PET to be 1,000 kilograms, while ending inventory is expected to be 1,700 kilograms. During the first three quarters of the year, management wants to keep the ending inventory of PET at the end of each quarter's PET needs.
Requirements
Using the original date (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.
Assume that the company retrofits the soda 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.
Compare the cost of PET plastic for Requirement 1 (original data) and for Requirement 2 (making the change to using less PET.) What is the direct material cost saving from making the change to using less PET? Compare the total of those savings to the cost of retrofitting the soda bottle molds. Should the company make the change? Explain your rationale.

Ending Inventory
The ending inventory is the amount of inventory that a business is required to present on its balance sheet. It can be calculated using the ending inventory formula Ending Inventory Formula =...