Forcast please show steps to rebate

Fill out Performa based on the forcast( 2nd screenshot)

Proforma Actual Q4 Q5 Q6 Q7 Q8 1,200,530 39,750 450,512 710,268 Gross Profit Revenues - Rebates -Cost of Goods Sold = Gross Profit Expenses Store Leases + Sales and Service Personnel Expense + Brand Promotions + Special Programs + Ad Creation/Revision + Point of Purchase Display Expenses + Advertising Expenses + Internet Marketing Expenses + Engineering Cost for New Brands + Market Research = Operating Expenses 98,500 108,904 0 0 18,000 1,800 69,699 5,700 60,000 60,000 422,603 287,665 Operating Profit Miscellaneous Income and Expenses + Other Income -Other Expenses - Research and Development Costs Set Up Costs for New Stores = Net Profit for Division 0 0 0 0 287,665 Cumulative Net Profit for Division -126,578 Quarter 4 Quarter 5 Quarter 6 Quarter 7 Quarter 8 City Brand Actual Units Sold Actual Price Actual Sales Price Sales Forecast Price Sales Forecast Price Sales Forecast Estimated Units Sold 600 345 nyc Brand X Brand Y Brand z Brand x Brandy Brand z 542 259 231 274 150 86 760 905 698 $ $ $ $ $ $ $ 750.00 910.00 690.00 775.00 900.00 600.00 Estimated Units Sold 550 288 240 285 160 92 $406,500 $235,690 $159,390 $212,350 $135,000 $51,600 $ 1,200,530.00 $ $ $ $ $ $ Estimated Units Sold 620 330 257 320 182 120 750 $ 412,500.00 905 $ 260,640.00 690 $ 165,600.00 775 $ 220,875.00 888 $ 142,080.00 600 $ 55,200.00 $ 1,256,895.00 $ $ $ $ $ $ $471,200 $298,650 $179,386 $246,400 $161,616 $73,200 $ 1,430,452.00 11111 tokyo Estimated Units Sold 620 355 270 340 230 140 $ 760 $ 456,000.00 $ 905 $ 312,225.00 $ 698.99 $ 187,329.32 $ 770 $ 265,650.00 $ 888 $ 158,064.00 $ $ 610$ 82,350.00 $ 1,461,618.32 Price Sales Forecast $ 780 $ 483,600.00 $ 890 $ 315,946.45 $ 698.99 $ 188,727.30 $ 785 $ 266,900.00 $ 885 $ 203,550.00 $ 620 $ 86,800.00 $ 1,545,523.75 268 345 178 135 770 888 III 610 Total Sales Brand x NYC Brandz $75 $25 Rebates Q5/Q6 Q7/Q8 $0 Brandy $75 $25 Brandy Tokyus Brandy | 375 Iso $50 $ 0 2 Brand $23 825