1. To solve the problem, proceed as follows: Use the Generalized Optimization Modeling Procedure (GOMP) to...

Transcribed Image Text:

1. To solve the problem, proceed as follows: Use the Generalized Optimization Modeling Procedure (GOMP) to set up your problem: i. Define your model in words 1. Identify the firm's/manager's objective function in words 2. Identify the decision variables in words 3. Identify the constraints in words ii. Formulate your model mathematically 1. Define the decision variables 2. Define the objective function in terms of decision variables Define the constraints in terms of the decision variables. 3. iii. Set up the problem in Excel and use Solver to find the optimal values of the decision variables. Once you complete the GOMP, answer parts a)-e) below. Note that you do not need to re-formulate the GOMP for each part. It is sufficient to formulate it only once, for part a). 2. Please submit only one Word or pdf file. Please do not submit your spreadsheet file. The file should include your GOMP that clearly specifies the notation you are using along with answers to any follow-up questions. 3. Congratulations! While cleaning out your attic, you discovered a box of vintage T-shirts of a formerly famous character/celebrity who is suddenly popular again. You'd like to sell these T-shirts in a flash online sale, but you're not sure what price to set to make the most profit. If you set the price too high, you will earn more per shirt, but may sell too few to make a good profit. On the other hand, if you set the price too low, you will sell more shirts, but may earn too little per shirt. There is a sufficient number of shirts to satisfy any demand. Your pricing specialist has done substantial research on how online advertising affects T-shirt sales, and offers to run two types of campaigns for you: a banner ad campaign and a targeted email campaign. The specialist tells you that the number of T-shirts you will sell is given by the following formula: Quantity Sold (100 - T-shirt Price + Square Root of Banner Dollars / 2 + Square Root of Email Dollars) The specialist informs you that you must set your shirt price to a minimum of $50. You must spend at least $100 on each campaign. You may spend up to $1000 dollars total on advertising (we'll call this the "budget constraint"). Finally, you must spend exactly as much on the banner campaign as the email campaign (we'll call this the "balance constraint"). a) Use the GOMP to determine your objective function, decision variables, constraints, and optimal decisions. What is your optimal price, banner advertising spend, and email advertising spend? What is your profit under the optimal solution? Don't be concerned if in your solution you sell a fractional number of T-shirts. b) Drop the balance constraint and re-solve your model. How much more profit do you earn by dropping the balance constraint? c) Add the balance constraint back in but drop budget constraint and re-solve your model. How much more profit do you earn by dropping the budget constraint? d) Now drop the balance constraint and the budget constraint and re-solve your model. How much more profit do you earn by dropping both constraints together? e) Compare the value in d) against the sum of the values in b) and c). What does this tell you about the value of relaxing multiple binding constraints? Specifically, can you predict what will happen when you drop multiple binding constraints simply by summing the effects of dropping each one individually? 1. To solve the problem, proceed as follows: Use the Generalized Optimization Modeling Procedure (GOMP) to set up your problem: i. Define your model in words 1. Identify the firm's/manager's objective function in words 2. Identify the decision variables in words 3. Identify the constraints in words ii. Formulate your model mathematically 1. Define the decision variables 2. Define the objective function in terms of decision variables Define the constraints in terms of the decision variables. 3. iii. Set up the problem in Excel and use Solver to find the optimal values of the decision variables. Once you complete the GOMP, answer parts a)-e) below. Note that you do not need to re-formulate the GOMP for each part. It is sufficient to formulate it only once, for part a). 2. Please submit only one Word or pdf file. Please do not submit your spreadsheet file. The file should include your GOMP that clearly specifies the notation you are using along with answers to any follow-up questions. 3. Congratulations! While cleaning out your attic, you discovered a box of vintage T-shirts of a formerly famous character/celebrity who is suddenly popular again. You'd like to sell these T-shirts in a flash online sale, but you're not sure what price to set to make the most profit. If you set the price too high, you will earn more per shirt, but may sell too few to make a good profit. On the other hand, if you set the price too low, you will sell more shirts, but may earn too little per shirt. There is a sufficient number of shirts to satisfy any demand. Your pricing specialist has done substantial research on how online advertising affects T-shirt sales, and offers to run two types of campaigns for you: a banner ad campaign and a targeted email campaign. The specialist tells you that the number of T-shirts you will sell is given by the following formula: Quantity Sold (100 - T-shirt Price + Square Root of Banner Dollars / 2 + Square Root of Email Dollars) The specialist informs you that you must set your shirt price to a minimum of $50. You must spend at least $100 on each campaign. You may spend up to $1000 dollars total on advertising (we'll call this the "budget constraint"). Finally, you must spend exactly as much on the banner campaign as the email campaign (we'll call this the "balance constraint"). a) Use the GOMP to determine your objective function, decision variables, constraints, and optimal decisions. What is your optimal price, banner advertising spend, and email advertising spend? What is your profit under the optimal solution? Don't be concerned if in your solution you sell a fractional number of T-shirts. b) Drop the balance constraint and re-solve your model. How much more profit do you earn by dropping the balance constraint? c) Add the balance constraint back in but drop budget constraint and re-solve your model. How much more profit do you earn by dropping the budget constraint? d) Now drop the balance constraint and the budget constraint and re-solve your model. How much more profit do you earn by dropping both constraints together? e) Compare the value in d) against the sum of the values in b) and c). What does this tell you about the value of relaxing multiple binding constraints? Specifically, can you predict what will happen when you drop multiple binding constraints simply by summing the effects of dropping each one individually?