Sustainability and budgeting (Learning Objective 1)
Liller Beverages manufactures its own soda pop bottles. The bottles are made from polyethylene terephthalate (PET), a lightweight yet strong plastic. The company uses as much PET recycled resin pellets in its bottles as it can, both because using recycled PET helps the company to meet its sustainability goals and because recycled PET is less expensive than virgin PET.
Liller 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 Liller’s engineers have suggested is to retrofit the soda bottle molds 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.004 kg. The cost of retrofitting the soda bottle molds will result in a one-time charge of $35,947, while the plastic reformulation will cause the average cost per kilogram of PET plastic to change from $4.00 to $4.30.
Liller’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:
For the upcoming year, management expects the beginning inventory of PET to be 1,280 kilograms, while ending inventory is expected to be 1,690 kilograms. During the first three quarters of the year, management wants to keep the ending inventory of PET a1 the end of each quarter equal to 10% of the following quarter’s PET needs.
Requirements
- 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.
- 2. 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.
- 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 soda bottle molds. Should the company make the change? Explain your rationale.
Want to see the full answer?
Check out a sample textbook solutionChapter 15 Solutions
Managerial Accounting (5th Edition)
- (Learning Objective 2: Distinguish a capital expenditure from an immediate expense)LimeBike, located in San Mateo, California, is a startup founded in 2017. Its mission isto make shared bicycles accessible and affordable. The company has taken the basic idea ofshared bicycles and eliminated the need to return the bike to a docking station, which may notbe near the cyclist’s destination. LimeBike charges $1 per 30 minutes of riding, or $0.50 perride for students.To use LimeBike, you first use the LimeBike app to locate one of the citrus-colored bikesnear your location. Once you are at the bike, you scan the QR code on the bike or enter thebike’s plate number into the app to unlock the bike. When you are finished using the bike, youpark the bike by a bike rack or post––anywhere that is legal and visible. Once you press downthe back-wheel lock, the trip is finalized and your payment is processed by LimeBike’s app.LimeBike does not depend on government funding, making it appealing to…arrow_forwardBE5.7 - Using Excel to Determine Profitability Given a Constrained Resource Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Rachel wants to use her knitting skills to make a little extra money so she can enjoy a theatre weekend with her besties. She’s got the pattern down for a hat, scarf, and mittens, but she realizes that her available time is limited. She should be able to sell as many of any item as she can make, but she wants to make sure she’s making the best use of her time. Cost and time information are provided here. Calculate the contribution margin per unit of the scarce resource for each item. Hat Scarf Mittens Hat Scarf Mittens Contribution margin per Time in minutes 20 30…arrow_forwardThe Shining Stars primary school was the recent recipient of a technology grant to source and implement a school management system. The school administrator is not technology savvy and therefore sought advice from three of the board members who were knowledgeable in the information systems and technology field. One director advised the administrator to purchase an off-the-shelf solution that would allow the school to get the system configured and up and running in a short period with reasonable costs. The second advised the administrator to invest in the development of a unique system to meet the custom requirements of the school’s administration. He suggested that this would create a closer fit to the school’s needs compared to purchasing software, but will cost more. The third director suggested using an open-source solution which would have little if any upfront costs but may require some customization. The school administrator must decide about which solution to go with.…arrow_forward
- Classifying quality costs and using these costs to make decisions Loiselle manufactures high-quality speakers. Suppose Loiselle is considering spending the following amounts on a new quality program: It also expects this program to avoid lost profits from the following: Requirements Classify each of these costs into one of the four categories of quality costs (prevention, appraisal, internal failure, or external failure). Should Loiselle implement the quality program? Give your reasons.arrow_forwardIn an effort to raise the demand for reading tests, managers are planning to lower the price from $36 per test to $20 per test, the current price of the math test. They believe that doing so will increase the demand for reading tests to 60,000. Prepare a contribution format income statement reflecting Abado’s new pricing and demand structure. Abado Profiles provides testing services to school districts that wish to assess students’ reading and mathematical abilities. Last year Abado evaluated 60,000 math tests and 20,000 reading tests. An income statement for last year follows. Math Testing Reading Testing Total Per Unit Total Per Unit Total Company Sales revenue $1,200,000 $20 $720,000 $36 $1,920,000 Variable expenses 840,000 14 360,000 18 1,200,000 Contribution margin $360,000 $6 $360,000 $18 720,000 Fixed expenses 360,000 Operating income $360,000arrow_forwardI'm just trying this out, so hang with me. I'm just curious how many questions this would count as and the answers would be nice. It says to ask one academic question, but this kinda is. I'll see what happens. Thank you much. The book I'm working out of Cornerstones of Cost Management 4th Ed. - Chapter 4 Scenario I: Goodmark Company produces two products: scented and regular birthday cards. Goodmark uses a plantwide rate based on direct labor hours. The estimated and actual data for the coming year are provided below: Estimated overhead $720,000 Expected activity (direct labor hours) 180,000 Actual activity (direct labor hours) Scented cards 20,000 Regular cards 160,000 Units produced Scented 20,000 Regular 200,000 Required: 1. Calculate the following: a. The predetermined overhead plantwide rate (round to the nearest cent): _______ per direct labor hour b. Applied overhead for each product (round to the nearest dollar): Scented:…arrow_forward
- The marketing director, Mr. Thomas, has been investigating the market for disposable coffee cupsthat are fully recyclable as the contribution made by the manufacturing industry growing andtrading to environmental and social issues. The cups are manufactured from a combination of paperand coated in Polylactic Acid-Based plastic to make them waterproof. He believes that this wouldallow Ceylon Coffee Vendors PLC to sell to the big coffee shop chains, to exploit the benefits fromthe growth in this market. The initial cost of the expansion will be Rs. 3.3 million with a residualvalue of Rs. 0.05 million at the end of the fifth year. The initial cost of expansion will be paid inthree (03) equal installments at the end of the current year, year 1 and year 3. The refurbishmentcost at the end of the fifth year is Rs. 0.5 million. Thomas forecasted to produce 200, 000 cups perannum over the next five (05) years. The annual sales of coffee cups as a percentage of plannedproduction are expected to…arrow_forwardLearning curve, cumulative average-time learning model. Northern Defense manufactures radar systems. It has just completed the manufacture of its first newly designed system, RS-32. Manufacturing data for the RS-32 follow: Calculate the total variable costs of producing 2, 4, and 8 units.arrow_forwardGreen Manufacturing is a traditional manufacturing company located in the midwestern United States. The company’s operations manager is developing a strategy to become more CSR-oriented. In an effort to evaluate possible areas where CSR initiatives can be implemented, the manager has gathered the following data regarding three potential CSR activities: Initialadded cost Variable cost Variable savings Recycle and reuse production material $5,000 $0.10 per lb. of recycled material $0.15 per lb. of recycled material Add solar panels as a source of power 700,000 $1,000 per year $33,000 per year Replace assembly room light fixtures with natural light 120,000 $180 per month $220 per month The recycling activity would carry on indefinitely. The solar panels would have a useful life of 30 years. The replacement of assembly room light fixtures with natural light is assumed to have an 80-year effect. a. Determine if it is viable to recycle and use…arrow_forward
- Make a Decision: Analyze CSR initiatives at Gree Manufacturing (from Chapter 14)Obj. 5 Green Manufacturing is a traditional manufacturing company located in the midwestern United States. The company's operations manager is developing a strategy to become more CSR-oriented. In an effort to evaluate possible areas where CSR initiatives can be implemented, the manager has gathered the following data regarding three potential CSR activities: Initial Added CostVariable CostVariable SavingsRecycle and reuse production materials$ 5,000$0.10 per lb. of recycled material$0.15 per lb. of recycled materialAdd solar panels as a source of power 700,000$ 1,000 per year$ 33,000 per yearReplace assembly room light fixtures with natural light 120,000$ 180 per month$ 220 per month The recycling activity would carry on indefinitely. The solar panels would have a useful life of 30 years. The replacement of assembly room light fixtures with natural light is assumed to have an 80-year effect.a.…arrow_forwardLime (formerly known as LimeBike), located in San Mateo, Califomia, is a startup founded in 2017. Its mission is to make shared bicycles accessible and affordable. The company has taken the basic idea of shared bicycles and eliminated the need to return the bike to a docking station, which may not be near the cyclist's destination. Lime charges $1 per 30 minutes of riding, or $0.50 per ride for students. (Click the icon to view additional information.) Read the requirements. Requirement 1. For each of the following items, identify whether the cost of the item would be expensed or capitalized at Lime: Item a. Customized bikes from Trek and Specialized b. Development costs of Lime's app for locating, paying, and returning bikes c. Salary of the salesperson who works to get cities to adopt Lime's program d. Replacement tires for bikes e. Routine bike maintenance including chain lubrication, brake pad replacement, and drivetrain cleaning f. Electricity and other utilities in the company's…arrow_forwardGreen Manufacturing is a traditional manufacturing company located in the midwestern United States. The company's operations manager is developing a strategy to become more CSR-oriented. In an effort to evaluate possible areas where CSR initiatives can be implemented, the manager has gathered the following data regarding three potential CSR activities: Initial Added Cost Variable Cost Variable Savings Recycle and reuse production materials $ 5,000 $0.10 per lb. of recycled material $0.15 per lb. of recycled material Add solar panels as a source of power 700,000 $ 1,000 per year $ 33,000 per year Replace assembly room light fixtures with natural light 120,000 $ 180 per month $ 220 per month The recycling activity would carry on indefinitely. The solar panels would have a useful life of 30 years. The replacement of assembly room light fixtures with natural light is assumed to have an 80-year effect. a. Identify which CSR activities Green Manufacturing should…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning