Answered

Explore Westonci.ca, the top Q&A platform where your questions are answered by professionals and enthusiasts alike. Experience the ease of finding quick and accurate answers to your questions from professionals on our platform. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

Using FIFO for Multiproduct Inventory Transactions (Chapters 6 and 7) [LO 6-3, LO 6-4, LO 7-3] Skip to question [The following information applies to the questions displayed below.] FindMe Inc., (FI) has developed a coin-sized tracking tag that attaches to key rings, wallets, and other items and can be prompted to emit a signal using a smartphone app. FI sells these tags, as well as water-resistant cases for the tags, with terms FOB shipping point. Assume FI has no inventory at the beginning of the month, and it has outsourced the production of its tags and cases. FI uses FIFO and has entered into the following transactions:
Jan. 2: FI purchased and received 260 tags from Xioasi Manufacturing (XM) at a cost of $7 per tag, n/15.
Jan. 4: FI purchased and received 60 cases from Bachittar Products (BP) at a cost of $2 per case, n/20.
Jan. 6: FI paid cash for the tags purchased from XM on Jan. 2.
Jan. 8: FI mailed 160 tags via the U.S. Postal Service (USPS) to customers at a price of $30 per tag, on account.
Jan. 11: FI purchased and received 360 tags from XM at a cost of $10 per tag, n/15.
Jan. 14: FI purchased and received 160 cases from BP at a cost of $3 per case, n/20.
Jan. 16: FI paid cash for the cases purchased from BP on Jan. 4.
Jan. 19: FI mailed 120 cases via the USPS to customers at a price of $15 per case, on account.
Jan. 21: FI mailed 260 tags to customers at a price of $30 per tag.
1. Calculate the dollars of gross profit and the gross profit percentage from selling tags and cases.
2. Which product line yields more dollars of profit? - Which product line yields more profit per dollar of sales?
3. Calculate the dollars of gross profit and the gross profit percentage from selling tags and cases. (Round your "Gross Profit Percentage" answers to 2 decimal places.)

Sagot :

Answer:

1-a. Dollars of gross profit from selling tags = $9,180

1-b. Dollars of gross profit from selling cases = $1,500

1-c. Gross profit percentage from selling tags = 72.86%

1.d. Gross profit percentage from selling cases = 83.33%

2-a. Tag yields more dollars of profit.

2-b. Tag yields more profit per dollar of sales.

Explanation:

Note: The requirements for this question are two not three as erroneously stated. This is because, the first and the third question are the same. Therefore, the two relevant requirements of the question are:

1. Calculate the dollars of gross profit and the gross profit percentage from selling tags and cases.

2. Which product line yields more dollars of profit? - Which product line yields more profit per dollar of sales?

The explanation of the answers is now given as follows:

1. Calculate the dollars of gross profit and the gross profit percentage from selling tags and cases.

Sales revenue from tags = Sales value of 160 tags mailed to customers on Jan. 8 at a price of $30 per tag + Sales value of 260 tags mailed to customers on Jan. 21 at a price of $30 per tag = (160 * $30) + (260 * $30) = $12,600

Sales revenue from cases = Sales value of 120 cases mailed to customers on Jan. 19 at a price of $15 per case = 120 * $15 = $1,800

Total number of tags sold = 160 tags mailed to customers + 260 tags mailed to customers on Jan. 21 = 420

Total number of cases sold = 120 cases mailed to customers on Jan. 19 at a price of $15 per case = 120

Using FIFO, we have:

Cost of tags sold = Value of 260 tags purchased on Jan.2 from Xioasi Manufacturing (XM) at a cost of $7 per tag + Value of the remaining 160 (i.e. 420 – 260 = 160) tags sold based on the 360 tags purchased on Jan. 11 from XM at a cost of $10 per tag = (260 * $7) + (160 * $10) = $3,420

Cost of cases sold = Value of 60 cases purchased on Jan.4 from Bachittar Products (BP) at a cost of $2 per case + Value of the remaining 60 cases sold based on the 160 cases purchased on Jan. 14 from BP at a cost of $3 per case = (60 * $2) + (60 * $3) = $300

Therefore, we have:

1-a. Dollars of gross profit from selling tags = Sales revenue from tags - Cost of tags sold = $12,600 - $3,420 = $9,180

1-b. Dollars of gross profit from selling cases = Sales revenue from cases - Cost of cases sold = $1,800 - $300 = $1,500

1-c. Gross profit percentage from selling tags = (Dollars of gross profit from selling tags / Sales revenue from tags) * 100 = ($9,180 / $12,600) * 100 = 72.86%

1.d. Gross profit percentage from selling cases = (Dollars of gross profit from selling cases / Sales revenue from cases) * 100 = 83.33%

2. Which product line yields more dollars of profit? - Which product line yields more profit per dollar of sales?

2-a. Which product line yields more dollars of profit?

From part 1 above, we have:

Dollars of gross profit from selling tags = $9,180

Dollars of gross profit from selling cases = $1,500

Since the dollars of gross profit from selling tags of $9,180 is greater than the dollars of gross profit from selling cases of $1,500, this implies that Tag yields more dollars of profit.

2-b. Which product line yields more profit per dollar of sales?

From part 1 above, we have:

Total number of tags sold = 420

Total number of cases sold = 120

Therefore, we have:

Tag's profit per dollar of sales = Dollars of gross profit from selling tags / Total number of tags sold = $9,180 / 420 = $21.86

Case's profit per dollar of sales = Dollars of gross profit from selling cases / Total number of cases sold = $1,500 / 120 = $12.50

Since Tag's profit per dollar of sales of $21.86 is greater than Case's profit per dollar of sales of $12.50, this implies that Tag yields more profit per dollar of sales.

Thank you for your visit. We are dedicated to helping you find the information you need, whenever you need it. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. We're glad you chose Westonci.ca. Revisit us for updated answers from our knowledgeable team.