Excel please. Calculation of number lots sold & Gross profit.

Phil Collins Realty Corporation purchased a tract of unimproved land for $35,000. This land was improved and subdivided into building lots at an additional cost of $34.460. These building lots were all of the same size but owing to differences in location were offered for sale at different prices as follows. $ Group 1 2 3 No. of Lots 9 15 17 Price per Lot 3,000 4,000 2,400 Lot Operating expenses for the year allocated to this project total $18,200. Lots unsold at the year-end were as follows. 0 1 Group 1 5 lots 2 Group 2 7 lots 3 Group 3 2 lots 4 5 Instructions: 16 At the end of the fiscal year Phil Collins Realty Corporation instructs you to arrive at the net income realized on 17 this operation to date. 18 Cost Per Lot No. Sales Cost (Cost of Price Per Total Sales Allocated to allcocated + 19 Group Lots Price Relative Sales Price Total Cost Lots No. of Lots) 20 1 9 $ 3,000 $ 27,000 S 0.21 $ 89,460 $ 18,900 S 2,100 21 22 2 15 4,000 60,000 0.47 89,460 42,000 2,800 23 24 3 17 2,400 40.800 0.32 89.460 28,560 1,680 25 26 27 28 Calculation of number of lots sold: 29 Group 1 30 Group 2 31 Group 3 32 33 Calculation of cost of lots sold, sales, and gross profit: No. of Cost per Cost of Lots 34 Group Lots Lot Sold Sales Gross Profit 35 1 4 $ 3,000 $ 2,100 $ 12,000 36 37 2 8 4,000 2,800 32,000 38 39 15 2,400 1.680 36,000 40 41 42 3