Statistical Techniques in Business and Economics
18th Edition
ISBN: 9781260579611
Author: Douglas Lind; William Marchal; Samuel Wathen
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 15E
a.
To determine
To draw: The graph of the given time series.
b.
To determine
To describe: The time series pattern.
c.
To determine
To explain: The reason that forecasting with a trend model is appropriate for the given time series.
d.
To determine
To calculate: A trend forecasting model using simple linear regression and the MAD.
e.
To determine
To state: The predicted annual change of industry sales.
f.
To determine
To calculate: The sales for the next three years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Over the years the U.S. grocery distribution and sales industry has grown. Today, the total industry sales are in the billions of dollars. Major retailers, such as Walmart and Target, added food to complement their merchandise sales and Amazon recently purchased Whole Foods. For many companies, forecasts of industry sales are necessary information to plan for short- and long-term decisions. Using the total U.S. grocery store annual sales in millions of dollars (https://www.census.gov/retail/index.html#mrts) in the following table, respond to the following items.
If a household has 3 members, and has an annual income of $100,000, predict this household’s monthly spending.
Complete the chase production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and
inventory costs should match those given here.
Click the icon to view the costs table.
Click the icon to view the forecasted sales.
Fill in the production plan table below (enter your responses as whole numbers).
More Info
Totals
Costs
Cost of plan
Month
March
Planning values
Starting inventory
Starting and ending workforce
Hours worked per month per worker
Hours per unit
Hiring cost per worker
Layoff cost per worker
Monthly per-unit holding cost
Print
Forecasted
sales
1,917
Sales in
to meet
worker
sales
hours average = 253
Layoff
256
$256,000
Done
Hiring Inventory
256
18,000
$18,000
$1,024,000
$1,298,000
1,500
209
315
35
$4,000
$1,000
$1
Actual
workers
209
Actual
production
Layoffs Hiring
More Info
Ending
inventory
1,500
Month
March
April
May
June
July
August
September
October…
Chapter 18 Solutions
Statistical Techniques in Business and Economics
Ch. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 1SRCh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 7ECh. 18 - Prob. 8ECh. 18 - Prob. 2SR
Ch. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 3SRCh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17ECh. 18 - Prob. 18ECh. 18 - Prob. 4SRCh. 18 - Prob. 19ECh. 18 - Prob. 20ECh. 18 - Prob. 21ECh. 18 - Prob. 22ECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
Knowledge Booster
Similar questions
- If you are performing a break-even analysis for a business and their cost and revenue equations are dependent, explain what this means for the company's profit margins.arrow_forwardThe director of a nonprofit ballet company in a medium-sized city in a certain country is planning its next fundraising campaign. In recent years, the program has found the percentages of donors and gift levels given in the accompanying table. Develop a spreadsheet model to calculate the total amount donated based on this information if the company contacts 900 potential donors to donate at the $100 level or below E Click the icon to view the percentages of donors and gift levels. C..... 3 Philanthropist $5,000 11 =B3*C3 4 Producer's Circle $1,000 25 =B4*C4 5 Director's Circle $500 49 =B5 C5 6 Principal $100 8% =B6*C6*$B$9 7 Soloist $50 14% =B7*C7*SB$9 8. 9 Solicitations 900 10 Total Donations =SUM(D2:D7) Enter the values in the model. (Type integers or decimals. Do not round.) B D Average Number of Gifts 1 Gift Level Amount Donations 2 Benefactor $10,000 3 Philanthropist $5,000 11 4 Producer's Circle $1,000 25 5 Director's Circle $500 49 6 Principal $100 8% ns? 7 Soloist $50 14% 8. 9…arrow_forwardAccording to the Bureau of Labor Statistics, there were 27,900 computer and research information scientist jobs available in 2016. It is estimated that the number of jobs in this area will increase by 19% by the year 2026. This is much more than the national average. If this prediction is accurate, which of the following statements gives the exact description of the number of computer and research information scientist jobs available in 2026? A The number of computer and research information scientist jobs will increase by roughly 5,401 in 2026. B The number of computer and research information scientist jobs will be more than 27,900 in 2026. C There will be 33,201 computer and research information scientist jobs available in 2026. D There will be a lot of computer and research information scientist job opportunities in 2026.arrow_forward
- According to Zillow.com, the median sale price for homes in January for South Carolina, California, and Virginia over the last three years is given in the table below (measured in $100,000). able South Carolina California Virginia 2018 183 534 98 2019 193 555 94 2020 216 569 85 In South Carolina, realtors take 5.4% of the sale price on average as part of their commission. The average realtor commission rates in California and Virginia are 4.9% and 5.3%, respectively. Use matrix multiplication to find the total earned by realtors from their commissionsarrow_forwardDetermine the market potential for a product that has 20 million prospective buyers who purchase an average of two per year and price averages $50. How many units must a company sell if it desires a 10% share of this market?arrow_forwarduse the given data on the societal cost of crashes and the approximate U.S. population of 325 million to calculate the average social cost per person. U.S. Data (2016 estimates): Car Crash fatalities = 40,200; Car Crash injuries = 4.6 million; cost to society = $430 billion. (source: National Safety Council.) • Global Data (estimated); car crash fatalities = ≈ 50 million; car crash fatalities with victim's underage 45 ≈ 400,000. (Source: Association Safe International Road Travel.) About how often (once every x minutes or x seconds) on average is a person killed in a car crash in the United States? How often is a person injured in a car crash. The answer to this question is about once every 13 minutes; about once every 7 seconds. use the given data on the societal cost of crashes and the approximate U.S. population of 325 million to calculate the average social cost per person. The answer to this is about $1,320 per person. I forgot to put this so the answer can be solved. I…arrow_forward
- The company you work for has been tracking sales histories to forecast this coming years sales. Over the last 9 years, sales have averaged $99,449.02. How many dollars in sales would the company need to do in year 10 to have an average of $99,421.7?arrow_forwardMorning House is a mail-order firm which carries a wide range of rather expensive art objects for homes and offices. It operate problems would be greatly reduced. Since it takes approximately six weeks to receive 90% of the response to a given campaign, an accurate prediction of total sales made as late as the end of the first week of receiving orders would be useful. The first week’s sales and total sales of the last 12 campaigns of the firm are shown below. Can the first week’s sales be used to predict total sales? First week’s Total Campaign Sales Sales 1 32 167 2 20 91 3 114 560 4 66 335 5 18 70 6 125 650 7 83 401 8 65 320 9 94 470 10 5 15 11 39 210 12 50 265 --------------------------------------------arrow_forwardA real estate company owns 120 apartments which are fully occupied when the rent is $700 per month. Analytics indicate that for each $35 increase in rent, 5 apartments will become unoccupied. What rent should be charged in order to obtain the largest gross income?arrow_forward
- Please show steps in Excel. The 32 teams in the National Football League (NFL) are worth, on average, $1.17 billion, 5% more than last year. The datafile NFLTEAMVALUE shows the annual revenue ($millions) and the estimated team value ($ millions) for the 32 NFL teams (Forbes website, February 28, 2014). a.Develop a scatter diagram with Revenue on the horizontal axis and Value on the vertical axis. Does there appear that there is any relationship between the two variables? b. What is the sample correlation coefficient? What can you say about the strength of the relationship between Revenue and Value? Team Revenue ($ millions) Current Value ($ millions) Arizona Cardinals 253 961 Atlanta Falcons 252 933 Baltimore Ravens 292 1,227 Buffalo Bills 256 870 Carolina Panthers 271 1,057 Chicago Bears 298 1,252 Cincinnati Bengals 250 924 Cleveland Browns 264 1,005 Dallas Cowboys 539 2,300 Denver Broncos 283 1,161 Detroit Lions 248 900 Green Bay Packers 282 1,183 Houston…arrow_forwardThe January 2010 National Health Expenditures report stated that overall health care spending in the United States rose from $7,421 per person in 2007 to $7,681 per person in 2008. Estimate the total amount spent on health care in the United States in 2007 and in 2008.arrow_forwardOpinions are split about a coffee company's pumpkin-flavored coffee (PFC). Yet every year over the last five years the consumption of pumpkin-flavored goods has increased. If we look at the numbers, it also becomes clear why a leading coffee company keeps offering the PFC earlier and earlier every year. According to a magazine, the amount spent by PFC buyers at the coffee company is about 17% higher than non-PFC buyers. The accompanying table shows a random sample of eight consumers, the amount they spend per week, y, and the number of PFCs purchased, x, per week. PFC Spending 1 13.17 8 38.65 3 19.49 2 9.56 4 15.85 1 21.82 5 37.53 3 13.69 α=0.05 t= 3.07 p-value= 0.022 Construct a 95% confidence interval for the population slope. UCL = 6.69 LCL = 0.75 What conclusions about PFC purchases and spending can be drawn from these…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill