This is Quantitative Decision Making for Business.

profileShelby4
ExcelDatafileforFinal.xlsx
Home>Business & Finance homework help>Operations Management homework help>This is Quantitative Decision Making for Business.

Q5

Activity Preceding Activity Expected Completion Time
(half months)
A - Write book - 22
B - Design book A 2
C - Edit manuscript A 12
D - Check editing C 4
E - Accept design B 2
F –Copy edit D, E 4
G – Prepare artwork D, E 8
H – Accept and correct artwork G 1
I – Set galleys F 8
J – Check and correct galleys I 2
K – Pull page proofs H, J 4
L – Check and correct pages K 2
M- Prepare index K 2
N – Set and correct index M 1
O – Check camera-ready copy L, N 1
P – Print and bind book O 4

Q6

Month Seasonal Factor Year Month Actual (Nominal) Value
Initial Seasonally Adjusted Forecast 78 α 25%
Initial Trend Estimate 0 β 20%
Jan 0.90 1 Jan 68
Feb 0.88 1 Feb 71
Mar 0.91 1 Mar 66
Apr 0.93 1 Apr 72
May 0.96 1 May 77
June 1.09 1 June 85
July 1.17 1 July 94
Aug 1.15 1 Aug 96
Sep 0.97 1 Sep 80
Oct 0.91 1 Oct 73
Nov 1.05 1 Nov 84
Dec 1.08 1 Dec 89
Jan 0.90 2 Jan 75
Feb 0.88 2 Feb 76
Mar 0.91 2 Mar 81
Apr 0.93 2 Apr 84
May 0.96 2 May 85
June 1.09 2 June 99
July 1.17 2 July 107
Aug 1.15 2 Aug 108
Sep 0.97 2 Sep 94
Oct 0.91 2 Oct 90
Nov 1.05 2 Nov 106
Dec 1.08 2 Dec 110
Type of Seasonality
Monthly
1.0 #REF! 1.0 #REF!

Time Period

Seasonally-Adjusted Value

Q7

Activities \ Days 0 1 2 3 4 5 6 7 8
Activity 1 5 22 36 48 52 55 58 60 61
Activity 2 22 30 37 44 49 54 58 60 61
Activity 3 46 52 56 59 62 65 67 68 69
Activity 4 30 40 48 55 59 62 64 66 67

Q8

Fashion Line Jorge Vera (avant-garde) Paolo Ricci (business attire)
Net cost of San Fransisco pre-test $200,000 $75,000
Additional cost of U.S. production of line after a San Francisco pre-test $500,000 $275,000
Cost of U.S. production if not pre-tested in San Francisco $600,000 $325,000
Revenue if fashion line is a "hit" $4,300,000 $2,400,000
Revenue if fashion line is a "miss" $300,000 $100,000