AutoSave OFF Home Insert Draw Page Layout Formulas Datal Review View Tell me X Calibri (Body) v 11 ' ' Wras Text [A v Poste B I U v A v Merge & Center J30 1 2 B : x fx D E F 6 H I 5 7 8 9 10 11 12 13 14 15 16 Big Bobby Weinstein Bob "Big Bobby" Weinstein Ltd. experienced complete melt-down of all inventory due to a very suspicious fire. The company's updated general ledger revealed the following balances at September 13th, the date of the casualty loss: Sales................. Sales Returns......... Sales discounts....... Inventory Jan 1st.......... Purchases......... Purchase returns.......... Purchase discounts....... 5,470,000 14,300 3,510 512,636 4,210,000 25,000 1,844 17 18 19 Historically the company's gross profit had been 25.00% 20 21 Calculate the: 22 23 24 25 b Cost of Goods Available for Sale Estimated Gross Profit as of September 13th 26 27 c Estimated Cost of Goods Sold as of September 13th 28 29 d Estimated cost of destroyed Inventory as of September 13th 30 31 32 33 34 35 36 37 38 39 40 41 42 43 14 Ready Problem 8 Problem 9 Problem 10 Problem 11 + 101 #4 Assignment Share Comments Number W $%9 00 Cell Conditional Format Formatting as Table Styles Insert Delete Format v Sort & Filter Find & Select Analyze Data K L M N P a R 5 T U 8 Answers b d 100%