Application that determines the optimal inventory policy, Visual Basic Programming

Assignment Help:

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.


Related Discussions:- Application that determines the optimal inventory policy

Employee data, Part 1: Create an application that allows the user to enter ...

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

Variable naming conventions, For reason of readability & consistency, emplo...

For reason of readability & consistency, employ the following prefixes along with descriptive names for variables in your VBScript code. S ub type Prefi

Associating images to toolbars - visual basic, Associating Images to Toolba...

Associating Images to Toolbars: 1. Add an Image list to your form from the tool box. 2. Pick the custom property of the image list. 3. Click the images tab. 4. Select

Visual processing - visual interface design, Visual Processing: Our mi...

Visual Processing: Our mind groups the things into patterns and this allows us to process the visual information. Understanding and applying how the human mind processes the v

Vbscript variables, A variable is convenient placeholder which refers to a ...

A variable is convenient placeholder which refers to a computer memory location where you can store program information which may change when your script is running. For instance,

Executesql - database application, Executesql: The ExecuteSQL is used ...

Executesql: The ExecuteSQL is used for executing the query on the database. The CRecordset uses the RFX mechanism to replace data between field data members of the record set

Appwizard, APPWIZARD   The Appwizard is a tool used for creating a p...

APPWIZARD   The Appwizard is a tool used for creating a project. It follows a series of steps to create a project. Steps Involved in Creating A Project: Step 1: Fr

Numeric data types - visual basic, Numeric data types: The Integer, lo...

Numeric data types: The Integer, long integer are used for entire numbers. Single and doubles are related with the floating point numbers. Currency is related with numbers dea

Context-sensitive help, CONTEXT-SENSITIVE HELP   The Context-sensitive...

CONTEXT-SENSITIVE HELP   The Context-sensitive help gives online help for the circumstances which is associated with that state. The Context-sensitive help can be implemented

Account Balance, The user has to enter a starting balance, the dollar amoun...

The user has to enter a starting balance, the dollar amount of deposits, and the dollar amount of withdrawals. the program then has to calculate the balance

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd