Or 12 Chap Stud Problem Set Assign Protected View Swed to this PC- Layout References Mailings Review View Help rosoft Defender Advanced Threat Protection and it hasn't detected any threats, if you need to edit this file, click enable editing Complete UIT OF EXCETEOCENTIERE PROVIDED BODITIZE Question 1 - Inventory Costing - Perpetual Systems - FIFO Costing Method Template provided Question 2-Inventory Costing - Average Costing Method Template Provided Starshine Coffee Equipment sells European style coffee makers and uses a perpetual inventory system. Its inventory records show that on June 1, Starshine had 12 units on hand at a cost of $220 each. Transactions related to purchase and sale of coffee makers in June were as follows: Date June 10 Transaction Units Per Unit Cost Sales Price Sale 3 $510 June 15 Sale 4 $510 June 20 Purchase 5 $230 June 22 Purchase 6 $240 June 30 Sale 10 $500 Instructions a) For each of FIFO and Weighted Average methods, create a chart and calculate the ending inventory as at June 30 and the cost of goods sold for the month of June. (22) Use the Excel Template provided. b) Prove your work for each method using the formula: (Opening Inventory + Purchases-COGS Ending Inventory) (2) c) Make the 2-part Sales entry on June 30 for each method. (4) O hp