Financial Planning. Managers at Industrial Supply, Inc. are planning a sales campaign for the coming year in
Question:
Financial Planning. Managers at Industrial Supply, Inc. are planning a sales campaign for the coming year in which they must determine how many sales representatives they will assign to seven product lines. S-shaped sales response functions of the form
have been fitted to subjective data provided by a group of experienced managers. (Both variables Sales and Reps have been measured relative to base levels. Thus %Reps represents the ratio between proposed reps and base reps, while %Sales represents the ratio between proposed sales and base sales.) The fitted values for the four parameters for each product are given in the table below.
The table below gives the current number of reps assigned to each product and current sales, along with the contribution margin on each product. The cost of each rep is $63,000 per year.
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 9780470530672
3rd Edition
Authors: Stephen G. Powell, Kenneth R. Baker