View the tutorial, then complete the worksheet, replacing the question marks below with formulas.

Required:

$($a$)$ Based on the information given below, calculate Cost of Goods Sold and Ending Inventory using the FIFO method.

$($b$)$ Calculate Cost of Goods Sold and Ending Inventory using the LIFO method.

$($c$)$ Calculate Cost of Goods Sold and Ending Inventory using the Weighted Average Method.

$($d$)$ Calculate Gross Profit under all three methods.

Answers:

$($a$)$ FIFO

$($d$)$ Calculate gross profit

Sales revenue

Cost of goods sold

Gross profit

Please provide all answers in excel format $($cell refrences, equal signs, and all!$)$