Question

In: Accounting

Share, Inc. The following data is available for one of the products sold by Share, Inc.,...

Share, Inc.
The following data is available for one of the products sold by Share, Inc., which uses a
perpetual inventory system.

May 1 On hand, 10 units at $2 each
8 Sold 6 units at $10 each
14 Purchased 30 units at $3 each
23 Sold 24 units at $10 each

Required:
a. If the moving average method is used, how much is cost of goods sold for May?
b. If the moving average method is used, how much is ending inventory on May 30?
c. If the FIFO method is used, how much is ending inventory on May 30?
d. If the LIFO method is used, how much is cost of goods sold for May?
e. How the valuations of inventory differ in average, LIFO and FIFO methods of inventory
valuation?

Solutions

Expert Solution

Ans:

Date

Units

Rate/unit

Total cost

1-May On hand

10

2$

20$

14-May purchases

30

3$

90$

Average cost per unit=Total cost/Total Units

40

2.75$

110$

a)Cost of goods sold

May 8th 6units+May 23rd 24units

30

2.75$

82.5$

b)Ending inventory May 30th

10

2.75$

27.5$

c. If the FIFO method is used,the ending inventory on May 30th is

10 units*3$=30$

Note:

In FIFO (first in first out) method sales are made from early purchases so Ending inventory is out of Recent purchases made on the date of may 14th 10 units@3$=30$

d. If the LIFO method is used, the cost of goods sold for May

30 units*3$=90$

Note:

Total sales units=30 units(6+24)

In LIFO (Last in first out) method sales are made from Recent purchases so sales are made from Recent purchases made on the date of may 14th 30 units@3$=90$

e)

The Difference between FIFO method, LIFO method and Weighted Average Cost method are three ways of valuing inventory.

  • FIFO method assumes that the first inventories bought are the first ones to be sold, and that inventories bought later are sold later.
  • LIFO method assumes that the last inventories bought are the first ones to be sold, and that inventories bought first are sold last.
  • Average cost method is ending inventory is valued at total cost/total number of units

note:

under perpetual inventory system stock value made at respective period end


Related Solutions

The following data are available for one of the products (i.e., baseballs) sold by Cano Company,...
The following data are available for one of the products (i.e., baseballs) sold by Cano Company, which uses a perpetual inventory system. November 1 On hand, 10 units at $2 each 8 Sold, 6 units for $10 each 14 15 Purchased, 30 units at $3 each Purchased, 10 units at $4 each 25 Sold, 24 units for $10 each If the company uses the FIFO, LIFO, Weighted Average Cost method, determine the following amounts (in dollars $): i) Ending Inventory...
The following data are available for one of the products sold by Dahlia Company, which uses...
The following data are available for one of the products sold by Dahlia Company, which uses a perpetual inventory system: Mar. 1 Beginning inventory, 500 units at $4.00 each 7 Purchased 2,000 units at $5.00 each 12 Sold 2,300 units 17 Purchased 1,800 units at $6.00 each 27 Sold 1,900 units Calculate cost of goods sold for March and the dollar amount of ending inventory on March 31 assuming FIFO is used. Calculate cost of goods sold for March and...
The following data are available for one of the products sold by Dahlia Company, which uses...
The following data are available for one of the products sold by Dahlia Company, which uses a perpetual inventory system: Mar. 1 Beginning inventory, 500 units at $4.00 each 7 Purchased 2,000 units at $5.00 each 12 Sold 2,300 units 17 Purchased 1,800 units at $6.00 each 27 Sold 1,900 units 1. Calculate cost of goods sold for March and the dollar amount of ending inventory on March 31 assuming FIFO is used. 2. Calculate cost of goods sold for...
The following data are available for the Midwest Division of Dimension Products, Inc. and the single...
The following data are available for the Midwest Division of Dimension Products, Inc. and the single product it makes. (Note that this is the same data as that provided for the question above.) Unit selling price $40 Variable cost per unit       $24 Annual fixed costs           $560,000 Average operating assets   $3,000,000 How many units must the Midwest Division sell each year to have an ROI of 16%? A)         52,000.             B)         65,000.               C)         240,000.             D)         1,300,000 2. Which of the following variances is caused by a difference between the...
The following data for Gardot Products Inc. are available: For the Year Ended December 31 Actual...
The following data for Gardot Products Inc. are available: For the Year Ended December 31 Actual Planned Difference—Increase or (Decrease) Sales $1,684,800 $1,652,400 $32,400 Less: Variable cost of goods sold $889,200 $874,800 $14,400 Variable selling and administrative expenses 171,600 178,200 -6,600 Total variable costs $1,060,800 $1,053,000 $7,800 Contribution margin $624,000 $599,400 $24,600 Number of units sold 15,600 16,200 Per unit: Sales price $108 $102 Variable cost of goods sold 57 54 Variable selling and administrative expenses 11 11 Prepare an...
Top Snap Products made the following data available:                                  &nbs
Top Snap Products made the following data available:                                                                  Whole Units         % Conversion Added this month Beginning WIP Inventory                 900                            70% Units Started and Completed        1,700                                    100% Ending WIP Inventory                        600                                      40% What is the Equivalent Units of Production for Conversion? Group of answer choices $2,500 $2,350 $3,210 $2,570
): Mandas Inc. has provided the following data concerning one of the products in its standard...
): Mandas Inc. has provided the following data concerning one of the products in its standard cost system.   Variable manufacturing overhead is applied to products on the basis of direct labor-hours.      Inputs                                            Standard Quantity of Output         Standard Price or Rate       or Hours per Unit Direct materials                                                7.80        liters                                     $ 7.40    per liter Direct labor                                                        0.40        hours                                    $25.70   per hour Variable manufacturing overhead            0.40        hours                                    $ 6.30    per hour The...
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped...
Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Month Number of Units Shipped Total Shipping Cost January 40 $2,950 February 75 3,650 March 25 2,250 April 35 1,850 May 30 2,300 June 55 3,250 July 50 3,000 Required: 1. Prepare a scattergraph of Odessa’s shipping cost and draw the line you believe best fits the data. 3. Using the high-low method, calculate Odessa’s total fixed shipping costs and...
Question 5 Fortes Inc. has provided the following data concerning one of the products in its...
Question 5 Fortes Inc. has provided the following data concerning one of the products in its standard cost system. Materials price variances is calculated on material purchased and materials quantity is based on Material used in production. Variable manufacturing overhead is applied to products on the basis of direct labor-hours. Inputs Standard Quantity or Hours per Unit of Output Standard Price or Rate Direct materials 10.0 ounces $ 8.10 per ounce Direct labor 0.5 hours $ 24.70 per hour Variable...
Kropf Inc. has provided the following data concerning one of the products in its standard cost...
Kropf Inc. has provided the following data concerning one of the products in its standard cost system. Variable manufacturing overhead is applied to products on the basis of direct labor-hours. Inputs Standard Quantity or Hours per Unit of Output Standard Price or Rate Direct materials 8.90 liters $ 8.50 per liter Direct labor 0.50 hours $ 29.70 per hour Variable manufacturing overhead 0.50 hours $ 7.40 per hour The company has reported the following actual results for the product for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT