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. 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.

Solutions

Expert Solution

Solution:

Computation of ending inventory COGS under FIFO
Date Cost of goods available for sale Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount
Dec 20 $5.30 $106.00 0 $0.00 $0.00 20 $5.30 $106.00
Feb 20 $7.30 $146.00 0 $0.00 $0.00 20 $5.30 $106.00
20 $7.30 $146.00
Mar 20 $9.30 $186.00 0 $0.00 $0.00 20 $5.30 $106.00
20 $7.30 $146.00
20 $9.30 $186.00
May 40 $9.10 $364.00 0 $0.00 $0.00 20 $5.30 $106.00
20 $7.30 $146.00
20 $9.30 $186.00
40 $9.10 $364.00
June 0 $0.00 $0.00 20 $5.30 $106.00 10 $9.10 $91.00
20 $7.30 $146.00
20 $9.30 $186.00
30 $9.10 $273.00
Total 100 $802.00 90 $711.00 10 $91.00

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