Do the following problem.

Fit Gym began January with merchandise inventory of $30$ bicycles that cost a total of $$2,400.$ During the month, Fit Gym purchased and sold merchandise on account as shown below:

$\backslash$table$[[,,$# of Units,Unit Cost,Sale Price$/$Unit$],[$Jan$.1,$Beginning Inventory,$30,80,],[18,$Purchase,$50,90,],[26,$Sale,$40,,120]]$

Requirements

Using the FIFO inventory costing method to determine the company's cost of goods sold, ending merchandise inventory, and gross profit.

Using the LIFO inventory costing method to determine the company's cost of goods sold, ending merchandise inventory, and gross profit.

Using the weighted$-$average inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit.

PLEASE SOLVE THE PROBLEM USING EXCEL SPREADSHEET!!!!!!