Assignment Instructions and Structure

Very Important Note:
The Instructions:

PLEASE READ AND FOLLOW THE INSTRUCTIONS VERY CAREFULLY

The subject is related to Operations Research.

I need genuine & original work (No copy, only expert work allowed) for excel spread sheet + word file.

I need excel spreadsheet + word file together provided after the order completed and details below:

The case has to have be done with excel spreadsheet solver (Mixed Integer Linear Programming Model MILP calculations in excel sheet for the case question) with excel sheet solver firstly, then word file describing in depth the case problem & solution, answering & analysing case question in depth, the answer has to be supported by excel sheet facts to case question to give the right analysis and recommendations.

The case 6.1 Giant Motor Company – Mixed Integer Linear Programming Modeling MILP (pp. 350 - 351) has to be looked by an expert in Operations Research field with excellent skills in excel sheet modeling and using solvers.

The source of the subject and assignment is Practical Management Science, W L Winston and S C Albright, Cengage Learning, 4th edition, 2012.

Note: You can find more information and guidelines in the book (Practical Management Science) from pp. 293 – 349.

ASSIGNMENT TASKS
• Examine and present the problem (in word file), formulate it as a spreadsheet (Excel Solver, Mixed Integer Linear programming model MILP calculations for the case question) and determine a solution.

ASSESSMENT ELEMENTS
• A description of the problem (in your own words) and solution (including any input and output spreadsheets used).






Subject Outline:
Quantitative Management
Subject Description

This subject is concerned with practical aspects of quantitative management, and covers recent developments in various areas of application. Applications considered include personnel scheduling, supply chain management (including logistics and inventory control), production planning and control, transportation problems and financial applications. The subject involves various case studies and study of recent journal publication.

Subject Objectives

Upon successful completion of this subject students should be able to:
1. Identify, model and solve problems involving the application of Operations Research methodology to real-life and realistic problems;
2. Use terms peculiar to the field; and,
3. Communicate your understanding of the subject orally and in written form.

Course Contribution

This subject presents the methodology commonly used in operations research/quantitative management practice in the analysis of complex systems and may include discussions on recent developments in various applications of operations research such as personnel scheduling, production planning and control, transportation problems, inventory control, supply chain management and financial applications of operations research. The subject involves various case studies and intensive study of recent journal publications.

This subject focuses on the development of some of the skills required in professional practice, and the application of skills and knowledge acquired in the other quantitative management subjects.


Content

• Professional development through real-life applications and use of spreadsheet modelling;
• Research methodology and practice.

Subject Topic

1. Operations Research Methodology and spreadsheet modelling
2. Linear Programming
3. Network Modelling
4. Quantitative Techniques for Project Management
5. Multiple Objective decision-making
6. Inventory Models
7. Decision Models and software
8. An introduction to queuing models
9. Simulation
10. Forecasting

PLEASE READ AND FOLLOW THE INSTRUCTIONS VERY CAREFULLY

The subject is related to Operations Research.

I need genuine & original work (No copy, only expert work allowed) for excel spread sheet + word file.

I need excel spreadsheet + word file together provided after the order completed and details below:

The case has to have be done with excel spreadsheet solver (Mixed Integer Linear Programming Model MILP calculations in excel sheet for the case question) with excel sheet solver firstly, then word file describing in depth the case problem & solution, answering & analysing case question in depth, the answer has to be supported by excel sheet facts to case question to give the right analysis and recommendations.

The case 6.1 Giant Motor Company – Mixed Integer Linear Programming Modeling MILP (pp. 350 - 351) has to be looked by an expert in Operations Research field with excellent skills in excel sheet modeling and using solvers.

The source of the subject and assignment is Practical Management Science, W L Winston and S C Albright, Cengage Learning, 4th edition, 2012.

Note: You can find more information and guidelines in the book (Practical Management Science) from pp. 293 – 349.

ASSIGNMENT TASKS

• Examine and present the problem (in word file), formulate it as a spreadsheet (Excel Solver, Mixed Integer Linear programming model MILP calculations for the case question) and determine a solution.

ASSESSMENT ELEMENTS

• A description of the problem (in your own words) and solution (including any input and output spreadsheets used).