Answered step by step
Verified Expert Solution
Link Copied!

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].

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases In Human Resource Management In Hospitality

Authors: Shirley Gilmore

1st Edition

0131119834, 9780131119833

More Books

Students also viewed these General Management questions