Please show your work, I will give thumbs up$!$ Requirements:

Using the data below, calculate the requested values.

Use appropriate cell referencing and formulas. Do not type in any numbers $($i$.$e$.,$ no "hard coding" data$).$

Tips:

The tables below have been provided to guide your calculations. For the more complex perpetual inventory calculations, I have filled in the first row to

get you started. These tables follow a similar format as the Excel example problem I did for class.

Remember that in a table, only the first line of data and totals should use $ signs. Otherwise use comma format. If you get a yellow cell after entering

data, be sure to look for the "tip" provided by the tool in the row at the top of your spreadsheet. Usually this is a cell formatting issue.

All dollar values should be taken to TWO decimal places.

For #$8$ and $9,$ it is efficient to use the $=$SUMPRODUCT formula when calculating the current balance in inventory after each additional sale or purchase

Here's a quick video demonstrating how to use $=$SUMPRODUCT. httos:$//$wwwwyoutube com$/$watch$?y=9$ AEiLPH$5$nwA

Grading: $10$ possible points

This spreadsheet contains macros which will provide real time feedback on EACH cell that you enter in the gray shaded areas. There are $110$ cells which

get graded, and your score on this assignment will be calculated based upon the $\%$ of the $110$ cells that are completed correctly.

Zhang Company manufactures many products for use in the airline industry. Presented below is information concerning one of its products, the Orbit. Use this information

to calculate the nine items below.

This is the some as Goods Avoiloble for Sole $($GAFS$)$ in units

Calculate Goods Available For Sale $($GAFS$)$ in dollars.

Calculate FIFO Cost of Goods Sold under a Periodic Inventory System

Calculate LIFO Cost of Goods Sold under a Periodic Inventory System

Calculate Weighted Average Ending Inventory and COGS under a Periodic Inventory System.

Weighted Average Cost$/$Unit

Units in Ending Inventory

Weighted Average Ending Inventory

Weighted Average cOGs

What are the following under a Perpetual Inventory System?

Calculate FIFO Ending Inventory under a Periodic Inventory System

$($HINT: You can do this directly using GAFS and COGS$)$

FIFO Ending Inventory

Calculate LIFO Ending Inventory under a Periodic Inventory System

$($Hint: You can do this directly using GAFS and COGS$)$

UFO Ending Inventory $|$

Calculate UFO Cost of Goods Sold & Ending Inventory under a Perpetual Inventory System $($HINT: The texthook example $7\mathrm{.}8$ on page $7\mathrm{.}16$ demonstrates how to do this$)$

UFO Ending Inventory $-$ Perpetual System

UIO COGS $-$ Perpetual System

Calculate Moving Average Cost of Goods Sold & Ending Inventory under a Perpetual Inventory System $($HINT: The textbook example $7\mathrm{.}10$ on page $7-19$ demonstrates how to do this$)$

Moving Average Ending Inventory

Moving Average cOGS

Moving Averape coGs

moing huse coss