Wat made on July 27 by Ranae Zwisk 2 F H 2 3 4 Y 100%. fx View only-> D You must make a copy before using this sheet. This is the master. File (right under the title) then make a copy to save to your own Google Drive or Download as Microsoft Excel. BBC2, Inc. uses a periodic inventory system and has the following Information available: REQUIRED FOR POINTS: A. Complete the master inventory record using formulas. Reference/link back to this information for each costing schedule. Referencing answer' cells back to 'input' cells creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. REQ. A MASTER INVENTORY RECORD Description (Shelves # of Units T Beginning inventory . Jan 15 purchase Cost per unit 20 $ 20.00 25 $ 25.00 Total cost " Jan 20 purchase 35 $ 33,00 10 Total Inventory 15 January Sales 42 answer will be on 32 Ending Inventory each schedule below " prouoco con now Share D 8 Chapter & Course Outcomes: (to be demonstrated in this project) Calculate Cost of Goods Sold and Ending Inventory using 3 costing methods in the periodic system A inventory. Analyze the impact on the financial statements of each inventory costing method and system of in Use Microsoft Excel proficiently to record and summarize information used in business analysis an making