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

Elements Of Electromagnetics
7th Edition
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Sadiku, Matthew N. O.
ChapterMA: Math Assessment
Section: Chapter Questions
Problem 1.1MA
icon
Related questions
Question

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.

period
year
1
2
3
4
1
1800
1950
2050
1900
Transcribed Image Text:period year 1 2 3 4 1 1800 1950 2050 1900
Machines THAT CAN be used in any order**.
Production rate per machine un/hr
Machine efficiency %
Machine reliability%
M1
М2
M3
М4
4.75 | 4.25 6.50
1.00 0.85
1.00 0.80
7.00
0.90
0.95
0.70
0.95
Transcribed Image Text:Machines THAT CAN be used in any order**. Production rate per machine un/hr Machine efficiency % Machine reliability% M1 М2 M3 М4 4.75 | 4.25 6.50 1.00 0.85 1.00 0.80 7.00 0.90 0.95 0.70 0.95
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Quality Assurance, Process Planning, and Quality Control
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Elements Of Electromagnetics
Elements Of Electromagnetics
Mechanical Engineering
ISBN:
9780190698614
Author:
Sadiku, Matthew N. O.
Publisher:
Oxford University Press
Mechanics of Materials (10th Edition)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:
9780134319650
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Thermodynamics: An Engineering Approach
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:
9781259822674
Author:
Yunus A. Cengel Dr., Michael A. Boles
Publisher:
McGraw-Hill Education
Control Systems Engineering
Control Systems Engineering
Mechanical Engineering
ISBN:
9781118170519
Author:
Norman S. Nise
Publisher:
WILEY
Mechanics of Materials (MindTap Course List)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:
9781337093347
Author:
Barry J. Goodno, James M. Gere
Publisher:
Cengage Learning
Engineering Mechanics: Statics
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:
9781118807330
Author:
James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:
WILEY