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 10 units at a total cost of $7.20 per unit. Nicole purchased 25 more units at $8.80 in February. In March, Nicole purchased 10 units at $10.80 per unit. In May, 40 units were purchased at $10.60 per unit. In June, NGS sold 40 units at a selling price of $12.80 per unit and 30 units at $10.80 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. (Round "Cost per Unit" to 2 decimal places.

Solutions

Expert Solution

  • Working

FIFO

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

31-Dec

10

$                   7.20

$                              72.00

10

$                 7.20

$                       72.00

0

$                   7.20

$                         -  

Feb

25

$                   8.80

$                            220.00

25

$                 8.80

$                     220.00

0

$                   8.80

$                         -  

Mar

10

$                10.80

$                            108.00

10

$               10.80

$                     108.00

0

$                 10.80

$                         -  

May

40

$                10.60

$                            424.00

25

$               10.60

$                     265.00

15

$                 10.60

$                159.00

TOTAL

85

$                            824.00

70

$                     665.00

15

$                159.00

  • Cost of Goods available for sale = $ 824
  • Cost of Goods Sold = $ 665
  • Cost of ending inventory = $ 159

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