please create a fake sales schedule with an absorption rate of 20%.

K M E G D B C Link in the unit and base price information from Question 3. Make up an arbitrary sales schedule for the homes and enter it in the area highlighted in red. Write a formula in the cell highlighted in yellow that will calculate the sales revenue generated by Type A, Plan 1 in 2007 that can be copied to all of the other cells to calculate the revenue generated by each product type in each period. Enter a title in the cell highlighted in green; the title should say "Absorption Schedule, X Units", X is the total number of units and should link to cell M22. 2014 Total 2013 2012 2011 2010 2007 2008 2009 Units Base Price Description Sales Schedule Type A, Plan 1 Type A, Plan 2 Type A, Plan 3 Type B, Plan 1 Type B, Plan 2 Type B, Plan 3 Type C, Plan 1 Type C, Plan 2 Type C, Plan 3 Type D, Plan 1 Type D, Plan 2 Type D, Plan 3 Total 34 $ 797,000 34 823,000 44 848,000 20 847,000 20 877,000 27 907,000 740,000 47 758,000 63 793,000 20 675,000 20 720,000 27 750,000 47 Instructions 01 02 03 04 05 Bonus W MIC dy