Need help badly on question 3.2. I will post the information along with the question. Thank you!

QUESTION: only need 3.2.

INFORMATION: (not sure if you need the bottom 2 info but I added anyways.

Q3. Constrained Optimisation and Scenario Analysis 3.1 Explain to John what linear programming involves and the types of problems it can help solve. (2 marks) 3.2 You are given the following data by Ecosneak: Their annual promotional budget (of 300,000); The cost of each Billboard advert (2,000) and the cost of each Magazine advert (5,000); The estimated 'reach' of each Billboard advert (20% of the men's and women's total market in 2022) and each Magazine advert (45% of the men's and women's market in 2022); There is a signed contract with World of Sports that Ecosneak will place at least 30 adverts per year in the Magazine; There is a limit of 100 on the number of dedicated Billboard spaces available in Edinburgh for Ecosneak to use. Use this information to formulate Ecosneak's promotional campaign as a linear programming problem, but do not solve. (6 marks) Q3: Constrained Optimisation and Scenario Analysis Constrained Optimisation: John Moto believes that Ecosneak's decision making might benefit from more rigorous analysis. One potential technique that he recalls from his Business Management studies at university is Linear Programming. He thinks that the technique could be used in the analysis of the company's promotional campaign, but he has only a hazy recollection of what Linear Programming involves and how it could help Ecosneak. Until now, Ecosneak's promotional campaign has been based largely on TV advertising, targeting both men's and women's markets, but this has not proved particularly effective. Jess, as marketing manager, has suggested that a combination of Billboards and Magazine advertising (in the World of Sports) may be a better approach in 2023. 5 April 2022 Management Decision Making for Business Decision Making for Marketing Managers 5MNST006W.2 5MNST007W.2 Scenario Analysis: The management team of Ecosneak would like to separately model the first-year (2024) profit from entering the kid's market segment (Option 2, above), using scenario analysis. Assume a notional fixed cost for the first year of 20,000 (120,000/6) and a selling price of 60 per pair. Assume the variable costs for the bicycle (Purchase and Distribution) can vary between 20 and 40, with a most likely value of 32 per pair. First- year demand for the bicycle is expected to range from 8,000 to 18,000 pairs, with 13,000 units the most likely level of demand for the sneakers. Table 1: Sales, Revenue and Cost Data for Ecosneak (2021 and 2022) Years 2021 2022 Sales volume Men* 29,832 25,500 Women* 29,000 30,000 Total revenues (Men) 2,684,880 2,550,000 Total revenues (Women) 2,320,000 2,100,000 Total revenues 5,004,880 4,650,000 Cost of sales (Men) 1,193,280 1,020,000 Cost of Sales (Women) 1,102,000 1,140,000 Distribution Cost 294,160 277,500 Total Cost of sales 2,589,440 2,437,500 Gross margin 2,415,440 2,212,500 Marketing and Sales 400,000 400,000 General administration cost 1,400,000 1,500,000 Net profit 615,440 312,500 *Total Sales Quality and Customer Intimacy Segments Table 2: Selling Prices and Variable Costs 2021 Men's Women's Sneakers Sneakers Price per pair 90 80 Purchase Cost 40 38 Distribution Cost 5 5 2022 Men's Sneakers 100 40 5 Women's Sneakers 70 38 5