Gale Company has the following inventory and purchases during the fiscal year ended December $31,2023.$

Beginning Inventory $305$ units @ $ $85/$unit

Feb. $10$ purchased $220$ units @ $ $89/$unit

Feb. $20$ sold $385$ units @ $ $165/$unit

Mar. $13$ purchased $269$ units @ $ $83/$unit

Sept. $5$ purchased $270$ units @ $ $69/$unit

Oct. $10$ sold $525$ units @ $ $165/$unit

Gale Company employs a perpetual inventory system.

Required:

$1.$ Calculate the dollar value of ending inventory and cost of goods sold using: $($Round your intermediate calculations and final answers to $2$ decimal places.$)$

$2.$ Using your calculations from Part $1,$ complete the following schedule: $($Round your intermediate calculations and final answers to $2$ decimal places.$)$ During $2023,$ Fresh Express Company sold $2,370$ units of its product on September $20$ and $2,350$ units on December $22,$ all at a price of $$77$ per unit. Incurring operating expenses of $$18$ per unit sold, it began the year with and made successive purchases of the product as follows:

January $1$ beginning inventory $470$ units @ $ $22$ per unit

Purchases:

February $201,370$ units @ $ $24$ per unit

May $16570$ units @ $ $28$ per unit

December $113,170$ units @ $ $29$ per unit

Total $5,580$ units

Required:

Prepare a comparative income statement for the company, showing in adjacent columns the profits earned from the sale of the product, assuming the company uses a perpetual inventory system and prices its ending inventory on the basis of $($a$)$ FIFO and $($b$)$ Moving weighted average: $($Round "Cost per unit" to $2$ decimal places. Do not round intermediate calculations. Round your final answers to $2$ decimal places.$)$ I need the correct answer in excel file