Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I calculate/solve for an adjustment factor? Period Year Month Occupancy Nave Forcast 3 Mo. 6 Mo. 9 Mo. Adjustment Factor 1 1989 Jan
How do I calculate/solve for an adjustment factor?
Period | Year | Month | Occupancy | Nave Forcast | 3 Mo. | 6 Mo. | 9 Mo. | Adjustment Factor |
1 | 1989 | Jan | 1697 | 1697 | ||||
2 | 1989 | Feb | 1701 | 1697 | ||||
3 | 1989 | Mar | 2838 | 1701 | ||||
4 | 1989 | Apr | 4182 | 2838 | 2078.67 | |||
5 | 1989 | May | 4756 | 4182 | 2907.00 | |||
6 | 1989 | Jun | 5001 | 4756 | 3925.33 | |||
7 | 1989 | Jul | 5492 | 5001 | 4646.33 | 3362.5 | ||
8 | 1989 | Aug | 5598 | 5492 | 5083.00 | 3995 | ||
9 | 1989 | Sep | 4707 | 5598 | 5363.67 | 4644.5 | ||
10 | 1989 | Oct | 4207 | 4707 | 5265.67 | 4956 | 3996.89 | |
11 | 1989 | Nov | 3424 | 4207 | 4837.33 | 4960.167 | 4275.78 | |
12 | 1989 | Dec | 2372 | 3424 | 4112.67 | 4738.167 | 4467.22 | |
13 | 1990 | Jan | 2636 | 2372 | 3334.33 | 4300 | 4415.44 | |
14 | 1990 | Feb | 1468 | 2636 | 2810.67 | 3824 | 4243.67 | |
15 | 1990 | Mar | 3090 | 1468 | 2158.67 | 3135.667 | 3878.33 | |
16 | 1990 | Apr | 3195 | 3090 | 2398.00 | 2866.167 | 3666.00 | |
17 | 1990 | May | 5191 | 3195 | 2584.33 | 2697.5 | 3410.78 | |
18 | 1990 | Jun | 4722 | 5191 | 3825.33 | 2992 | 3365.56 | |
19 | 1990 | Jul | 5059 | 4722 | 4369.33 | 3383.667 | 3367.22 | |
20 | 1990 | Aug | 5188 | 5059 | 4990.67 | 3787.5 | 3461.89 | |
21 | 1990 | Sep | 4732 | 5188 | 4989.67 | 4407.5 | 3657.89 | |
22 | 1990 | Oct | 3874 | 4732 | 4993.00 | 4681.167 | 3920.11 | |
23 | 1990 | Nov | 3203 | 3874 | 4598.00 | 4794.333 | 4057.67 | |
24 | 1990 | Dec | 1685 | 3203 | 3936.33 | 4463 | 4250.44 | |
25 | 1991 | Jan | 2211 | 1685 | 2920.67 | 3956.833 | 4094.33 | |
26 | 1991 | Feb | 1076 | 2211 | 2366.33 | 3482.167 | 3985.00 | |
27 | 1991 | Mar | 2295 | 1076 | 1657.33 | 2796.833 | 3527.78 | |
28 | 1991 | Apr | 2907 | 2295 | 1860.67 | 2390.667 | 3258.11 | |
29 | 1991 | May | 4168 | 2907 | 2092.67 | 2229.5 | 3019.00 | |
30 | 1991 | Jun | 3479 | 4168 | 3123.33 | 2390.333 | 2905.67 | |
31 | 1991 | Jul | 4425 | 3479 | 3518.00 | 2689.333 | 2766.44 | |
32 | 1991 | Aug | 4633 | 4425 | 4024.00 | 3058.333 | 2827.67 | |
33 | 1991 | Sep | 2976 | 4633 | 4179.00 | 3651.167 | 2986.56 | |
34 | 1991 | Oct | 2974 | 2976 | 4011.33 | 3764.667 | 3130.00 | |
35 | 1991 | Nov | 2148 | 2974 | 3527.67 | 3775.833 | 3214.78 | |
36 | 1991 | Dec | 873 | 2148 | 2699.33 | 3439.167 | 3333.89 | |
37 | 1992 | Jan | 2299 | 873 | 1998.33 | 3004.833 | 3175.89 | |
38 | 1992 | Feb | 1554 | 2299 | 1773.33 | 2650.5 | 3108.33 | |
39 | 1992 | Mar | 1635 | 1554 | 1575.33 | 2137.333 | 2817.89 | |
40 | 1992 | Apr | 2660 | 1635 | 1829.33 | 1913.833 | 2613.00 | |
41 | 1992 | May | 3906 | 2660 | 1949.67 | 1861.5 | 2416.89 | |
42 | 1992 | Jun | 4016 | 3906 | 2733.67 | 2154.5 | 2336.11 | |
43 | 1992 | Jul | 5631 | 4016 | 3527.33 | 2678.333 | 2451.67 | |
44 | 1992 | Aug | 4400 | 5631 | 4517.67 | 3233.667 | 2746.89 | |
45 | 1992 | Sep | 3801 | 4400 | 4682.33 | 3708 | 2997.11 | |
46 | 1992 | Oct | 2571 | 3801 | 4610.67 | 4069 | 3322.44 | |
47 | 1992 | Nov | 1886 | 2571 | 3590.67 | 4054.167 | 3352.67 | |
48 | 1992 | Dec | 1139 | 1886 | 2752.67 | 3717.5 | 3389.56 | |
49 | 1993 | Jan | 1674 | 1139 | 1865.33 | 3238 | 3334.44 | |
50 | 1993 | Feb | 738 | 1674 | 1566.33 | 2578.5 | 3224.89 | |
51 | 1993 | Mar | 2666 | 738 | 1183.67 | 1968.167 | 2872.89 | |
52 | 1993 | Apr | 1836 | 2666 | 1692.67 | 1779 | 2722.89 | |
53 | 1993 | May | 3645 | 1836 | 1746.67 | 1656.5 | 2301.22 | |
54 | 1993 | Jun | 3802 | 3645 | 2715.67 | 1949.667 | 2217.33 | |
55 | 1993 | Jul | 5628 | 3802 | 3094.33 | 2393.5 | 2217.44 | |
56 | 1993 | Aug | 5170 | 5628 | 4358.33 | 3052.5 | 2557.11 | |
57 | 1993 | Sep | 4307 | 5170 | 4866.67 | 3791.167 | 2922.00 | |
58 | 1993 | Oct | 2746 | 4307 | 5035.00 | 4064.667 | 3274.00 | |
59 | 1993 | Nov | 2256 | 2746 | 4074.33 | 4216.333 | 3393.11 | |
60 | 1993 | Dec | 1250 | 2256 | 3103.00 | 3984.833 | 3561.78 | |
61 | 1994 | Jan | 916 | 1250 | 2084.00 | 3559.5 | 3404.44 | |
62 | 1994 | Feb | 1057 | 916 | 1474.00 | 2774.167 | 3302.22 | |
63 | 1994 | Mar | 2512 | 1057 | 1074.33 | 2088.667 | 3014.67 | |
64 | 1994 | Apr | 2576 | 2512 | 1495.00 | 1789.5 | 2871.33 | |
65 | 1994 | May | 3608 | 2576 | 2048.33 | 1761.167 | 2532.22 | |
66 | 1994 | Jun | 3906 | 3608 | 2898.67 | 1986.5 | 2358.67 | |
67 | 1994 | Jul | 5786 | 3906 | 3363.33 | 2429.167 | 2314.11 | |
68 | 1994 | Aug | 4890 | 5786 | 4433.33 | 3240.833 | 2651.89 | |
69 | 1994 | Sep | 4179 | 4890 | 4860.67 | 3879.667 | 2944.56 | |
70 | 1994 | Oct | 2777 | 4179 | 4951.67 | 4157.5 | 3270.00 | |
71 | 1994 | Nov | 2359 | 2777 | 3948.67 | 4191 | 3476.78 | |
72 | 1994 | Dec | 1521 | 2359 | 3105.00 | 3982.833 | 3621.44 | |
73 | 1995 | Jan | 1629 | 1521 | 2219.00 | 3585.333 | 3511.33 | |
74 | 1995 | Feb | 1249 | 1629 | 1836.33 | 2892.5 | 3406.11 | |
75 | 1995 | Mar | 2054 | 1249 | 1466.33 | 2285.667 | 3144.00 | |
76 | 1995 | Apr | 2589 | 2054 | 1644.00 | 1931.5 | 2938.22 | |
77 | 1995 | May | 3790 | 2589 | 1964.00 | 1900.167 | 2583.00 | |
78 | 1995 | Jun | 3793 | 3790 | 2811.00 | 2138.667 | 2460.78 | |
79 | 1995 | Jul | 6074 | 3793 | 3390.67 | 2517.333 | 2417.89 | |
80 | 1995 | Aug | 4905 | 6074 | 4552.33 | 3258.167 | 2784.22 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started