QUESTION E The sales of a factory, manufacturing bicyles, over the last 24 months were as...

QUESTION E

The sales of a factory, manufacturing bicyles, over the last 24 months were as follows:

MONTH	UNITS SOLD
1	1140
2	1180
3	1130
4	1180
5	1110
6	1200
7	1280
8	1340
9	1340
10	1240
11	1140
12	1230
13	1440
14	1530
15	1560
16	1350
17	1350
18	1420
19	1530
20	1530
21	1430
22	1430
23	1490
24	1570

It is obvious that the monthly sales are increasing, but it is also obvious to the production manager that he is getting close to his capacity. In fact, should demand exceed 1 600 units a month, the factory would have to be expanded to meet the requirements.

Investigate the possibility, by conventional forecasting methods (in other words, the moving averages) that the figure of 1 600 units will be exceeded in any of the next six months.

Expert Solution

Hello

The excel forecasting moving averages output :

Timeline	Values	Moving Average	Forecast	Lower Confidence Bound	Upper Confidence Bound
1	1140
2	1180	1160
3	1130	1155
4	1180	1155
5	1110	1145
6	1200	1155
7	1280	1240
8	1340	1310
9	1340	1340
10	1240	1290
11	1140	1190
12	1230	1185
13	1440	1335
14	1530	1485
15	1560	1545
16	1350	1455
17	1350	1350
18	1420	1385
19	1530	1475
20	1530	1530
21	1430	1480
22	1430	1430
23	1490	1460
24	1570	1530	1570	1570	1570
25		1617	1664	1542	1786
26		1699	1735	1612	1858
27		1699	1663	1539	1787
28		1649	1635	1510	1760
29		1592	1549	1423	1675
30		1593	1638	1511	1765

And the corresponding Chart: ( I recommend you to first download it and then view it.)

I hope this solves your doubt.

Do give a thumbs up if you find this helpful.

orchestra answered 2 years ago

QUESTION Over the last few months, the Bank of Ghana ( has cracked the whip at...

QUESTION Over the last few months, the Bank of Ghana ( has cracked the whip at the banking industry in a bid to restore sanity in the industry. In August 2017, the UT and Capital Banks were liquidated for failing to meet the bank of Ghana’s minimum capital ratio. The operations of UniBank, Royal Bank, Beige Bank, Sovereign Bank, and Construction Bank ended. In their place the bank of Ghana announced a new bank called the Consolidated Bank, as part...

The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given...

The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given below. Month Sales Month Sales 1 12 8 14 2 14 9 17 3 16 10 12 4 10 11 14 5 15 12 16 6 17 13 11 7 11 a) Use a weighted moving average for three periods to forecast sales for next month. Use a weight of 3 for the most recent period, 2 for the middle period, and 1 for...

If you were given a large data set, such as the sales over the last year...

If you were given a large data set, such as the sales over the last year of our top 100 customers, what might you be able to do with these data? What might be the benefits of describing the data?

Question 1 (24 Marks): Below are the processing costs of Duraseal Products observed over the last...

Question 1 : Below are the processing costs of Duraseal Products observed over the last 10 months: Use the high low method to determine the variable cost per unit and fixed cost per month. Express your results in the form of a linear equation y = a + bx. Month Units Produced Processing Cost 1 9,900 74,000 2 8,200 63,000 3 7,600 61,000 4 7,800 62,000 5 9,000 65,000 6 6,000 60,000 7 8,300 60,000 We assume the linear relation...

A manufacturing company producing medical devices reported $108,000,000 in sales over the last year. At the...

A manufacturing company producing medical devices reported $108,000,000 in sales over the last year. At the end of the same year, the company had $42,000,000 worth of inventory of ready-to-ship devices. a. Assuming that units in inventory are valued (based on COGS) at $2,000 per unit and are sold for $4,000 per unit, what are the annual inventory turns? The company uses a 20 percent per year cost of inventory. That is, for the hypothetical case that one unit of...

QUESTION 2 Over the last few months, the Bank of Ghana (BoG) has cracked the whip...

QUESTION 2 Over the last few months, the Bank of Ghana (BoG) has cracked the whip at the banking industry in a bid to restore sanity in the industry. In August 2017, the UT and Capital Banks were liquidated for failing to meet the BoG’s minimum capital ratio. The operations of UniBank, Royal Bank, Beige Bank, Sovereign Bank, and Construction Bank ended. In their place the BoG announced a new bank called the Consolidated Bank, as part of measures to...

QUESTION 2 Over the last few months, the Bank of Ghana (BoG) has cracked the whip...

QUESTION 2 Over the last few months, the Bank of Ghana (BoG) has cracked the whip at the banking industry in a bid to restore sanity in the industry. In August 2017, the UT and Capital Banks were liquidated for failing to meet the BoG’s minimum capital ratio. The operations of UniBank, Royal Bank, Beige Bank, Sovereign Bank, and Construction Bank ended. In their place the BoG announced a new bank called the Consolidated Bank, as part of measures to...

Sequoia Furniture Company’s sales over the past three months,half of which are for cash, were...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were as follows: March April May $440,000 $690,000 $560,000 a. Assume that Sequoia’s collection period is 60 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May? b. Now assume that Sequoia’s collection period is 45 days. What would be its cash receipts in May? What would be its accounts receivable balance at the...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were as follows: March April May $402,000 $652,000 $522,000 a. Assume that Sequoia’s collection period is 60 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May? b. Now assume that Sequoia’s collection period is 45 days. What would be its cash receipts in May? What would be its accounts receivable balance at the...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were as follows: March $408,000 April $658,000 May $528,000 a. Assume that Sequoia’s collection period is 60 days. What would be its cash receipts in May? What would be its accounts receivable balance at the end of May? - Cash Receipts: ? - Accounts receivable balance:? b. Now assume that Sequoia’s collection period is 45 days. What would be its cash receipts in May? What...

Question

QUESTION E The sales of a factory, manufacturing bicyles, over the last 24 months were as...

Solutions

Expert Solution

Related Solutions

QUESTION Over the last few months, the Bank of Ghana ( has cracked the whip at...

The sales of vacuum cleaners at Lowenthal’s Industrial Supply over the last thirteen months are given...

If you were given a large data set, such as the sales over the last year...

Question 1 (24 Marks): Below are the processing costs of Duraseal Products observed over the last...

A manufacturing company producing medical devices reported $108,000,000 in sales over the last year. At the...

QUESTION 2 Over the last few months, the Bank of Ghana (BoG) has cracked the whip...

QUESTION 2 Over the last few months, the Bank of Ghana (BoG) has cracked the whip...

Sequoia Furniture Company’s sales over the past three months,half of which are for cash, were...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were...

Sequoia Furniture Company’s sales over the past three months, half of which are for cash, were...