only B is required

1 Assignment fall 2019 2See separate word document for instructions to submit this assignment to takboard 3 See separate word document for instructions access the appropriate sections of the Accounting Standards Codification 4 Prepare your responses to parts and 2 in this Excel Workbook and submit per instructions 5 Format this Excel Workbook so that your answers are fully visible in Landscape Layout 6 Part 1: Prepare solution to exercise in Excel 7 Use the features of Excel as demonstrated in class and provide a schedule to determine required items) and (b) below. 8 Your grade for this assignment will reflect not only the correct solution but also presentation and use of Excel features to arrive at the correct solution The first month of Petit Company's detailed inventory records indicated the following Number of Units Unit Castle Price 3.10 12 Date Transaction 1/2/2020 Purchase 1/7/2020 Sale 15 1/10/2020 Purchase 16 1/11/2020 Sale 1/19/2020 Purchase 1/18/2020 Sale 19 1/20/2020 Sale 20 1/23/2020 Purchase 1/26/2020 Sale 22 1/23/2020 Purchase 23 1/31/2000 Sale 3.25 7.10 1000 7.70 1300 800 1600 8.20 120 25 Required: 27 (a) Measure the value of ending inventory to the nearest doll 28 b) Measure the prossmarin based on UFO under a perpetual inventory system