Question

In: Accounting

In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking...

In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking each product line had exceeded the profits earned. In December, a supplier asked her to sell a prepackaged spa kit. Feeling she could manage a single product line, Nicole agreed. Nicole’s Getaway Spa (NGS) would make monthly purchases from the supplier at a cost that included production costs and a transportation charge. NGS would keep track of its new inventory using a perpetual inventory system. On December 31, NGS purchased 20 units at a total cost of $5.30 per unit. Nicole purchased 20 more units at $7.30 in February. In March, Nicole purchased 20 units at $9.30 per unit. In May, 40 units were purchased at $9.10 per unit. In June, NGS sold 40 units at a selling price of $11.30 per unit and 50 units at $11.70 per unit.

4.value: 0.25 pointsRequired information Required: 1. State whether the transportation cost included in each purchase should be recorded as a cost of the inventory or immediately expensed. Cost of the Inventory Immediately Expensed

5.value:

2. Compute the Cost of Goods Available for Sale, Cost of Goods Sold, and Cost of Ending Inventory using the first-in, first-out (FIFO) method. (Round "Cost per Unit" to 2 decimal places.)

6.value:

4. Would a different inventory cost flow assumption allow Nicole’s Getaway Spa to better minimize its income tax?

The LIFO method would allow Nicole’s Getaway Spa to better minimize income tax. Product costs have been increasing, so LIFO will produce the highest Cost of Goods Sold, which results in the lowest Income before Income Tax Expense.

The FIFO method would allow Nicole’s Getaway Spa to better minimize income tax. Product costs have been increasing, so FIFO will produce the highest Cost of Goods Sold, which results in the lowest Income before Income Tax Expense.

Solutions

Expert Solution

Units Price Total Price
31-Dec 20 5.3 106 Opening
Feb 20 7.3 146 Purchased
Mar 20 9.3 186 Purchased
May 40 9.1 364 Purchased
June 40 11.3 452 Sold
June 50 11.7 585 Sold
1) As per IFRS all the expenses which are incurred in purchasing the products should be part of the inventory. Hence, the transportation cost included in each purchase should be recorded as cost of inventory
2) Cost of Goods Available for Sale 106+146+186+364 802
Closing Inventory using the FIFO Method
Under FIFO method the units which are available earlier are assumed to be sold first
We have sold 90 units in June which are sold from
Units Price Total Price
31-Dec 20 5.3 106 Opening 20 0
Feb 20 7.3 146 Purchased 20 0
Mar 20 9.3 186 Purchased 20 0
May 40 9.1 364 Purchased 30 10
We are left with 10 units of inventory which was purchased in May
The closing inventory is therefore 10*9.10
91
Cost of Goods Sold = Opening Stock + Purchase - Closing Inventory
106+(146+186+364)-91
711
If LIFO method is used to value the inventory than the closing inventory would be
In LIFO the purchases which are purchase last are assume to be sold first
Units Price Total Price
31-Dec 20 5.3 106 Opening 10 10
Feb 20 7.3 146 Purchased 20 0
Mar 20 9.3 186 Purchased 20 0
May 40 9.1 364 Purchased 40 0
Cost of Inventory would be 10*5.30 = $53
Therefore Cost of goods sold would be = 106+146+186+364-53
749
The Cost of Goods sold in FIFO method is $ 711 and in LIFO method is $ 749
In case of FIFO method there would be more of net income as compared to LIFO method due to reduce value of Cost of goods sold.
Hence,The LIFO method would allow Nicole’s Getaway Spa to better minimize income tax. Product costs have been increasing, so LIFO will produce the highest Cost of Goods Sold, which results in the lowest Income before Income Tax Expense.

Related Solutions

In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking...
In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking each product line had exceeded the profits earned. In December, a supplier asked her to sell a prepackaged spa kit. Feeling she could manage a single product line, Nicole agreed. Nicole’s Getaway Spa (NGS) would make monthly purchases from the supplier at a cost that included production costs and a transportation charge. NGS would keep track of its new inventory using a perpetual inventory...
In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking...
In October, Nicole eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking each product line had exceeded the profits earned. In December, a supplier asked her to sell a prepackaged spa kit. Feeling she could manage a single product line, Nicole agreed. Nicole’s Getaway Spa (NGS) would make monthly purchases from the supplier at a cost that included production costs and a transportation charge. NGS would keep track of its new inventory using a perpetual inventory...
In October 2017, Nicole of Nicole’s Getaway Spa (NGS) eliminated all existing inventory of cosmetic items....
In October 2017, Nicole of Nicole’s Getaway Spa (NGS) eliminated all existing inventory of cosmetic items. The trouble of ordering and tracking each product line had exceeded the profits earned. In December, a supplier asked her to sell a prepackaged spa kit. Feeling she could manage a single product line, Nicole agreed. NGS would make monthly purchases from the supplier at a cost that included production costs and a transportation charge. The spa would use a perpetual inventory system to...
7. The costs of carrying inventory include all of the following except: * a- Ordering costs....
7. The costs of carrying inventory include all of the following except: * a- Ordering costs. b- Cost of warehouse space. c- Insurance and handling costs. d- Interest on funds tied up in inventory. e- None of the above. 8. Once the break-even point is reached: * a- The contribution margin ratio begins to decrease. b- The variable expenses will remain constant in total. c- The total contribution margin changes from negative to positive. d- The net operating income will...
All inventory items are not counted or tagged. Extension errors are made on the client's inventory...
All inventory items are not counted or tagged. Extension errors are made on the client's inventory summaries. Purchase received near the balance sheet date may be included in the physical count but may not be booked. Obsolete and damaged goods are not noticed in the warehouse. Inventory stored in a public warehouse may not exist. Client personnel may incorrectly count the inventory. The lower of cost or market method may be incorrectly applied. Empty containers or hollow squares may be...
1- Inventory costs include all of these: purchase costs, holding or carrying costs, and ordering costs....
1- Inventory costs include all of these: purchase costs, holding or carrying costs, and ordering costs. T. True F. False 2- The Economic Order Quantity (EOQ) model tells us........ A. how much to order B. which are higher - holding or ordering costs C. how to use price discounts D. when to order 3- When tracking or counting inventory items, we should focus on which items most? A. A-items B. B-items C. C-items D. D-tems 4- The Economic Order Quantity...
1- Inventory costs include all of these: purchase costs, holding or carrying costs, and ordering costs....
1- Inventory costs include all of these: purchase costs, holding or carrying costs, and ordering costs. T. True F. False 2- The Economic Order Quantity (EOQ) model tells us........ A. how much to order B. which are higher - holding or ordering costs C. how to use price discounts D. when to order 3- When tracking or counting inventory items, we should focus on which items most? A. A-items B. B-items C. C-items D. D-tems 4- The Economic Order Quantity...
Takke Company orders 10 inventory part items on a purchase order. All 10 items are received...
Takke Company orders 10 inventory part items on a purchase order. All 10 items are received along with the bill. Takke Company opens a bill form and selects the vendor. What is the next step? Select one: A. Takke should add the items (including quantities) from the purchase order to the bill. B. Takke should close the bill form, open the purchase order, and select Create Bill. C. Takke should manually enter the items and quantities received in the item...
1. ABC analysis is based upon the principle thatA) all items in inventory must be...
1. ABC analysis is based upon the principle thatA) all items in inventory must be monitored very closely.B) more time should be spent on class "C" items because there are more of them.C) an item is critical if its usage is high.D) there are usually a few critical items, and many items which are less critical.E) as with grade distributions in many undergraduate courses, there should be more medium-level "B" items than either “A” or "C” items. 2. The graph below...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT