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

  An argument supporting the importance of a strategic plan

Develop an argument supporting the importance of a strategic plan for the success of the defined business.

  Risk management methods of custom agencies

Risk Management Methods Of Custom Agencies

  Discuss the costs

Discuss the many costs that businesses face today.

  How has learning been built into strategic planning process

How the strategic plan is/might is turned into tactile and in turn operating plans and individual and team performance indicators and how has learning been built into the strategic planning process?

  Which choice is best choice in terms of salary

Review all of the job offers that the graduate student has received, considering all of the trade offs listed above. Which choice is best choice in terms of salary for this student

  Widgecorp became the market leader in snack foods

You meet with them to discuss the matter. Suggest at least 3 quantitative objects that you should keep track about each caller and/or their behavior with respect to the snack food category and indicate if each variable is continuous or discrete.

  Buyu manufactures the pc boards

BUYU Manufacturing has been contracted to provide SAEL Electronics with printed circuit and motherboards (PC) boards under the following terms:

  Swot analysis on the viability of upgrading

Assignment: Preparing for a Company-Wide Migration to Windows 8, Develop a SWOT analysis on the viability of upgrading to Windows 8 for the organization as a whole

  The organisation''s business strategy

Conduct a thorough strategic analysis of your organisation's external environment and critically evaluate how the identified issues might impact on the organisation's business strategy.

  Managing strategic change

Managing Strategic Change

  How to reduce mitigation

How do you believe that information sharing could lead to a reduction of lead times, and how would it be used to reduce its mitigation?

  Visionour vision is to be the preferred world leader in

visionour vision is to be the preferred world leader in chemicalsmissionour mission is to responsibly provide quality

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