6-FIFO, LIFO, Ave Cost Read-Only Excel Home Insert Draw Page Layout Formulas DataReview View Help Tell me what you want to do 11AA Ab Wrap Text Calibri General Paste BIU td Merge & Center. $.% , 40.00 Conditional For Clipboard Font Alignment 025 EFGH 3 Inventory Cost Flow Assumptions 5 Johnson Company uses a perpetual inventory system. The January 2018 inventory information is as follows. Assume cash purchases and sales DATA Description Units Per Unit Date Jan 1 Inventory on hand 1,000 S 3,000 S5 Jan 3 Jan 6 Jan 15 Purchase Sale Purchase Sale 10 2,750 5,000 4,500 $ 10 Jan 22 Prepare a perpetual inventory record using, FIFO, LIFO, and weighted-average inventory costing methods, and determine cost of go cell references from Data Table for quantities and unit cost. Use Excel formulas for total costs and total quantities. Format weight Requirements