Birmingham All$-$Terrain Corporation $($BATC$)$ plans to produce a new

type of ATV. To advertise their new product, they are considering three media

venues. The first option is to buy a series of ads in the local newspaper, the

second option is to buy advertising ads on local TV$,$ and the third option is

advertising on local radio. Each newspaper ad costs $$800,$ each TV ad costs $$900,$

and each radio ad costs $$500.$ The company has $$8800$ budgeted weekly for

advertising purposes. Each newspaper ad reaches an average audience of $8500$

people, a TV ad reaches $5000,$ and a radio ad reaches an average of $2500$ people.

The maximum number of newspaper ads per week is $2,$ and the maximum number

of TV ads per week is $12.$ In a new tab called $3,$ build an organized

spreadsheet model and optimize BATC$$s audience exposure with Excel Solver

using the $$Simplex LP$$ engine. Note: restrict decision variables $($number of ads

of each type$)$ to integer values. Then, perform a Parametric Sensitivity Analysis

using SolverTable one$-$way feature, for total available budget $($currently set to

$$8800).$ Use $5000$ as the minimum, $15000$ as the maximum and $1000$ as the

incremen