Please help me fill in the blue shaded areas! Include the formula... having major trouble computing "Required Purchases in Dollars"

... D = cash_flow_budget_v3 X Cut 19 Copy Format Calibri (Body) - 11 BIU, L A- A A = = = D Et Wrap Text General E3333 Merge & Center - $ - % , Paste o Conditional F Formatting as A25 A 1 Budget Assumptions 2 First Month's Sales in Units 3 Unit Sales Growth Per Month Unit Sales Price 10,000 250 12.00 LEFT/FIND Functions First Month's Sales in Units Assumption Unit Sales Growth Per Month Assumption Unit Sales Price Assumption $ Gross Margin Commission Ending Inventory 50% 10% 60% TRIM Function Gross Margin Commission Ending Inventory $ 12 Minimum Cash Balance 13 Interest Rate 20,000 12% SUBSTITUTE Function Minimum Cash Balance Assumption Interest Rate Assumption Collections 25% 50% 25% Payments 60% 40% 0% CONCATENATE/RIGHT Function Period 1 Period 2 Period 3 UPPER Function PERIOD 1 PERIOD 2 PERIOD 3 LOWER Function period 1 period 2 period 3 15 Month 16 Month 1 17 Month 2 18 Month 3 19 20 Operating Expenses 21 Payroll Utilities Other Per Month 192,000 84,000 234,000 MID Function 7200 Payroll 7500 Utilities 7900. Other cash_flow_budget_v3 Wrap Text Comma ooo On = % Cut Calibri (Body) , 11 Copy Paste Format BI U X v fx A- A- A Paste = = = = Accounting $ - % E = = Merge & Center Merge & Center - 2 4.0 .00 00 .0 . Currency [O] Conditional Format Conditional Format Formatting as Table Currency [0] 3 Format B7 H K L M. April May June July August 1 Wally's Widgets 2 Budgeted Sales in Units 3 Add: Ending Inventory 4 Total Needs Less Beginning Inventory 6 Required Purchases in Units 7 Required Purchases in Dollars 8 Budgeted Sales in Dollars 9 Sales Commissions in Dollars January 10,000 6,150 16,150 6,000 10,150 February 10,250 6,300 16,550 6,150 10,400 D March 10,500 6,450 16,950 6,300 10,650 10,750 6,600 17,350 6,450 10,900 11,000 6,750 17,750 6,600 11,150 11,250 6,900 18,150 6,750 11,400 11,500 7,050 18,550 6,900 11,650 11,750 7,200 18,950 7,050 11,900 September 12,000 7,350 19,350 7,200 12,150 October 12,250 7,500 19,750 7,350 12,400 November 12,500 7,650 20,150 7,500 12,650 December 12,750 7,650.00 20,400 7,650 12,750 10 January February March April May June July August September October November December 11 Collection Ratio 12 January 13 February 14 March 15 April 16 May 17 June 18 July 19 August 20 September 21 October 22 November 23 December