Can you assit me with this problem 17 by showing me the process step by step. I prefer it not be in the form of an excel sheet because it is hard to follow along. Thank you kindl A Missouri job shop has four departments: machining (M), dipping in a chemical bath (D), finishing (F), and plating (P), each assigned to separate work areas. The operations manager, Mary Marrs, has collected data on the movement of materials between these areas.**Number of Workpieces Moved Yearly Between Work Areas:**| | M | D | F | P ||-----|----|----|----|----|| M | - | 600| 1,800| 300|| D | - | - | 600| 300|| F | - | - | - | 1,900|| P | - | - | - | - |It costs $0.50 to move one workpiece one foot in the job shop. For planning the layout design, Mary compares the current layout (Plan A) with two proposals (Plan B and Plan C).### a) Layout Plan A: Distance Between Work Areas (Departments) in Feet| | M | D | F | P ||-----|---|---|---|---|| M | - | 20| 11| 7 || D | - | - | 5 | 9 || F | - | - | - | 3 || P | - | - | - | - |**The yearly total material handling cost of the current layout presented in Plan A = $___** (enter your response as a whole number).### b) Proposal for Plan BIn Plan B, the proposal is to switch the departments with high loads, namely, finishing (F) and plating (P). This alters the distance between them and the machining (M) and dipping (D) departments as follows:**Layout Plan B: Distance Between Work Areas (Departments) in Feet**| | M | D | F | P ||-----|---|---|---|---|| M | - | 9 | 7 | 11|| D | - | - | 3 | 5 || F | - | - | - | 20|| P | - | - | - | - | The yearly total material handling cost of the current layout presented in Plan A = $ [enter your response as a whole number].b) In Plan B, the proposal is to switch those departments with the high loads, namely, finishing (F) and plating (P), which alters the distance between them and machining (M) and dipping (D), as follows:**Layout Plan B: Distance between work areas (departments) in feet:**| | M | D | F | P ||---|----|----|----|----|| M | – | 20 | 7 | 11 || D | – | – | 9 | 5 || F | – | – | – | 3 || P | – | – | – | – |The yearly total material handling cost of the proposed layout presented in Plan B = $ [enter your response as a whole number].c) In Plan C, the Machining (M) and Dipping (D) are also switched and the distances are as follows:**Layout Plan C: Distance between work areas (departments) in feet:**| | M | D | F | P ||---|----|----|----|----|| M | – | 20 | 9 | 5 || D | – | – | 7 | 11 || F | – | – | – | 3 || P | – | – | – | – |The yearly total material handling cost of the proposed layout presented in Plan C = $ [enter your response as a whole number].d) The best layout from the cost perspective is [enter your response].

Total material handling cost = Sum of (Distance between work areas × No. of workpieces moved)…

(D), nising () the movement of material. The number of workpieces moved yearly between work areas are: D M 600 1,800 300 - 600 300 1,900 P It costs $0.50 to move 1 workpiece 1 foot in the job shop. For the layout design of the job shop, Mary has the current layout (Plan A) and two proposals (Plan B and Plan C). a) LAYOUT PLAN A: Distance between work areas (departments) in feet: M D M 20 11 6. 3 The yearly total material handling cost of the current layout presented in PLAN A = S (enter your response as a whole number). b) In Plan B, the proposal is to switch those departments with the high loads, namely, finishing (F) and plating (P), which alters the distance between them and machining (M) and dipping (D), as follows: LAYOUT PLAN B: Distance between work areas (departments) in feet: M D

(D), nising () the movement of material. The number of workpieces moved yearly between work areas are: D M 600 1,800 300 - 600 300 1,900 P It costs $0.50 to move 1 workpiece 1 foot in the job shop. For the layout design of the job shop, Mary has the current layout (Plan A) and two proposals (Plan B and Plan C). a) LAYOUT PLAN A: Distance between work areas (departments) in feet: M D M 20 11 6. 3 The yearly total material handling cost of the current layout presented in PLAN A = S (enter your response as a whole number). b) In Plan B, the proposal is to switch those departments with the high loads, namely, finishing (F) and plating (P), which alters the distance between them and machining (M) and dipping (D), as follows: LAYOUT PLAN B: Distance between work areas (departments) in feet: M D

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The hierarchy of components, their description, and the quantity of each needed to make one unit of a product are documented in: Select one: a. an engineering drawing. b. a list of group technology. c. a roadmap. d. a list of materials. and. a work order.
Evaluate the role IT systems such as MRP and ERP have within an organization’s operations and analyze how these systems interact with strategic planning. write in your perspective
make a formal application letter for mcdo after graduating senior hisg school.
Must be 2000-2500 words Case Study Question The entire case study cannot be submitted, so I attached the title and the questions to be answered. I will submit the same questions with the rest of the case study. The case study is based on an article about Pataka Tea Co., Ltd. (PT) - Reassessing the External Environment. Assignment Questions As of May 2018, what challenges had PT faced in recent years? Assess the factors in the internal and external environment that led to those challenges? Analyze the industry competition conditions that PT faced. Identify the key external factors that affected PT’s strategic decision. Develop a SWOT Analysis for PT to help King develop his strategy. Indicate how each of elements from the four (4)components from your SWOT, can be used to enhance PT’s competitive advantage. Each component of your SWO must have at least three (3) elements If you were Phillip King, chairman of PT, what recommendations – at least four (4), would you make to improve…
Projects may be audited at any point in the life cycle. Even after projects are closed, it is common for an audit to be performed to ensure that all closure activities were completed. Unfortunately, audits are often viewed negatively as a process designed to catch the team doing something wrong. Describe the purpose of an audit. How can the audit experience be viewed as positive?
Compare the two grading systems. Round everything to two decimals. Grading System 1 Grading System 2 Test: 40% Final Exam: 10% Homework: 10% Projects: 40% Test: 30% Final Exam: 20% Homework: 25% Projects: 25% a. You have an 82% test average, a 75% on your final exam, an 80% homework average and a 90% project average. What is your class average under each system? Which system do you prefer? b. You are at the end of the semester and you want to know what you need to get on the final exam for an A (90%) in the class. You have an 88% test average, 93% homework average, and a 90% project average. What do you need to get on the final in each grading system? Give exact answers.
In this step of new product development, a product that passes test-marketing is ready for market introduction, called rollout, which requires a lot of logistical coordination. Various divisions of the company must be encouraged to give the new item the attention it deserves. Packaging and labeling in a different language may be required. Sales training sessions must be scheduled, spare parts inventoried, service personnel trained, advertising and promotion campaigns readied, and wholesalers and retailers informed about the new item. If the new product is to be sold internationally, it may have to be altered to meet the requirements of the target countries. For instance, electrical products may have to run on different electrical currents. Test market the new product Introduce the product evaluation of alternatives screen ideas/concepts
Explain how to deal effectively with problems that could arise with areas such as quality, safety, people, drawings and other documentation, tools and equipment or if material are incomplete or do not meet the requirements of the activity and the action that should be taken.
The manner in which the inputs, project resources, are combined, will have an impact on the quality of the output. Select one: True False
help please I need it to be done in excel
What exactly is PLM? What is the relationship between it and other business software?
Describe the main application components of enterprise resource planning and briefly discuss the advantages and disadvantages of ERP.