Accty 1A HW Ch 6 523.xls [Compatibility Mode] Wrap Text General = = += += Marge & Center v Home Insert Page Layout Formuks Data Review View * Cut Arial 10 v Paste * Copy Format BI Uv Y43 fix C E A B 1 Homework Chap 8 2 3 Name 5 B Given Information G Extended Cost Share Nama Good Neutra v Conditional Format Formatting as Table Calculation Check Cl Explanatory Input Insert Delete Format Clear Sort & Filter Find 5 Select 1,620.00 2.400.00 1,575.00 2,000.00 2.025.00 9.820.00 total includes beginning inventory Kevenue $ 45,000.00 Weighted Avg Unit Units Cast 10 Beginning Inventory 1/1/200X 300 5.40 $ 11 Purchases 13 2/6/200X 400 6.00 13 5/15/200X 350 4.50 14 8/12/200X 500 4.00 15 10/4/200X 450 4.50 16 Avaliable for Sale 2,000 1/ 13 Units 19 Total year sales (Revenue) 1,500 21 FIFO LIFO 22 Fill in 9 Boxes Below 23 Value of Ending Inventory 24 25 Cost of Goods Sold 23 23 Grass Profit 30 32 31 87 38 32 22 43 44 43 61 52 53 54 57 52 Problem Sheet3 Sheet4 Ready L M N 0 P Remember Revenue-Cast of Goods Bold-Gross Profil 19 13 B T U x 4 1005