Blythe Inc. uses a perpetual inventory system and had the following activity for a single inventory item:

Units Unit Cost March 1, inventory 500 3.25

Purchases:

4-Mar 250 3.00

9-Mar 175 4.50

27-Mar 100 5.75

Sales:

11-Mar 550

29-Mar 425 Required:

All calculations should be rounded to 2 decimal places. For example: $500/3 = 166.666667 Rounded to 166.67 The above should be manually entered in your calculations as 166.67, rather than keeping the formula built within your cells.

1) FIFO: Perpetual System

2) Weighted-average - Perpetual System

3) Weighted-average - Periodic System with an ending inventory of 50 units.