Please provide parts $1-3,$ please put it in the same or similar format of the pictures and if you can explain how to put it in a formula in google sheets too please! if not than, totally okay! thanks for the help!

REQUIRED FOR POINTS: Complete the inventory costing schedules documenting details $($shelf$/$purchase location$)$ in

the calculation of BOTH ending inventory and cost of goods sold. Use math functionality for

calculations and reference$/$link to the master record for each detail. Making connections to

the Master Inventory Record allows the worksheet to be used for analyzing potential

changes in the results.

FIFO Cost of Goods Sold

resources

$($Slides$)$ &

Ebook Ch $7$

$**$ consider all possible locations$/$shelves in your analysis of COGS and End Inv

$**$If you are typing numbers, you are not meeting the requirements of the project. $*$design this schedule in a manner that is logical to you. Round to $2$ decimal places.

WEIGHTED AVERAGE Cost of Goods Sold

WEIGHTED AVERAGE Ending Inventory $3$ Answer the following questions using the above information: double click in the answer box and begin typing your answer; enter when done

Which method provides the lowest tax expense? Explain.

Which method provides the largest asset value on the Balance Sheet? Explain why that might be important.

What primary factor do we need to identify that affects our analysis and responses for the first two questions? Explain.

Which method would you choose? Explain.