MGT 3332


Don't use plagiarized sources. Get Your Custom Essay on
From as low as $9/Page
Order Essay

Highline Financial Service offers three types of service to its client. Freddie Mack (Managing partner) has a data from three categories of services over the past eight quarters. Seem like other company’s factors have not changes “in terms of advertising or promotion, and competition doesn’t change” (Stevenson, William (2011-02-15).  This data will be utilized to estimate demand for each service for the subsequent four quarters using Naive Forecast and Moving Average. Naive forecast “uses a single previous value of a time series as the basis of a forecast. But naïve forecast has one weakness of the naive method is that the forecast just traces the actual data, with a lag of one period; it does not smooth at all.” Stevenson, William (2011-02-15). Moving Average forecast “uses a number of the most recent actual data values in generating a forecast” Stevenson, William (2011-02-15).

As we can see each graph present for each term Highline Financial service provides. I will now analysis the whole graph using forecast. Service A seem to be increase in each quarter, service B seem to be decrease and service C is the most unstable one.

First I will use Naïve Forecast there are three items need to be figured MAD, MSE and MAPE. First step I will used period as a quarter and year like (1,2,3,4,5,6,7,8)  then input the Service A numbers (60,45,100..).  “With seasonal variations, the forecast for this “season” is equal to the value of the series last “season.””Stevenson, William (2011-02-15), so we have (60,45,..) for Naïve forecast. then calculated the Error by using actual (service A)- Naïve Forecast we have (-15,55,-25,..), next used |E| and sum the |E| we have 207. Then we will used Error2 and calculated it sum we have 8775. Then using |E| to calculated MAD=207divide for 7 is equal to 29.57, then calculate MSE=8775 divide for (7-1) is equal 1462.5. last used MAPE (Absolute Percentage Error)for each period |E| divide for ServiceA then sum all the result and divide for 7 (number of error)

Period Service A Forecast Error |E| Error2 Absolute Percentage Error
1 60
2 45 60 -15 15 225 0.33
3 100 45 55 55 3025 0.55
4 75 100 -25 25 625 0.33
5 72 75 -3 3 9 0.125
6 51 72 -21 21 441 0.4117
7 112 51 61 61 3721 0.5446
8 85 112 -27 27 729 0.317
207 8775 2.6089




Second I will use Moving Average to calculate MAD, MSE and MAPE to final compare and find out which method is the best used for this case, like above I will still used period as a quarter and year like (1,2,3,4,5,6,7,8)  then input the Service A numbers (60,45,100,75..).  For Moving average I used the average between 2 numbers. For example with a giving number (60+45) divide for 2 and equal 52.5 I have the second number for Moving Average continue we have (72.5, 87.5, 73.5, ….). Used all the same methods to Error, |E|, and Error^2 and Absolute Percentage Error.

Period Service A Moving Average Error |E| Error^2 Absolute Percentage Error
1 60
2 45 60 -15 15 225 0.33
3 100 52.5 47.5 47.5 2256.25 0.475
4 75 72.5 2.5 2.5 6.25 0.033
5 72 87.5 -15.5 15.5 240.25 0.215
6 51 73.5 -22.5 22.5 506.25 0.441
7 112 61.5 50.5 50.5 2550.25 0.451
8 85 81.5 3.5 3.5 12.25 0.041
Sum 157 5796.5 1.986

MAD = 157/7=22.43

MSE = 5796.5/(7-1)= 966.08

MAPE = 1.986/7=0.284

By compare the MAD, MSE, and MAPE of each method Naïve Forecast and Moving Average to find the best method for forecast the next year.

Naive Moving Average  
29.57 22.43 MAD
1462.5 966.08 MSE
0.37 0.284 MAPE


Based on the above data we can clearly see that Moving Average is the best method for next year forecast. With all the MAD, MSE, and MAPE (mean percent of error) is all lower than naïve forecast method.


Mr. Freddie should prepared more data to construct a viable financial and personnel plan for the next year and using Moving Average he should be able to do it because it easy to understand and used moreover very low percent of errors.


Highline financial services ltd offer 3 service to its clients. We have analysis and calculated the errors percent to predict the forecast for next year is all based on quantitative records and the information given. With all the information and using Moving method Highline Financial services can easily forecast the outcome for the upcoming year. But if it’s provided more data and information we can forecast more accuracy.  However, guessing the result thought software and numbers will not be ensure and can’t be guarantee.  If there is some even small change in economic, internal environment with cause the forecast go wrong.

How to place an order?

Take a few steps to place an order on our site:

  • Fill out the form and state the deadline.
  • Calculate the price of your order and pay for it with your credit card.
  • When the order is placed, we select a suitable writer to complete it based on your requirements.
  • Stay in contact with the writer and discuss vital details of research.
  • Download a preview of the research paper. Satisfied with the outcome? Press “Approve.”

Feel secure when using our service

It's important for every customer to feel safe. Thus, at The Homework Writings, we take care of your security.

Financial security You can safely pay for your order using secure payment systems.
Personal security Any personal information about our customers is private. No other person can get access to it.
Academic security To deliver no-plagiarism samples, we use a specially-designed software to check every finished paper.
Web security This website is protected from illegal breaks. We constantly update our privacy management.

Get assistance with placing your order. Clarify any questions about our services. Contact our support team. They are available 24\7.

Still thinking about where to hire experienced authors and how to boost your grades? Place your order on our website and get help with any paper you need. We’ll meet your expectations.

Order now Get a quote