Discount Models
Objective: To develop an Application (Excel + VBA) that determines the optimal inventory policy under an All-Units Discount scheme.
APPLICATION CHARACTERISTICS
Consider the All-Units Discount Inventory Model.
Develop an application (EXCEL + VBA) that determines the optimal inventory policy, out of data on a spreadsheet.
- Allow the user to enter the problem parameters into a user form.
- Read the relevant intervals data from a spreadsheet (the user does not introduces the number of price intervals), such as: breakpoints (upper and lower), unit purchase cost.
- Generate a report (on a User Form) that shows the characteristics of the optimal strategy.