Preview

Assignment 3

Good Essays
Open Document
Open Document
1286 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Assignment 3
Prepared by: Syed Mustafa Ahmed
Student ID: 500-513-715
Assignment #3
Professor: Amy Peng

Course: ECN 620

Question #1: Choosing optimal public transit fleet size Excel Solutions Q1
Q2
K
SUMPRODUCT

Solutions
5
2
5
1

Max (

290

Constraints
1

-1
0
<=
0

1
-1
-3
<=
0 1

5
>=
0

1

2
>=
0

1
5
>
0

How this table was created? The constrains and other valuable information that was given by the question and with manual analysis was inserted into the Excel spreadsheet in an appropriate format. The Excel Solver function was utilized in order to get the solutions.
Interpretation: This table gives us the optimal values of fleet size we should consider to solve the problem. Using the manual analysis we already know that the only possible cases are 3 and 4 respectively. But case 3 is most optimal because profit is maximized in it( 290) while in case 4( 215).

Question #2: Assigning milk to three variety stores problem.

Excel Solutions
How this table was created?
Choices values are binary and were chosen at random before the Excel Solver was computed. Number of gallons were given by the question alongside its respective probability. Revenue was also highlighted in the question. Demand one is $2 for one gallon, demand one for two gallons is $2-0.5=1.5 in which 0.5 is the opportunity cost, demand three for three gallon is 2-0.5-0.5=1. Same method is followed for demand two and three. Expected revenue of store one at one gallon is calculated by Demand one at one gallon*probability at one gallon + demand two at one gallon * probability at two gallons + demand three at one gallon * probability at three gallons. In numerical it will be (2*.06+2*0+2*0.4=2). Same method was considered to calculate expected revenue for all stores at two and three gallons respectively. Calculation are given below. Objective function was calculated by using Excel "SUMPRODUCT" of choices and expected revenue.
Expected

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Assignment 2

    • 338 Words
    • 2 Pages

    1. Joan's conduct is protected by the business judgment rule, because its a legal principle that makes officers, directors, managers, and other agents of the corporation immune from liability to the corporation for loss incurred in corporate transactions that are within their authority and power to make when sufficient evidence demonstrates that the transactions were make in Good Faith.…

    • 338 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Assignment 3

    • 255 Words
    • 2 Pages

    6. Show that immigration, like population growth, tends to create unemployment in the short run and reduce the standard of living of workers in the long run, even though it does enhance the economy’s ability to produce.…

    • 255 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    ASSIGNMENT 2

    • 1085 Words
    • 3 Pages

    The principles of time and management that were violated in this case is the lack of organizational skills when dealing with time and stress. Chet is always forgetful. He has no memory of his past commitments but is always adding new tasks to his plate. Chet is all about poor planning; not knowing what he wants and what he needs. A normal day for Chet is very stressful. He can’t even go through a day and was already tired. Chet also has a family so its visible he can stressed at home as well dealing with a small child. When it comes to time, Chet’s day at work is all about “so much work so little time” Not once in his work day did he take a time to breathe and focus on himself. Chet was all about running around and trying to managing everything on his own. Even though he has other Managers who are at his level they were not overly stressed as he was. It is clear to see from the structure of the company the other managers will never be stressed out like him. From the structure of how the Norris Company is run, the other managers don’t even have anyone reporting under them to receive the amount of stress that Chet gets in his workload.…

    • 1085 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    assignment 2

    • 378 Words
    • 2 Pages

    What are the underlying assumptions in projections versus forecasts? Are the extension of past trends into the future. They identify trend lines and simply extend them to the future regarless of constraints or changes. Forecast are the prediction of future conditions based on projection modified by expected assumptions of driving forces, constraints, and opportunites.…

    • 378 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    1) This transportation model problem consists of 18 decision variables, representing the number of barrels of wastes product transported from each of the 6 plants to each of the 3 waste disposal sites:…

    • 1325 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Assignment 2

    • 419 Words
    • 2 Pages

    This was composed as an ensemble. The introduction leads to a new theme: strong pair of beats alternating…

    • 419 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    14. If Evergreen Fertilizer Company increases its advertising expenditures by $14,000 per year, what effect will the increase have on the break-even volume computed in Problem 13?…

    • 916 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    assignment 3

    • 256 Words
    • 1 Page

    Because Aquaman withheld imformation and breeched his fiduciary duty he is guilty of violating 17 C.F.R. § 240.10b, which prohibit any person, directly or indirectly, from committing fraud in connection with the sale or purchase of securities.…

    • 256 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    2) After obtaining the Objective Function and constraints we enter all the information into Microsoft Excel and use the solver feature to find the optimal solution for this Product Mix. The Optimal Product Mix is to produce 17500 pounds of the Regular Mix, 10625 pounds of the Deluxe Mix, and 5000 pounds of…

    • 946 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Assignment 2

    • 1003 Words
    • 3 Pages

    Question 1 : Explain how utilitarianism might provide a defense for Roche and how a rights-based ethic might instead condemn Roche’s drug trials in China. Which of these two approaches is stronger or more reasonable? Explain the reasons for your answer.…

    • 1003 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Julia S Food Booth

    • 467 Words
    • 7 Pages

    I believe that Julia would increase her profit if she borrowed some more money from a friend. Her shadow price, or dual value, is $1.50 for each additional dollar that she earns. The upper limit given in the model is $1,658.88, which means that Julia can borrow only $158.88 from her friend, which would give her an additional profit of $238.32.…

    • 467 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Assignment 2

    • 3222 Words
    • 10 Pages

    Assignments2 solutions: Due by Midnight Monday October 13th, 2014(drop box of week 2) (Chapters 5, 6, 7 and 8) Total 75 points.…

    • 3222 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    Logistic

    • 332 Words
    • 4 Pages

    Recall the example of the “Location on the Network” models (with and without single sourcing restriction) discussed in class. Suppose the company had identified another potential warehouse (WAREHOUSE-4) with a throughput capacity of 3000 units they can lease. Table below gives the associated fixed cost, handling cost and transportation cost for product flowing through this warehouse.…

    • 332 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Choosing The Best School

    • 536 Words
    • 4 Pages

    Mr Shyam Prasad, recently transferred to Chennai from Lucknow, has to choose a school for his two children. He has three choices of the school and it is likely that his children would be allotted one of them. Shyam Prasad has chosen his best 3 schools (A, B, C) and wishes to rank them. He would be happy if the children get either the first or the second choice.…

    • 536 Words
    • 4 Pages
    Satisfactory Essays