Search Data Section For the quarter ended Sales Sales returns and allowances Purchases Purchases returns and allowances Beginning inventory Gross profit percent historical) September 30, 2013 $325,000 9,00X1 225.000 11,000 48.000 Answer Section $48.000 214.000 $262,000 Beginning inventory Net purchases Cost of goods available for sale Net snles Estimated gross profit in dollars) Estimated cost of goods sold Estimated ending inventory 5316,000 126,400 189,600 $72.400 Quarterly Data, 2013 5180 STO 8140 5120- $100 $20 Srd Orch Examine the pattern of behavior for these two items and comment on any favorable or unfavorable trends noted. What is happening to the gross profit ratio? Parta. Sales $150,000 Sales returns and allowances 7,500 Purchases 125,000 Purchases returns and allowances 9,600 Freight-in 2,200 Beginning inventory (12/31/13) 22.000 Gross profit percentage (historical) 39% Preview the print and then print the worksheets Chart. Ude, create an XY chart for the GP2 worksheet that demonstrates the relationship between gross profit percentage (X-axis) and estimated ending inventory (Y-axis). the Cast ----- re GRECIA RIBE part B GP Gross Profil A 1 2 3 41 5 Data Section 6 7 For the quarter ended 8 Sales 9 Sales returns and allowances 10 Purchases 11 Purchases retums and allowances 12 Beginning inventory 13 Gross profit percent (storical) 14 15 Answer Section 16 17 Beginning inventory 18 Net purchases 19 Cost of goods available for sale 20 Net sales 21 Estimated gross profit in dolars) 22 Estimated cost of goods sold 23 Estimated ending invente 24 September 30, 2013 $325,000 9,000 225,000 11,000 48,000 40% FORMULA1 FORMULA2 FORMULAS FORMULA4 FORMULAS FORMULAG FORMULAT