Develop a model to forecast future demand

Assignment Help Strategic Management
Reference no: EM13899004

K's Brewery is selling its famous beers (K Lager, K-IPA, and K's Black Belt Ale) in four sales regions throughout Germany. These four regions are Northeast, Northwest, Southeast and Southwest. Due to cultural, as well as historic and political differences, demand in the four regions differs. The firm uses two general marketing tools: advertisements and promotions (determined by the marketing budget) and signing up restaurants as contract distributors that exclusively sell K beers. Regional managers are allowed to employ varying emphasis on these two strategies, depending on what they think works best in a given region. The table includes sales data for the past 12 months, as well as marketing budgets and number of contracted restaurants for each region (also per month). Also included is the proposed marketing budget for each region for the next month, and the number of restaurants that are expected to be under contract in the next month.

K's brewery's management wants to develop a model to forecast future demand. Which of the three possible predicting variables (marketing budget, number of contracted restaurants, or time) alone or in any possible combination represents the best forecasting model? Choose your preferred model, explain your choice, and forecast demand for the next month (Note: although beer sales may be subject to seasonality, you do not need to consider this to solve this problem). Further hints: The forecasts are done by each of the four regional managers, i.e. demand for each region is forecasted separately. The best forecasting model may not be based on the same predicting variable for each region.

Period (month) Demand Northeast Marketing/sales budget
Northeast
Number of contracted restaurants Northeast Demand Northwest Marketing/sales budget Northwest Number of contracted reastaurants Northeast
1 1200 25,000.00 € 80 800 18,000.00 € 50
2 1300 28,000.00 € 85 850 18,000.00 € 58
3 1200 30,000.00 € 93 820 18,000.00 € 63
4 1400 30,000.00 € 95 900 22,000.00 € 66
5 1500 30,000.00 € 95 880 22,000.00 € 67
6 1450 35,000.00 € 95 920 22,000.00 € 68
7 1550 35,000.00 € 95 900 25,000.00 € 73
8 1700 38,000.00 € 95 950 25,000.00 € 73
9 1800 35,000.00 € 95 1020 26,000.00 € 75
10 1630 35,000.00 € 95 930 27,500.00 € 79
11 1480 35,000.00 € 95 990 28,000.00 € 77
12 1480 35,000.00 € 95 1000 28,500.00 € 77
13
35,000.00 € 95
25,000.00 € 75

Demand Southeast Marketing/Sales Budget Southeast Number of contracted restaurants Southeast Demand Southwest Marketing/Sales Budget Southwest Number of contracted restaurants Southwest
990 20,000.00 € 88 1550 25,000.00 € 135
950 15,000.00 € 85 1600 25,000.00 € 135
940 15,000.00 € 80 1450 25,000.00 € 140
820 12,000.00 € 77 1500 28,000.00 € 143
900 12,000.00 € 78 1600 28,000.00 € 142
950 12,000.00 € 83 1450 28,000.00 € 144
1030 18,000.00 € 87 1640 28,000.00 € 151
1020 18,500.00 € 91 1670 28,000.00 € 158
1050 19,000.00 € 92 1750 25,000.00 € 160
1000 19,000.00 € 92 1780 25,000.00 € 157
1050 19,000.00 € 92 1800 25,000.00 € 161
1100 19,000.00 € 93 1850 25,000.00 € 161

20,000.00 € 93
25,000.00 € 160

Reference no: EM13899004

Questions Cloud

Economic order quantity and annual order and carrying cost : A manufacturer buys cardboard boxes from a supplier. The annual demand is 36000 boxes and is uniformly distributed. The boxes cost $4 each. The estimated order cost is $6, and the carrying cost rate is 30% per year. how many times a year are orders p..
What material types of transactions and transaction cycles : Prepare a broad audit plan: Papa John's International, Inc. What material types of transactions and transaction cycles are involved? If management faced tremendous pressure regarding the entity's financial performance, what opportunities might exist ..
Analyze the pros and cons for the issuer and for the buyer : Analyze the pros and cons for the issuer and for the buyer. Would an investor be indifferent between buying a callable bond or a non-callable bond from the same issuer and same maturity? Under which circumstances would be indifferent?
According to definition of quality-can both sides be right : Several years ago, a major automotive manufacturer was sued because the latch on a minivan’s rear door failed after the vehicle was hit from the side at 30 miles per hour. The plaintiff argued that the latch was of poor quality because it didn’t hold..
Develop a model to forecast future demand : K's brewery's management wants to develop a model to forecast future demand. Which of the three possible predicting variables alone or in any possible combination represents the best forecasting model?
Discuss how these will affect income and the cash available : Discuss how these will affect income and the cash available to the business
Measurements to ensure quality of the process : TQM program uses several quantitative tools and measurements to ensure quality of the process. Evaluating processes and performances that uses system of quantitative rates, reports, annual reviews of attainments, etc.
Cultivated a friendship with several union stewards : The employees of Alexander Hotel are unionized. The owner has cultivated a friendship with several union stewards - they drink and play cards together. When they do ask for raises he stonewalls the negotiations by insisting that he cannot afford the ..
Describe an alternative marketing strategy : Describe an alternative marketing strategy

Reviews

Write a Review

Strategic Management Questions & Answers

  What are four types of sbus and what are the goals of each

Name two types of organizational design and explain how they differ. What are four types of SBUs, and what are the goals of each?

  The most difficult barriers to strategy implementation

Please discuss what you consider to be the most difficult barriers to strategy implementation and discuss the value of evaluation and measurement in ensuring strategy implementation.

  Difference between strategic alliance and partnership

Difference between Strategic Alliance and Partnership

  Analysis of the organisations new product development

New product development is one of the riskiest, yet most important activities that a company can undertake. For this reason, there is significant interest and research on how companies can improve their chances of success in NPD.

  Mass customization

How does mass customization help firms combat encroaching commoditization?

  Dealing problems with team members

Dealing problems with team members

  Accurate information to marketing decision makers

Sort, analyze, evaluate, and distribute needed, timely, and accurate information to marketing decision makers.

  Question 1i discuss the key activities of the strategic

question 1i discuss the key activities of the strategic management process. explain why it is important for managers to

  About walmart and its corporate social responsibility

about Walmart and its corporate social responsibility

  Explain how and why fraud invalidates a contract

Prepare a document explaining how and why fraud invalidates a contract. Include in your treatment of this subject examples of undue influence and duress that can arise in the business context. Finally, you should describe some of the different types ..

  Brief description of the law or issue

The United States has not yet achieved equal pay in the workplace. Explain and evaluate the factors that contribute to this situation and offer a well reasoned and supported argument about whether this should be a priority for organizations operating..

  Analyze the different ways that quality can be applied

Analyze and discuss the different ways that quality can be defined and applied within the operations context and what implications does this have for an organisations as it seeks to deliver a high-quality product or service

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd