Question
Latest monthly sales for a company are as follows: Month Sales November 81 December 78 January...
Latest monthly sales for a company are as follows:
|
Month |
Sales |
|
November |
81 |
|
December |
78 |
|
January |
73 |
|
February |
98 |
|
March |
Compute a 2-Month Moving Average forecast for March.
Homework Answers
Answer #1
Note: Here, I have taken 86 as the round
off the value of 85.5 since I think, sales should be number as
whole number since a number of sales in a month can't be in decimal
otherewise you may consider actual forecast value of march is
85.5.
Not the answer you're looking for?
Similar Questions
The monthly sales for Yazici Batteries, Inc., were as follows: MONTH SALES January 20 February 21...
The monthly sales for Yazici Batteries, Inc., were as
follows:
MONTH
SALES
January
20
February
21
March
15
April
14
May
13
June
16
July
17
August
18
September
20
October
20
November
21
December
23
Plot the monthly sales data.
Forecast January sales using each of the following:
Naive method.
A 3-month moving average.
A 6-month weighted average using .1, .1, .1, .2, .2, and .3,
with the heaviest weights applied to the most recent months.
Exponential smoothing using...
Topez Service anticipates the following sales revenue over a five-month period: November December January February March...
Topez Service anticipates the following sales revenue over a
five-month period:
November
December
January
February
March
Sales Revenue
$16,200
$10,800
$15,400
$12,200
$14,800
The company's sales are 40% cash and 60% credit.
Its collection history indicates that credit sales are collected
as follows:
25% in the month of the sale
50% in the month after the sale
20% two months after the sale
5% are never collected
How much cash will be collected in January? In February? In
March? For...
It is November 1 of Year 1. Sales for Jude Company for November and December of...
It is November 1 of Year 1. Sales for Jude Company for November
and December of Year 1 and January (of Year 2) are forecasted to be
as follows:
November, 300,000; December 700,000; January, 200,000
100% of sales are credit sales. Of these credit sales, 15% are
collected during the month of sale, 25% in the following month, 50%
in the second following month, and 10% are never collected. Total
sales for September and October of Year 1 were 100,000...
It is November 1 of Year 1. Sales for Corbin Company for November and December of...
It is November 1 of Year 1. Sales for Corbin Company for
November and December of Year 1 and January of Year 2 are
forecasted to be as follows:
November, 400,000; December 600,000; January, 200,000
On average, cost of goods sold is 70% of sales. During this
period, Corbin Company expects inventory levels to remain constant.
This means that inventory purchases are expected to equal the
amount of cost of goods sold.
40% of purchases are for cash. Of the...
It is November 1 of Year 1. Sales for Kadan Company for November and December of...
It is November 1 of Year 1. Sales for Kadan Company for November
and December of Year 1 and January of Year 2 are forecasted to be
as follows:
November, 400,000; December 600,000; January, 200,000
100% of sales are credit sales. Of these credit sales, 5% are
collected during the month of sale, 25% in the following month, and
65% in the second following month; 5% are never collected. Total
sales for September and October of Year 1 were 100,000...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six
months (January – June):
Month
Period
Sales
January
1
16
February
2
25
March
3
20
April
4
20
May
5
31
June
6
35
July
7
26
August
8
(a)
Use this information to answer the following 7
questions:
6.Using January through July values, develop a linear trend
equation for this time series (to 4 decimals). Please write the
equation in the proper form.
7.Using your answer from...
The Ace Battery Company has forecast its sales in units as follows: January 1,500 May 2,050...
The Ace Battery Company has forecast its sales in units as
follows:
January
1,500
May
2,050
February
1,350
June
2,200
March
1,300
July
1,900
April
1,800
Ace always keeps an ending inventory equal to 130 percent of the
next month's expected sales. The ending inventory for December
(January's beginning inventory) is 1,950 units, which is consistent
with this policy.
Materials cost $10 per unit and are paid for in the month after
production. Labour cost is $3 per unit and...
Suppose a company has the following sales for the last six months (January – June): Month...
Suppose a company has the following sales for the last six
months (January – June):
Month
Period
Sales
January
1
16
February
2
25
March
3
20
April
4
20
May
5
31
June
6
35
July
7
26
August
8
(a)
Use this information to answer the following 7
questions:
ques 1 given the information above
1.Use exponential smoothing (a= 0.10) to forecast the sales for
August (to 2 decimals). What is the value?
2. Compute the MSE for...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750...
The Volt Battery Company has forecast its sales in units as
follows: January 2,200 May 2,750 February 2,050 June 2,900 March
2,000 July 2,600 April 2,500 Volt Battery always keeps an ending
inventory equal to 120% of the next month’s expected sales. The
ending inventory for December (January’s beginning inventory) is
2,640 units, which is consistent with this policy. Materials cost
$11 per unit and are paid for in the month after purchase. Labor
cost is $4 per unit and...
It is November 1 of Year 1. Sales for Burt Company for November and December of...
It is November 1 of Year 1. Sales for Burt Company for November
and December of Year 1 and January of Year 2 are forecasted to be
as follows:
November, 300,000; December 700,000; January, 200,000
On average, cost of goods sold is 60% of sales. During this
period, Burt Company expects inventory levels to remain constant.
This means that inventory purchases are expected to equal the
amount of cost of goods sold.
90% of purchases are on credit. Of the...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 5 minutes ago
asked 37 minutes ago
asked 40 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago