Concept explainers
Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of $320,000 and the 500 units purchased to replace them cost $256,000, so his cash account has increased by $64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her heʼd “make at least $50,000 after taxes. That will give us $25,000 after paying off the investors.”
Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales.
Del has heard that the choice of an inventory cost flow assumption can have a significant effect on net income and taxes. He asks you to show him the differences between the specific identification method and the cost flow assumptions of FIFO, LIFO, and weighted average methods. Review the worksheet FIFOLIFO that follows these requirements. Note that all of the problem data have been entered in the Data Section of the worksheet.
Prepare a worksheet to show the differences between the specific identification method and the cost flow assumptions of FIFO, LIFO, and weighted average methods.
Explanation of Solution
Prepare a worksheet to show the differences between the specific identification method and the cost flow assumptions of FIFO, LIFO, and weighted average methods.
Table (1)
The formulae for the calculation are as follows:
Want to see more full solutions like this?
Chapter 7 Solutions
Excel Applications for Accounting Principles
- Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Examine your completed worksheet and answer the following questions: a. Which inventory cost flow assumption produces the most net income? b. Which inventory cost flow assumption produces the least net income? c. What caused the difference between your answers to a and b? d. Which inventory cost flow assumption produces the highest ending cash balance? e. Which inventory cost flow assumption produces the lowest ending cash balance? f. Does the assumption that produces the highest net income also produce the highest cash balance? Explain. g. As you recall, Del originally used the specific identification method in his initial calculations when he projected 51,600 net income. According to Dels reckoning, that should have left him cash of 25,800 (50% of 51,600) after paying his investors. Why would he only have 3,800 left? Explain. h. Which inventory cost flow assumption would you suggest Del use? Explain.arrow_forwardDel Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500 additional units were purchased, 500 units were sold, and Del ended the year with 200 units. Del is very satisfied with his first year of business although the cost of replacing his inventory rose continually throughout the year. The 500 units sold for a total of 320,000 and the 500 units purchased to replace them cost 256,000, so his cash account has increased by 64,000. Del is concerned however because he has three obligations yet to meet: taxes, dividends, and his wife. Federal and state income taxes will take 40% of his income. His investors are to receive dividends equal to half of any income after taxes are paid. And finally, Del promised his wife a big trip to Hawaii if she let him quit his job as a professor and start his own business. He promised her hed make at least 50,000 after taxes. That will give us 25,000 after paying off the investors. Del kept fairly good records during the year and knows the specific cost of each inventory unit sold. He has prepared the following table to summarize his purchases and sales. Reset the purchase prices to their original values (cells C11 through C14). Suppose Del had purchased 250 units on November 20 rather than 150. Enter 250 in cell C14 and alter column G in the Data Section. Explain what happens to net income under each inventory cost flow assumption and why. Also, what management implications might this have for Del?arrow_forwardMalone Industries has been in business for five years and has been very successful. In the past year, it expanded operations by buying Hot Metal Manufacturing for a price greater than the value of the net assets purchased. In the past year, the customer base has expanded much more than expected, and the companys owners want to increase the goodwill account. Your CPA firm has been hired to help Malone prepare year-end financial statements, and your boss has asked you to talk to Malones managers about goodwill and whether an adjustment can be made to the goodwill account. How do you respond to the owners and managers?arrow_forward
- Harvey quit his job where he earned $45,000 a year. He figures his entrepreneurial talent or foregone entrepreneurial income to be $5,000 a year. To start the business, he cashed in $100,000 in bonds that earned 10 percent interest annually to buy a software company, Extreme Gaming. In the first year, the firm sold 11,000 units of software at $75 for each unit. Of the $75 per unit, $55 goes for the costs of production, packaging, marketing, employee wages and benefits, and rent on a building. The total revenues for the firm in the first year were: Multiple Choice O $605,000 $825.000 $50,000 $100,000 Oarrow_forwardA small business owner made $ 30,000 the first year he owned his store and made an additional 8% each year thereafter. He finds out how much he earned during his fourth year of business. (Round to the nearest penny, if necessary.)arrow_forward. Nadine runs a business that imports re-usable water bottles for sale in the UK. The supplier sells these to Nadine in batches of 500 units. Nadine has been trading for three and a half years. She has consistently achieved sales of 1,250 units per month (2019 to 2021). In the period January to June 2022 however this increased to 2,000 per month, and she has run out of stock every month as a result. She has estimated that each stock out has cost her £60. Nadine has had this problem before in 2019 (5 stock outs) and 2020 (2 stock outs) but in 2021 she had fixed the problem and achieved no stock out events. Each batch of 500 units, including shipping and taxes costs £2,800. The cost of placing and processing each order, regardless of quantity, is £80. Records show the following average stock holdings and associated costs: 2019 750 units £500 2020 1,000 units £650 2021 1,250 units £800 Required: Assuming that the…arrow_forward
- GRB Ltd has several product lines with a manager in charge of each product line. The managers are paid a bonus based on the net income generated by their product line. Rubica (the CEO of GRB Ltd) was going through the financial reports of the 2nd quarter of 2021 to analyse the performance of the product lines. For 'Sweets' one of the largest product lines of GRB Ltd, Rubica noted that while the sales declined from $800,000 in quarter 1 to $600,000 in quarter 2, the product line manager of Sweets received a bonus larger than the 1st quarter. The manager of Sweets division was eligible for a higher bonus due to an operating profit increase from $90,000 in the 1st quarter to $120,000 in the 2nd quarter. Rubica wondered how the product line manager was entitled to a higher bonus with a decline in sales. Rubica also wants to know how net income increased with a decline in sales. Rubica found the following data from the financial reports of 'Sweets': Particulars Quarter 2 Quarter 1 Units…arrow_forwardDiamond Computers, which is owned and operated by Dale Diamond, manufactures and sells different types of computers. The company has reported profits every year since its inception in 2002 and has applied for a bank loan near the end of 2021 to upgrade manufacturing facilities. These upgrades should significantly boost future productivity and profitability. In preparing the financial statements for the year, the chief accountant, Sandy Walters, mentions to Dale that approximately $80,000 of computer inventory has become obsolete and a write-down of inventory should be recorded in 2021. Dale understands that the write-down would result in a net loss being reported for company operations in 2021. This could jeopardize the company’s application for the bank loan, which would lead to employee layoffs. Dale is a very kind, older gentleman who cares little for his personal wealth but who is deeply devoted to his employees’ well-being. He truly believes the loan is necessary for the company’s…arrow_forwardAt the beginning of the year, a high school football coach decided to leave his job and give up his annual coaching salary of $65,000 and open his own sporting goods store. A partial income statement for follows: To get the sporting goods store opened, the former coach used $80,000 of his personal savings. The coach opened his store in a building that he owns. Prior to opening his store, the building was rented for $31,000 per year. The coach could have earned 5 percent return by investing in stocks of other new businesses with risk levels similar to the risk level associated with his new sporting goods store. 1)The former high school coach incurs $_____ of total explicit costs for using market-supplied resources. 2)The opportunity cost of the owner’s equity capital is $_____ annually. 3)Total implicit cost of owner-supplied resources is $ 4)Total economic cost is $_____. 5)Accounting profit is $_____ 6)By how much did coach’s wealth change by opening the sporting…arrow_forward
- Davy Johnson is CFO for a newly formed manufacturing company. Below is the anticipated monthly production for the first six months of operation. Davy is interested in learning which of the first six months will require cash outlays of more than $40,000 toward the purchase of materials. Each unit requires 5 pounds of material at $10 per pound. All material is purchased in the month prior to its expected use. Purchases are paid for 10% in the month of purchase, 40% in the month following the month of purchase, and 50% in the second month following the month of purchase. Compute the total amount paid for March.arrow_forwardJerry was working as a veternarian, and he earned an annual income of $135,000. He had savings of $86,000 in the bank, which was earning 3% interest per year. Then he decided to quit and start his own landscaping business. He used his $86,000 savings to purchase a truck and equipment. The values for his first year with his new business were: Revenue 265,000 Wages for employees 108,000 Insurance 2990 Depreciation 1920 Gasoline and vehicle 6125 maintenance Calculate Jerry's accounting profit for his first year. Answer:arrow_forwardEster has a small store. For the current month, she purchased merchandise costing 75000 for which she paid for 7500. She sold 60% of the merchandise for 68000, after spending for various expenses totaling 13000. She also paid 2000 for the interest on a money she borrowed for her store. a. How musch was her cost of sales?b. How much gross profit did she make?c. How much operating profit did she make?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning