Answer To: Case 26-1 Outsourcing Straight Supply Straight Supply is a major supplier of medical components to...
Sarabjeet answered on Apr 10 2021
Straight Supply
Topic: Straight Supply
Student Name:
Unit Code:
University Name:
Date:
Part 1: Evaluate the two proposed alternatives regarding the insulinpump.
Based on the quantitative study, the following is the evaluation of the two locations Denver and India based on cost and revenue:
For the Denver location, the following is the analysis:
Denver
1
2
3
4
5
No. of employees
25
25
25
25
25
Average wage
$
$
$
$
$
per hour
30.00
31.80
33.71
35.73
37.87
No. of products produced in an hour
75
75
75
75
75
Total shift
8
8
8
8
8
Total days
250
250
250
250
250
$
$
$
$
$
Direct labor
1,500,000.
1,590,000
1,685,400
1,786,524
1,893,715.
cost
00
.00
.00
.00
44
$
$
$
$
$
2,700,000.
2,862,000
3,033,720
3,215,743
3,408,687.
Indirect cost
00
.00
.00
.20
79
$
$
$
$
$
117,000.0
121,680.0
126,547.2
131,609.0
Shipping cost
112,500.00
0
0
0
9
Production capacity
150000
Demand
150000
165000
181500
199650
219615
Price of
$
$
$
$
$
product
100.00
105.00
110.25
115.76
121.55
$
$
$
$
$
15,000,000
17,325,00
20,010,37
23,111,98
26,694,34
Total revenue
.00
0.00
5.00
3.13
0.51
$
$
$
$
$
Working capital
1,800,000.
2,079,000
2,401,245
2,773,437
3,203,320.
requirements
00
.00
.00
.98
86
$
$
$
$
$
8,887,500.
10,677,00
12,768,33
15,209,73
18,057,00
Profit
00
0.00
0.00
0.75
7.33
Net present
$39,532,90
value
9.06
Since the basic discount rate is 14.80% and in addition risk premium for new products is 2.50%, the net value is intended at a discount of 17.30%. The current net worth is $ 39,532,909.06 (Brent Wistrom, 2021).
The net present value analysis for India is as follows:
India
1
2
3
4
5
No. of employees
25
25
25
25
25
Average wage
per hour
$
10.50
$
11.55
$
12.71
$
13.98
$
15.37
No. of products produced in an hour
2
75
75
75
75
total shift
8
8
8
8
8
total days
250
250
250
250
250
Direct labor cost
$ 525,000.00
$ 577,500.0
0
$ 635,250.0
0
$ 698,775.0
0
$ 768,652.5
0
Indirect cost
$ 945,000.00
$ 1,039,500
.00
$ 1,143,450
.00
$ 1,257,795
.00
$ 1,383,574
.50
Shipping cost
$ 500,000.00
$ 598,000.0
0
$ 715,208.0
0
$ 855,388.7
7
$ 889,604.3
2
Shipping cost
per unit
$
5.00
$
5.20
$
5.41
$
5.62
$
5.85
Production...