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.
The application should:
1. Allow the user to enter the problem parameters into a user form.
2. 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.
3. Generate a report (on a User Form) that shows the characteristics of the optimal strategy.
The application runs at the click of a button by the user.