t-time screenings are: • Total number of screenings during day time must be at least 18 • Total number of nightly screenings must be at least 60% of the total number of screenings for the whole advertising campaign. • The number of day-time and night-time screenings on each day must not exceed 12 and 16 respectively. Based on the given information: (a) Develop a linear programming (LP) model to maximise the total number of views for this advertising campaign. Your model must be in the form of algebraic equations and inequalities where appropriate. Define clearly the Decision variables, the Objective function and Constr
Your General Manager has given you his requirements on the budget for this advertising campaign. They are:
• The screening of the advertisement will be done on two consecutive days – Saturday and Sunday. Screenings will be over two periods each day, viz: day-time (9.00am to 5.00pm) and night-time (7.00pm to 11.00pm).
• Total budget available for the advertising campaign is $30,000
• The maximum amount of money for advertising on Saturday (day-time and night-time) is $9600
With the help of a digital marketing consultant, you determined the following details for launching the advertising campaign on a popular social media:
Day/period Cost per Screening Expected Number of Views per screening
Saturday (day-time)
$450
5300
Saturday (night-time)
$470
8000
Sunday (day-time)
$500
5500
Sunday (night-time)
$550
8200
BUS107 (Online) Group-based Assignment
SINGAPORE UNIVERSITY OF SOCIAL SCIENCES (SUSS) Page 8 of 9
Specific requirements for day-time and night-time screenings are:
• Total number of screenings during day time must be at least 18
• Total number of nightly screenings must be at least 60% of the total number of screenings for the whole advertising campaign.
• The number of day-time and night-time screenings on each day must not exceed 12 and 16 respectively.
Based on the given information:
(a) Develop a linear programming (LP) model to maximise the total number of views for this advertising campaign. Your model must be in the form of algebraic equations and inequalities where appropriate. Define clearly the Decision variables, the Objective function and Constraints.
Step by step
Solved in 4 steps with 4 images
(b) Solve the LP model using the Excel Solver and present your Answer and Sensitivity Reports as generated by the Solver (please do not type or re-format the reports)
by Bartleby Expert