100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
Summary QuestionYou are to use the supplied historic data to develop forecasts that can inform $7.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. Ashford University
  4.  
  5. ACC 205

Summary

Summary QuestionYou are to use the supplied historic data to develop forecasts that can inform

 0 purchase

You are to use the supplied historic data to develop forecasts that can inform KCBQuestionYou are to use the supplied historic data to develop forecasts that can inform KCB's decision whether and when to add additional high bay capacity to the toll station. 1. Plot the historic data and provi...

[Show more]

Preview 2 out of 9  pages

Document information

  • October 13, 2024
  • 9
  • 2024/2025
  • Summary

Subjects

  • you are to use the supplied historic data to devel
  • based on the complete data set you have been give
  • based solely on data recorded after the onset of

Written for

All documents for this subject (71)

Seller

avatar-seller
newage

Reviews received

Content preview

Question


You are to use the supplied historic data to develop forecasts that can inform

KCB's decision whether and when to add additional high bay capacity to the toll

station. 1. Plot the historic data and provide an estimate of seasonality of the

leisure traffic. 2. Provide a forecast of the expected traffic up to the end of 2025,

based on the complete data set you have been given. Create a suitable chart to

visualise the data. 3. Provide a forecast of the expected traffic up to the end of

2025, based solely on data recorded after the onset of the COVID-19 pandemic

in January 2020. Create a suitable chart to visualise the data. 4. Discuss the

similarity and differences between the two forecasts. 5. What advice would you

offer KCB regarding the decision to invest in additional capacity? Note that

there is no expectation that you will use specialist software to undertake this

assignment. No additional credit will be given for doing so. Microsoft Excel is

quite sufficient. Show your working; simple, auditable steps are preferred to the

use of complex models.

, Answer & Explanation


To address the questions regarding the traffic forecasting for KCB, we'll

proceed step by step using basic forecasting techniques. Here's a structured

approach using Excel:




1. Plot the Historic Data and Estimate Seasonality


Firstly, let's plot the historic data and estimate the seasonality. Suppose we have

monthly traffic data from January 2017 to December 2023 (7 years).


- Step-by-step:


a. Enter the historic traffic data into Excel.




b. Create a line chart to visualize the traffic data over time.




c. Calculate the seasonal indices to estimate seasonality. This can be done by

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller newage. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $7.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

63950 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling

Recently viewed by you

Other ·

(0)

NR-661 Week 7 RISK MANAGEMENT AND NEGLIGENCE DISCUSSION - DOWNLOAD PAPER FOR A HIGH SCORE

Exam (elaborations) ·

(1)

Solutions for Calculus & Its Applications, 15th Edition Goldstein (All Chapters included)

Exam (elaborations) ·

(0)

Chapter 6 Exam Review Questions, ISBN: 9781734681123 Human Anatomy & Physiology (BSC1085C)

Summary ·

(0)

Samenvatting H1 | Zuid-Amerika: continent van extremen - De Geo Gebieden: Zuid-Amerika (5/6 VWO)

Package deal ·

(0)

HESI RN V1,2,3 &4 MED SURG Exam Questions& Answers; Bunded; Latest Updated A Score Solution

Exam (elaborations) ·

(1)

NR 546 / NR546 Psychopharmacology Midterm Exam Questions and Answers (2023 / 2024) (Verified Answers)

Exam (elaborations) ·

(0)

Exam (elaborations) Medical – Surgical Exit HESI Questions with Answers and Rationales (HESI)

Exam (elaborations) ·

(0)

ACCOUNTING 211 Liberty University -ACCT 211-Liberty University EXAM 1 correctly answered

Exam (elaborations) ·

(0)

CHEM 113 CHAPTER 9 AND 10 PRACTICE QUESTIONS AND ANSWERS CORRECT SOLUTION LATEST UPDATE
$7.99
  • (0)
Add to cart
Added