Question

Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...

Question 5: Forecasting (8 p)

The table below shows the demand (in units per quarter) of a specific product in the past three years.

Quarter

Year

1

2

3

4

2015

350

254

176

228

2016

367

258

169

236

2017

342

250

166

228

Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units.

Homework Answers

Answer #1
Demand forecast for 2018:
Quarter 1 = 364 units
Quarter 2 = 260 units
Workings:
Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
2015 (i) 350 254 176 228 1008
Percentage of total [(i) / 1008] 35% 25% 17% 23%
2016 (ii) 367 258 169 236 1030
Percentage of total [(ii) / 1030] 36% 25% 16% 23%
2017 (iii) 342 250 166 228 986
Percentage of total [(iii) / 986] 35% 25% 17% 23%
Demand forecast for 2018:
Quarter 1 = 1040 units X 35%
= 364 units
Quarter 2 = 1040 units X 25%
= 260 units
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of a specific product in the past three years. Quarter Year 1 2 3 4 2015 350 254 176 228 2016 367 258 169 236 2017 342 250 166 228 Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units. Question 6: DRP (8 p) A central DC supplies a...
A loan made on March 14 is due September 13 of the following year. Find the...
A loan made on March 14 is due September 13 of the following year. Find the exact time for the loan in a​ non-leap year and a leap year. days. The exact time in a​ non-leap year is ? days The exact time in a leap year is ? days. Data Table Sequential Numbers for Dates of the Year Day of Month Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 1 1 32 60 91 121...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the seasonal influenza vaccine in preventing acute respiratory infection (ARI). A total of 507 subjects from Texas who showed symptoms of ARI were recruited for this study. The data provided show the result of each subject's test for influenza. Click to download the data in your preferred format.    CrunchIt!    CSV    Excel    JMP    Mac-Text    Minitab    PC-Text    R   ...
Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression...
Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, New Capital Expenditures, Value Added by Manufacture, and End-of-Year Inventories. Locate the observed value that is in Industrial Group 12 and has 7 employees. Based on the model and the multiple regression output, what is the corresponding residual of this observation? Write your answer as a number, round to 2 decimal places. SIC Code...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are interested in purchasing bolts from different suppliers and have obtained and tested samples of 200 bolts from three suppliers: Allnutt, Boltzman, Coachers.You have tested these in your new bolt testing machine, purchased after you had discovered your old bolt testing machine was performing erratically. (For the purposes of this question, you are safe to assume that the new machine works perfectly and that its...