MyLab Operations Management with Pearson eText -- Access Card -- for Operations Management: Sustainability and Supply Chain Management
12th Edition
ISBN: 9780134165325
Author: Jay Heizer, Barry Render, Chuck Munson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 50P
Question
•• 4.38 City government has collected the following data on annual sales tax collections and new car registrations:
Determine the following:
- a. The least-squares regression equation.
- b. Using the results of part (a), find the estimated sales tax collections if new car registrations total 22,000.
- c. The coefficients of correlation and determination.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
question
A manufacturer is developing a facility plan to provide production capacity for the factory. the amount of capacity required in the future depends on the number of products demanded by its customers. The data below reflect past sales of its products.
a) use simple linear regression to forecast annual demand for the products for each of the nnext 3 years.
b) determine the correlation coefficient for the data and interpret its meaning.
c) find the coefficient of determination for the data and interprete its meaning.
year
annual sales (number of products
year
annual sales (number of products)
1
490
5
461
2
487
6
475
3
492
7
472
4
478
8
458
QUESTION 1 Sales of Fat Lips Burgers for 2012 are shown in the table below. 1. Do the 2 month SMA forecast 2. Do 2 month WMA forecast using the information below WMA – 2: last month, 1 – last 2 months 3. For the month of January 2012, the forecast was 438. Do the EMA forecast with the smoothing constant = 0.3. What is the forecast for Jan 2013? 4. Compare the forecasts above using MAD, MSE and MAPE. Which forecast method gives the least errors?
Month
Actual Sales
Forecast
Jan 2012
438
Feb
420
March
414
Apr
318
May
306
June
240
July
240
Aug
216
Sep
198
Oct
225
Nov
270
Dec
315
Jan 2013
-
QUESTION 2Dayang sells 5 kg bags of fertilizer to local farmers in Tg Karang. The sales data for the past 11 months is shown below.
Month
Demand (10s of bags)
1
4
2
6
3
4
4
5
5
10
6
8
7
7
8
9
9
12
10
14
11
15
1. Find the forecast for the month 12 using the methods below: a. Simple 4 month moving average (SMA) b.…
Question (4): Answer the following problem:
Cover Me, Inc. sells umbrellas in two cities. Management assumes that annual rainfall is the primary determinant of umbrella sales, and it wants to generate a linear regression equation to estimate potential sales in another city. Use the table below to develop a linear regression equation to find out what sales might be if the rainfall is 12 inches in City C.
Show your work in the below table
Rainfall X
Sales Y
X2
XY
City A
36 inches
200
City B
30 inches
250
City C
12 inches
Total
66
450
Chapter 4 Solutions
MyLab Operations Management with Pearson eText -- Access Card -- for Operations Management: Sustainability and Supply Chain Management
Ch. 4 - What is a qualitative foretasting model, and when...Ch. 4 - Identify and briefly describe the two general...Ch. 4 - Identify the three forecasting time horizons....Ch. 4 - Briefly describe the steps that are used to...Ch. 4 - A skeptical manager asks what medium-range...Ch. 4 - Explain why such forecasting devices as moving...Ch. 4 - What is the basic difference between a weighted...Ch. 4 - What three methods are used to determine the...Ch. 4 - Research and briefly describe the Delphi...Ch. 4 - What is the primary difference between a...
Ch. 4 - Define time series.Ch. 4 - What effect does the value of the smoothing...Ch. 4 - Explain the value of seasonal indices in...Ch. 4 - Which forecasting technique can place the most...Ch. 4 - In your own words, explain adaptive forecasting.Ch. 4 - What is the purpose of a tracking signal?Ch. 4 - Explain, in your own words, the meaning of the...Ch. 4 - What is the difference between a dependent and an...Ch. 4 - Give examples of industries that are affected by...Ch. 4 - Give examples of industries in which demand...Ch. 4 - Prob. 21DQCh. 4 - Prob. 22DQCh. 4 - The following gives the number of pints of type B...Ch. 4 - 4.2 a. Plot the above data on a graph. Do you...Ch. 4 - Refer to Problem 4.2. Develop a forecast for years...Ch. 4 - A check-processing center uses exponential...Ch. 4 - The Carbondale Hospital is considering the...Ch. 4 - The monthly sales for Yazici Batteries, Inc., were...Ch. 4 - The actual demand for the patients at Omaha...Ch. 4 - Daily high temperatures in St. Louis for the last...Ch. 4 - Lenovo uses the ZX-81 chip in some of its laptop...Ch. 4 - Data collected on the yearly registrations for a...Ch. 4 - Use exponential smoothing with a smoothing...Ch. 4 - Consider the following actual and forecast demand...Ch. 4 - As you can see in the following table, demand for...Ch. 4 - Following are two weekly forecasts made by two...Ch. 4 - Refer to Solved Problem 4.1 on page 138. a. Use a...Ch. 4 - Solved example 4.1 Sales of Volkswagens popular...Ch. 4 - Refer to Solved Problem 4.1. Using smoothing...Ch. 4 - Consider the following actual (At) and forecast...Ch. 4 - Income at the architectural firm Spraggins and...Ch. 4 - Question 4.20 Resolve Problem 4.19 with =.1 and ...Ch. 4 - Question 4.21 Refer to the trend-adjusted...Ch. 4 - Question 4.22 Refer to Problem 4.21. Complete the...Ch. 4 - Question 4.23 Sales of quilt covers at Bud Baniss...Ch. 4 - Question 4.25 The following gives the number of...Ch. 4 - Prob. 25PCh. 4 - Question 4.27 George Kyparisis owns a company...Ch. 4 - Question 4.28 Attendance at Orlandos newest...Ch. 4 - Question 4.29 North Dakota Electric Company...Ch. 4 - Question 4.33 The number of internal disk drives...Ch. 4 - Dr. Lillian Fok, a New Orleans psychologist,...Ch. 4 - Emergency calls to the 911 system of Durham, North...Ch. 4 - Using the 911 call data in Problem 4.43, forecast...Ch. 4 - Question 4.47 Storrs Cycles has just started...Ch. 4 - Question 4.49 Boulanger Savings and Loan is proud...Ch. 4 - Question 4.24 Mark Gershon, owner of a musical...Ch. 4 - Lori Cook has developed the following forecasting...Ch. 4 - Prob. 45PCh. 4 - Question 4.32 The following data relate the sales...Ch. 4 - Question 4.34 The number of auto accidents in...Ch. 4 - Question 4.35 Rhonda Clark, a Slippery Rock,...Ch. 4 - Accountants at the Tucson firm, Larry Youdelman,...Ch. 4 - Sales of tablet computers at Ted Glickmans...Ch. 4 - Question 4.38 City government has collected the...Ch. 4 - Using the data in Problem 4.39, apply linear...Ch. 4 - Bus and subway ridership for the summer months in...Ch. 4 - Thirteen students entered the business program at...Ch. 4 - Question 4.48 Dave Fletcher, the general manager...Ch. 4 - The following are monthly actual and forecast...Ch. 4 - Prob. 1CSCh. 4 - Prob. 2CSCh. 4 - Prob. 3CSCh. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - For its first 2 decades of existence, the NBAs...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...Ch. 4 - Forecasting at Hard Rock Cafe Video Case With the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Question 4 The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship).arrow_forwardQUESTION ONE (b) The forecast of a product for the first week of January was 200 units, whereas the actual demand turned out to be 220 units. i. Find the forecast for the week of January assuming the smoothing constant 0.2 α = ii. Find the forecast for the third week of third week of January if the actual demand of the second week is 210 unitsarrow_forwardQuestion 1 Forecasting calculation X Month Sales (y)(000 units) 1 Feb. 19 2 Mar. 18 3 Apr. 15 4 May 20 5 Jun. 18 6 Jul. 22 7 Aug. 20 8 Sep a. Using a 5-month moving average, calculate September sales b. Calculate September sales Using a 3-month weighted moving average (weights are 0.60, 0.30. 0.10). c. Calculatate Exponential Smoothing (assume February sale is 19) sales in September (alpha 0.2, that means 1-0.2 = 0.8) d. Using regression analysis, what is Y (September sales) if X is 8? (use data> data analysis button> regression)arrow_forward
- Question 21 A CFE of -140 suggests which of the following? Group of answer choices a. There is a bias towards over forecasting, though we cannot determine from the data provided whether that is severe bias or not b. There is a severe bias towards overforecasting c. There is a bias towards under forecasting, though we cannot determine from the data provided whether that is severe bias or not d. There is a severe bias towards under forecasting e. Bias is negligible in this casearrow_forwardQuestion 16 Daily demand for sandwiches at a local deli is shown in the table. Using a 3 period weighted moving average (most recent demands receive the highest weights) with weights W1 = 0.50, W2 = 0.30 and W3 = 0.20, what is the forecast for day 8? Group of answer choices a. 39.3 sandwiches b. 41.3 sandwiches c. 43 sandwiches d. 43.3 sandwiches e. Impossible to determinearrow_forwardQUESTION 1.3 If any research endeavor. Errors in data collecting can have an impact on the results of a study, ultimately leading to erroneous results. The methods used to collect data for impact evaluation differ on a scale. Quantitative data gathering methods are at one end of the scale, while qualitative data collection methods are at the other. Choosing a particular data collection strategy will be determined by the accuracy of the information produced as well as practical issues such as the availability of staff, time, equipment, and other resources. Analyse the different data collection techniques, evaluate their respective purposes and assess their strengths andlimitations in order to create a critical understanding.arrow_forward
- Question 1 – Case Study Alpha Homes is a private limited company involved in specialist home improvements, with two (2) main products. These are: Garage Conversions (GC) and Extension to Properties (EX). Alpha Homes currently implements the full-costing absorption method in providing price quotes to customers. The company seeks to remain competitive and has an existing policy to price all jobs at budgeted total costs plus 50%. You are the new management accountant, and currently reviewing the cost records, for materials, labour and overheads. Table 1 below indicates the expected costs of “jobs” in both product areas: Table 1 Cost subheads Garage Conversion (GC) Extension to property (EX) Price Quotes (£) Units Construction materials (£) 3500 8,000 Labour (£) 5,500 6,500 Fixed Overheads(£) 1,000 2,000 Variable Overheads(£) 1,000 4000 Required a i) Define and calculate the marginal costs and throughput costs for each unit of GC and EX products, using the…arrow_forwardQUESTION ONEIn August 2020 government through the Republican President, Zambia launched a K470 million Multi sectoral youth empowerment programme. The Head of State said during the launch in Ndola that government will listen more to young people and address their concerns. As a result of this initiative government had identified oil refining as a major business which youths can venture into. Data collected from Indeni oil refinery (specimen) shows that there are two blending processes of which the inputs and outputs per production run are as follows Inputs Outputs Crude A Crude B Petrol Kerosene Process 1 53 58 Process 2 45 44 The maximum amount available of crude A and B is 200 units and 150 units respectively.Market requirements show that at least 100 units of Petrol and 80 units of Kerosenemust be produced. The profits per production run from process 1 and 2 are $3 and $4respectively. You have been hired as a consultant to help these youth groups makerefining a…arrow_forwardQUESTION 1 The 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 a. Using the following, forecast the sales for the months up to January the following year:-i. A simple three month moving average. ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data. iii. Exponential Smoothing when α= .6 and the forecast for March is 350.iv. Determine which of the three forecasting technique is the most accurate using MADarrow_forward
- Question 4An investor is to purchase one of three types of real estate, as illustrated in Figure below. Theinvestor must decide among an apartment building, an office building, and a warehouse. Thefuture states of nature that will determine how much profit the investor will make are goodeconomic conditions and poor economic conditions. The profits that will result from eachdecision in the event of each state of nature are shown in Table below: a) Find the optimal act using Maxi-Max criteriab) Find the optimal act using Mini-Max criteria c) Find the optimal act using Maxi-Min criteria d) Find the optimal act using Min-Max regret tablearrow_forwardQUESTION 1The 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 a. Using the following, forecast the sales for the months up to January the following year:- ii. A three period weighted moving average using weights of 1, 2 and 3. Assign thehighest weight to the most recent data.arrow_forwardQUESTION 34 Suppose the actual sales and the forecasted, or smoothed sales, for the past 5 months have been Actual Smoothed 54.4 76.8 54.4 75.5 72.3 53.2 74.8 39.2 57.6 What is the Mean Absolute Error of the smoothed series? (please round your answer to 1 decimal place)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.
Introduction to Forecasting; Author: Ekeeda;https://www.youtube.com/watch?v=5eIbVXrJL7k;License: Standard YouTube License, CC-BY