In: Accounting
Gibson Manufacturing Company was started on January 1, Year 1, when it acquired $87,000 cash by issuing common stock. Gibson immediately purchased office furniture and manufacturing equipment costing $8,400 and $25,800, respectively. The office furniture had an eight-year useful life and a zero salvage value. The manufacturing equipment had a $3,600 salvage value and an expected useful life of three years. The company paid $11,100 for salaries of administrative personnel and $15,800 for wages to production personnel. Finally, the company paid $9,800 for raw materials that were used to make inventory. All inventory was started and completed during the year. Gibson completed production on 4,400 units of product and sold 3,480 units at a price of $15 each in Year 1. (Assume that all transactions are cash transactions and that product costs are computed in accordance with GAAP.) Required Determine the total product cost and the average cost per unit of the inventory produced in Year 1. (Round "Average cost per unit" to 2 decimal places.) Determine the amount of cost of goods sold that would appear on the Year 1 income statement. (Do not round intermediate calculations.) Determine the amount of the ending inventory balance that would appear on the December 31, Year 1, balance sheet. (Do not round intermediate calculations.) Determine the amount of net income that would appear on the Year 1 income statement. (Round your answer to the nearest dollar amount.) Determine the amount of retained earnings that would appear on the December 31, Year 1, balance sheet. (Round your answer to the nearest dollar amount.) Determine the amount of total assets that would appear on the December 31, Year 1, balance sheet. (Round your answer to the nearest dollar amount.)
Attached are images of two excel sheets, one with the solution and the other showcasing the formulas used.