X Inventory Problem Template - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View AutoSum - * Cut Calibri - 11 - A A = = = Wrap Text General Normal Bad Good Fill - aCopy . Check Cell Insert Delete Format Sort & Find & 2 Clear * Paste 3 I U . . & . A . B 1Merge & Center . $ - % 168 98 Conditional Format as Neutral Calculation Filter . Select Format Painter Formatting ~ Table Cells Editing Clipboard Font Alignment Number Styles B17 fx G K L M N P Q R S U A B 1 The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a three-month period ending June 30 are as follows: 2 Date Transaction Number of Units Per Unit Total 3 Apr. 3 Inventory 40 $670 $26,800 1. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. 4 8 Purchase 120 690 82,800 2. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system. 11 Sale 60 67,200 30 Sale 50 56,000 Check Figure: Inventory, June 30, $33,700 7 8-May Purchase 100 700 70,000 . Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system. Ro 8 10 Sale 80 1,120 89,600 1. Compare the gross profit and June 30 inventories using the following column headings: 9 19 Sale 20 1,120 33,600 10 28 Purchase 120 707 84,840 FIFO LIFO Weighted Average 11 5-Jun Sale 60 1,260 75,600 Sales 12 16 Sale 40 1,260 Cost of merchandise sold 13 21 Purchase 180 712 128,160 Gross profit 14 28 Sale 190 1,260 239,400 Inventory, June 30 15 16 FIFO LIFO Weighted Average 17 BI 18 Purchases 19 COGAS 20 EI 21 COGS 22 23 24 25 26 27 28 29 30 31 14 4 Sheet1 Ready Type here to search 8: 100% + Breaking news ~ E ( 4) 9:23 PM 11/8/2022 20