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 Cost 20 $ per unit 20.00 Total cost Beginning inventory Jan 15 purchase Jan 20 purchase Total Inventory January Sales Ending Inventory 25 $ 25.00 35 $ 33.00 42 answer will be on each schedule below Chapter & Course Outcomes: (to be demonstrated in this pro Calculate Cost of Goods Sold and Ending Inventory using 3 costing methods A inventory. Analyze the impact on the financial statements of each inventory costing me Use Microsoft Excel proficiently to resord and summarize information used 8 making