Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me!!! Cell Styles Styles 45 > > 3 X 22567 - Week 9 - Online Homework Question - (Multiple Regression) Retail Traders operates

Please help me!!!

image text in transcribed
Cell Styles Styles 45 > > 3 X 22567 - Week 9 - Online Homework Question - (Multiple Regression) Retail Traders operates in a fast growing and competitive market. For the purpose of forecasting operating profit, the two predominant drivers, namely Operating Revenue and Total Assets, have been identified. The following table contains information on the operating profit and profit drivers for the period 2011 to 2009: Operating Operating Year Profit ($) Revenue ($) Total Assets ($) 2011 294 11,482 2,391 2012 342 12,789 2,924 2013 361 13,986 3,102 2014 408 15,574 3,564 2015 473 16,841 4,084 2016 494 18,465 4,702 2017 594 20,019 4,817 2018 694 20,915 5,083 2019 742 24,473 5,724 2020 865 26,321 5,887 Retail Traders wants to develop reliable forecasting functions for the prediction of the level of business activity and the estimation of Operating Profit and has asked you to develop a model to facilitate this requirement. Required: Using a three month fractionally weighted moving average applied to the Growth Rate of Operating Revenue, with weights of 0.714, 0.27-2, 0.1,.), develop a forecast for Operating Revenue for 2021 (whole dollars only). N Compute the Mean Absolute Deviation (MAD) of the forecast Growth rate of Operating Revenue. Using Exponential Smoothing forecasting techniques applied to the Growth Rate of Assets with a= .4, develop a forecast for Total Assets for 2021 (whole dollars only). Compute the Mean Absolute Deviation (MAD) of the forecast Growth rate of Total Assets. Using multiple regression techniques, develop a forecast of Operating Profit based on the forecast of Operating Revenue developed in Question 1 and the forecast of Total Assets developed in Question 3. Using the forecast developed in Question 5, what is the probability that Operating profit will exceed $900? Using the forecast developed in Question 5, what is the probability that Operating profit will exceed $980? Management has decided that the forecast for Sales in 2021 will be $29,500 and the Forecast of Total Assets for 2021 will be $6,700, What is the expected Operating Profit for 2021? Using the forecast developed in Question 8, what is the probability that Operating profit will exceed $1,000? 10. Using the forecast developed in Question 8, what is the probability that Operating profit will exceed $950? Taskbar Taskbar ENG

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Differential Equations A Maple™ Supplement

Authors: Robert P Gilbert, George C Hsiao, Robert J Ronkese

2nd Edition

1000402525, 9781000402520

More Books

Students also viewed these Mathematics questions