Question

In: Accounting

the following inforomation about one of the items carried in the food inventory of the yellow...

the following inforomation about one of the items carried in the food inventory of the yellow dog restaurant is taken from inventory records for the month of january. as of january 31, a physical inventory shows 10 on the shelf.

1/1 opening inventory 9 units            $1.07

1/5 purchased           15 units          $ 1.20

1/12 purchased        15 units           $1.25

1/19 purchased       10 units           $1.35

1/26 purchased         6 units            $1.40

1) what is closing inventory unit?

2) determine value ($) of closing inventory for each method.

a) FIFO

b) latest purchase price method

c) weighted average price method.

d) last in, first out method.

3) calculate cost of units issued for each method.

a) FIFO

b) latest purchase price method

c) weighted average price method

d) last in, first out method

Solutions

Expert Solution

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
1. Closing inventory units 10
2. Value of ending inventory:
Units Rate Total Value
FIFO 4 $       1.35 $           5.40
6 $       1.40 $           8.40
$         13.80
Latest Pur Price 10 $       1.40 $         14.00
Weighted Average
9 $       1.07 $           9.63
15 $       1.20 $         18.00
15 $       1.25 $         18.75
10 $       1.35 $         13.50
6 $       1.40 $           8.40
              55 $         68.28
Average Rate $       1.24
Value of Ending Inventory 10 $       1.24 $         12.41
LIFO 9 $       1.07 $           9.63
1 $       1.20 $           1.20
$         10.83
3. Cost of Units Issued
Units Rate Total Value
FIFO 9 $       1.07 $           9.63
15 $       1.20 $         18.00
15 $       1.25 $         18.75
6 $       1.35 $           8.10
$         54.48
Latest Pur Price 10 $       1.40 $         14.00
Weighted Average
9 $       1.07 $           9.63
15 $       1.20 $         18.00
15 $       1.25 $         18.75
10 $       1.35 $         13.50
6 $       1.40 $           8.40
              55 $         68.28
Average Rate $       1.24
Value of Ending Inventory 45 $       1.24 $         55.87
LIFO 14 $       1.20 $         16.80
15 $       1.25 $         18.75
10 $       1.35 $         13.50
6 $       1.40 $           8.40
$         57.45

Related Solutions

Need to fill in yellow gaps in the table Inventory Items Historical Cost Current Sales Price...
Need to fill in yellow gaps in the table Inventory Items Historical Cost Current Sales Price Disposal Cost Current Replacement Cost Normal Mark-up (Profit Margin) TGIT $20.00 $25.00 $7.15 $22.00 $8.00 TT9G5 $25.00 $30.00 $6.90 $29.00 $12.00 Inventory Items Floor Current Replacement Cost Ceiling Choose the appropriate comparison price TGIT $9.85 $22.00 $17.85 i.e., the designated market value TT9G5 $11.10 $29.00 $23.10 Inventory Items Historical Cost Designated Market Value Adjustment compare designated market value to TGIT $20.00 historical cost, and...
The following pertains to the cost of a product carried in the inventory of the R...
The following pertains to the cost of a product carried in the inventory of the R Store: Inventory on hand, January 1                                          0 units Purchases, January 8                                                 2,200 units @ $162.00 per unit =     $356,400 Purchases, January 19                                                   600 units @ $166.00 per unit =     $ 99,600 Purchases, January 23                                                   200 units @ $168.00 per unit =     $ 33,600 Purchases, January 26                                                1,000 units @ $170.00 per...
Which of the following are independent demand inventory items? Dependent demand inventory items? 1. Bicycles in...
Which of the following are independent demand inventory items? Dependent demand inventory items? 1. Bicycles in a toy store 2. Bicycle wheels in a bicycle factory 3. Blood at a blood bank 4. Hamburgers at a fast-food restaurant 5. Hamburger buns at a plant that produces frozen dinners Explain each with the reason and principle behind it.
Sam's Corner Store has the following purchase and sales information for one of their inventory items:...
Sam's Corner Store has the following purchase and sales information for one of their inventory items: Date Units $/Unit. Total Feb   1 Opening inventory 10 $8 $80 Feb   9 Purchase 25 $9 $225 Feb 15 Sale 15 $15 $225 Feb 17 Purchase 20 $11 $220 Feb 25 Sale 10 $16 $160 Required: For (a) and (b) assume the company uses the periodic inventory system. (a) Calculate the gross profit if the company uses first-in, first-out (FIFO) (b) Calculate the value...
Sam's Corner Store has the following purchase and sales information for one of their inventory items:...
Sam's Corner Store has the following purchase and sales information for one of their inventory items: Date Units $/Unit Total Feb 1 Opening inventory 10 $8 $80 Feb 9 Purchase 25 $9 $225 Feb 15 Sale 15 $15 $225 Feb 17 Purchase 20 $11 $220 Feb 25 Sale 10 $16 $160 Required: For (a) and (b) assume the company uses the periodic inventory system. (a) Calculate the gross profit if the company uses first-in, first-out (FIFO) (b) Calculate the value...
Tyler Company has the following information related to purchases and sales of one of its inventory items.
Inventory Costing MethodsTyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory400 units @ $16Sept. 10Purchase600 units @ $18Sept. 20Sales690 units @ $31Sept. 25Purchase800 units at $19Assume the company uses a perpetual inventory system.Required:Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.FIFOLIFOAvg CostCost of goods sold$fill in the blank 1$fill in the blank 2$fill in the blank 3Ending...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the...
Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the month of september: Sep. 1 Inventory 24 units at $15          5 sold 17 units         17 Purchased 10 units at $20          30 sold 8 units If Addison uses LIFO, the cost of the ending inventory on September 30 is a. $160 b.$125 c. $180 d. $145 Please help! I don't understand. Due at 11:59 p.m. Thanks!
Write down all the food items you consume in one complete day. Assemble information from food...
Write down all the food items you consume in one complete day. Assemble information from food labels, menus, and dietary tables to calculate the number of grams of proteins, carbohydrates, and fats consumed. Calculate the number of Calories in each food type using 4 Cal/g for proteins and carbohydrates and 9 Cal/g for fats. Then obtain information about recommended dietary requirements for persons of your sex, age, weight, height, and level of activity from health or biology teachers or the...
We are managing the inventory and one of the items is very important for us, so...
We are managing the inventory and one of the items is very important for us, so we have to calculate the best quantity to order. Consider following data related to this inventory item: -      D = quantity over 1 year = 350,000 units -      U = unit cost = 3 Euro -      WACC = 10% -      S = Order cost = 150 Euro -      Orders have to contain multiples of 500 units 1.    Draw the different variable costs in a...
1. EMO Company had the following inventory items at 12/31/xx Inventory items purchased from another company...
1. EMO Company had the following inventory items at 12/31/xx Inventory items purchased from another company that cost $3,300 and were in transit on December 31 with shipping terms of FOB Shipping Point. Inventory items purchased from another company that cost $2,800 and were in transit on December 31 with shipping terms of FOB Destination. Inventory items sold to another company that had cost $3,500 and were in transit on December 31 with shipping terms FOB Shipping Point. Inventory items...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT