part b is to solve using excel solver
Q: Review the essential elements of an ERP system for a manufacturing business.
A: Each manufacturing plants have certain complex and simple activities to be performed. Many…
Q: Select the best answer for the question. 4. A supply chain consulting firm offers by its nature OA.…
A: Supply chain consulting firms offer advice to businesses on how to improve their supply chains. They…
Q: A linear programming computer package is needed. Frandec Company manufactures, assembles, and…
A: Decision Variables: Suppose-FM be the no. of frames manufacturedFP be the no. of frames…
Q: An operations manager is deciding on the level of automation for a new process. The fixed cost for…
A: Ans) Formula: Profit = Units*(Sales Price - Variable Cost) - Fixed Cost At Breakeven, Profit = 0…
Q: Why would you use collaborative software in project management?
A: Collaborative software:- Collaborative software, sometimes known as groupware, is application…
Q: Critically examine the effectiveness of product development, citing relevant examples.
A: Product development, also known as new product management, is a process that begins with an idea and…
Q: a. Determine the critical path and the early completion time in weeks for the project. b. For the…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic…
A: From the above given data, The equation for the regression line can be given as, y^ =b0+b1x y^…
Q: Mistral plc is a wholesaler of fast-moving consumer goods throughout the UK. The board of directors…
A: Information sharing is considered to be an important aspect for co-operation in the supply chain…
Q: flowch. uterize
A: A web-based program known as a computer reservation system, or central reservation system (CRS), is…
Q: What are the three most important quality management steps in producing excellent software
A: Management of service quality lies at the heart of what is meant by the phrase quality management.…
Q: Resistors for electronic circuits are manufactured on a high-speed automated machine. The machine is…
A: Formulae used: Number of samples (N) = 15 Size of samples (n) = 4 Range (R) = Difference between…
Q: How are Cp and Cpk calculated and process capabilities explained?
A: Process capability is defined as the spread of a process. Let us consider, σ =standard deviation of…
Q: The following is given: $8.00/unit $4.00/unit $56,000 a) Based on the given information, the…
A: Break even point is calculate fixed cost divided by contribution margin Formula for Break even…
Q: Write a short essay(250 words) on how managers can control more effectively using feedback,…
A: Management controls can be defined as an approach where most of the organizations deploy to realize…
Q: The accidental baker Mamello Morongwe, a certified food technologist was working on a biscuit…
A: "Since you have asked multiple questions, we will answer the first question for you. If you want…
Q: What is the bottleneck of the process is which worker ?
A: The worker with the lowest capacity or highest processing time will be the bottleneck of the…
Q: 1: Preparing raw material Buffer A 2: Make the body 3: Make the attachments Buffer B 4: Assemble…
A: Activity Worker Time per unit 1 A 4 2 B 5 3 C 3 4 C 5
Q: Using the precedence network diagram below, create the corresponding Activity list: Start A B с E D…
A: Network diagram is a diagram that shows the visual picture of the project activities and its…
Q: Zan Azlett and Angela Zesiger have joined forces to start A&Z Lettuce Products, a processor of…
A: For the manual process Fixed cost(F) = 37,500 Variable cost(V) = 1.60 Price(P) = 2.50 Contribution…
Q: What is the break-even point for option A?
A: Breakeven point = fixed cost / (selling price - variable cost)
Q: When several processes are taking place at once, how does the capacity analysis respond?
A: Capacity analysis react when many processes are running in parallel People who work in production…
Q: EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the…
A: Objective function: Minimize Z = 1I1+1I2+1I3+0.65D1+0.65D2+0.65D3 Constraints: 1. February demand:…
Q: Review the essential elements of an ERP system for a manufacturing business.
A: Enterprise resource planning is software-based planning that many organizations commonly use to…
Q: Julia Robertson is a senior at Tech, and she’s investigating different ways to finance her final…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: in the following table, compute the weighted average score for each of the three providers (enter…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Explain the following practices and how they enhance the operations and project managemenet…
A: An organization undergoes many practices in its tenure to obtain a certain level of potential for…
Q: Design an assembly line to manufacture cupcakes from scratch. - Assume the bakery operates for 1…
A: The bakery operates for 1 eight-hour shift per day, so there are 8×60=480 minutes available for…
Q: The school cafeteria can make pizza for approxi- mately $0.30 a slice. The cost of kitchen use and…
A: Make or Buy decision identifying the total costs for each options or equilibrium point for options.…
Q: Each coffee table produced by Kevin Watson Designers nets the firm a profit of $10. Each bookcase…
A: Assume Decision variables: Let X1 = No of coffee tables to be produced per week and X2 = No of books…
Q: The break-even quantity in units for the manual process = ______ bags (round your response to the…
A: Note: We are allowed to do first three sub-parts only. Break-even quantity= fixed cost/ (selling…
Q: A jewelry firms buys semiprecious stones to make bracelets and rings. The supplier quotes a price of…
A: From the above given information, Number of operating days, d= 200 days Unit price, u =RM 32 per…
Q: Engineering Management 1. Assuming you are the project engineer of a certain construction project,…
A: Quality management in Construction projects comprises of putting the policies & procedures to…
Q: Assuming the same assignment of tasks per stations shown in the previous question, calculate the…
A: Here, I have been given the table data, this table data includes Task Id, time in minutes for each…
Q: The Canine Gourmet Company produces delicious dog treats for canines with discriminating tastes.…
A: The x-bar and r-bar control charts are two types of control charts that can be used to monitor the…
Q: project scheduling, the critical route approach is crucial, but what does it really do?
A: Critical path is the longest path on a project network diagram. In critical route approach, the…
Q: You have been given sales data for TOMMY's Fall/Winter/Spring/Fall New Collection for the last 4…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In business…
Q: Experience the Tour de France (ETF) is a specialty travel agent. It arranges vacations for amateur…
A: Queuing Theory relative to studies about waiting time. Waiting time is faced by customers to consume…
Q: a. the 6th year using the weighted moving average w/weights.7&.3 b.The 6th year using Exponential…
A: Forecasting the demand or sales can be done by various methods like weighted moving averages,…
Q: company sells 20,000 radios evenly throughout the year. The cost of carrying one unit of inventory…
A: Economic order quantity is described as the number of items or units a company needs to add up to…
Q: Predict orders for the following day for each of the products using an appropriate naive method.
A: A basic naive is chosen for more stable data as blueberry. Seasonal naive is chosen for data with…
Q: Max Z= 6x, + 8x₂ s.t. 2X₁ X₂ ≤ 50 3x₂ +4x₂ < 180 - X₁ +2x₂ ≤ 40 X₁, X₂ ≥ 0
A: As per Bartleby guidelines, we can only solve one question at a time...Kindly upload the other…
Q: (5000 S) Assume that the initial forecast for February is 30.0 (in $ thousands) and the initial…
A: Ft = alpha*actual of previous period +(1-alpha)*previous forecast trend = beta*(Ft of same - Ft of…
Q: 6. A dessert shop plans to purchase a new commercial ice cream maker to replace the old one. They…
A: Breakeven analysis is a tool which helps to identify the minimum required unit sales for covering…
Q: Company Ajax has the following information from its financial statements in 2021. The annual sales…
A: Average day of inventory is number of days that company store its inventory before sales. It is…
Q: Given the following original forecast and actual data: Month Actual Jan Feb Mar Apr May Jun Jul 600…
A: Ft = (Ft-1) + a {(At-1) - (Ft-1)} Ft = Forcast for period t Ft-1 = Forcast for prior period…
Q: Take into account the traits that you believe make a project stand out.
A: Projects of a business are of core importance to its people working internally and associated…
Q: 2) A service garage operates 300 days and uses 120 boxes of cleaning cloths a year. The boxes cost…
A: Given data: Annual Demand (D)= 120 boxes per year Ordering cost (Co)= RM3 Holding cost Ch 10% =…
Q: The McGranger Mortgage Company of Problem 6 made some changes to the process and undertook a process…
A: Given data: Upper Specification Limit (USL) = 25 Lower Specification Limit (LSL) = 5 Standard…
Q: Consider the problem of assigning multiple identical machines to an individual operator for the…
A: Ideal assignment n = a+ta+b Here, a = Concurrent activity time (Basically loading and unloading…
part b is to solve using excel solver
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
- Frank Green, an independent TV repairman, is considering purchasing a home in Ames, Iowa, that he will use as a base of operations for his repair business. Frank’s primary sources of business are 10 industrial accounts located throughout the Ames area. He has overlaid a grid on a map of the city and determined the following locations for these clients as well as the expected number of calls per month he receives: (given) Find the optimal location of his house, assuminga. A weighted rectilinear distance measure.b. A squared Euclidean distance measure.c. The goal is to minimize the maximum rectilinear distance to any client.4) What advantages and disadvantages does the one-sided type location of town- forming objects have in comparison with the alternate type location of town- forming objects?Problem 15-10 (Algo) A small manufacturing facility is being planned that will feed parts to three heavy manufacturing facilities. The locations of the current plants with their coordinates and volume requirements are given in the following table: PLANT LOCATION COORDINATES (x, y) VOLUME(PARTS PER YEAR) Peoria 304, 293 4,100 Decatur 377, 472 6,050 Joliet 469, 171 3,100 Use the centroid method to determine the best location for this new facility. (Round your answers to 1 decimal place.) Cx Cy
- Task 1: An oil refining company ships the following gasoline volumes from its refining plant in Long beach to its major distributors: Coordinates (x, y) 400, 150 450, 350 350, 400 25, 450 Distributor Gallons (in millions) Anaheim 150 LaHabra 350 Glendale 250 Thousand Oaks 450 The location coordinates of the refining plant in Long Beach are: (325, 75). Under a new proposed distribution setting, the company wants to setup an intermediate holding facility, such that gasoline will first get transported to this holding facility, and then, from there, to the distributors. What will be the ideal location (coordinates) for the intermediate holding facility? (Round to 2 decimal places.)10. Grave City is considering the relocation of several police substations to obtain better enforcement in high-crime areas. The locations under consideration together with the areas that can be covered from these locations are given in the following table. Potential Locations for Substations Areas Covered A 1,5, 7 B 1, 2, 5, 7 1,3, 5 2,4, 5 3, 4, 6 F 4,5, 6 1, 5, 6, 7 a. Formulate an integer programming model that could be used to find the minimum number of locations necessary to provide coverage to all areas. b. Solve the problem in part (a). 11. Hart Manufacturing makes three products. Each producarequires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, areA food manufacturer wants to locate a warehouse to serve its major The customers, annual volume, and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 Using the center of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products.
- b. A food manufacturer wants to locate a warehouse to serve its major customers.The customers, annual volume and the X and Y coordinates are shown in thetable below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc. 25 3 7Zac Supermarket 13 5 2Harry Inc. 6 8 4Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the locationcoordinates that will minimize the transportation costs for their family ofproducts1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xlsx: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 2. Using the weighted average center-of-gravity, which accounts for quantities to be shipped from locations, compute the centralized coordinates among the following locations: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 *Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsxConsider this data for three potential locations A1, A2, and A3. factor weight A1 A2 A3 initial cost 100 150 140 traffic 12 40 40 30 maintenance 2 20 25 18 dock space 25 10 12 neighborhood 4 12 8 15 What is the composite score for the alternative "A2"? (Compute composite score as the sum of (weight times score) - i.e. you do not have to convert weights to add to one)
- a. A farmers' cooperative association plans to build a new sugar mill in Georgetown. The primary objective of the mill is to provide the farmers with a place to take their crop for processing that will reduce their transportation costs. The members of the co-op believe that the center-of-gravity method is appropriate for this objective. While there are over 200 sugar cane farms in the region, they are tightly clustered around six villages. Using the data below, use the center-of-gravity method to calculate the coordinates of the best location for this mill. All mileage references use Browns Town as (0,0). Village Barney Valley Blue Pasture Congo Valley Bower Rabacca Salem Miles East of Miles North of Sugar Cane Browns Town Browns Town 90 140 20 50 100 10 10 60 70 20 80 120 tonnage 240,000 320,000 450,000 120,000 60,000 140,000The university administration would like to add some additional parking locations. To make everyone happy, they would like each building to be within a 5 minute walk of one set of new parking spaces (the spaces will be added in blocks of 10 parking spaces). The university is considering six locations for the new parking spaces, but would like to minimize the overall cost of the project. In addition to the walking time requirement, the university would like to add at least 40 new parking spaces (at least 4 blocks of 10). To help with the decision, the management science department formulated the following linear programming model: Min 350x1 + 425x2 + 425x3+ 465x4 + 485x5 + 365x6 s.t. x1 + x2 + x5 + X6 2 1 (Residence Hall A constraint) x1 + x2 + X3 2 1 {Residence Hall B constraint) X4 + X5 + X6 2 1(Science building constraint) X1 + X4 + X5 2 1{Music building constraint} x2 + x3 + X4 2 1{Math building constraint} x3 + X4 + X5 2 1{Business building constraint} x2 + x5 + X6 2 1{Auditorium…Describe fixed and random systems for assigning locations to SKUs.