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
What I understand from the assignment is I have to make the VB code in file nu1. xlsm generic, and run several iterations for Kc and Ti to find out the optimal combination which wi

I have all my program done except the loan part that I am having a lot of troubles with

WINDOWS 32 BIT (WIN 32) APPLICATIONS   The Win 32 based applications are the applications developed for the windows family of the operating systems. The Win 32 applications ac

create an application that performs the following operation with the employee file created by the application in programming challenge 1: uses an open dialog box to allow the user

Assume you are creating an order entry and editing application for a book store. An order consists of a product, quantity, total price, payment type including Credit/Debit card acc

I need assistance with writing the Tryparse I have 98% of the assignment done.

Coding conventions are recommended that may help you write code via Microsoft Visual Basic Scripting Edition. Coding conventions can include the given: Naming conventions for ob

Develop a web page that is used for accepting information regarding stocks. Make sure the form carry out the possible validations. The simple instance code below merely illustrates

You can employ Do...Loop statements to run a block of statements indefinite number of times. The statements are repeated either whilst a condition is True or till a condition becom

Steps for Creating A MDI Form: 1. Build a new form and set IsMdiContainer property to true. 2. Build a child form class to add to the form. 3. Now Right click the proj