Application that determines the optimal inventory policy, Visual Basic Programming

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.

Posted Date: 3/2/2013 5:18:35 AM | Location : United States







Related Discussions:- Application that determines the optimal inventory policy, Assignment Help, Ask Question on Application that determines the optimal inventory policy, Get Answer, Expert's Help, Application that determines the optimal inventory policy Discussions

Write discussion on Application that determines the optimal inventory policy
Your posts are moderated
Related Questions
MODULE The Modules are the collection of VB statements. Modules are used to simplify the program development. To add a module to your project, choose the project tabpage, and t

types and concept of recurson

translate''Q''for insert into element and''Q''delete for deletion element into programming language

Sets or returns wholly qualified path to a Help File. If Help file is indicated in HelpFile, it is called automatically when the user clicks Help button (or presses the F1 key) in

I have a project due tomorrow that I am really struggling in. Please help.

The following table lists suggested conventions for objects you might encounter while programming VBScript. Code Commenting Conventions All process should begin with a brie

We will discuss scripting language; called VB Script. VBScript is Microsoft's scripting language. It enables us to write programs which enhance the power of Web pages by letting us

I need a VB6 software for making a soccerboard for 10 teams & automatically generate their fixtures


CLASS WIZARD The Class wizard shown in figure is a tool to handle the message handlers for objects, to define the member variables. Figure: Class Wizard