week 9 2510
xlsx
keyboard_arrow_up
School
Seneca College *
*We aren’t endorsed by this school
Course
2510
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
14
Uploaded by fhruhieru
Hull and Keel
39000
30%
Standing rig
22100
17%
sails
19500
15%
electrical
19500
15%
other
29900
23%
total
130000
100%
Component Safety
Styling
Performance
Comfort
Hull and Keel
30%
40%
50%
30%
Standing rig
30%
20%
20%
10%
sails
10%
10%
30%
10%
electrical
20%
10%
other
10%
20%
50%
Safety 34%
Comfort
33%
Peformance
20%
Styling
13%
Component Safety (34%)
Styling (13%
Performance (20%)
Comfort (20%)
Hull and Keel
10.20%
5.20%
10.00%
9.90%
Standing rig
10.20%
2.60%
4.00%
3.30%
sails
3.40%
1.30%
6.00%
3.30%
electrical
6.80%
1.30%
other
3.40%
2.60%
16.50%
Component Importance Index
Cost Index Value Index
Hull and Keel
35.30%
30% 1.18 Standing rig
20.10%
17% 1.18 sails
14.00%
15% 0.93 electrical
8.10%
15% 0.54 other
22.50%
23% 0.98
a) Importance Index 35.30%
20.10%
14.00%
8.10%
22.50%
No. of Hours Req. for Each Pr
Activity
Polymer 1
Filtering
2
Stripping
2
Reacting
3
Final filtering
2
Mixing
3
Other information:
Current sales demand
60
Selling price per unit
$145 Polymer 1
Filtering
120
Stripping
120
Reacting
180
Final filtering
120
Mixing
180
2. Throughput margin
Price $145 (Cost)
45
Throughput margin
$100 Contraint time per unit 3
thoughput per hour
33.3333333333333
Given the result from requirements 1 and 2, how
1. identify which product is more profitable > use throughput per h
the higher the thorughput per hour > the more profitable the prod
So, we should produce as many units of Polymer 1, as possible Capacity left for Polymer 2
140
Number of units for Polymer 2
28
Polymer 1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Units
60
Throughout margin $100 Total throughput 6000
roduct
Polymer 2
4
3
5
1
3
40
$185 Polymer 2
=60 (current sales demand) * 2 (filtering time)
160
120
200
40
120
$185 =chemical A ($20) + chemical B ($25) 60
$125 5
25
w many units of each proct should be produced?
hour
duct is
=we should match the demand > produce 60 units of polymer 1
=320 (available time - what you spend on polymer 1 (3*60)
=140 / 5 (5 is the number of hours for activity constraint for polymer 2)
Polymer 2
28
$125 3500
9500
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
No. of Hours
Available per Week
320
320
320
160
320
Total activity hours
No. of Hours
Slack
280
320
40
240
320
80
380
320
-60
constraint
160
160
0
300
320
20
=chemical A + B + C
=point of maximum efficiency
Age
1 to 4
45,688 48,977 5 to 14
82,456 84,663 15 to 19
95,873 95,887 20 to 24
66,246 67,882 25 to 34
133,496 132,554 35 to 44
166,876 175,446 45 to 54
85,496 90,889 55 to 64
99,624 101,923 65 to 74
156,288 161,559 75 to 84
67,895 72,465 85 years and older
23,499 26,849 TOTAL
###
1,059,094 Current market price 368.00 Current desired profit 110.86 =market price - cost
Current cost 257.14 Part 2
Age
1 to 4
45,688 48,977 5 to 14
82,456 84,663 15 to 19
95,873 95,887 20 to 24
66,246 67,882 25 to 34
133,496 132,554 35 to 44
166,876 175,446 45 to 54
85,496 90,889 55 to 64
99,624 101,923 65 to 74
156,288 161,559 75 to 84
67,895 72,465 Enrollment in current year
Projected Enrollment next year
Target cost = Selling/Market price - Desired profit Enrollment in current year
Projected Enrollment next year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
85 years and older
23,499 26,849 TOTAL
###
1,059,094 1. Desired profit stays the same 110.86 New market price 350
Cost 278.607006943006
Target cost 239.14 Required reduction in costs needed to maintain the same profit?
=Average costs in the next year - target cost
39.46 = required reduction in costs
$ 11,147,872 10,059,632 8,436,824 9,539,424 26,432,208 38,882,108 22,741,936 28,691,712 49,518,144 33,432,760 24,286,475 $263,169,095
257.14 =sum of average monthly costs / enrollment
New market price
325
Desired profit 110.86 Target cost
214.14 Average cost per enrolle in the current year
=average monthly cost / enrollment in the current
$ 11,147,872 244.00
10,059,632 122.00
8,436,824 88.00
9,539,424 144.00
26,432,208 198.00
38,882,108 233.00
22,741,936 266.00
28,691,712 288.00
49,518,144 316.84
33,432,760 492.42
Average Monthly Cost in current year
Average Monthly Cost in current year
24,286,475 1033.51
$263,169,095
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Next year costs
Average monthly cost in the next year
=previous column * 1.07
=previous column * projected enrolment
261.08 12,786,915.16 130.54 11,051,908.02 94.16 9,028,719.92 154.08 10,459,258.56 211.86 28,082,890.44 249.31 43,740,442.26 284.62 25,868,827.18 308.16 31,408,591.68 339.017800982801 54,771,376.91 526.887888651594 38,180,930.85
1105.85677050087 29,691,148.43 295,071,009.41 Average cost per enrollee
278.607006943006
=average monthly cost in the next year / projected enrollment in the next year