BUSN 312 WEEK6

profilejamealag
ch14hmwkdata_withcomments_.xlsx
Home>Mathematics homework help>BUSN 312 WEEK6

Pr18

Item AB500 1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
Projected Available
Planned Orders
Item AB501 1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
Projected Available
Planned Orders
Item AB511 1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
Projected Available
Planned Orders
Item AB521 1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
Projected Available
Planned Orders

Pr20

Machines 3
Work time 8
Word days 5
Effic Rate 90%
Util Rate 90%
Orders Qty Setup Time Run Time Hrs Needed
LL110 10 2.0 1.2
Available Capacity
JR Horne: Tip: Use the formula to the right on this sheet		 LL118 25 4.0 0.4
Additional Capacity
JR Horne: Tip: the differnece between what your available capacity is and what you need based on the highest requirement		 LL131 100 6.0 0.6
LL140 50 4.0 0.2

Pr22

Machines 3
Work time 15
Word days 5
Effic Rate 80%
Util Rate 90%
Orders Qty Setup Time Run Time Hrs Needed
LL110 10 2.5 1.2
Available Capacity LL118 25 4.5 0.4
Additional Capacity LL131 100 6.5 0.7
LL140 55 4.5 0.1

Pr24

Machines 3
Work time 12
Word days 6
Effic Rate

JR Horne: Tip: given in problem		 Util Rate

JR Horne: Tip: given in problem 		Orders Qty Setup Time Run Time Hrs Needed
LL110 100 4.0 0.3
Available Capacity
JR Horne: Tip: Use the formula to the right on this sheet 		LL118 250 6.0 0.1
Additional Capacity
JR Horne: Tip: the differnece between what your available capacity is and what you need 		LL131 100 3.0 0.3
LL140 500 8.0 0.1
Orders Qty Setup Time Run Time Hours Needed
LL110 100 4.0 0.3
LL118 250 6.0 0.1
LL131 100 3.0 0.3
LL140 500 8.0 0.1