The accounting department needs to forecast the profit for a subsidiary. The data for several months...

The accounting department needs to forecast the profit for a subsidiary. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing with trend accounting for seasonality given a smoothing constant (alpha) of 0.69, a trend smoothing constant (delta) of 0.3, a previous trend amount, seasonally adjusted, of 65, and a previous seasonal forecast of 582. Please round your forecast to the nearest whole number.

Jul 2020: 544	Jun 2020: 274	May 2020: -1684	Apr 2020: 1439	Mar 2020: 970	Feb 2020: -1689
Jan 2020: 340	Dec 2019: 253	Nov 2019: 1631	Oct 2019: 257	Sep 2019: -660	Aug 2019: 582
Jul 2019: 2258	Jun 2019: 945	May 2019: 2580	Apr 2019: 704	Mar 2019: -1884	Feb 2019: 1902
Jan 2019: 1477	Dec 2018: 2141	Nov 2018: -778	Oct 2018: 1609	Sep 2018: -1625	Aug 2018: 1187
Jul 2018: 2959	Jun 2018: -653	May 2018: -16	Apr 2018: 2132	Mar 2018: -979

Solutions

Expert Solution

Answer:

_{Formula’s
used}:

F_t+1 = α*D_t + (1-α)*F_t

T_t+1 = δ*(F_t+1-F_t) + (1-δ)*(T_t)

AF_t+1 = F_t+1 + T_t+1

Where,

F_t+1 = Unadjusted Forecast for current period

D_t= Sales for previous period

F_t= Forecast for previous period

T_t+1 = Trend factor for current period

T_t = Trend factor for previous period

AF_t+1 = Adjusted forecast for current period

Final forecast required is shown as “Adjusted Forecast in the last column of below table:

	α =	0.69
	δ =	0.3

Month (t)	Profit (Dt)	Seasonal Forecast (Ft)	Trend factor (Tt)	Adjusted Forecast (AF)
				AF = Ft+Tt
Mar-18	979	582	65	647
Apr-18	2132	855.930	127.679	984
May-18	-16	1736.418	353.522	2090
Jun-18	-653	527.250	-115.285	412
Jul-18	2959	-287.123	-325.011	-612
Aug-18	1187	1952.702	444.440	2397
Sep-18	-1625	1424.368	152.608	1577
Oct-18	1609	-679.696	-524.394	-1204
Nov-18	-778	899.504	106.684	1006
Dec-18	2141	-257.974	-272.565	-531
Jan-19	1477	1397.318	305.792	1703
Feb-19	1902	1452.299	230.549	1683
Mar-19	-1884	1762.593	254.473	2017
Apr-19	704	-753.556	-576.714	-1330
May-19	2580	252.158	-101.986	150
Jun-19	945	1858.369	410.473	2269
Jul-19	2258	1228.144	98.264	1326
Aug-19	582	1938.745	281.965	2221
Sep-19	-660	1002.591	-83.471	919
Oct-19	257	-144.597	-402.586	-547
Nov-19	1631	132.505	-198.680	-66
Dec-19	253	1166.467	171.113	1338
Jan-20	340	536.175	-69.309	467
Feb-20	-1689	400.814	-89.125	312
Mar-20	970	-1041.158	-494.979	-1536
Apr-20	1439	346.541	69.824	416
May-20	-1684	1100.338	275.016	1375
Jun-20	274	-820.855	-383.847	-1205
Jul-20	544	-65.405	-42.058	-107

Excel working is shown below:

keosha answered 9 months ago

Next > < Previous

Related Solutions

The purchasing and supply department needs to forecast the number of tubes of adhesive being ordered....

The purchasing and supply department needs to forecast the number of tubes of adhesive being ordered. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is exponential smoothing accounting for seasonality with a smoothing constant of 0.35 and a previous forecast (with seasonality) of 635. Please round your forecast to the nearest whole number. Jul 2020: 588 Jun 2020: 508 May 2020:...

