Chelsea's Cameras Ltd records its inventory of digital cameras by using a perpetual inventory system on a FIFO basis. The following details are supplied for one particular popular make and model for the month of November. Ignore GST. Nov. 1 Inventory on hand consisted of 18 cameras costed at $160 each. Purchases: Nov. 2 10 cameras at $150 each Nov.20 20 cameras at $165 each Nov.25 30 cameras at $158 each Sales: Nov. 4 16 cameras at $290 each Nov.22 22 cameras at $290 each Nov. 29 20 cameras at $310 each Required Prepare an inventory record showing the above transactions. Assuming instead that the company uses the moving average method of recording cost of sales, calculate the cost of sales and ending inventory balance for the month of November and compare your answers with those from requirement A