Inventories, please help with creating table!

Exercise 1. Cost of goods sold Musica y Mas had an inventory of guitars and other musical instruments. Using the FIFO method and the perpetual inventory system, the company recorded initial inventory, purchases, and sales. Determine the cost of merchandise sold and the value of the inventory. Fecha Detalla Cantidad Costo de unidad (unit cost) Mayo 1 Inventario inicial 10 $91 6 Venita B Compra 14 95 13 Vanta 30 Venta Exercise 2. Perpetual inventory record Electronic Equipment and Much More had an inventory of computers. Using the LIFO method and the perpetual inventory system the company recorded the initial inventory, purchases and sales. Determine the cost of merchandise sold and the value of the inventory. Fecha Detalle Cantidad Costo de unidad (unit cost) Mayo 1 Inventario inicial 12 $125 venta 6 Compra 17 110 13 Venta 30 N A venta Exercise 3. Perpetual inventory record Musica y Mas had an inventory of guitars and other musical instruments. Using the average inventory method and the perpetual inventory system, the company recorded beginning inventory, purchases, and sales. Determine the cost per unit and the cost of merchandise sold. Fecha Detalle Cantidad Costo de unidad (unit cost) Mayo 1 Inventario inicial $82 Venta 3 Compris 20 Venta 4 Venta