hi can someone please help me create a formula using the max function to find the max COGS please thank you!! and show work

6. In cell A25, type Max COGS 7. In cell B25, write a formula using the MAX function to find the maximum COGS amount: =MAX(B6:119) (You should see $9,318.96 in B25, while the actual value is $9,318.958) D E F G H hi Region 2 Product Ally (AMI) 4 Maximum COGS Column Labels OI 5 Row Labels Chin Jeri Jon Luke Rhonda Sheliadawn Steven Troung Grand Total 32 6 Amazon.com $ 7,133.75 S 7,221.70 $ 6,971.50 $5,948.17 S 8,498.82 $6,587.70 $ 6,892.16 $ 6,202.68 $ 8,498.82 7 Costco $ 8,100.62 S 8,815.92 $ 8,149.08 $8,792.47 $ 6,619.09 $ 5,342.11 $ 6,101,10 S 9,318.96 $ 9,318.96 8 ExcellsVeryFun.com $ 8,271.49 5 8,446,46 $4,494,45 $8,220.26 $ 8,333.41 $ 8,429.33 58,667.17 $ 7,657.57 $ 8,667.17 9 Google $ 9,007.05 $ 8,136.27 $ 6,938.77 $5,510.95 5 5,896.50 $ 8,598,61 $ 7.774.05 $ 7,327.08 $ 9,007.05 10 Home Depot $ 6,225.63 $ 5,923.06 $ 8,476.72 $6,141.74 $ 4,939.54 $ 5,409.03 $ 7,371.44 $ 6,180.38 $ 8,476.72 r 11 McLendon's Hardware s 5,842.79 5 6,469.43 $ 7,176.73 $5,237,02 $ 8,702.34 $ 9,284,38 $ 8,192.47 $ 9,189.78 $ 9,284,38 12 Nature Company $ 6,043.74 $ 8,622.15 5 5,395.13 $7,994.14 $8,208.34 $ 5,622 97 5 5,525.39 $ 7.772.23 $ 8,622.15 13 Office Depot $ 8,115.05 $ 8,814.57 $ 6,394.51 $6,886.34 $ 7.750.48 5 5.147.44 S 6,204.57 $ 7,872.32 $ 8,814.57 14 Peet's Coffee 5 8,482 25 56,245.32 $ 6,835.97 $7,044,34 $ 4,846.16 $ 7,266.91 $ 6,481.88 $ 7,841.64 $8,482.25 15 Sherman Williams $ 7,251.87 $ 6,647.98 $ 9,317.97 $7.479.79 $ 6,567.72 $ 8,206.42 $ 8,071.51 $ 6,549.87 $ 9,317.97 16 Solar and Wind Inc S 5,554.45 S 8,350.13 $ 6,619.97 $7,898.92 $ 8.240.28 $ 8,930.01 $ 8,787.63 $ 7,657.33 $ 8,930.01 nd 17 The Economist $ 8,649.28 $ 6,993.48 $ 7,539.60 $8,929.90 $ 7,012.77 $ 5,456.00 $ 7,438,07 $ 5,808.62 $ 8,929.90 18 Whole Foods $ 5,856.69 $ 8,079.50 $ 8,311.60 $8,615.62 $ 7,959.19 $ 5,628.87 $ 8,722 38 $ 8,748.78 $ 8,748.78 19 Yahoo S 8,597.46 5 5,286,075 5,988 93 $4.993.1954,825.25 58.346.09 S 8,318.62 $ 7,429.13 $ 8,597.46 20 Grand Total $ 9,007.05 5 8,815.92 $ 9,317.97 $8,929.90 $8,702.34 $9,284,38 $ 8,787.63 $ 9,318.96 $ 9,318.96 21 22 23 24 25 Max COGS