Please create a table to put your answers in

Calculating the Value of Ending Inventory and Cost of Goods Sold: Lower of Cost or Net Realizable Value Method The following inventory data is taken from the financial records of Fernandez, Inc., a personal computer software manufacturer. No. of Units Unit Cost Total Cost Beginning inventory (Jan. 1) 160,000 $8.00 $1,280,000 Purchases: May 5 60,000 12.00 720,000 Sept.3 60,000 16.00 960,000 Total available for sale 280,000 $2,960,000 Less: Sales* 250,000 ? Ending inventory (Dec. 31) 30,000 ? Net realizable value per unit 11.20 Sales for No. of the year Units Sold Feb. 3 120,000 Jun. 30 30,000 Oct. 5 100,000 250,000 Required 1. Complete the following table. Round all answers to the nearest whole number. Assume that any LCNRV inventory adjustments are not recorded in Cost of Goods Sold. Periodic Ending Cost of Inventory Goods Sold 0 x 0 x Perpetual Ending Cost of Inventory Goods Sold 0 x 0 x Method a. FIFO b. LIFO 0 x 0 x 0 X 0 x 0 x 0 x 0 % C. Weighted-average* 0 x *Do not round until your final answers