MBA 580 Module 2
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
580
Subject
Business
Date
Jan 9, 2024
Type
docx
Pages
4
Uploaded by msmith605
Michael Smith
MBA 530
Professor Paul Markham
12/17/2023
Financial Justification Sales Forecast Data-Option A
0
1
2
3
4
5
6
7
8
9
10
0
50
100
150
200
250
300
350
Chart Title
Sales forecast Data Option A Tradiitional Sales forecast Data Option A Connected
Sales forecast Data Option A Connected
Sales Forecast Data-Option B
0
1
2
3
4
5
6
7
8
9
10
0
50
100
150
200
250
300
Chart Title
Sales Forecast Data-Option B Traditional
Sales Forecast Data-Option B Connected
Sales Forecast Data-Option B Connected
Gross Margin Forecast Data- Option A
0
1
2
3
4
5
6
7
8
9
10
0
5
10
15
20
25
30
35
40
45
50
Chart Title
Gross Margin Forecast Data - Option A Traditional
Gross Margin Forecast Data - Option A Connected
Gross Margin Forecast Data- Option B
0
1
2
3
4
5
6
7
8
9
10
0
5
10
15
20
25
30
35
40
45
Chart Title
Gross MarginForecast Data- Option B Traditional
Gross MarginForecast Data- Option B Connected
Gross MarginForecast Data- Option B Connected
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
New
Accounts
New
Accounts
Period
200
232
11
214
248
12
211
250
13
228
253
14
5
235
10
267
15
Using linear regression, what is your forecast for period 16?
Less than 300
Between 301 and 308
Between 309 and 350
Period
1
2
3
4
O Higher than 350
Period
6
7
8
9
New
Accounts
281
275
280
288
310
arrow_forward
Choose the correct option and answer:
1) In which of the following circumstances is godown is not required to store the goods ?
a) Seasonal Demand b) customized production c) Perishable goods d) Raw material-seasonal
2) Which service is most beneficial in coastal area ?
a) Daily service b) Ferry service c) private service d) tourism service
3) Which of the following is not included in non-financial transactions done by bank ?
a) to give bank statement b) cheque book issue c) issue pass book d) issue demand draft
4) What does bank do to pay the money whose name is written in draft ?
a) Orderr b) Instruct c) request d) insist
5) What is required for online sale,banking and transportation ?
a) B2B b) B2C c) C2B d) C2C
arrow_forward
(b) Demand history of five different products of a company is shown below.
Products
2012
2013
2014
2015
2016
2017
2018
2019
2020
A
37
40
41
45
49
26
34
30
26
23
33
28
32
C
58
55
32
38
45
56
62
70
77
86
95
83
88
81
92
85
i. Name the methods that is suitable to forecast the demand of the above five products?
ii. Forecast demand of the product B or D with error for the year 2021. If you need a value of a then
consider it 0.7.
arrow_forward
If ABC Corporation has following historical data about sales volume:
Years
Sales
Years
Sales
Years
Sales
Years
Sales
2001
110
2006
99
2011
100
2016
110
2002
112
2007
101
2012
104
2017
111
2003
122
2008
95
2013
108
2018
109
2004
111
2009
98
2014
102
2019
114
2005
104
2010
96
2015
115
2020
112
Note: All the sale values are in thousands.
Required:
Which type of forecasting approach is suitable for this type of data?
Which forecasting technique is best to employ in order to forecast the above data? And also define the suggested technique.
Calculate the predicted values by employing the discussed technique in part (b) on the above data.
arrow_forward
Alt
Degree
Assignment
January-June
Bebeware Open
Universby
All Gr
Special/ Supplementary Structured Timed
BMK722-Principles of Marketing
7. A specialty store is
A. A store that carries a narrow products line with a deep assortment
B. Any store that carries standardized merchandise and sold at lower prices with
lower margins and higher volumes
C. A store that sells merchandise bought at less than regular wholesale prices and
sold at less than retail
D. A store that carries several product lines
8. Segmented pricing is
A. Promotional money paid by manufacturers to retailers, in return to agreement to
feature the manufacturer's products in some way
B. Prices that buyers carry in their minds and refers to when they look at given
product
C. Selling a product or service at two or more prices, where the difference in prices
is not based on differences in costs
D. None of the above
9. Which of the following is not one of the steps in the new product development process?
A. Idea generation
B.…
arrow_forward
Assuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be for future deseasonalized demand estimates?
(Hint, you might want to use excel for this)
period
1
2
3
4
5
6
7
8
9
10
13673
6640
2737
3486
141 13186)
5448
3485
7728
16591
8236
3316
855358
11
12
13
15
16
17
18
19
Demand Deseasonalized
D₁
Demand D
3200
7658
4420
2384
3654
8680
5795
1953
4742
20
4472
4657
4956
5074
5157
5917
6646
6850
6791
6573
6363
6308
6932
7887
8662
8989
O Level-4696 Trend-343
O Level-3612. Trend-264
O Level 3629; Trend-263
O Level-2528: Trend-185
arrow_forward
Suppose that AlwaysRain Irrigation’s marketing department will undertake an intense ad campaign for the bronze sprinklers, which are more expensive but also more durable than the plastic ones. Forecast demand for the next four years is:
YEARLY DEMAND
1 (IN 000s)
2 (IN 000s)
3 (IN 000s)
4 (IN 000s)
Plastic 90
32
44
55
56
Plastic 180
15
16
17
18
Plastic 360
50
55
64
67
Bronze 90
11
15
18
23
Bronze 180
6
5
6
9
Bronze 360
15
16
17
20
Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. Three bronze machines and only one injection molding machine are available.
Required:
What are the capacity implications of the marketing campaign? (Assume that there is no learning.)
In anticipation of the ad…
arrow_forward
Q5. Discuss the Internet marketing possibilities for the product/service in Amazon retail company?
Q6. Discuss the use of social media in the marketing of the product/service in Amazon retail company?
arrow_forward
QUESTIONS:
Quarterly demand for a washing machine is as shown.
1. After obtaining initial estimates for level, trend, and seasonal factors. forecast the demand for the first
quarter of year III using Winter's model with a 6- - 0,25 where x is the last two digits of your
student number.
2. Make a tracking signal analysis for the forecast and evaluate
Maks
Year
I
II
Quarter
1
2
3
4
1
2
3
4
Demand
1900
1224
4000
5600
4800
1048
6200
8000
arrow_forward
Q29 please help me!!
arrow_forward
Month
Demand Forecast
Error
Abs Error alpha
1
20
2
18
3
21
4
25
5
24
6
27
7
22
8
30
9
23
10
20
11
29
12
22
Mean
Bias
MAD
(mean
error)
Problem 6: Maverick Jeans' demand manager decided to evaluate exponential
smoothing. To maintain com- parability, she used the data from problem 6, copied below.
1
Month
2 3
Demand 20 18 21 25
4 5
24
6
7
8 9 10 11 12
27 22
30 23 20 29 22
Develop forecasts for months 5-12. Calculate the Bias and MAD. Use a starting forecast
of 20 for month 4 and an alpha value of 0.2. (Note: Adjust all cell values to two decimal
points.)
arrow_forward
tions Management Spring21
Time left 0:30:19
Qui
The sales of XYZcompany for the previous three periods are 45, 42, and 43 respectively. Estimate
the sales of the fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial
forecast (Round to 2 decimals)
O a. 42.8
O b. 41
Mar
O C. None is correct
12-
O d. 43.25
O e. 41.92
S PAGE
NEXT PAGE
Finish
TOSHIBA
F11
F17
F9
F10
F6
F7
F8
F5
F3
F4
60
AH
arrow_forward
Answer the given question with proper explanation and step by step solution.
arrow_forward
Year 1
Demand
Year 2
Demand
Year 3
Demand
1
12
1
16
1
14
45
25
32
3
76
52
3
71
84
4
4
62
4
47
a. Determine the seasonal factors for each quarter.
b. Based on the result of part (a), determine the deseasonalized demand series.
c. Predict the demand for each quarter of Year 4 for the deseasonalized series from
a six-quarter moving average.
d. Using the results from parts (a) and (c), predict the demand for the shoes for
each quarter of Year 4.
arrow_forward
I just need the first 3 please (:
arrow_forward
please answer in 30 mins. answer if 100% sure.
arrow_forward
2G
MTN Zambia
ll
78%
3:30 PM
< OperationsManagement_HW1..
4.12 Consider the following actual and forecast demand lev-
els for Big Mac hamburgers at a local McDonald's restaurant:
Day
Actual Demand
Forecast Demand
Monday
Tuesday
Wednesday
Thursday
Friday
88
88
72
88
68
84
48
80
The forecast for Monday was derived by observing Monday's
demand level and setting Monday's forecast level equal to this
demand level. Subsequent forecasts were derived by using exponen-
tial smoothing with a smoothing constant of 0.25. Using this expo-
nential smoothing method, what is the forecast for Big Mac demand
for Friday? Px
Download-
(1.009 9KB)
Comments (0)
Send
More
arrow_forward
Part C
Exponential
Exponential
Gasoline Demand
Gasoline
Month
smoothed forecast smoothed forecast
Exponential smoothed forecast (a = 0.25)
Demand
(a = 0.25)
(a = 0.45)
Exponential smoothed forecast (a = 0.45)
Mar
900
920
920
1200
Apr
May
755
915.00
911.00
1100
1000
650
875.00
840.80
g20 915.00
846 80
755
818.75
754.94
904.76
835.12
Jun
550
818.75
754.94
800
320
751.56
66272 645.74
746.83
Jul
625
751.56
662.72
650
600
550
Aug
Sep
730
719.92
645.74
820
722.44
683.66
400
D Oct
1100
746.83
745.01
200
1 Nov
835.12
904.76
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
1. Make a comparative analysis out of your answers in the plotted data. (3-5
5 sentences)
arrow_forward
Q-4: Define and briefly explain the following methods of demand estimation with
examples from the real world?
a) Consumer Surveys
b) Consumer Clinics
c) Market Experiments
arrow_forward
b. Given the demand and forecast values shown in the following Table Q3b,
i.Determine the three-period moving average forecast for November.
ii. Analyze the exponential smoothing forecast for November using a = 0.35.
iii. Evaluate the forecast error for September.
arrow_forward
Student Portal | Main
BUS-660 Topic 1 DQ 1
/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
eBook
X
X
State of Nature
Decision Alternative Strong Demand S₁ Weak Demand S₂
Small complex, d₁
7
6
Medium complex, d₂
12
6
Large complex, d3
19
-9
CengageNOWv2 | Online teachin X MindTap-Cengage Learning
Problem 4-11 (Algorithmic)
Following is the payoff table for the Pittsburgh Development Corporation (PDC) Condominium Project. Amounts are in millions of dollars.
x +
A
million, the large complex remains the best decision.
30 G
Suppose PDC is optimistic about the potential for the luxury high-rise condominium complex and that this optimism leads to an initial subjective probability assessment of 0.8 that demand will be strong (S₁) and a corresponding probability of
0.2 that demand will be weak (S₂). Assume the decision alternative to build the large condominium complex was found to be optimal using the expected value approach. Also, a…
arrow_forward
Please answer all three subparts with explanation.
I will really really upvote. Thanks
arrow_forward
Ma3.
arrow_forward
part c
arrow_forward
Question content area
Part 1
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below).
Year
Sales
1
450
2
510
3
516
4
555
5
575
Part 2
a) Forecasted sales for year 6 using the trend projection (linear regression) method are
enter your response here
sales (round your response to one decimal place).
Part 3
b) The MAD for a linear regression forecast is
enter your response here
sales (round your response to one decimal place).
Part 4
c) The MSE for the linear regression forecast is
enter your response here
sales (round your response to one decimal place).
arrow_forward
Part B
Three-period
Four-period
Units
Units Demanded
Period
weighted moving weighted moving
Demanded
Three-period weighted moving average forecast
average forecast
average forecast
Four-period weighted moving average forecast
24
2
25
60
28
50
49
S50
4
32
26.33
46
4.90
39,80
40
41
5
35
29.50
28.6
38
35
38
32.83
31.7
30
32
28
25
26,93 250 es
7
41
36.00
34.9
24
20
8
46
39.00
38
49
43.00
41.8
10
10
53
46.67
45.4
50.50
49.2
1
2
3
4
5
6
7
8
9
10
11
1. Make a comparative analysis out of your answers in the plotted data. (3-5 sentences)
arrow_forward
A forecast for the first six months of the year revealed a tendency to underpredict the actual demand for the revitalized Hubig’s Pies plant in the Marigny.
Month
Actual
Forecast
January
675
600
February
720
700
March
640
620
April
510
495
May
480
410
June
565
535
What is the MAD of this forecast?
a.
38.33
b.
64.11
c.
55.79
d.
71.89
arrow_forward
What is Use a naive method to make a forecast?
arrow_forward
Scenario 1 | New Hybrid Cultures Will Develop and Personal Horizons Will Broaden
Scenario 2 | Although the Outward Expressions of National Culture Will Continue to Become More Homogeneous, Distinct Values Will Tend to Remain Stable
Scenario 3 | Nationalism Will Continue to Reinforce Cultural Identity
Scenario 4 | Existing National Borders Will Shift to Accommodate Ethnic Differences
Identify the cultural scenario that is the most credible—that is, the forecast that you see most likely to prove accurate in the next decade. Why?
arrow_forward
Answer using irac method
Question 3
The Unemployment Program of the Government of Guava Land has several offices throughout the country, ten (10) to be specific. At these offices, all the administrative matters of the Program are administered, inclusive of payments to suppliers, payroll and Information Technology services. There are several assets and confidential data on each compound such as computer equipment, filing cabinets, personal data and several pieces of furniture.
Within recent times, there were numerous burglaries’ at a number of locations, which resulted in the loss of two million dollars’ worth in items. The Police are currently undertaking an investigation to catch the culprits.
The Minister, who is responsible for the Program, has mandated the Program to procure security services for one year at each location. After a highly competitive procurement process, Big Trouble Security Services secured the contract to provide security services at all the locations.…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
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
Related Questions
- New Accounts New Accounts Period 200 232 11 214 248 12 211 250 13 228 253 14 5 235 10 267 15 Using linear regression, what is your forecast for period 16? Less than 300 Between 301 and 308 Between 309 and 350 Period 1 2 3 4 O Higher than 350 Period 6 7 8 9 New Accounts 281 275 280 288 310arrow_forwardChoose the correct option and answer: 1) In which of the following circumstances is godown is not required to store the goods ? a) Seasonal Demand b) customized production c) Perishable goods d) Raw material-seasonal 2) Which service is most beneficial in coastal area ? a) Daily service b) Ferry service c) private service d) tourism service 3) Which of the following is not included in non-financial transactions done by bank ? a) to give bank statement b) cheque book issue c) issue pass book d) issue demand draft 4) What does bank do to pay the money whose name is written in draft ? a) Orderr b) Instruct c) request d) insist 5) What is required for online sale,banking and transportation ? a) B2B b) B2C c) C2B d) C2Carrow_forward(b) Demand history of five different products of a company is shown below. Products 2012 2013 2014 2015 2016 2017 2018 2019 2020 A 37 40 41 45 49 26 34 30 26 23 33 28 32 C 58 55 32 38 45 56 62 70 77 86 95 83 88 81 92 85 i. Name the methods that is suitable to forecast the demand of the above five products? ii. Forecast demand of the product B or D with error for the year 2021. If you need a value of a then consider it 0.7.arrow_forward
- If ABC Corporation has following historical data about sales volume: Years Sales Years Sales Years Sales Years Sales 2001 110 2006 99 2011 100 2016 110 2002 112 2007 101 2012 104 2017 111 2003 122 2008 95 2013 108 2018 109 2004 111 2009 98 2014 102 2019 114 2005 104 2010 96 2015 115 2020 112 Note: All the sale values are in thousands. Required: Which type of forecasting approach is suitable for this type of data? Which forecasting technique is best to employ in order to forecast the above data? And also define the suggested technique. Calculate the predicted values by employing the discussed technique in part (b) on the above data.arrow_forwardAlt Degree Assignment January-June Bebeware Open Universby All Gr Special/ Supplementary Structured Timed BMK722-Principles of Marketing 7. A specialty store is A. A store that carries a narrow products line with a deep assortment B. Any store that carries standardized merchandise and sold at lower prices with lower margins and higher volumes C. A store that sells merchandise bought at less than regular wholesale prices and sold at less than retail D. A store that carries several product lines 8. Segmented pricing is A. Promotional money paid by manufacturers to retailers, in return to agreement to feature the manufacturer's products in some way B. Prices that buyers carry in their minds and refers to when they look at given product C. Selling a product or service at two or more prices, where the difference in prices is not based on differences in costs D. None of the above 9. Which of the following is not one of the steps in the new product development process? A. Idea generation B.…arrow_forwardAssuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be for future deseasonalized demand estimates? (Hint, you might want to use excel for this) period 1 2 3 4 5 6 7 8 9 10 13673 6640 2737 3486 141 13186) 5448 3485 7728 16591 8236 3316 855358 11 12 13 15 16 17 18 19 Demand Deseasonalized D₁ Demand D 3200 7658 4420 2384 3654 8680 5795 1953 4742 20 4472 4657 4956 5074 5157 5917 6646 6850 6791 6573 6363 6308 6932 7887 8662 8989 O Level-4696 Trend-343 O Level-3612. Trend-264 O Level 3629; Trend-263 O Level-2528: Trend-185arrow_forward
- Suppose that AlwaysRain Irrigation’s marketing department will undertake an intense ad campaign for the bronze sprinklers, which are more expensive but also more durable than the plastic ones. Forecast demand for the next four years is: YEARLY DEMAND 1 (IN 000s) 2 (IN 000s) 3 (IN 000s) 4 (IN 000s) Plastic 90 32 44 55 56 Plastic 180 15 16 17 18 Plastic 360 50 55 64 67 Bronze 90 11 15 18 23 Bronze 180 6 5 6 9 Bronze 360 15 16 17 20 Both production lines can produce all the different types of nozzles. The bronze machines needed for the bronze sprinklers require two operators and can produce up to 12,000 sprinklers. The plastic injection molding machine needed for the plastic sprinklers requires four operators and can produce up to 200,000 sprinklers. Three bronze machines and only one injection molding machine are available. Required: What are the capacity implications of the marketing campaign? (Assume that there is no learning.) In anticipation of the ad…arrow_forwardQ5. Discuss the Internet marketing possibilities for the product/service in Amazon retail company? Q6. Discuss the use of social media in the marketing of the product/service in Amazon retail company?arrow_forwardQUESTIONS: Quarterly demand for a washing machine is as shown. 1. After obtaining initial estimates for level, trend, and seasonal factors. forecast the demand for the first quarter of year III using Winter's model with a 6- - 0,25 where x is the last two digits of your student number. 2. Make a tracking signal analysis for the forecast and evaluate Maks Year I II Quarter 1 2 3 4 1 2 3 4 Demand 1900 1224 4000 5600 4800 1048 6200 8000arrow_forward
- Q29 please help me!!arrow_forwardMonth Demand Forecast Error Abs Error alpha 1 20 2 18 3 21 4 25 5 24 6 27 7 22 8 30 9 23 10 20 11 29 12 22 Mean Bias MAD (mean error) Problem 6: Maverick Jeans' demand manager decided to evaluate exponential smoothing. To maintain com- parability, she used the data from problem 6, copied below. 1 Month 2 3 Demand 20 18 21 25 4 5 24 6 7 8 9 10 11 12 27 22 30 23 20 29 22 Develop forecasts for months 5-12. Calculate the Bias and MAD. Use a starting forecast of 20 for month 4 and an alpha value of 0.2. (Note: Adjust all cell values to two decimal points.)arrow_forwardtions Management Spring21 Time left 0:30:19 Qui The sales of XYZcompany for the previous three periods are 45, 42, and 43 respectively. Estimate the sales of the fourth period by exponential smoothing with 0.5. Use naïve as a starting/initial forecast (Round to 2 decimals) O a. 42.8 O b. 41 Mar O C. None is correct 12- O d. 43.25 O e. 41.92 S PAGE NEXT PAGE Finish TOSHIBA F11 F17 F9 F10 F6 F7 F8 F5 F3 F4 60 AHarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
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