- Develop a descriptive model that shows, for any given demand level and any quantity ordered by Predicto, the following measures: (i) Predicto’s profit; (ii) InTech’s profit; (iii) the total profit of Predicto and InTech. In order to do so:
Clearly list all inputs (i.e., decision variables), parameters, and outputs (objective function) and assign them a symbol if necessary. [2 pts]
Hint: You can refer to Art’s newsstand for an example.
Express the algebraic relationship between inputs/parameters and constraints/outputs/objective function. [6 pts]
Hint: Please list ALL relevant equations. You can refer to Art’s newsstand for an example.
- Implement the model you developed in Q1. In the cell representing the demand, set its value to generate a random demand from a normal distribution with a mean of 10,000 and a standard deviation of 4,000. Do not worry about non-integer values, but use the function =max(mean+std*NORMINV(RAND(),0,1),0), to ensure that you do not get negative demand values. Run the simulation for an order quantity of 8,000 units, and provide a 99% confidence interval for Predicto’s expected profit, InTech’s expected profit, and total expected profit. Consider 5,000 runs of simulation. [12 pts]
Instruction: Please clearly indicate different component of your model (parameters, inputs, calculation, output). Seven points will be given for correctness and five points will be given for clarity of your implementation.
- Create a table (or a graph) in which you show the estimated expected profits (Predicto’s, InTech’s, and total) for all possible order quantities (5,000, 5,500, 6,000, …, 11,500, 12,000). Based on your estimates, what should be Predicto’s optimal order quantity if it wanted to maximize its expected profit? [7 pts]
Instruction: Five points will be given for correctness and two points will be given for clarity of your implementation. You may include your answer to Q2 and Q3 in the same spreadsheet.
Questions 4-5 are related to the Quantity Discount Contract:
- Modify your benchmark model in Q1 to represent the new setting. Specifically, list new parameters and adjust the algebraic relationship between inputs/parameters and constraints/outputs/objective function to incorporate all-unit quantity discount. We are still interested in (i) Predicto’s profit; (ii) InTech’s profit; (iii) the total profit of Predicto and InTech. [5 pts]