Consider the transportation model in the provided file Williamson, which is very similar to the Foster Generators model $($section $7\mathrm{.}3).$ Williamson produces a single product and has plants in Atlanta, Lexington, Chicago, and Salt Lake City and warehouses in Portland, St$.$ Paul, Las Vegas, Tucson, and Cleveland. Each plant has a capacity, and each warehouse has a demand. Williamson would like to find a low$-$cost shipping plan. Mr$.$ Williamson has reviewed the results and notices right away that the total cost is way out of line. Use the Formula Auditing Tools under the FORMULAS tab in Excel to find any errors in this model. Correct the errors. $($Hint: The model contains two errors. Be sure to check every formula$).$

Use the provided file RSR to complete the following question. Richardson Ski Racing $($RSR$)$ sells equipment needed for downhill ski racing. One of RSR$\text{'}$s products is fencing used on downhill courses. The fence product comes in $150-$foot rolls and sells for $$215$ per roll. However, RSR offers quantity discounts. The file contains $172$ orders that have arrived for the coming six weeks.

a$.$ Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders.

b$.$ Use the COUNTIF function to determine the number of orders in each price bin $+$