Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Your company is planning its next marketing campaign across three online channels [Weibo, Wechat and Douyin] for markets in three cities (Beijing Shanghai, and Guangzhou].
Your company is planning its next marketing campaign across three online channels [Weibo, Wechat and Douyin] for markets in three cities (Beijing Shanghai, and Guangzhou]. Table 1 reports the expected number of added customers per dollar spent on each channel for the market in each city. Marketing spend is constrained by the available budget constraints: - Budget per city: $200,000 for Beijing, $300,000 for Shanghai, and $250,000 for Guangzhou. - Budget per channel: $300,000 on Weibo, $200,000 on Wechat, and $40 0,000 on Douyin. The company's objective is to maximize the total number of customers added through the marketing campaign. Table 1. Added customers per dollar spent on each channel and market in each city Channel Beijing Shanghai Guangzhou Weibo 7.69 7.90 8.65 Wechat 3.91 5.16 4.11 Douyin 5.31 3.84 5.73 [a] Please formulate a linear program for your company. [b] Develop a spreadsheet model to solve the LP. Make sure to show your work. to) What is the optimal solution, and what is the optimal number of customers added? Run a sensitivity report for your model and answer the following questions. Please include the screenshot of the sensitivity report before answering the following questions. [d] You realize that the number of customers added per dollar spent on Weibo for Guangzhou is equal to 3.50 instead of 8.65. Does it affect the optimal solution? [e] Due to a budget reduction of $50,000, the headquarter decides to reduce the budget in one and only one of the three cities: Beijing, Shanghai, and Guangzhou. 1313251191198. that each customer in all cities contributes equal profit, which city would you recommend to reduce the budget? How will the budget reduction affect the number of customers added through the marketing campaign
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started