Question

In: Accounting

Inventory Pricing Methods When working with inventories, there are four main pricing methods: FIFO, LIFO, Averaged...

Inventory Pricing Methods

When working with inventories, there are four main pricing methods: FIFO, LIFO, Averaged Price, and Actual Price. All four of these will be used.

Complete each of the pricing methods. Find the cost of goods sold for each.

Use the following information for this assignment:

- The restaurant in question sells a salad that used cannellini beans. The salad is so popular that lots of jars of the beans must always be on hand, which the restaurant orders from an Italian importer by the case. Each case contains 12 jars at 16 ounces each. Each salad gets about 2 ounces of beans. - On March 8th, 2013, the restaurant ordered 4 cases and the cost for each was $40.

On March 15th, the restaurant ordered 8 cases at the same cost. On March 22nd, because of rising gas prices, the restaurant had to pay $50 for each of the 12 cases it ordered. That same price applied for the final order of the month on the 29th, when the restaurant ordered another 12 cases. - At the beginning of the month, 2 cases were on-hand, and at the end, 3.5 were available.

Considering the results of each pricing method you just completed, which would you choose to use if you were the manager of a restaurant with these numbers? Why?

Solutions

Expert Solution

CALCULATION FOR THE CASES SOLD

Opening stock =2

Purchased = 24

closing stock = 3.5

sold cases = (2+24-3.5 ) =  22.5

COST OF GOODS SOLD UNDER FIFO

CASES SOLD PRICE TOTAL
2 40 80
4 50 200
8 50 400
8.5 50 425
22.5 1105

COST OF GOODS SOLD UNDER LIFO

CASES SOLD PRICE TOTAL
12 50 600
8 50 400
2.5 50 125
22.5 1125

COST OF GOODS SOLD UNDER AVERAGE METHOD

Calculation of average price

average price = (40+50+50+50)/4 = 47.5

cost of goods sold under simple average method = 47.5*22.5 = 1068.75

COST OF GOODS SOLD UNDER ACTUAL METHOD

The practice of following of FIFO method can be said a actual method for the valuation of the cost of goods sold.

Thus cost of goods sold under actual method will remain same as calculated in FIFO basis. i.e., 1105

The best method for the computation of cost of goods sold is FIFO, because it reflects true and fair view in the financial statments.


Related Solutions

What are the FIFO, LIFO and Weighted Average inventory valuation methods? What is the importance of...
What are the FIFO, LIFO and Weighted Average inventory valuation methods? What is the importance of each and how does it impact the ending inventory value?
Explain the difference between the FIFO and LIFO inventory costing methods. In a period of rising...
Explain the difference between the FIFO and LIFO inventory costing methods. In a period of rising prices, which method would result in a higher net income and why? Why might a company choose the method that would result in a lower net profit? Participate in follow-up discussion by discussing which inventory method you would recommend and why.
There are several methods available to calculate the value of a company’s inventory (FIFO, LIFO, Average...
There are several methods available to calculate the value of a company’s inventory (FIFO, LIFO, Average Cost, Specific Identification, Lower of Cost or Market). Pick one method and provide a company that uses that method and a valid reason why you think the company has chosen that method.
Inventory Discussion Compare and contrast the three different inventory costing methods: LIFO, FIFO and weighted average...
Inventory Discussion Compare and contrast the three different inventory costing methods: LIFO, FIFO and weighted average cost. Additionally, give an example of a reason why one company might use one of these methods.
Inventory Discussion Compare and contrast the three different inventory costing methods: LIFO, FIFO and weighted average...
Inventory Discussion Compare and contrast the three different inventory costing methods: LIFO, FIFO and weighted average cost. Additionally, give an example of a reason why one company might use one of these methods.
Using Weighted Average, FIFO and LIFO inventory cost flow methods calculate inventory. Be sure to show...
Using Weighted Average, FIFO and LIFO inventory cost flow methods calculate inventory. Be sure to show all work!!! Beginning Inventory 600 units @$6 February purchase 400 units @$7 April Purchase 700 units @$8 June purchase 300 units @$9 sold 500 units Weighted Average FIFO LIFO
FIFO & LIFO periodic inventory system
Below is the information relating to Montel purchases of snowboards during september ,during the same month 120 snoeboards were sold .Montel uses periodic inventory system.   Date Transaction                              Unit unit cost 1-Sep Inventory 20 $100.00  12-Sep Purchase 45 $103.00  19-Sep Purchase 20 $104.00  26-Sep Purchase 50 $105.00  Compute the ending Inventory under FIFO and LIFO method and Cost of Goods sold. What you notice about in...
FIFO & LIFO periodic inventory system
Below is the information relating to Montel purchases of snowboards during september ,during the same month 120 snoeboards were sold .Montel uses periodic inventory system.   Date Transaction                              Unit unit cost 1-Sep Inventory 20 $100.00  12-Sep Purchase 45 $103.00  19-Sep Purchase 20 $104.00  26-Sep Purchase 50 $105.00  Compute the ending Inventory under FIFO and LIFO method and Cost of Goods sold. What you notice about in...
The valuation of inventory follows a consistent application of FIFO, LIFO, or weighted average methods. Manufacturing,...
The valuation of inventory follows a consistent application of FIFO, LIFO, or weighted average methods. Manufacturing, merchandising, and retail companies use different valuation methods based on the products they are selling. As the CPA conducting an audit: Select a current company that uses one of these methods. Explain why the method is appropriate. Explain the significant accounting policies and practices that will be used with the inventory valuation method.
how to calculate various inventory valuation methods [FIFO, LIFO, weighted average, etc.]
please explainhow to calculate various inventory valuation methods [FIFO, LIFO, weighted average, etc.]how to calculate cost of goods sold when using different inventory valuation methodshow to calculate ending inventory when using different inventory valuation methodshow to calculate ending inventory when gross profit rate is given
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT