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.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 7, Problem 1R

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.

Chapter 7, Problem 1R, Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500

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.

Expert Solution & Answer

To determine

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Devan Co. began the year with $500 in office supplies. During the year, Devan used $2,800 worth of additional supplies. At the end of the year, Devan had $1,200 worth of supplies remaining. How many supplies did Devan purchase during the year?

During its first month of business, Dig the Dogs, Inc. purchased $900 of hotdogs of which it paid $500 and owes the rest. During the month, it sold two thirds of its inventory for $1,500 on account. What is the amount of Cost of Goods Sold for the month ended?

During its first month of business, Dig the Dogs, Inc. purchased $700 of hotdogs of which it paid $300 and owes the rest. During the month, it sold 3/4 of its inventory for $1,000 on account. What is the amount of Cost of Goods Sold for the month ended?

Answer 2

Textbook Question

Chapter 7, Problem 1R

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.

Chapter 7, Problem 1R, Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500

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.

Expert Solution & Answer

To determine

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 7, Problem 1R

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.

Chapter 7, Problem 1R, Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500

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.

Expert Solution & Answer

To determine

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 7, Problem 1R

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.

Chapter 7, Problem 1R, Del Rio began Rio Enterprises on January 1 with 200 units of inventory. During the year, 500

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.

Expert Solution & Answer

To determine

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

Expert Solution & Answer

To determine

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Answer 8

Expert Solution & Answer

To determine

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Answer 9

Expert Solution & Answer

Answer 10

Expert Solution & Answer

Answer 11

To determine

Prepare a worksheet to show the differences between the specific identification method and the cost flow assumptions of FIFO, LIFO, and weighted average methods.

Answer 12

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.

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 1

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 2

Table (1)

The formulae for the calculation are as follows:

Excel Applications for Accounting Principles, Chapter 7, Problem 1R , additional homework tip 3

Answer 13

Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Prob. 3R Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - What changes would have taken place if Dels...Ch. 7 - Suppose Dels purchase prices had remained...Ch. 7 - Del Rio began Rio Enterprises on January 1 with...Ch. 7 - Reset the November 20 purchase to 150 units,...Ch. 7 - Click the Chart sheet tab. On the screen is a...

Concept explainers

Videos

Explanation of Solution

Want to see more full solutions like this?

Chapter 7 Solutions