Scribd
Upload
22 views3 pages

Excel Solver

The document outlines a financial scenario with a revenue of 75,000 and a return rate of 90%. It details the cost per salesperson at 45,000 and indicates that the number of sales is capped at 100. Profit calculations and revenue projections based on varying numbers of employees are also presented but lack specific figures.

Uploaded by

Pratap Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
22 views3 pages

Excel Solver

The document outlines a financial scenario with a revenue of 75,000 and a return rate of 90%. It details the cost per salesperson at 45,000 and indicates that the number of sales is capped at 100. Profit calculations and revenue projections based on varying numbers of employees are also presented but lack specific figures.

Uploaded by

Pratap Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Revenue is 75000

Return will br 90%


Cost per salesperson will be 45000
Sales is not gretaer than 100

Number of Sales People Profit


Revenue per Salesperson 1
Diminishing Return
Cost per Salesperson

Revenue -
Salaries -
1
Profit -

-
1 10 20 30 40 50 60 70 80 90 100 110 120 130
Profit Employees Revenue
1 -
10 -
20 -
30 -
40 -
50 -
60 -
70 -
80 -
90 -
100 -
110 -
0 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200
120 -
130 -
140 -
150 -
160 -
170 -
180 -
190 -
200 -
Salaries Profit
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -

You might also like