please show in excel

Part 1: Compute the inventory at May 31 on each of the following bases. Assume that perpetual inventory records are kept in units only. Carry unit costs to the nearest cent. Assume costs are not computed for each withdrawal: If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, what amount would be shown as ending inventory in (1), (2), and (3) above? (Carry average unit costs to four decimal places.) Assume costs are computed for each withdrawal