what is the required purchase in dollars formula? I keep getting it wrong

Step 19 of 40: Required Purchases in Dollars D E M 1 Wally's Widgets 1 2 Budgeted sales in Units YOUR TURN: Use the Gross Margin and Sales Price inputs to determine the cost 3. Add: Ending Inventory per unit and then compute the required purchases in dollars. This is calculated as: 4 Total Needs 5 Less Beginning inventory Sales Price multiplied by (1-Gross Margin Percentage) multiplied by Required Units 6 Required Purchases in Units 16150 16550 16950 17:50 17 19750 20150 20400 7 Required Purchases in Dollar 8 Budgeted Sales in Dollars 9 Sales Commissions in Dollars 10 Inputs Supporting Schedules Operating Budget Cash Budget A M 1 W Widgets Cash Flow Budget v3xlsx 2 August September October November Decembed 2 BO Tip: Excel formulas return #********when a column is too narrow view View Help 3 Add to display the entire amount To resolve this you can either widen 4 Total the column(s) or change the number format, as shown in step 3. 25 (General s Less Begregory 3 Conditional 6 Required Purchases in Units 11900 12150 12400 12650 12 Select cells B7:M7 and then 7 Required Purchases in Dollars $71,400.00 $72.900.00 ANALITES 76,500 choose General from the format 8 Budgeted sales in Dollars list within the Number section 9 Sales Commissions in Dollars of the Home menu. 10 Inputs Supporting Schedules Operating Budget Cash Budget 7650 7650 " ng 1 Wally's Widgets January February March April 2 Budgeted sales in Units 10000 10250 10500 3 Add: Ending Inventory 6150 6300 6450 4 Total Needs 16150 16550 16950 5 Less Beginning inventory 5000 6250 6300 6. Required Purchases in Units 10150 10650 7 Required Purchases in Dollars 8 Budgeted sales in Dollars 9 Sales Commissions in Dollars May 10750 6600 17350 6450 10900 G June July 11000 11250 6750 5900 17750 18150 6600 6750 11150 11400 H M August September October November December 11500 11750 12000 12250 12500 22750 7050 7200 7250 7300 2650 7850 TESSO 18950 19350 19750 20150 20,000 6500 2050 2200 7350 7500 2650 11650 11900 12150 12600 12650 127.50 10400 10