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

Reimbursement

Define Case Mix Index (CMI) and assess the consequences of shifts in the CMI. Compare the acute inpatient PPS to the LTCH-PPS. Summarize the similarities and differences.

cha 16-22 & 8

Ch 16 Questions 1. How does mutual respect contribute to successful conflict resolution? 2. What are signs of disrespect in negotiation, and how should they be addressed? Ch 17 Questions 1. Why is consistency important in building credibility? 2. How can inconsistency undermine negotiation efforts? Ch 18 Questions 1. What

Case Study Week 2

  In this short case study, you will apply the principles of supply and demand to a real-world firm of your choice.

Sam Strother and Shawna Tibbs

   Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Insurance Company and co-directors of the company’s pension fund management division. An important new client, the North-Western Municipal Alliance, has requested that Mutual of Seattle present an investment seminar to the mayors of the represented cities, and

Stock valuation

   You have been asked to perform a stock valuation prior to the annual shareholders’ meeting next week. The two models you have selected to value are the dividend discount model and the discounted cash flow model. Explain why the estimates from the two valuation methods differ. Address the assumptions

Current economic conditions

   Using your Wall Street Journal subscription, select an article about the current economic conditions and trends regarding a changing interest rate environment. How would bond values change over time? As a bond investor, what measures would you take to manage rate risk based on current economic conditions and the

Reading 7

Instructions and readings attached  For section #2 Comparative Insight (7 points) I also attached week 6 reading (Selection_ Initial Assessment Methods.pdf) 

D8

Risk Management Plan Peer Review Instructions Review at least one other student’s risk management plan and complete the following within this discussion. · List the company and project name for the plan you reviewed. · Choose one risk identified and follow it through the qualitative analysis, quantitative analysis, and risk

QSO 321

  QSO 321 Module Eight Assignment Guidelines and Rubric Overview An important part of any career is professional development. Professional development can consist of attending conferences, taking additional courses, reading professional texts, or earning industry credentials. Many workplaces encourage professional development and also provide employees with funds to be used

supply chain

i need help w/supply assignment · Highlight potential challenges or trade-offs involved in implementing your recommendations. Working as a team, produce a 5-page professional guide that not only summarizes your research but also critically evaluates and applies it to real-world procurement practice. Our Topic:  · How procurement professionals should approach

Dummy post- Tax Admin

1. How is the current tax administration in the Turks and Caicos Islands structured, and what challenges or limitations have you observed in its ability to ensure compliance and effective revenue collection? Function-based Organizational Model -functional areas – 1. Taxpayer Services and Business Licenses- 2. Audit and Investigations 3. Compliance

Unit IV Ass

see attached Assignment Objective: For this assignment, you will research and compare international and U.S. accounting standards. This will enable you to see how the different reporting methods affect business and how product costs are affected by international business. In the assignment you will do the following: 1. Compare and

ACCt105

see attached Instructions Complete the Budget in a Service Company (Cash Budget) assignment.   Please use the template provided below. The document must have the complete budget and show the entire process along with an explanation. Add a brief explanation of the budget just like what you should do if you

Balik and Kiefer Inc

   Assume that you recently graduated and have just reported on working as an investment advisor at the brokerage firm of Balik and Kiefer Inc. One of the firm’s clients is Michelle DellaTorre, a professional tennis player who has just come to the United States from Chile. DellaTorre is a

Questions

Just need a brief answers to prepare for my proposal defense  Last Updated: Jul 1, 2025 11:01 AM URL:  Print Page Staff Login Report a problem Dissertation Center / Dissertation Defense / Example Defense Questions Dissertation Defense Dissertation Defense: Home Preparing for the Defense Example Defense Questions Consider These

Motivation a driving force for goals achievement

Please see attachment for assignment reference and instruction. BMAL 703 Motivation Theory Assignment Instructions Overview Since motivation is a major determinate of a person’s persistence toward achieving a goal, it is important to examine how managers can use motivation to attain organizational goals. There are various theories to help managers

Conscious Capitalism and Christian Worldview

     Describe how the concept of Conscious Capitalism aligns with Christian worldview principles; and demonstrates the importance of corporate social responsibility to the parent company’s board of directors. Instructor Tips: Include 1 short paragraph (3 to 5 sentences / bullets) for each of the 2 parts of the question:  

lFG-1

please review BUSI 606 Discussion Assignment Instructions The Discussions allow you the opportunity to apply what you have learned from the Module: Week’s readings. There are 2 parts to each Discussion: thread and replies. Both parts must be posted and written in a substantive manner, without spelling and grammatical errors