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, Student Value Edition (5th Edition)
- (J) Citations are required for this exercise. Comments to other students must be detailed and substantive. Alpaca Industries, located in the beauty pacific Northwest, manufactures a household electronic device. The company is fairly small with revenues and total assets of approximately $370,000 and $300,000, respectively. The company has never maintained a budget since its inception, and as a new hire, you are eager to create a budget for the company. Write a 1-page memo, explaining to the owner the advantages of budgeting. In your memo, provide exact page number citations. Please note that any responses without citations will not be graded. Only the original responses are graded; subsequent edits are not graded.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_forwardEthical Behavior Consider the following scenario between Dave, a printer, and Steve, an assistant in the local universitys athletic department. Steve: Dave, our department needs to have 10,000 posters printed for the basketball team for next year. Heres the mock-up, and well need them in a month. How much will you charge? Dave: Well, given the costs I have for ink and paper, 1 can come in at around 5,000. Steve: Great, heres what I want you to do. Print me up an invoice for 7,500. Huts our budget. Then, when they pay you, you give me a check for 2,500. Ill make sure that you get the job. Required: CONCEPTUAL CONNECTION Is Steves proposal ethical? What should Dave do?arrow_forward
- LearnCo PARAGRAPH IS FOR ASSISTANCE TO HELP WITH THE QUESTIONS IN THE IMAGES ONLY WANT THE IMAGES ANWSERED LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets. Sales Budget The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised for various factors such as planned advertising…arrow_forward(Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?arrow_forwardP10-53B Determine transfer price at a manufacturer under various scenarios (Learning Objective 4) Assume the Small Components Division of Lang Manufacturing produces a video card used in the assembly of a variety of electronic products. The division's manufacturing costs, and variable selling expenses related to the video card are as follows: Cost per unit Direct materials $ 14.00 Direct labor $ 4.00 Variable manufacturing overhead $ 8.00 Fixed manufacturing overhead (at current production level) $ 9.00 Variable selling expenses $ 10.00 The Computer Division of Lang Manufacturing can use the video card produced by the Small Components Division and is interested in purchasing the video card in-house rather than buying it from an outside supplier. The Small Components Division has sufficient excess capacity with which to make the extra video cards. Because of competition, the market price for this video card is $30 regardless of whether the…arrow_forward
- Budgeting is important not only for businesses. Also in our personal lives we have scarce resources, especially money and time, but also other resources like for example cell phone data, use of the family computer or family TV set, access to childcare etc. Our college prepares annual budgets as well. please look at line items 18 and 21. What do these dollar amounts tell you? What are your conclusions for the college? Share your observations with the class and discuss possible reasons for your observations.arrow_forwardYou wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process: Costs/Benefits College Course Community Course Cost $4,300 $1,190 Distance to course 0.20 miles (walking distance) 18 miles (driving distance) Timing of course Weekday Weekend Number of meetings 16 8 Qualitative considerations Convenience, quality of instruction Flexibility, brief duration Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose? Multiple Choice College course Community course Both alternatives Neither alternativearrow_forwardQuestion Content Area I AM NEEDING THE PICTURES ANWSERED THE PASSAGE IS JUST FOR ASSISTANCE TO ANSWER THE QUESTIONS Question Content Area LearnCo LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets. Sales Budget The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised…arrow_forward
- Please step by step process. Professor von Nordenflycht presents Dean Kayande with two new proposals for offering a graduate certificate program. Both programs will cost $60,000, for classroom and instructor time. Both programs are projected to have two possible revenue outcomes. Program 1, which focuses on accounting, is projected to have a 50% chance of generating $150,000 in revenue and a 50% chance of generating $100,000 in revenue. Project 2, which focuses on cryptocurrencies, is predicted to have a 62.5% chance of generating $200,000 in revenue or, otherwise, generating no revenue! a. What is the expected value of each program? b. What is the variance of each program?arrow_forwardA firm has recently added a new product to their offerings. Manufacturing reports that production is going smoothly and factory workers are becoming familiar with the manufacture of this product. All expectations are that the current rate of learning will continue and the manufacture of future units will be more efficient (i.e., take less time). The following shown table shows the results for the first two units produced. The firm has an order for two additional units. Assuming the pattern of learning curve continues (same rate): Solve, a. At what rate is learning occurring? b. How long will it take to produce the fourth unit? c. If the labor rate is $15 per hour, what is the cumulative average labor cost per unit for the first four units produced?arrow_forwardTriad Children's Center(TCC), a non-profit organization, uses relevant cost analysis to determine whether new services are desirable. TCC is looking at adding a new education program for grade school children who are having difficulty with the reading and math skills. The following relevant cost are expected if the program is accepted:arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning