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

Hotel management system, i need to do my final project for my last year bsc...

i need to do my final project for my last year bsc honours degree in Business Information systems. I need to develop a system which is operational for hotel management system. th

Programming project using straight-line method, Depreciation to a Salvage V...

Depreciation to a Salvage Value of 0.   For tax purposes an item may be depreciated over a period of several years, n. With the straight-line method of depreciation, each year th

Error handling in vbscript, While a run-time error takes place, the propert...

While a run-time error takes place, the properties of the Err object are filled with information which uniquely identifies the error & information which can be used to handle it. I

Vbscript operators, VBScript Operators VBScript contain a full range of...

VBScript Operators VBScript contain a full range of operators, including comparison operators, arithmetic operators, concatenation operators, and logical operators.

Mfc classes, THE MFC CLASSES The CDocument, CWinAppCFrameWnd and CView ...

THE MFC CLASSES The CDocument, CWinAppCFrameWnd and CView are derived from the CObject and they give the majority of the structure and functionality.

Crop image from tif and paste it on Excel Sheet, I have a tiff image of 25 ...

I have a tiff image of 25 pages. I capture particular square from particular page and past on one excel sheet one by one. it is possible, if yes how. Image have line no and pe

John Galt requests a program to double-check his Gas Bill, John''s gas supp...

John''s gas supply is read from a 4-digit meter each month that shows the current total gas used in cubic meters. The amount of gas used that month is determined by subtracting t

For next loop - vbscript, You can employ For...Next statements to run a blo...

You can employ For...Next statements to run a block of statements a specific number of times. For loops, employ a counter variable whose value is increased or decreased with each r

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