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

Unit VII

see attached Assignment Instructions You will use the multinational corporation (MNC) you researched in Unit VI for this assignment. The purpose of this scholarly activity is to continue to analyze fundamental aspects of corporate finance management in multinational corporations. You will examine supply chains and working capital management and make

Discussion 1

Write a 350 word response with 1 reference Due 1/6/2026 Discussion Question One: In this course, you will have an opportunity to explore ways to address topics of your interest that may represent challenges or areas in need of improvement or growth facing the organization.  · Considering your position, what

Business Finance – Management MBA 511 Week One Assignment. Powerpoint Presentation 7-8 slides

Week One Assignment Instructions Assignment 1: Assess Emotional Intelligence Top of Form Bottom of Form Instructions Competent leadership drives organizational success. Research shows that self-awareness, a central aspect of Emotional Intelligence, is more crucial for effective leadership than IQ or technical skills (Showry & Manasa, 2014). Self-awareness underpins managerial capability

sdddjsjs

Personal Reaction Paper Instructions: The purpose of the assignment is to reflect on the concepts gleaned from reading chapters 1 – 3 of the required textbook ( Human Resource Management). The objective of the paper is to analyze how human resource concepts apply to employees and the organizations they are

7-1 Discussion: What Would You Do Differently?

 For this discussion, describe a persuasive message that your workplace leader sent to an audience who resisted the idea, product, or service. Imagine yourself as a member of the audience. What would you recommend to the leader to better construct the message to get the intended results? Identify at least

Week 7 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team B Discussion 1 In this Discussion, you will continue to analyze your continuum of care scenario using the value-based care model, the IOM Aims, and a country comparison. You will be placed into a team and share your suggestions for improvements. Then, you will provide

Week 7 Discussion- Managerial Finance

Using Financial Forecast  Financial forecasts are crucial for businesses to make informed decisions, allocate resources effectively, and measure performance. They are typically based on historical data, which can make it challenging to predict sudden changes in market conditions or business operations. To mitigate financial risk, managers can employ strategies such

week 5

 overall business strategy your canvas depicts.  Assignment Directions: GOAL: Build on your work with your business model canvas by discussing the patterns, the design, and the overall business strategy it illustrates.  Introduction: Using the week 5 Learning Material in the Content area (coupled with the other course resources), examine and discuss

BUSN100

See attached. Instructions For this assignment just type the transcript Assignment Instruction: You are the public information officer (PIO) for a small company, responsible for communicating and distributing information for your organization. Prompt In this scenario, an unexpected incident has occurred within your local community, impacting the safety of employees

MKTG201

see attached Instructions: EOS Brand Assignment Directions: Objective:  For this assignment, you will explore how brands implement Integrated Marketing Communications (IMC) by evaluating their ability to deliver a consistent message across various marketing channels. Start by selecting a brand that interests you; this can be a well-known company or a

Unit V

see attached Post 1: Initial post addressing the discussion board topic • Your initial post should be at least 300 words in length. • Your initial post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or quoted material.

Is Royal Ludo a good first online game?

  Royal Ludo stands out as a welcoming entry point into online real-money gaming, especially for those wary of overly complex platforms. It emphasizes simplicity, familiarity, and low-risk learning. With easy   <a href=” Ludo download</a> options and cross-device compatibility, it’s accessible to everyone.  

How Do Pattern Recognition and Timing Affect Success in Stock Trading

 How does understanding market behavior in sideways trends (like TTQA shifts in sentiment and large vs. small fund activity) compare to recognizing patterns and timing in a game like [url= surfers[/url]  , where success depends on reading the level and reacting at the right moment? 

Create a Shipping list for the items bellow. It needs to be editable

   six-bedroom household shipment.  List of items in shipping Container: * Two (2) dining table sets * Three (3) living room couch sets * Washer and dryer * Two (2) master bedroom furniture sets * Four (4) regular bedroom furniture sets , (2) Kids’ basketball court  10 Children’s toys and

Week 6 Discussion- Delivery of Healthcare

Continuum of Care Scenario: Team A Discussion 3 For this team Discussion, you will have the opportunity to review the work of others and provide them with peer-reviewed feedback, as well as consider how their continuum of care might be improved. Further, you will be able to compare and contrast

Business Finance – Management Week 5 Assignment- Managerial Finance

Module 2 Assignment: Financial Health Assessment: Barry Computer Company Report prepared by: Replace this text with your name. Date: Replace this text with the submission date. Walden University MBAX 6070: Managerial Finance 1 Part 1: Financial Information Replace this text with introductory information. Add or remove headings as necessary. [Heading]

Week 8 MGMT601

 align and discuss the implications for organizational commitment   Assignment Directions:  You will conduct an interview with a colleague or contact currently employed, focusing on their perceptions of the psychological contract with their employer. You will then write a 3–5-page report outlining the unwritten expectations from both the employee and