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

Related questions

Q: Graphically illustrate the TQM model or continuous improvement process of mind map/TQM Process flow…

A: DMAIC Cycle for Oman Cement Company**1. Define:** - **Goal**: Clearly define the quality objectives…

Q: a) What would be the total cost, revenue and profit for a weekly volume of 10,000 bottles? (b) What…

A: Here, It is assumed that all output can be sold, I will answer the given sub-part questions,

Q: An ad for a new oven shows a working mother serving lunch to her kids. This is an example of what…

A: An ad for a new oven shows a busy professional woman serving lunch to her kids. The convection oven…

Q: You have recently joined as the project manager of ABC Company. Please refer to the Excel file to…

A: Find the Calculations methods below:

Q: a) Document flow chart: The document flow chart visually represents the flow of documents through…

A: * DM (invoice)→ Accounts Payable Subsidiary (manual recording)→ Cash Disbursement Office…

Q: Discuss the importance of standardization in process planning.

A: Process planning includes the actions and processes required to create detailed designs and…

Q: Please explain (show the work) how to enter the information in EXCEL to create the chart and please…

A: Given-

Q: Describe how putting an ERM plan into place can boost the amount of support a business gets from…

A: INTRODUCTION - A concept known as enterprise risk management (ERM) examines risk management…

Q: Below are the ten knowledge areas defined by the PMI. Let's discuss their importance and contrast…

A: The ten knowledge areas defined by the PMI (Project Management Institute) are crucial to successful…

Q: Analyze the concept of BYOD (Bring Your Own Device) in the context of IT resource acquisition and…

A: With the help of the BYOD policy, employees can bring their personal devices for work purposes, such…

Q: Describe the importance of conducting a Business Impact Analysis (BIA) in the development of a…

A: In today's complex and ever-changing business landscape, organizations must be prepared to navigate…

Q: Goog Evening. i have an homework powerpoint presentation. Could you please explain me how to put a…

A: A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and…

Q: CUSTOMER SATISFACTION PROCESS

A: Client fulfillment is characterized as an estimation that decides how cheerful clients are with a…

Q: In Step 3A of the Problem Solving Process, it is important to understand the problem. All off the…

A: Although the scale of affected employees in the two scenarios was markedly different, the faster…

Q: The core of many firms' e-commerce initiatives today is an e-commerce process architecture, which…

A: An e-commerce process architecture of any firm is defined as the step by steps processes that are…

Q: Understand what an enterprise resource planning (ERP) system is.

A: ERP refers to Enterprise resource system. It is a software used by the organizations to manage all…

Q: Please provide at least two approaches you've used to reduce the expense of reworking. How does…

A: Here, these two approaches are Process improvement and quality assurance, Iterative development, and…

Q: How to make an IPO chart (Input, Process, Output) for grading individual tests for 3 sections of a…

A: Representing, an IPO chart for grading individual tests for 3 sections of a course, including the…

Question

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 B

In 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].

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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
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.
help please I need it to be done in excel
1) Briefly discuss the elements of a process map ? 2) Briefly discuss the elements of a successful business plan presentation ? 3) Briefly discuss why a full set of pro forma financial statements is not needed at the feasibility analysis stage ?