please help with sales commissions in dollars, and show the formula to get the sales commission in excel. the commisions percentage is 50%

Cash Flow Budget.at Ecel Jatie FORMULAS DATA REVIEW vEw Farit POF FILE HOME INSERT PAGE LAVDUT Trace Precedents Show Formula Define Name fx Cakculste Now Trace Dependents Eo Checking Use in Formle Watch Calkulation Calculate Sheet Options More Name AutoSum Recently Financial Logical Tet Date & tookup & Math & Insert Evaluste Formule Create from Sellection Remove Aows Time Reference Trig Functions Window Used Manaoe Function Fermula Auditing Calculation Fundion Libry Defined Names 88*Commissions H D August October November December September 1Wally's Widgets 2 Budgeted Sales in Units 3 Add: Ending Inventory June aly January February March April May 12,750 12.250 12.500 11.70 12,000 11.500 11,250 10,500 10,750 11,000 10,000 10.250 7,600 7,500 7,650 7,200 7,350 7,000 6.900 6.450 6,000 6,750 6,150 6,300 20,400 19,750 20,150 18.550 18,950 19.350 18.150 17.350 17,750 16.150 16,550 16,950 4 Total Needs 2,650 7,350 7,500 6.900 7,050 7.200 6450 6600 6,750 6,300 6,000 6.150 5 Less Beginning Inventory 12,650.00 12,750.00 12,150.00 12400.00 11,400.00 11.650.00 11.900.00 10.900.00 10.400.00 11,150.00 10,650.00 10.150.00 6 Required Purchases in Units 76,500 72,900 75,900 24,400 71,400 69,900 66.900 68,400 65,400 62,400 63,900 60.900 7 Required Purchases in Dollars 150,000 153,000 147,000 141,000 144,000 138,000 135,000 126,000 129,000 132,000 Budgeted Sales in Dollars 9Sales Commissions in Dollars 120,000 123,000 6,500.00 75,000.00 73,500.00 70,500.00 72,000.00 69,000.00 66.000.00 67,500.00 61,500.00 64.500.00 63,000.00 60,00p0 September October November December August July June March April May 11 Collection Ratio January 12 January 13 February 14 March 15 April 16 May 17 June July 19 August 20 September 21 October 22 November