Northgate Products Corp. sells gadgets and uses the perpetual inventory system. During the month of June 2023 , the number of gadgets purchased and sold was as follows: 16 Units were sold for the following amount: Units were sold for the following amount: \begin{tabular}{l|l} June 10 & $11 \\ June 20 & $12 \end{tabular} Required: Note: USE Excel for linking the numbers and use formulas in Excel for any calculations. 1 Complete the applicable inventory record card, and calculate cost of goods sold and the cost of ending inventory under each of the following inventory cost flow assumptions: a. FIFO (see sheet Q2 Req 1a FIFO) b. Weighted average (see sheet Q2 Req 1b WeightAvg) 2 Prepare the journal entries required to record purchases and sales using the FIFO inventory cost flow assumption. Descriptions are not necessary. (see sheet Q2 Req 2)