Preview

Optimization modeling for spreadsheetsPortland

Powerful Essays
Open Document
Open Document
6468 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Optimization modeling for spreadsheetsPortland
Optimization Modeling for Inventory Logistics
Engineering & Technology Management
ETM 540 – Operations Research in
Engineering and Technology Management
Fall 2013
Portland State University
Dr. Tim Anderson

Team: Logistics
Noppadon Vannaprapa
Philip Bottjen
Rodney Danskin
Srujana Penmetsa
Joseph Lethlean

Optimization Modeling for Inventory Logistics

Contents
Abstract ......................................................................................................................................................... 2
Literature review........................................................................................................................................... 2
Review of Optimization Modeling ............................................................................................................ 3
Logistics Characterization ......................................................................................................................... 4
Methodology............................................................................................................................................. 6
Problem Background..................................................................................................................................... 6
Industry Players......................................................................................................................................... 6
Current Business Process .......................................................................................................................... 8
Problem Statement ................................................................................................................................... 9
The Goal of the Project ................................................................................................................................. 9
Scope


References: Vehicle Manufacturers, 2013. [Online]. Available: http://www.oica.net/category/productionstatistics/2012-statistics/. [Accessed: 09-Nov-2013]. publications, 1998. 334–346, 2007. 4, pp. 366–422, 1960. [10] “In Memoriam: Leonid Khachiyan,” Rutgers, The State University of New Jersey, 2003 pp. 217 –240, 2011. 1, pp. 21 – 37, 2006. Publishers, 2001. Page Limited, 2010. [16] “Opportunities in Thailand’s Automotive Industry,” Thailand Board of Investment, 2013
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Powerful Essays

    Bsbmg522a Undertake Project Review Paper
    • 5764 Words
    • 24 Pages

    Bsbmg522a Undertake Project Review Paper

    Identify the assumptions that were made to form the basis of defining scope and any that will be made for the purposes of planning the project. List any constraints on the project or dependencies on resources or funding to the project (e.g. time, cost, dates, regulatory issues).…

    • 5764 Words
    • 24 Pages
    Powerful Essays
    Read More
  • Good Essays

    Accounting Project: Calculations
    • 371 Words
    • 2 Pages

    Accounting Project: Calculations

    Cost of new equipment $200,000 Expected life of equipment in years 5 years Disposal value in 5 years $40,000 Life production - number of cans 5,500,000 Annual production or purchase needs 1,100,000 Number of workers needed 3 Annual hours to be worked per employee 2000 hours Earnings per hour for employees $12.00 Annual health benefits per employee $2,500 Other annual benefits per employee-% of wages 18% Cost of raw materials per can $0.25 Other variable production costs per can $0.05 Costs to purchase cans - per can $0.45 Required rate of return 12% Tax rate 35% Make Purchase Need of 1,100,000 cans per year *.25 $275,000 Variable production costs *.05 $55,000 Wages $72,000 Health benefits $7,500 Other benefits $12,960 Total wages and benefits $92,460 $422,460 $495,000 (72540) Before Tax Tax Effect After Tax Item Amount Amount Annual cash savings (make vs buy) $72,540 0.65 $47,151 * Tax effect on Annual Cash Savings is 1 - tax rate Tax savings due to depreciation $32,000 0.35 $11,200 * Tax effect on Depreciation is the tax rate Total annual cash flow $58,351.00 Initial investment/ Annual Cash Saving $200,000/ $58351= 3.4 years Annual cash savings (before tax effect) $72,540 Less Depreciation $(32,000) Before tax income $40,540 Tax at 35% rate $(14,189) After tax income $26,351 $ 26,351 / 200,000 13.18% Before Tax After tax 12% PV Present Item Year Amount Tax % Amount Factor Value Cost of machine 0 $(200,000) $(200,000) 1 (200,000) Annual cash savings 1-5 $72,540 0.65…

    • 371 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Spreadsheet and Monthly Worksheets
    • 369 Words
    • 2 Pages

    Spreadsheet and Monthly Worksheets

    you move to the next step. Enter your name in cell B4 of the Documentation sheet.…

    • 369 Words
    • 2 Pages
    Good Essays
    Read More
  • Powerful Essays

    Economic Issues Simulation Paper
    • 1212 Words
    • 5 Pages

    Economic Issues Simulation Paper

    As a representative of Castor Insurance, the job is to maximize profit and minimize risk for the company. Healthcare is a high in demand good that the consumers of any job wants and needs to have. So it is very important to chose the right kind of healthcare for your employees. The two companeys in question Constructit and E-editors need to choose a well balanced health insurance plan that will work for there group of people.…

    • 1212 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Economic Issues Simulation Paper
    • 1073 Words
    • 5 Pages

    Economic Issues Simulation Paper

    Health care economics studies such issues as demand for medical care, pharmaceutical prices, competition among health care providers and insurers, and financing of health care services. Castor Collins has put together a plan which will help solve many issues facing the organization. The plan is built to maximize profit for the company and minimize the risk of poor choices provided to individuals who will cause the organization to fall.…

    • 1073 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Bottlenecks in a Process Paper
    • 544 Words
    • 3 Pages

    Bottlenecks in a Process Paper

    I notice you used a source of reference to define bottlenecks and it is different than our course of study. However, I am not sure if you understand the concept of bottleneck correctly as evidence discussed in your paper. Except for you mentioning heart rate and vital signs being abnormal and these factors can limit the capacity of your workout and there is limited discussion about this bottleneck. (-3) Consider using a value-added analysis (focused on eliminating the non–value-adding activities), you might be able to reduce the workout time and maintain an acceptable heart rate for your activities. I would like to have seen you support your perspectives of the process and support it with theoretical concepts from the assigned reading where necessary. (-.25)…

    • 544 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Spreadsheet Modeling and Decision Analysis (
    • 368 Words
    • 2 Pages

    Spreadsheet Modeling and Decision Analysis (

    Sensitivity Report A sensitivity report of the analysis described above was created and can be found in Appendix E. The solution is not degenerate because there are no zero values in the allowable increase or allowable decrease columns of the constraints in the Sensitivity Report. All of the constraints affect the optimal solution. The solution is unique because there are no zero values in the allowable increase or allowable decrease columns in the decision variables section of the Sensitivity Report. This shows that there are no other combinations of production levels that will optimize this solution.…

    • 368 Words
    • 2 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Speadsheet Modeling & Decision Analysis 5e: Chapter 3 Solutions
    • 4511 Words
    • 19 Pages

    Speadsheet Modeling & Decision Analysis 5e: Chapter 3 Solutions

    Acres planted in watermelons = 60, Acres planted in cantaloupes = 40, Maximum profit = $26,740…

    • 4511 Words
    • 19 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Quiz on Linear Programming Models: Graphical and Computer Methods
    • 2781 Words
    • 17 Pages

    Quiz on Linear Programming Models: Graphical and Computer Methods

    3) A redundant constraint is eliminated from a linear programming model. What effect will this have on the optimal solution?…

    • 2781 Words
    • 17 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Demand Estimation Paper and Excel Assignment
    • 1031 Words
    • 17 Pages

    Demand Estimation Paper and Excel Assignment

    For this assignment, one is to imagine that they work for the maker of a leading brand of low calorie, frozen microwavable food. The maker estimates a demand equation for its product. They use data from twenty-six supermarkets around the country for the month of April. To get a better understanding of how to solve the equation, one must first have a better understanding of demand estimation.…

    • 1031 Words
    • 17 Pages
    Better Essays
    Read More
  • Better Essays

    Financial Reporting Model
    • 809 Words
    • 3 Pages

    Financial Reporting Model

    I am a coworker and friend to Mr. Ethics. This morning at break, he appeared to look worried and under a lot of stress. Being his friend, I ask if he needed to talk. He told me that Mr. Fraud, the CEO of the company for which we work, called him into his office and asked him to adjust the books so that a spot of land purchased is recorded at book value of $50,000 rather than the price of $20,000 actually paid for the land. He also asked Mr. Ethics to reverse bad debt from the customer Mr. Bankrupt while ignoring the news about how Mr. Bankrupt’s company is experiencing financial trouble. Mr. Ethics continues to tell me that Mr. Fraud has requested that $30,000 of recorded unearned revenue be recorded as service revenue to increase company sales. Mr. Fraud states that if Mr. Ethics performs everything requested the company will be able to obtain a loan from the bank for new equipment.…

    • 809 Words
    • 3 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Multinational Business Finance 10th Edition Solution Manual
    • 41192 Words
    • 165 Pages

    Multinational Business Finance 10th Edition Solution Manual

    Frankfurt & New York................................................. Peso Exchange Rate Changes……………………….. Good as Sold……………………………………………. Gold Standard…………………………………………… Spot Rate Customer……………………………………. Forward Rate……………………………………………. Forward Discount on the dollars………………………. Forward Premium on the euro………………………… Iraqi Imports……………………………………………..…

    • 41192 Words
    • 165 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Data Modeling and Product Table
    • 375 Words
    • 2 Pages

    Data Modeling and Product Table

    6. Modify the table structure by adding a new field named Unit (data type: Text, field size: 15) between the Price and Color fields. Move the Size field so that it follows the Material field.…

    • 375 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Financial Models in Excel
    • 1424 Words
    • 6 Pages

    Financial Models in Excel

    Payments Time: Bond 1 Bond 2 Bond 3 Bond 4 Bond 5 1 104 4 4 4 4 2 0 104 4 4 4 3 0 0 104 4 4 4 0 0 0 104 4 5 0 0 0 0 104…

    • 1424 Words
    • 6 Pages
    Good Essays
    Read More
  • Powerful Essays

    ITVEM Optimization Model
    • 1383 Words
    • 6 Pages

    ITVEM Optimization Model

    Associated with the ITVEM optimization model, it will be the optimization of the cost minimization, although the optimization can also be in terms of maximizing the performance. To do so, Figure V.5 can assist to be a chart reference, whereas it should also develop several assumptions regarding the optimization process, for example, the Cobb-Douglas production function (Lin and Kao, 2014) replaces each the desired output (the starred y*it, i = 1, 2, 3, 4 and t = 1, ..., 11) of subsystems. In this optimization testing, the data that will be used is Telkom’s data representing the others. Moreover, the Cobb-Douglass function is as follows:…

    • 1383 Words
    • 6 Pages
    Powerful Essays
    Read More

Related Topics