Question
In: Operations Management
Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 19 23...
|
Month |
Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
|
Sales |
19 |
23 |
15 |
14 |
13 |
16 |
15 |
17 |
19 |
20 |
20 |
23 |
Using a method of trend projection, the forecast for the next month (Jan) =
nothing
sales (round your response to two decimal places).
Solutions
Expert Solution
Month period(X) sales(Y) XY X^2(square of X)
Jan. 1 19 19 1
Feb 2 23 46 4
Mar 3 15 45 9
Apr 4 14. 56. 16
May. 5. 13. 65. 25
June. 6. 16. 96. 36
July. 7. 15. 105. 49
Aug. 8. 17. 136. 64
Sept. 9. 19. 171. 81
Oct. 10. 20. 200. 100
Nov. 11. 20. 220. 121
Dec. 12. 23. 276. 144
X = 1+2+3+4+5+6+7+8+9+10+11+12 =
78
Y = 19+23+15+14+13+16+15+17+19+20+20+23 =
214
XY =
19+46+45+56+65+96+105+136+171+200+220+276 = 1435
X^2 = 1+4+9+16+25+36+49+64+81+100+121+144 =
650
Number of periods = n = 12
X-bar =
X/n = 78/12 = 6.5
Y-bar =
Y/n = 214/12 = 17.83
b = [
XY - (n. X-bar. Y-bar)] / [ X^2 - (n. Square of X-bar)]
= [1435 - (12 x 6.5 x 17.83333333)] / [650 - (12 x 6.5 x 6.5)]
= (1435 - 1391)/(650-507)
= 44/143
= 0.31
a = Y-bar - (b. X-bar) = 17.83333333 - (0.31 x 6.5) = 17.83333333-2.015 = 15.82
So the regression equation is Y = a+bx => Y = 15.82+0.31x
Where x = sequential number of the year.
January is period 13. So for January,value of x = 13.so the forecast for January = 15.82+0.31x = 15.82+(0.31x13) = 15.82+4.03 = 19.85
keosha answered 6 months agoRelated Solutions
AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE jan feb mar apr may jun jul aug...
AVERAGE EMPLOYMENT LEVELS FOR SEAT OF KNOWLEDGE
jan
feb
mar
apr
may
jun
jul
aug
sep
oct
nov
dec
machine/fabricating
47
47
50
49
51
51
52
51
51
50
52
53
shipping/recieving
24
23
25
25
25
23
24
24
24
24
24
24
welding
30
31
34
34
33
32
32
33
33
38
43
43
paint/assembly
26
30
30
30
29
36
34
33
36
37
36
35
TURNOVER
Date
Department Reason
04/12
Machining/Fabricating
Other...
Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Profit ($) 5,700 5,453 5,034 4,717...
Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12
Sep-12
Profit ($) 5,700 5,453 5,034 4,717 5,185 5,638 6,519 6,182
5,913
Step 2 of 5: What are the MAD, MSE and MAPE scores for the
three-period moving average? Round any intermediate calculations,
if necessary, to no less than six decimal places, and round your
final answer to one decimal place.
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of...
Dynamic Futon forecasts the following purchases from
suppliers:
Jan.
Feb.
Mar.
Apr.
May
Jun.
Value of goods ($ millions)
32
28
25
22
20
20
a. Forty percent of goods are supplied
cash-on-delivery. The remainder are paid with an average delay of
one month. If Dynamic Futon starts the year with payables of $22
million, what is the forecasted level of payables for each month?
(Do not round intermediate calculations. Enter your answers
in millions rounded to 1 decimal place.)...
Finish the following Cash Budget CASH BUDGET JAN FEB MAR APRIL MAY JUNE JULY AUG SEPT...
Finish the following Cash Budget
CASH BUDGET
JAN
FEB
MAR
APRIL
MAY
JUNE
JULY
AUG
SEPT
OCT
NOV
DEC
SALES
200,000
230,000
150000
210,000.00
220,000.00
170,000.00
160,000.00
150,000.00
180,000.00
210,000.00
220,000.00
210,000.00
COLLECTIONS:
No cash Sales
30 days
50%
60 days
50%
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
SUPPLIES
70%
PAYABLES/SUPPLIES
paid next month(in 30 days)
SALARIES/OVER
monthly
40000
INTEREST
monthly
1000
DIVIDENDS
monthly
1000
TAXES
quarterly
1200
TOTAL DISBURSEMENT
42000
0
1200
0
0
0
0
0
0
0
0...
The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr...
The monthly sales for Yazici Batteries, Inc., were as
follows:
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sept
Oct
Nov
Dec
Sales
21
21
15
12
11
16
16
18
22
21
20
24
This exercise contains only parts b and c.
b) The forecast for the next month (Jan) using the naive
method =
nothing
sales (round your response to a whole number).
The forecast for the next period (Jan) using a 3-month moving
average approach...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data:
Monthly Profit of a Gym
Month
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Profit ($)
6,150
5,903
5,304
5,077
5,320
5,998
7,419
6,299
6,012
Step 1 of 5:
Determine the three-period moving average for the next time
period. If necessary, round your answer to one decimal place.\
Step 2 of 5:
What are the MAD, MSE and MAPE scores for the three-period
moving average? Round any intermediate calculations, if necessary,
to no less than...
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data:
Monthly Profit of a Gym
Month
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Profit ($)
5,650
5,403
5,004
4,677
5,170
5,598
6,419
6,169
5,903
Step 2 of 5:
What are the MAD, MSE and MAPE scores for the three-period
moving average? Round any intermediate calculations, if necessary,
to no less than six decimal places, and round your final answer to
one decimal place.
Consider the following data: Monthly Profit of a Gym Month Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
Consider the following data:
Monthly Profit of a Gym
Month
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Profit ($)
6,500
6,253
5,514
5,357
5,425
6,278
8,119
6,390
6,090
Step 1 of 5:
Determine the three-period moving average for the next time
period. If necessary, round your answer to one decimal place.
Step 2 of 5:
What are the MAD, MSE and MAPE scores for the three-period
moving average? Round any intermediate calculations, if necessary,
to no less than...
ASAP!!!!!!!!! The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr...
ASAP!!!!!!!!!
The monthly sales for Yazici Batteries, Inc., were as follows:
Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 21 21
15 15 11 18 16 18 19 20 23 22 This exercise contains only parts b
and c.
b) The forecast for the next month (Jan) using the naive
method = 22 sales (round your response to a whole number). The
forecast for the next period (Jan) using a 3-month moving average
approach...
Date Sales (000,000) Sep-12 206 Oct-12 245 Nov-12 185 Dec-12 169 Jan-13 162 Feb-13 177 Mar-13...
Date
Sales (000,000)
Sep-12
206
Oct-12
245
Nov-12
185
Dec-12
169
Jan-13
162
Feb-13
177
Mar-13
207
Apr-13
216
May-13
193
Jun-13
230
Jul-13
212
Aug-13
192
Sep-13
162
Oct-13
189
Nov-13
244
Dec-13
209
Jan-14
207
Feb-14
211
Mar-14
210
Apr-14
173
May-14
194
Jun-14
234
Jul-14
156
Aug-14
206
Sep-14
188
Oct-14
162
Nov-14
172
Dec-14
210
Jan-15
205
Feb-15
244
Mar-15
218
Apr-15
182
May-15
206
Jun-15
211
Jul-15
273
Aug-15
248
Sep-15
262
Oct-15
258
Nov-15...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A room with 2.7-m-high ceilings has a metal plate on the floor with V = 0V...
- which of the following statements are true? a) the same nuclear changes (creation/destruction of specific nucleons)...
- Overview: Advances in technology have impacted many facets of the auditing process, from assessing risk and...
- Background: This course is all about data visualization. However, we must first have some understanding about...
- A rescue helicopter lifts a 70.6-kg person straight up by means of a cable. The person...
- Dolomite, [CaMg(CO3)2] is found in a soil sample. A geochemist titrates 24.65 g of soil with...
- 4) Cost per equivalent unit of direct materials and conversion (4 marks) The cost per equivalent...
ADVERTISEMENT