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
Visual Basic 1. What is the method of creating a new project in VB.SSS 2. Illustrate Code Editor Window and Solution Explorer. 3. Write a VB program to sort and display a

Restricting The Vocabulary: The properly formed vocabulary is like an inverted pyramid. All easy to learn communication system follow this pattern. The canonical vocabulary in

i need code for assignment problem of operational research in vb

Part 1: Create an application that allows the user to enter the following employee data: First Name, Middle Name, Last Name, Employee Number, Department, Telephone Number, Telephon

Returns or sets a numeric value indicating an error. Number is the Err object's default property. While returning user-defined error from an Automation object, set Err.Number throu

Problem 1. Describe the concept of exception in .Net environment 2. Explain the process of adding, updating and deleting records with an example 3. Explain DTD elements a

flow chart symbols

Function IsPalindrome(str) Dim iStart,iEnd,ctr,blnPalin str=trim(str) blnPalin=true iEnd=len(str) iCnt=round(iEnd / 2) iStart=1 for ctr=1 to cint(iCnt) if(mid(str,iEnd,

Sets or returns context ID for topic in Help File. If Help file is indicated in the VBScript Err Object HelpFile Property, the HelpContext property is utilized to display automatic

Indexing: In libraries, the card catalog is the index. The three indices are used in the library. The Author, Subject and title are the 3 indices. Each index is relative. The