Formula: Multiply; Cell Reierencing

Using Excel to Determine Ending Inventory

PROBLEM

in its first month of operations, McLanie Company made

three purchases of merchandise in the following sequence:

McLanie uses a periodic inventory system. It also provided

the following information:

Units on hand

$200$

Compute the cost of the ending inventory under the

a$.$ FIFO method

FIFO

b$.$ LIFO method

I NEED THE EXCEL FORMULAS!!!!! ALREADY KNOW THE ANSWER NEED THE EXCEL FORMULAS!!!!!