Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The manager wants to forecast the month 6's sales using the following historical data:
Months
Month 1
Month 2
Month 3
Month 4
Month 5
Sales
20
25
32
35
38
Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and
weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 6.
Month 5 = 0.1*(25) +0.2*(32) + .25* (35) divided by 0.1 +0.2 +1.25 -17.65/0.55 = 32.09
Month 6= 0.1* (25) +0.2* (32) +0.25 (35) +0.45* (38) divided by 0.1 +0.2+0.45 = 34.75
The manager wants to forecast the month 6's sales using the following historical data:
Months
Month 1
Month 2
Month 3
Month 4
Month 5
Sales
20
25
32
35
38
Please use the weight 0.45 for Month 5, weight 0.25 for Month 4, weight 0.2 for Month 3, and
weight 0.1 for Month 2 to use the weighted moving average to forecast the demand of Month 5.
A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was
developed:
y = 3,600+ 0.16x,
where y is the annual cost and x is the miles driven.
a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile = $
b) If the car is driven 26,000 miles this year, the forecasted cost of operating this automobile = $
(enter your response as a whole number).
(enter your response as a whole number).
Knowledge Booster
Similar questions
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.arrow_forwardStock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.arrow_forwardThe management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.arrow_forward
- Cost Estimation; High-Low and Regression Methods The Mac Davis Company specializesin the purchase, renovation, and resale of older homes. Mac employs several carpenters and paintersto do the work for him. It is essential for him to have accurate cost estimates so he can determinetotal renovation costs before he purchases a piece of property. If estimated renovation costs plus thepurchase price of a house are higher than the house’s estimated resale value, it is not a worthwhileinvestment.Mac has been using the home’s interior square feet for his exterior paint cost estimations. Recentlyhe decided to include the number of external openings—the total number of doors and windows ina house—as a cost driver. Their cost is significant because they require time-consuming preparatorywork and careful brushwork. The rest of the house usually is painted either by rollers or spray guns,which are relatively efficient ways to apply paint to a large area. Mac has kept careful records of theseexterior…arrow_forwardThe table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 Using the following, forecast the sales for the months up to January the following year:- 1. Use exponential Smoothing when α= .6 and the forecast for March is 350.2. Determine which of the three forecasting technique is the most accurate using Mean Absolute Deviation MADarrow_forwardBelow is a table that shows the Freshmen Enrollment of the New Texas Elementary School during the 1a Semesters of the past ten (10) Academic Years (AY), AY 2013-2014 2014-2015 2015-2016 2016-02017 2017-2018 Freshmen Enrollees AY 200 220 235 270 315 4. For the Weighted Moving Averages model, use: a weight of 0.40 for the most recent data; a weight of 0.35 for the second most recent data; and a weight of 0.25 for the third most recent data. You are the Principal of New Texas Elementary School. You are interested to know the forecast of freshmen enrolment for the next academic year (AY2023-2024), in order to plan ahead the necessary resources: faculty, classroom, library holdings, physical facilities, student services, furniture and fixtures, etc.). These are the requirements: AT 2013-2014 1. Calculate the forecast using 5 forecasting techniques/methodologies/models namely: Naïve Model, Unweighted and Weighted Moving Averages, Exponential Smoothing, and Time-Series Regression. Follow and…arrow_forward
- The following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method. Note: Enter your answers in millions. YEAR 1 2345 5 6 7 8 9 10 11 Period 12 13 14 15 REVENUE (MILLIONS) $4,865.7 5,072.3 5,507.7 5,738.2 5,495.4 5,198.7 5,087.0 5,111.5 5,559.7 5,740.4 5,868.4 Forecastarrow_forwardThe following are sales revenues for a large utility company for years 1 through 11. Forecast revenue for years 12 through 15. Because we are forecasting four years into the future, you will need to use linear regression as your forecasting method.arrow_forwardThe table below shows the quarterly sales of television set (in thousands) in an electrical appliance shop in years 2017-2019. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2017 4.8 4.1 6.0 6.5 2018 5.8 5.2 6.8 7.4 2019 6. 5.6 7,5 7.8 (a) Describe the trend and seasonal variation of the sales of television set by referring to the following time series plot. (In a short paragraph of around 30 words.) Sales of Television Set (1000s) 2 3 5 8 9 10 11 12 Time: (2017 Quarter 1 to 2019 Quarter 4) (b) Calculate the seasonal variation for Quarter 1, Quarter 2, Quarter 3, and Quarter 4 respectively by using the calculated 4-quarter moving average as below. Year Quarter Sales Centered Moving (1000) Average (1000) 2017 5.475 2017 4 6.5 5.7375 2018 1 5.8 5.975 2018 2 5.2 6.1875 2018 3 6.8 6.325 2018 7.4 6.4 2019 1 6 6.5375 2019 2 5.6 6.675 TTTT"arrow_forward
- 3arrow_forwardA company wants to forecast demand using a weighted moving average and weights of 0.5, 0.3 and 0.2. If the company's yearly sales values for year 2016 = 120, year 2017 = 140, year 2018 = 140, and year 2019 = 210, which of the following is the three month weighted moving average sales forecast for year 2020 154 136 175 130 152.5arrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: 4 Week 1 Demand 20 5 6 7 24 29 35 8 9 10 22 24 28 36 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.60 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): 8 Week 1 Demand 20 Forecast 20.0 2 3 20 29 6 7 29 35 22 2 20 3 29 4 36 5 24 9 10 24 28arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,