Develop an activity relationship chart for four departments

Assignment Help Database Management System
Reference no: EM131469678

Question: A machine shop located on the outskirts of Los Angeles accepts custom orders from a number of high-tech firms in southern California. The machine shop consists of four departments: A (lathes), B (drills), C (grinders), and D (sanders). The from-to chart showing distances in feet between department centers is given here.

66_Dep 1.png

The shop has accepted orders for production of four products: P1, P2, P3, and P4. The routing for production of these products and the weekly production rates are

829_Rout.png

Assume that products are produced in batches of size 25.

a. Convert this information into a from-to chart giving numbers of materials handling trips per week between departments.

b. If the cost to transport one batch 1 foot is estimated to be $1.50, convert the from to chart you found in part (a) to one giving the materials handling cost per week between departments.

c. Develop an activity relationship chart for these four departments based on the results of part (b). Assume that A is assigned to the highest cost and O to the least, with the rankings E and I assigned to the costs falling in between the extremes.

d. Suppose that the machine shop is located in a building that is 60 feet by 80 feet. Furthermore, suppose that departments are rectangularly shaped with the

1317_11-32.png

1176_Dim.png

Sketch a layout consistent with the rel chart you obtained in part (c).

Reference no: EM131469678

Questions Cloud

Find the optimal assignment to minimize employee travel time : A real estate firm wishes to open four new offices in the Boston area. There are six potential sites available. Based on the number of employees in each office.
Identify six sources of export marketing information : Identify at least six sources of export marketing information. How can youconvincethem that EU could do the best job or better job than any other shipper?
Identify if there have been changes in purchasing patterns : Identify if there have been changes in the purchasing patterns of your organization's target market in recent years.
Find the assignment of warehouses to sites : A large supermarket chain in the Southeast requires five additional warehouses in the Atlanta area. It has identified five sites for these warehouses.
Develop an activity relationship chart for four departments : A machine shop located on the outskirts of Los Angeles accepts custom orders from a number of high-tech firms in southern California.
Circuit analysis of a circuit using laplace transforms : Circuit Analysis of a circuit using Laplace Transforms - determine the voltage across the two capacitors, v1(t) and v2(t).
Explain how federal reserve operates in the united states : Explain how Federal Reserve operates in the United States. What is the function of the FED? How does the FED support the banking system of the United States.
Find the location of the centroid of this facility : A facility has the shape shown in Figure. Using the methods described find the location of the centroid of this facility.
What can you use to support your arguments : Fixed price with targets- What would you do personally to avoid or overcome these challenges? What can you use to support your arguments?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd