Perform operations in excel .... (and shows the formulas)
Company Z has the following historical information about sales for one of its hydraulic pump models for the last 4 years:
(PICTURE OF THE PERIOD AND YEARS)
On the other hand, the manufacturing process used by Company Z is sequential* and has the following characteristics:
(THE OTHER IMAGE)
* Sequential; in the sense that the output of Mi is the input of Mi+1.
** In any order; in the sense that they can be interchanged, e.g. MA -> MB or MB -> MA.
The company's operating costs are as follows:
Cost per final unit produced "defect free": $100
Cost per final unit produced "with defects": $150
Cost per excess inventory (units "free of defects"): $50
Cost per inventory shortage ("defect free" units): $200
Revenue per final "defect free" unit produced and sold: $250
We have the following operating conditions:
- Any sequence of 3 machines can be used.
- Only one machine can be used once, within the same sequence of machines.
- You can work UP TO 720 hours per month.
- A "level production" type production strategy is followed.
-------------------------------------------------------------------------------------
Establish the 1st and 2nd best machine sequence that allows company Z to obtain higher profits (profit = total revenue - total costs) for a hypothetical 5th year.
In both cases PROVE that both sequences meet the requirements of being the 1st and 2nd best sequences.
Step by stepSolved in 3 steps with 3 images
- Problem #3 - Modeling, Mixing Problem Two tanks are connected by pipes in parallel as shown in Figure 2. Tank 1 starts with 160 lb of salt dissolved in 200 gal of water. Tank 2 starts with 100 gal of pure water. Using the diagram below, solve for the particular solutions of salt concentration in each tank as a function of time. Plot the solutions in Excel on the same plot. Note: some flow rates have been intentionally left out of the diagram below; use the conservation of mass to determine those. As a thought experiment, consider what negative eigenvalues imply. What would it mean if the eigenvalues were positive instead (what would the math say)? i.) ii.) iii.) iv.) v.) vi.) vii.) Use a conservation equation to develop your differential equation model (you should end up with two ODEs to describe the change in salt in both tanks). Write your system of ODEs in matrix form. Set up the eigenvalue problem and then determine the eigenvalues. Use the eigenvalues to determine the…arrow_forwardQuiqarrow_forwardConsider the following instance of the two-machine job shop with the makespan as objective (J2 || Cmax). Job 2 3 6. 7. 8 1. 4 P1j 12 3 4 10 3 P2j 3 8 7 3 6. 11 Route Mi-> M1-> M2-> M1-> M2-> M2-> M1 M2 M2 М2 M1 M2 M1 M1 1. Apply the shifting bottleneck heuristic to this two-machine job shop. 2. Apply the SPT(1)-LPT(2) heuristic to this two-machine job shop. 3. Compare the schedules found under (1), (2). 2.arrow_forward
- I need a clear answer by hand, not by keyboard and fast answer within 20 minutes. Thank you | dybalaarrow_forwardDetermine the % increase in Flowrate, Net pumping head and Pump power based on the following conditions below: a) Increasing the impeller speed by 30% b) Increasing the impeller diameter by 20% c) Compute the same if the two conditions above will prevail in one condition Please show complete solution.arrow_forwardSketch a typical turbine speed (rpm) VS wind speed characteristics (which indicates how turbine speed is controlled as wind speed changes to achieve the given power curve). Rated speed of the turbine is 18 rpm. Mark all the main points on the curve and the associated values. ..arrow_forward
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY