Requirements:

$1)$ Using the data below, calculate the requested values.

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

Tips:

$1)$ 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.

$2)$ 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.

$3)$ All dollar values should be taken to TWO decimal places.

$4)$ For #s $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. https:$//$www$.$youtube.com$/$watch$?$v$=9$AEjLPH$5$nyA

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.

Date Transaction Quantity Price$/$cost

$1/1/2024$ Beginning Inventory $1600$ $ $31\mathrm{.}00$

$3/6/2024$ Sale $100050\mathrm{.}00$

$6/26/2024$ Purchase $350033\mathrm{.}00$

$8/2/2024$ Purchase $200034\mathrm{.}00$

$10/31/2024$ Sale $400052\mathrm{.}00$

Total Units Available$*$

Total Units Sold

Total Units in Ending Inventory

$*$ This is the same as Goods Available for Sale $($GAFS$)$ in units

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

Date Units Unit Cost Extended Cost

$2)$ Calculate FIFO Cost of Goods Sold under a Periodic Inventory System

$3)$ Calculate FIFO Ending Inventory under a Periodic Inventory System

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

Units Sold Unit Cost

Extended Cost

FIFO Ending Inventory

FIFO COGS

$4)$ Calculate LIFO Cost of Goods Sold under a Periodic Inventory System

$5)$ Calculate LIFO Ending Inventory under a Periodic Inventory System

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

Units Sold Unit Cost

Extended Cost

LIFO Ending Inventory

LIFO COGS

Calculate Goods Available for Saie $($GaFs$)$ in dollans.

$\backslash$table$[[,,,],[,,,],[,,,],[,,,],[,,,]]$

Calculate FiFo Cost of Goods Sold under a Periodic inventory System

Calculate FaFO Endine inventory under a Periodic inventory System

$\backslash$table$[[$Units Fold,Unit Cont,frendend Cort$],[,,],[,$Firo coGs,$]]$

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

Aro thating inuentary

Calculate uro Cost of Coods Sold under a Periodic Inventory Syatem

Calculate uro Ending Inventory under a Periodic Inventory Syatem

$\backslash$table$[[,,$Ican$],[,,],[,$UPO coGs,$]]$

$($Hint: You can do this directly using CASS and COCS$)$

upo Ending inventory

noose$[$

novidintery

uro coos. Merpetial lipran

$\backslash$table$[[$Burs$,$buncruat,Solis,ifyatinartsy,$\backslash$table$[[$voing$],[$itrogr$],[$Unit tiant$]]],[$so of anita,untant,nis. of vily,unt an:$,$va of ata,unit $=0$ t$,$Anoum:$],[\frac{21}{2}=1,2,5x,,,$sted,Insed,,$\backslash$table$[[19,1350]]],[,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[,,,,,,,,],[$arapt bes,netory,,,,,,,$],[$tavapt ceo,,,,,,,,$]]$