Purchase Solution

Vita-Rite Vitamin Co. LIFO FIFO Weighted Average Cost method for costing inventory

Not what you're looking for?

Ask Custom Question

Excel spreadsheet including calculations.

Details: Vita-Rite Vitamin Company had a series of inventory transactions that need to be reported. Calculate the cost of ending inventory using the LIFO, FIFO, and average cost methods.

Use the Periodic method for all 3 calculations.
show the answer for each method

I have attached the Excel file. But if it doesn't open here is the info.

Vita-Rite Vitamin Co.
Inventory History

Date Units Purchased Price Purchased Units Sold Unit Balance

12/27/2004 2000 $14.50 5700
12/26/2004 2100 3700
12/24/2004 2500 $14.25 5800
12/18/2004 1500 $14.10 3300
12/16/2004 1800 $14.05 1800

They start adding from the oldest dates on up. First purchase is 1800 then 2nd is 1500 = 3300 and so on.

Attachments
Purchase this Solution

Solution Summary

Computations shown for the WACC method for costing inventory.

Purchase this Solution


Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.