Better Bottlec, Inc, wiss a periodic inventory syotem and has the following informution wailable: Check Answers Legend Graded cell: Leave blank if no answer it nevied Aequired: 1) Catculate both the fnding inventary and Cout of cioods Sold uing feriodic nio. Sctatchnad Use as a non-graded Whe cells A4 to bLo from the even information to complete thi question]. Check Answers 2) Cuculate both the Inding inventory and Cont of Goods Sold usine Periose uFO. (Use cells A4 to D10 trom the diven informatice to cemplete this question.) Legend Graded coll Leave blank if no anwwer in necded. Scratchood: Use as a non-graded workspace 3) Uning Periodic weighed Average, hrat calculate the cost per unit asine the tarrula belaw 3) Using Prriodic Weighted Average, first calculate the coit ger unit using the formula below. Next, apply that ame cost per unit to calculate both the inding inventory and Coit of Goodi Sold. McGraw Hill (Use crilt A4 to D10 from the given information to comclate this euestion.) Check Answers per unit Legend Oraded cel- Leave titank if no answer in Heeded. mulhadi, (A) numbers thould be possive I (Uie cell Ma to Dro bum the even information to complele this question.) (Use cells A4 to D10 from the given intormation to complete this question.) McGraw Fill Check Answers (1). Legend Giaded cell Leave biork if ne arnwer is needed. Students: The soratchpad area is for yeu to do afy additional work you need to solve this queribion or can be wied to show your wous. Nothine in this area will be graded, but it will be whomitted with your angrement. Scratchoad: Uie as a non-gradeqf workspace