Submission Guideline: This sheet and a spreadsheet with Solver are required.

English Motors, Ltd.(EML) developed a new all-wheel-drive sports utility vehicles. As part of the marketing campaign, EML produced a video tape sales presentation to send to both owners of current EML four-wheel-drive vehicles as well as to owners of four-wheel-drive sport utility vehicles offered by competitors; EML refers to these two target markets as the current customer market and the new customer market. Individuals who receive the new promotion video will also receive a coupon for a test drive of the new EML model for one weekend. A key factor in the success of the new promotion is the response rate, the percentage of individuals who receive the new promotion and test drive the new model. EML estimates that the response rate for the current customer market is 25% and the response rate for the new customer market is 20%. For the customers who test drive the new model, the sales rate is the percentage of individuals that make a purchase. Marketing research studies indicate that the sales rate is 12% for the current customer market and 20% for the new customer market.

The cost of each promotion, excluding the test drive costs, is $4 for each promotion sent to the current customer market and $6 for each promotion sent to the new customer market. Management also specified that a minimum of 32,000 current customers should test drive the new model and a minimum of 12,000 new customers should test drive the new model. In addition, the number of current customers who test drive the new vehicle must be at least twice the number of new customers who test drive the new vehicle. If the marketing budget, excluding test drive costs, is $1.2 million, how many promotions should be sent to each group of customers in order to maximize total sales?

Step 1: Describe the objective.

Step 2: Describe each constraint.

Step 3: Define the decision variables.

Step 4: Write the objective in terms of the decision variables.

Step 5: Write the constraints in terms of the decision variables. .---All constraints have to have a format of Right-Hand Side a number only.

2. Please make an LP model based on your step 4 and step5.

Please refer to your spreadsheet and write a verbal conclusion to state the number of promotions sent to the group of current customers and the group of new customers and the maximized total sales. Must indicate the cells you referred on the Excel spreadsheet. Please figure out the sales from each of the two groups of customers. (Minimum words: 30).