The human resources department needs to forecast the number of sexual harassement investigations for the entire company.

The human resources department needs to forecast the number of sexual harassement investigations for the entire company. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the 4 month weighted moving average adjusting for seasonality where the weights, starting with the most recent time period, are 0.4, 0.3, 0.2, 0.1. Again, you must find the seasonality factors for the data....

A manufacturing area needs to forecast workhours. This is a slightly different project. The data for...

A manufacturing area needs to forecast workhours. This is a slightly different project. The data for several months is supplied below. Beside each of the actual numbers in black, the forecast is provided in red. The goal is to calculate three stats on the data: MAD, MAPE, and the tracking signal. Be careful since the data is listed beginning with the most recent. Please round to two decimal places. For MAPE, please convert to a percentage before rounding. Do not...

The following data represent the profit in thousands over the last 60 months, of an SME...

The following data represent the profit in thousands over the last 60 months, of an SME 142 123 109 124 142 117 108 106 103 114 91 102 108 110 83 90 69 117 84 122 113 105 112 117 122 129 100 138 99 106 102 115 120 120 117 122 111 119 109 125 108 116 105 117 114 101 99 112 120 108 91 115 105 99 122 106 113 114 75 96 (a) Make a frequency...

Data from the duplicating department of Fastcopy Ltd for the 5 months are as follow: Month...

Data from the duplicating department of Fastcopy Ltd for the 5 months are as follow: Month #Copies Dept Costs January 14,800 $12,830 February 16,000 13,930 March 20,000 17,300 April 23,600 19,430 May 18,500 15,800 What are the expected duplicating department costs for June if 19,000 copies are expected to be made? $15,858 $15,980 $16,216 $18,580

After analysing several months of sales data, the owner of an appliance store produced the following...

After analysing several months of sales data, the owner of an appliance store produced the following joint probability distribution of the number of refrigerators (x) and stoves (y) sold daily. Refrigerators (x) Stoves (y) 0 1 2 0 0.08 0.14 0.12 1 0.09 0.17 0.13 2 0.05 0.18 0.04 a Find the marginal probability distribution of the number of refrigerators sold daily. b Find the marginal probability distribution of the number of stoves sold daily. c Compute the mean and...

Based on data that was collected over the past several months, the average time between arrivals...

Based on data that was collected over the past several months, the average time between arrivals to the Emergency Room on a Monday between the hours of 7am to 7pm is 35min. Emergencies occur at random, and hence the arrival of patients to the Emergency Room follows a purely random process. What probability distribution would you use to model the time between patient arrivals? Suppose a patient just arrived, what is the probability the next patient will arrive in less...

After analyzing several months of sales data, the owner of an appliance store produced the following...

After analyzing several months of sales data, the owner of an appliance store produced the following joint probability distribution of the number of refrigerators and stoves sold hourly 0 1 2 Stoves 0 0.08 0.14 0.12 0.34 1 0.09 0.17 0.13 0.39 2 0.05 0.18 0.04 0.27 REF 0.22 0.49 0.29 1 b. What are the laws for a discrete probability density function? c. If a customer...

Work in Process Account Data for Two Months; A report prepared periodically by a processing department,...

Work in Process Account Data for Two Months; A report prepared periodically by a processing department, summarizing (1) the units for which the department is accountable and the disposition of those units and (2) the costs incurred by the department and the allocation of those costs between completed and incomplete production.Cost of Production Reports Pittsburgh Aluminum Company uses a A type of cost system that accumulates costs for each of the various departments within a manufacturing facility.process cost system to...

8-17. Listed below are several types of accounting data to be coded. For each data item,...

8-17. Listed below are several types of accounting data to be coded. For each data item, recommend a type of code (mnemonic, sequence, block, or group) and support your choice. a. Employee identification number on a computer file b. Product number for a sales catalog c. Inventory number for the products of a wholesale drug company d. Inventory part number for a bicycle manufacturing company e. Identification numbers on the forms waiters and waitresses use to take orders f. Identification...

Subjects