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.

Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

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.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
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.

Ask a Question
ADVERTISEMENT