3
/ / / / / / / / z / }
/ } / } / }
/ } / N E :@ J
J
ALL c" ASSUMP c" ' BLANK c" DATE c" b c LABOR c" ( ; MATERIAL " < O REPAIR L " P c SUMMARY " c UPDATE " V k
\G ATE " R R \P ATE " R R \U ATE " X X \W ATE " [ [
G9 E " 3 3
G: E " 4 4
G; E " 5 5
G< E " 6 6
G? E "
P3 E " P c
G9 E " l l
G: E "
G; E "
G< E "
G? E "
G9 E " ) )
G: E " * *
G; E " + +
G< E " , ,
G? E "
G9 E " . .
G: E " / /
G; E " 0 0
G< E " 1 1
G? E "
G9 E " 4 4
G: E " 5 5
G; E " 6 6
G< E " 7 7
G? E "
G9 E " - -
G: E " / /
G; E " 0 0
G< E " 1 1
G? E "
G9 E " ? N
G? E " ?
N
G9 E " C N
G: E " C N
G; E " C N
G? E " C N
G9 E " C N
G: E " C N
G; E " C N
G? E " C N
G9 E " 3 3
G: E " 4 4
G; E " 5 5
G< E " 6 6
G? E "
G9 E " z z
G: E " { {
G; E " | |
G< E " } }
G? E "
G9 E " 8 8
G: E " 9 9
G; E " : :
G< E " ; ;
G? E "
G9 E " W a
G: E " W a
G? E " W a
DF0 E " C M
RN0 E " \G ! ? @ V P B L < rk q +q +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
$ THOUSANDS QUARTERLY
O/T Premium ATTRITION q +0 +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
% OF LABOR FORCE QUARTERLY
Attrition HIRECOST q +q +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
$ THOUSANDS QUARTERLY
Hiring Cost HIRING q +q +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
WORKERS QUARTERLY
Hiring + Layoffs LABOR COST q +q +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
DOLLARS COST
CUMULATIVE
LABOR COST LABOR FORCE q +q +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
Number of Workers Labor Force Size O/T VS ATTRIT 0 +0 +q + Rate
OVERTIME %
ATTRITION % Attrition vs.
Overtime ORDERS 1 R q + +q +
Total Cost Carrying Ordering Orders
Dollars/Qtr INVENTORY COSTS
Raw Material 1 ORDERS 2 cr q + +q +
Total Cost Carrying Ordering Orders
Dollars/Qtr INVENTORY COSTS
Raw Material 2
OTPREM rk q +q +q +
Fixed Labor
Fixed OT
Min OT
Max OT
QUARTER
$ THOUSANDS
QUARTERLY
O/T Premium PERHOUR q +" +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
DOLLARS/HOUR HOURLY TOTAL
LABOR COST POLICIES am q +q +q + Fixed Labor Fixed OT Min OT Max OT
QUARTER
$ THOUSANDS QUARTERLY
Hiring + O/T Cost
REPAIRCOST q + +q +
Idle Repairmen
Idle Workers
Repairmen
Idle Costs
Repair Policy
Costs Arial Arial Arial ! Arial "
Arial # Arial $ Arial % Arial + + + % 1 + 0 + + ! + " + # 3 + $ + % 0 + & + " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2
Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2
Normal Undefined " 2 Normal Undefined " 2 Normal Undefined " 2 Normal Undefined q 0* k J9jt j PP 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* PP 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* PP 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* PP 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* P 1*
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* PP 1*
3* # 1* D D
3* # 1*
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* PP 1*
3* # 1* D D
3* # 1*
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0*
PP 1*
3*
# 1*
D D
3*
# 1*
3*
# 1*
2 2
3*
# ( 4*
" # # # # # # # # " " " ! " # # # h 5*
q 0* 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0* PP 1*
3* # 1* D D
3* # 1*
3* # 1* 2 2
3* # ( 4* " # # # # # # # # " " " ! " # # # h 5* q 0*
1*
3*
# 1*
D D
3*
# ( 4*
" # # # # # # # # " " " ! " # # # h 5*
@ @
@ @ @@ @@@ @@@ @@@
@@@ @@@
@@ @ @@ @@ @@ @@@ @@@ $ @@@ @@@ @@@ @ @
` O O ` ` O O
` ` ` ` ` ` @ ! @@ ! " @ $ % @@@ @@ $ & @"@ @@ - ' @ @@"@ @@ ( @@ * @
+ @ - @@ .
/ 0@
1 3 4 @ 5 @ 6 4 7 @ 8 3 9 8 : ; : < ( > ? ` ! " ` # $ % ` & ` ' ` O( ` ) * + , - ` . / ` 0 1 2 3 4 5 6 7 8 9 : ; < ` = > ? ` @ @ A B A # C @ @@@ @ D C E D F E G F H G I H J I K J L K M L N M O @ P <
Q @ R @ @
S W @ X W Y X Z Y [ Z \ [ ] \ ^ ] _ ^ @ ` A B C D E F G H I J K L M N O P ` Q ` R ` S T U V W X Y Z [ \ ] ^ _ ` @ a ` c d @@ e f e g f h g i @ j l j m n m o n p o q p r @ s r t s u t v u w v x @@ z @ { z | { } | ~ i l q w d ~ h @@ $ d ` x ` ` ` ' 'PRODREQ.WK4 ! ' PRODUCTION REQUIREMENTS ' Productivity "X "Y
"Z @ = ' Labor and Material Requirements Beginning / @ <<1STARTUP.WK4>>C:H2..C:H2
'Quarter 'Base Hours - @<<1STARTUP.WK4>>E:C23..E:C23 - @<<1STARTUP.WK4>>E:D23..E:D23 -
@<<1STARTUP.WK4>>E:E23..E:E23 "Firm + @<<1STARTUP.WK4>>C:D1..C:D1 'Coefficient A - S?<<1STARTUP.WK4>>F:E24..F:E24 - v/?<<1STARTUP.WK4>>F:F24..F:F24 -
S?<<1STARTUP.WK4>>F:G24..F:G24 P T
21STARTUP must be open and this drive must be default! ; 'Coefficient B - ,eX<<1STARTUP.WK4>>F:E25..F:E25 - ,eX<<1STARTUP.WK4>>F:F25..F:F25 -
,eX<<1STARTUP.WK4>>F:G25..F:G25 F ' Productivity =1 + A * @EXP( B * Cumulative units produced ) 'DIRECTORY
'QUARTER 'Assumptions ! ' Cumulative Production @ @
@ @
'Labor Summary
"Product X N@% @
@ @
'Materials Summary 'Enter assumptions
"Product Y @& @
@ @
'Repair Force Summary "in
"Product Z @' f@
f@ f@
!
'Option 1: Input Labor Force
'HIGHLIGHTED AREAS #
' Labor Hrs/unit Required 'Option 2: Fixed % Overtime " Product X 0 q @ % . 0 }l@ . 0
Y4L@ . 0 Y4L@
. 'Option 3: Minimum Overtime 'PgUp and PgDn " Product Y 0 0ȡ<@ & . 0 h@ . 0
n Li@ . 0 n Li@
.
'Option 4: Maximum Overtime
' to navigate
" Product Z 0
#@
' .
0
q@
.
0
O\-0t@
.
0
O\-0t@
.
' Attrition 'Coefficients 'Coefficient A - #~jt?<<1STARTUP.WK4>>F:F31..F:F31 'Coefficient B - F?<<1STARTUP.WK4>>F:F32..F:F32 'Coefficient C - iM"?<<1STARTUP.WK4>>F:F33..F:F33 4 ' Attrition = A + B * (O/T%) + C * (O/T%)^2 'ASSUMPTIONS " Next Qtr ' Future Quarters
'Quarter
@ @
@
@ 'Quarters @ @ @ @ @ @ 'Total Req'd Hrs 8
=c@
8 mU@
8
8
"Exp Sales
"End Inv
"Produc.
"Produc.
"Produc.
"Produc. "X % # @ $ H& ( 'Material Units Per Unit of Product
'Material Units Required "Y ! # ؈ @ % ! "Material "X
"Y "Z
"Quarter
"Matl 1 "Matl 2 "Z % , # @ & % "1 - @<<1STARTUP.WK4>>E:C25..E:C25 -
@<<1STARTUP.WK4>>E:D25..E:D25 - ?<<1STARTUP.WK4>>E:E25..E:E25 @ ;
h
;
"Total h @ P @ P ; @ P P too much! ; ; @ P P too much! ; ; P P too much! ; ; P P too much! ; "2 - @<<1STARTUP.WK4>>E:C26..E:C26 -
@<<1STARTUP.WK4>>E:D26..E:D26 - @<<1STARTUP.WK4>>E:E26..E:E26 @ ;
p
;
' Plant Capacity `m `m
"Quarter @ @ @ @ @ ' R/T Hours/Qtr -
@<<1STARTUP.WK4>>E:C31..E:C31 'Last Quarter was + @<<1STARTUP.WK4>>C:H2..C:H2 'Avg Employment - @<<1STARTUP.WK4>>C:B64..C:B64
'Avg Ind Wage $/hr - (\@<<1STARTUP.WK4>>C:C64..C:C64 # @ '
%
# @ '
%
# @ '
%
"Low
"High # 'Hiring & Train / new worker =
"Cost
"Cost "Impossible ! 'Supervisor Salary - ! @ @<<1STARTUP.WK4>>E:C35..E:C35 ! ' Material ! 'Overtime Limit - !
?<<1STARTUP.WK4>>E:G33..E:G33 - ! ?<<1STARTUP.WK4>>E:G34..E:G34 " ' Workers/supervisor - " @<<1STARTUP.WK4>>E:C36..E:C36 " ' Quarter " " " 'Overtime Premium - "
<<1STARTUP.WK4>>E:E33..E:E33 - " <<1STARTUP.WK4>>E:E34..E:E34 " # 'Beginning Inventories # ' On hand # @* - # @<<1STARTUP.WK4>>C:B75..C:B75 - # @<<1STARTUP.WK4>>C:C75..C:C75 #
"Through Qtr # @ $ "X - $ @<<1STARTUP.WK4>>C:B71..C:B71 $ ' Ordered $ @ - $
@<<1STARTUP.WK4>>C:B79..C:B79 - $ @<<1STARTUP.WK4>>C:C79..C:C79 $ 'Labor Supply curves $
'Cumul Production % "Y - % <<1STARTUP.WK4>>C:C71..C:C71 % ' Desired Buffer % % % 'Industry slope = - %
ףp=
ף?<<1STARTUP.WK4>>F:E38..F:E38
% '/worker %
"X - % @<<1STARTUP.WK4>>C:B86..C:B86 & "Z - & @<<1STARTUP.WK4>>C:D71..C:D71 & ' Storage Cost/Unit - & Q ?<<1STARTUP.WK4>>E:C39..E:C39 - & GzG?<<1STARTUP.WK4>>E:D39..E:D39 & 'Indiv Firm slope = - &
ףp=
ף?<<1STARTUP.WK4>>F:E39..F:E39
& '/worker &
"Y - & @<<1STARTUP.WK4>>C:B87..C:B87 ' "Total ' @$ & P ' ' Order Cost/Order - ' @<<1STARTUP.WK4>>E:C38..E:C38 - ' @<<1STARTUP.WK4>>E:D38..E:D38 ' ' Intercept = # '
@ %
'
"Z - ' D@<<1STARTUP.WK4>>C:B88..C:B88 ( 'LABOR FORCE POLICY SUMMARY
( "Quarter ) @ ) @) ) @) ) @) ) 'hirecost ) W9v @u )
tV@u ) Q @u ) S㥛 @u * 'End of Qtr * @# S *
/ . . T! Dream on! Overtime can't exceed 50%! ; * * W9v @ *
n@ * * + 'Labor Force was = - + @<<1STARTUP.WK4>>C:B83..C:B83 + Zd;@ +
Gz@ + + % , 'Labor Force Policy Alternatives , 'Number of Workers , ,
v@ , , - ' 1 - Fixed Labor Force - - @- - @- - @- . '% Overtime . ^'Ο?j . %z?j . j . j
. '# hired . @f g .
@f g . @f g . @f g / ' 2 - Fixed OT % / 2 / @} / @} / } / } / @{ | /
@{ | / { | / { | 0 ' 3 - Minimum OT 0 @ 0 @@ 0 0 0 @ 0
@ 0 0 1 ' 4 - Maximum OT 1 1 @ 1 @ 1 1 1 1
@ 1 1 > 2 r|
- 1 Fixed Labor Force too small! ; 2 3 'Cumulative Cost 000's 3 'o/t prem . 3 s Ki n p P . 3
s Ki n p P . 3 s Ki n p P . 3 s Ki n p P 4 ' 1 - Fixed Labor Force 4 ^ D1
@w 4 ~Kn! @w 4 ,L@ @w 4 "6;Ef @w - 4 K~ P - 4
K~ P - 4 K~ P - 4 K~ P 5 ' 2 - Fixed OT % 5
ףp=
ף?/ 5 ^ D1
@ 5 O~8Ǚ @ 5 O~8 @ 5 ' 5 K ' 5
K ' 5 K ' 5 K 6 ' 3 - Minimum OT 6 MbX9
@ 6 ˡE @ 6 ˡE @ 6 - 6 ɿ K P - 6
K P - 6 K P - 6 K P 7 ' 4 - Maximum OT 7 ?1 7 @Ћ
@ 7 ?:!" @ 7 ?:!r @ 7 8 'hire+prem 8 W9v @) 3 8
tV@)
3
8 Q @) 3 8 S㥛 @) 3 9 'Idle Hours 9 W9v @* 4 9
n@*
4
9 * 4 9 * 4 : ' 1 - Fixed Labor Force : q : q : @q : @q : Zd;@+ 5 :
Gz@+
5
: + 5 : + 5 ; ' 3 - Minimum OT ; V%@ ; ,R@ ; ; ; ɿ, 6 ;
v@,
6
; , 6 ; , 6 < 'MATERIAL SUMMARY < ' Material Units = ' Quarter = "Matl 1 = "Matl 2 > 'Inventory End of Quarter > @$ * > @# $
? * > @# $ ? >
"O/T
> "Attr ? 'Min Spec Order Quarter ? @> A ?
# $
# $ ; A ? # $
# $ ; ?
^'Ο?j ? ?l @ 'Minimum Order now for Qtr @ @ # @ 4
@%
> # @ 4@% > @
%z?j @ ?l A "Number of A ' Matl 1 A ' Matl 2 A ' Matl 1 A ' Matl 2 A
j A ?l B "Orders B "Units/Ordr
B "Cost B "Units/Ordr
B "Cost B "Carr Cost B "Ord Cost B "Carr Cost B "Ord Cost B
j B ?l / C
C C N S======> ; C C C 4
@ @ C
? C ̜ @C C / C {
C C N S======> ; C C 4@ @ C
? C @C C C @ & C C @ ' C C Ѳ @ & C C @ ' C C
^'Ο? C ? / D
D C N S======> ; D D D 4 @ @ D
? D @ @D D / D |
D C N S======> ; D D 4
@ @ D
? D 1
@D D D @ & D D @ ' D D Ѳ
@ & D D @ ' D D
UG? D k׆&T? / E
E C N S======> ; E E E x @ @ E
? E ffffff
@E E / E |
E C N S======> ; E E x
@ @ E
? E ffffffƹ
@E E E ffffff
@ & E E @ ' E E l @ & E E @ ' E E
E / F
F C N S======> ; F F F 8 @ @ F
? F zG
@F F / F |
F C N S======> ; F ======> F 4 @ @ F
? F (
@F F F zG
@ & F F @ ' F F Ѳ @ & F F @ ' F F
F / G µ
G C N S======> ; G ======> G
G @ @ G
? G p=
ף0
@G G / G "|
G C N S======> ; G G @ @ G
? G
ףp=
w
@G G G GzG @ & G G @ ' G G Gz @ & G G @ ' G G
G [琚? / H ̵
H C N S======> ; H H H x @ @ H
? H 333333+
@H H / H ,|
H C N S======> ; H H x @ @ H
? H 333333
@H H H ffffff @ & H H
@ ' H H l@ & H H
@ ' H H
H aݢv ; I I I ؍ @ @ I
? I >
ףp=
@I I / I 6|
I C N S======> ; I I 8 @ @ I
? I (\f
@I I I {Gz @ & I I P
@ ' I I =
ףp=Z@ & I I P
@ ' I I
I / J
J C N S======> ; J J J 0
@ @ J
? J \(\
@J J / J @|
J C N S======> ; J J 8 @ @ J
? J HzG5
@J J J Q @ & J J
@ ' J J Q ղ@ & J J
@ ' J J
J / K
K C N S======> ; K K K
@ @ K
? K ffffff @K K / K J|
K C N S======> ; K K @ @ K
? K l
@K K K 333333s@ & K K
@ ' K K 333333@ & K K
@ ' K K
ޏPQg? K >e9X? / L
L C N S======> ; L L L
@ @ L
? L )\( @L L / L T|
L C N S======> ; L L @ @ L
? L (\р @L L L GzG@ & L L
@ ' L L Gz@ & L L
@ ' L L
OD ? L (\? / M
M C N S======> ; M M M
@ @ M
? M
ףp=
@M M / M ^|
M C N S======> ; M M ȓ @ @ M
? M Q I @M M M Q Q@ & M M
@ ' M M )\( @ & M M
@ ' M M
M / N
N C N S======> ; N N N
@ @ N
? N ףp=
ף @N N / N h|
N C N S======> ; N N x @ @ N
? N @N N N Q @ & N N @ ' N N l@ & N N @ ' N N
N P 'REPAIR FORCE ANALYSIS
P "QUARTER P @ Q ' Assumptions: Q fffffff @ Q 'DT Hrs saved per man Q ' Repair Wage R L
F%u? R 'Fraction Potential DT - R zGz@<<1STARTUP.WK4>>C:D64..C:D64 R 'Graphs R '/gnu{?}~{esc}{esc} S ' Potential Downtime = ( S n@R
? S 'hours T "Extra
T "Idle
T "Idle U 'Number of
U "Percent U "Hours U "Repairman U "Worker V 'Repairmen V "Util. V "Downtime V "Saved
V "Cost
V "Cost W @X ? W @W Q S S Q W ; ; W 433333 @ S Q W S Q W
; ; W W Q S
W Q S ; 6 W W
W Q R ; W M"Ȗ@W X @Y ? X @X Q S S Q X ; ; X < @ S Q X S Q X
; ; X X Q S
X Q S ; 6 X X
X Q R ; X V!@X Y @Z ? Y @Y Q S S Q Y ; ; Y 833333 @ S Q Y S Q Y
; ; Y Y Q S
Y Q S ; 6 Y Y
Y Q R ; Y 5$@Y Z @[ ? Z @Z Q S S Q Z ; ; Z 033333
@ S Q Z S Q Z
; ; Z Z Q S
Z Q S ; 6 Z Z
Z Q R ; Z Cl
@Z [ @\ ? [ @[ Q S S Q [ ; ; [ @ S Q [ S Q [
; ; [ [ Q S
[ Q S ; 6 [ [
[ Q R ; [ W @[ ! \ @S Q {" ? \ x!s@\ Q S S Q \ ; ; \ S Q \ S Q \
; ; \ @\ Q S
\ Q S ; 6 \ Z @\
\ Q R ; \ \ ] @\ ? ] -jJ@] Q S S Q ] ; ; ] S Q ] S Q ]
; ; ] `fffff
@] Q S
] Q S ; 6 ] / @]
] Q R ; ] ] ^ @] ? ^ D{x@^ Q S S Q ^ ; ; ^ S Q ^ S Q ^
; ; ^ \ @^ Q S
^ Q S ; 6 ^ LUUUU @^
^ Q R ; ^ ^ _ @^ ? _ i/v@_ Q S S Q _ ; ; _ S Q _ S Q _
; ; _ `fffff @_ Q S
_ Q S ; 6 _ 凘
@_
_ Q R ; _ _ ` @_ ? ` q q@` Q S S Q ` ; ; ` S Q ` S Q `
; ; ` @` Q S
` Q S ; 6 `
@`
` Q R ; ` ` a @` ? a zz@a Q S S Q a ; ; a S Q a S Q a
; ; a @a Q S
a Q S ; 6 a
@a
a Q R ; a a c <@7" c n <@7 ! d 'OPTION 1 - FIXED LABOR QTR d @ d @d d @d d @d e 'Beginning Labor Force e @ + e @h k " e @h k " e @h k " f "Number hired = f @-
h e
h e
;; = f @-
h e
h e
;; = f @-
h e
h e
;; = f @-
h e
h e
;; g 'Number laid off = g -
h e
e h
;; = g -
h e
e h
;; = g -
h e
e h
;; = g -
h e
e h
;; h "Total h @ - h @ - h @ - h @ - i 'Wage Rate + i Q @ h &
+ i @ h &
+ i @ h &
+ i ̰@ h &
j 'Percent Overtime + j ^'Ο?n o p m + j %z?n o p m + j n o p m + j n o p m k 'Attrition H k @ j j j h
? H k @ j j j h
? H k @ j j j h
? H k @ j j j h
? l '% Attrition l ?k h l ?k h l ?k h l ?k h m "R/T hours avail m @h
m @h
m @h
m @h
n "O/T hours low premium T n Bs; @
m
!
m
m !
m ;; T n @wMj @ m
!
m m !
m ;; T n m
!
m m !
m ;; T n
m
!
m
m !
m ;; o "O/T hours high premium j o n !
m
! m
m n ! !
m ;; j o n !
m
! m m n ! !
m ;; j o n !
m
! m m n ! !
m ;; j o n !
m
! m
m n ! !
m ;; p ' Excess Overtime Hours G p
! m
m n o ; G p ! m
m n o ; G p ! m
m n o ; G p
! m
m n o ; q ' Idle Hours * q n
m
; * q n
m ; * q @n
m ; * q @n
m
; r 'R/T wages r "$1,000'S r .ۈ
@m i K r Gz
@m i K r Gz
@m i K r p=
ף @m i K s 'O/T wages S s cDlݪ@i n "
o " p " K S s k~@i n "
o " p " K S s i n "
o " p " K S s i n "
o " p " K t 'Supervisory 2 t @ ! h " " K 2 t @ ! h " " K 2 t @ ! h " " K 2 t @ ! h " " K u 'Hiring/Training . u W9v @f
f
;K . u tV@f
f
;K . u Q @f
f
;K . u S㥛 @f
f
;K v "Total labor v ^ D1
@r u P v v38
@r u P v (\
@r u P v x& @r u P w 'Cumulative cost w ^ D1
@v w ~Kn! @v w w ,L@ @v w w "6;Ef @v w ) x 'OPTION 2 - FIXED OVERTIME % REGULAR x
ףp=
ף? /
y "QUARTER y @ y @y y @y y @y z 'Beginning Labor Force z @ + z @} z @} z } z "$/hour z O@v
z
3mi ƞ@v z v z v
z
'fixed men { "Number hired 1 { @} z
} z
; 1 { @} z
} z
; 1 { } z
} z
; 1 { } z
} z
; { O@
{
OF
@ { {
{
'fixed % | 'Number laid off 1 | } z
z }
; 1 | } z
z }
; 1 | @} z
z }
; 1 | } z
z }
; | z :[@
|
K L=ў@ | |
|
'min o/t } "Total 2 } @
x
" 2 } @ x
" 2 } x
" 2 }
x
" } oMB@
}
R"&TE@ } }
}
'max o/t ~ 'Wage Rate + ~ Q @ } &
+ ~ gffffff@ } &
+ ~ 4333333@ } &
+ ~ @ } &
'Percent Overtime + ^'Ο? + UG? + + 'Attrition H @ }
? H @ }
? H }
? H }
? '% Attrition ? } k׆&T? } } } "R/T hours avail @}
@}
}
}
"O/T hours low premium T Bs; @
!
!
;; T ;ަ[5 @
!
!
;; T
!
!
;; T
!
!
;; "O/T hours high premium j !
!
! !
;; j !
! ! !
;; j !
! ! !
;; j !
!
! !
;; ' Excess Overtime Hours G
!
; G !
; G !
; G
!
; 'R/T wages "$1,000'S .ۈ
@ ~ K (\v
@ ~ K ~ K ~ K 'O/T wages S cDlݪ@~ "
" " K S -Gjׂ#@~ "
" " K S ~ "
" " K S ~ "
" " K 'Supervisory 2 @ ! } " " K 2 @ ! } " " K 2 @ ! } " " K 2 @ ! } " " K 'Hiring/Training . W9v @{
{
;K . n@{
{
;K . {
{
;K . {
{
;K "Total labor ^ D1
@ P @l@
@ P @ P P 'Cumulative cost ^ D1
@ O~8Ǚ @ O~8 @ ! 'OPTION 3 - MINIMUM OVERTIME
"QUARTER @ @ @ @ 'Beginning Labor Force @ + @ @ "Number hired 1 @
; 1 @
; 1
; 1
; 'Number laid off 1
; 1
; 1 @
; 1
; "Total K @
" +
" + ; & @@
" &
" &
" 'Wage Rate + Q @ &
+ 4333333@ &
+ 4333333@ &
+ @ &
'Percent Overtime 'Attrition H @
? H @
? H
? H
? '% Attrition [琚? aݢve9X? (\? "R/T hours avail @
@
"O/T hours low premium T @
!
!
;; T @
!
!
;; T
!
!
;; T
!
!
;; "O/T hours high premium j Pޣ@ !
!
! !
;; j V@ !
! ! !
;; j !
! ! !
;; j !
!
! !
;; ' Excess Overtime Hours G
!
; G !
; G !
; G
!
; 'R/T wages "$1,000'S _L @ K 433333 @ K K K 'O/T wages S *E@ "
" " K S OK'r@ "
" " K S "
" " K S "
" " K 'Supervisory 2 @ ! " " K 2 @ ! " " K 2 @ ! " " K 2 @ ! " " K 'Hiring/Training .
;K . v@
;K .
;K .
;K "Total labor @Ћ
@ P G 5tD
@ P @ P P 'Cumulative cost @Ћ
@ ?:!" @ ?:!r @ - U _ Arial Arial Arial Times New Roman Times New Roman Times New Roman Times New Roman Symbol
O 4!* d 5
f # $ Graphs \G f # U Finne & Churchill
<
" Doc Info Author Doc Info Creation Date Doc Info Editing Time Doc Info Last Revision Date Doc Info Object Doc Info Property Doc Info Revisions Count FM3 FM3 Property WK3 WK3 Property
w
s f
b
7 '
I CMHdr