ACCY $131$ Tablean Assignment as required.

For each submission ensure ther your namclicilabs are par of the file or verible nomes and are visitle. While there mas be 'cleaner' wass to peseent your gophics, $1$ prefer that you wee whit screenshots your whole seroen, including the dete ind time, is visible. work. Use that as a guide to ingot the formula nivigy He Tikiosu commands

For the calculated Belds that require calculabioss, wee the "ROUND" function and calculase to $2$ decimal places. ROUND $(2)$

Don't feel that you have to was the specific guidesoe I heve povided fer how wo crrate the graphics. If you have a better wny$,$ of one that you undernand better, you can use that as long as you arrive at the right answers

For several of the requiremens, I heve proviled yoa wibl the solutios, or what the graptic should look like so that you can check if you ure doing the rigle thing.

Inventery verification

Import the Excel file provided and rename it Year Name, fercatery and ave it as a fubtor file.

Before yoa begin your inventory analy sis, move the varlible "PoalCode fiom measures to dimensions as it represents the namse of a prodast and mot a quandifille nexame.

Exercise $1-$General

Create a labeled griphic that shows the valut of imensory beld at each depge $($Ipt$)$ the inventary

Exercise $2-$ Aceuracy of inventory compilation

You wish to test the accuracy of the inventory compilation. You note that inventory cost is equal to QTY x Av COST, $s0$ you will recalculate the lotal cost of the inventory wo compare it with what your client has stated, to check for accuracy of inventory compilation.

Create a table that shows any differenees between the client's total cost and your own calculated total cost per product. Show only the products where a difference is found. $(3$pts$)$

Wher: Create a calculated field for recalculated imentary cost and name it Your Name$\_$RecalcTotal Cost$).$

Create anowher calculated field where you find ilhe difference benween TatulCost and RecaleTotalCost and name it YourName$\_$TotalCosiDiff.

Create a graphic using TotalCens, ReCalcTotalCens, TotalCest Diff and ProdCode

Change the fresientation of the graplte so thar it tr a takle $($Click 'show me$\text{'}$ and select the first opvion which is a fable$).$