You are the manager of the Sales Department for the Epic Widget Manufacturing

Company. The company produces three different types of widgets: small widgets, medium

widgets, and large widgets.

The senior management of your company has forecasted sales and has asked you and your

sales team to sell the following quantities of products during the upcoming fiscal year:

You must sell these quantities of widgets. Since you are the Sales Manager and not in

charge of production, you do not control the production levels of the widgets.

Senior management is willing to spend up to$,$ but not over, $10\%$ of the company's total

sales on sales force compensation. This is the limit of total compensation available that you

have to distribute to your sales team.

The sales force professionals in the sales department include:

$3$ Senior Sales Representatives

$5$ Sales Representatives

$2$ Sales Trainees

Assignment: Design a sales compensation plan for your department.

For each type of sales professional include plans for:

Base salary

Commission rate $($constant$,$ progressive, or regressive$)$ for each tvpe of product. here is the excel sheet please explain your steps