Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Business Finance – Accounting assignment

Group Forecasting Analysis Instructions


Instructions

This is a group assignment and therefore must be completed by the student group without outside assistance. To complete the assignment, first read the write-up for the “Clean Sweep” case study. Then, answer the questions listed below for each part of the case.

Part 1 questions refer to
hiring using
monthly data based on the first 18 months of operating the call center.


Clean Sweep Student File No. 2, Fall 2023.xlsx

Part 2 offers a recommendation to management based on the analysis you conducted.

Conduct necessary calculations and visualizations to answer the questions.

For full credit you must submit

1.
Excel spreadsheet model(s) with calculations/formulas (not harded-coded numbers)

2.
Properly formatted

Business Report

which includes your group’s answers to the assignment questions.
Include a cover page, and all citations and headers should be in APA format.

Reports and models should be uploaded before the posted deadline.

This is the 2nd of
two forecasting projects. Make sure to use
Student File
2
which has

monthly
data.


Clean Sweep Student File No. 2, Fall 2023.xlsx


Grading

A total of 10 points is possible for this assignment. This includes the point values which are assigned to each question (point values are noted next to each question below). Your report should follow the prescribed assignment format, the proper writing style, and APA format.

Part 1 (10 points):

In answering the Part 1 questions, you should download and refer to Student Data File No. 2 which contains the historical data that you will need to answer the questions.


Question 1a (3 points)
:

Prepare a forecast of call volume for July 2023 by applying Exponential Smoothing to the prior 18 months of data. Use the appropriate Excel template from the Hillier text to prepare your forecast. Either assume that initial call volume is 29,778 and/or justify using a different initial value. Choose at least two different alpha values for your model. Model do these choices change your forecasts?

Show your forecast below and attach the completed Excel template. You must show your formulas within your spreadsheet (not hard-coded numbers).


Question 1b (3 points)
:

Apply Linear Regression to predict call volume from monthly cleans using the appropriate Excel template. Use 95,000 as your July 2023 monthly cleans input or a simple time-series method to project July 2023. Show your forecast below and attach the completed Excel template. Show your formulas (not hard-coded numbers).


Question 1c (1 point)
:

Calculate the Mean absolute deviation value of the Exponential Smoothing model (Question 3a) and the Average Absolute Estimation Error of the Linear Regression model (Question 3b). Explain the difference between these two values. Why does one method out-perform the other?


Question 1d (1 point)
:

What is your best forecast for July 2023? Show your forecast value. Explain how you came up with this forecast. Justify the Methods used in this analysis. Consider your answers to Questions 1a, 1b and 1c and all the factors that have been described above. You may present an additional model if you feel it could beat the models you have already run.


Question 2 (2 points)
:

Provide your recommendations to Belinda on how to modify forecasting processes and improve its accuracy.

Appendix

Business Report Format

Executive Summary

Problem statement

Methods

Describe your dataset

Describe and justify analytical methods

Results (or Analysis)

Results with interpretation

Descriptive statistics (how big is your dataset?)

Inferential statistics and tests

Recommendation

Appendices (if necessary)

Example in Getting Started>Grading Policy

1

image1.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Government and Politics

Details attached.   The role of government in the economy is often debated by economists and businesspeople. 

HRM 6302 Unit V DBR

2 Employment Law HRM 6302 Unit V DB Reply 1 Posts to others should be a minimum of 150 words and use at least one supporting reference. You can use the text for this course as one of the reference sources. Reply to student post below Part I Under the Federal

Fin 6301 Unit VI PPP

2 Corporate Finance ECO 6301 Unit VI PowerPoint Presentation This assignment measures your mastery of ULOs 5.1, 5.2, and 5.3. The purpose of this PowerPoint Presentation is to analyze fundamental aspects of corporate finance management in multinational corporations. You will research a multinational corporation to focus on for the assignment,

gender

 In this summarize, Gallant writes mostly about gender and sex work. How might her ideas be expanded to consider gender in other areas of life?  

Real Estate Evaluation| Neighborhood Analysis

Identify and evaluate the neighborhood within which you live? Create a neighborhood profile using internet links and personal information that will provide some specific data. Draw some inference from this evaluation. Be sure to understand the term neighborhood and what makes this neighborhood different. Is it close to jobs? How

week 3 dicussion Organizational Behavior

 What are the factors that influence our perception? What is the link between perception and decision making? How do individual differences and organizational constraints influence decision making? 

FIN 6301 Unit V DB R1

2 Corporate Finance ECO 6301 Unit V DB Reply 1 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

FIN 6301 Unit V DB R2

2 Corporate Finance ECO 6301 Unit V DB Reply 2 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

discussion and assignment ASSIGNMENT Brand Extension Assignment For this assignment, you are asked to choose an  existing brand and create a  brand extension for that brand. This is not connected to your final paper topic, so you can use any brand, including your final paper topic for this deliverable. Your goal is

Cash Budget

See attached Please complete Excel template provided The goal of this assignment is to demonstrate the process of construction and utilization of a cash budget for a company. The assignment is closely related to Course Objectives #02. For this assignment we consider the monthly cash budget for six months (January

Final Project: Present a Business Plan

   Final Project: Present a Business Plan WHO: You are the entrepreneur, and your job is to present a business plan for your entrepreneurial venture (I was thinking of a truck parking stop).

Deliverable 7 – Strategic Implementation of Quality Initiatives

  Competencies Analyze the history of healthcare quality improvement and how it shapes current and future quality initiatives. Evaluate patient care clinical outcomes using quality improvement principles. Evaluate healthcare quality measures and their use in diverse populations and settings. Apply models of quality improvement to institutional challenges within the healthcare

Week 4 Discussion Response- Account for Managment Decision Making

Account for Management Decision Making Week 4 Learning Resources Costs There are many different types of costs that impact a manager’s decision making. Therefore, it is imperative that managers understand what each type is as well as the ones relevant to a specific decision. In these resources, you will examine

Marketing Strategy

Marketing Strategy is already completed but need to make improvements based on feedback. I will share the document i have prepared thus far with the feedback, referrences.

Unit VIII FP

see attached Unit VIII A Case Analysis of AMC Assignment objective: AMC is the largest movie theater operator in the world. AMC recently became a popular meme stock. Take a few minutes to learn more about AMC Theaters . Length: Your submission is required to be at least 5 pages

Unit VII J

see attached Unit VII Journal Journal objective: Auctions can be an important tool for selling/buying goods and gathering information. Auctions are used in multiple venues including agriculture, eBay, and distressed asset sales. The seller does not have to worry about estimating demand and setting a price because the demanders will

3-2 Case Brief: Module Three Case Brief Listen

 Read and brief the case provided in this module’s resources. In addition to the brief, discuss the impact of the case on statutory law related to premises liability as a result of the court’s decision. 

Social, Behavioral, and Psychosocial Aspects of Epidemiology

Please respond to the following: After reviewing this week’s readings, analyze how social, behavioral, and psychosocial aspects of epidemiology are used to make decisions in a health care setting. Imagine you are going to work in a health care setting after finishing your readings for this week. How would you