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
- Grave City is considering the relocation of several police substations to obtain better enforcement inhigh-crime areas. The locations under consideration together with the areas that can be covered fromthese locations are given in the following table: a) Formulate an integer programming model that could be used to find the minimum number oflocations necessary to provide coverage to all areas.b) Solve the problem in part (a).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: Locations Areas A 1,4,7 B 1,3,5,7 C 1,2,5 D 2,5,6 E 3,4,7 F 4,6 Areas 2 and 6 must be covered by at least 2 locations. The rest of the areas must be covered by at least 1 location. What is the minimum number of locations?A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm’s goal is to maximize the net present value of their decision while not spending more than their currently available capital. Max 35x1 + 25x2 + 15x3+ 30x4s.t. 7x1 + 8x2 + 7x3 + 13x4 ≤ 18 {Constraint 1}x1 + x2 + x3 + x4 ≥ 2 {Constraint 2}x1 + x2 ≤ 1 {Constraint 3}x1 + x3 ≥ 1 {Constraint 4}x2 = x4 {Constraint 5} xj = {1, if location j is selected0, otherwisexj = 1, if location j is selected0, otherwise Solve this problem to optimality and answer the following questions:
- A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm’s goal is to maximize the net present value of their decision while not spending more than their currently available capital. Max 15x1 + 25x2 + 15x3+ 35x4s.t. 8x1 + 11x2 + 6x3 + 6x4 ≤ 17 {Constraint 1}x1 + x2 + x3 + x4 ≥ 2 {Constraint 2}x1 + x2 ≤ 1 {Constraint 3}x1 + x3 ≥ 1 {Constraint 4}x2 = x4 {Constraint 5} xj = {1, if location j is selected0, otherwisexj = 1, if location j is selected0, otherwise Solve this problem to optimality and answer the following questions: Which of the warehouse locations will/will not be selected? What is the net present value of the optimal solution? (Round your answer to the nearest whole number.) How much of the available capital will be spent (Hint: Constraint 1 enforces the available capital limit)? (Round your answer to the nearest whole number.)A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm’s goal is to maximize the net present value of their decision while not spending more than their currently available capital. Max 15x1 + 25x2 + 15x3+ 35x4s.t. 8x1 + 11x2 + 6x3 + 6x4 ≤ 17 {Constraint 1}x1 + x2 + x3 + x4 ≥ 2 {Constraint 2}x1 + x2 ≤ 1 {Constraint 3}x1 + x3 ≥ 1 {Constraint 4}x2 = x4 {Constraint 5} xj = 0, 1 Solve this problem to optimality and answer the following questions: Which of the warehouse locations will/will not be selected? Location 1 will Answer Location 2 will Answer Location 3 will Answer Location 4 will Answer What is the net present value of the optimal solution? (Round your answer to the nearest whole number.) Net present value Answer How much of the available capital will be spent (Hint: Constraint 1 enforces the available capital limit)? (Round your answer to the nearest whole number.) Available capital AnswerA firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm’s goal is to maximize the net present value of their decision while not spending more than their currently available capital. Max 30x1 + 30x2 + 25x3+ 20x4s.t. 5x1 + 10x2 + 8x3 + 12x4 ≤ 22 {Constraint 1}x1 + x2 + x3 + x4 ≥ 2 {Constraint 2}x1 + x2 ≤ 1 {Constraint 3}x1 + x3 ≥ 1 {Constraint 4}x2 = x4 {Constraint 5} xj = {1, if location j is selected0, otherwise xj = 1, if location j is selected0, otherwise Solve this problem to optimality and answer the following questions: Which of the warehouse locations will/will not be selected? What is the net present value of the optimal solution? (Round your answer to the nearest whole number.) How much of the available capital will be spent (Hint: Constraint 1 enforces the available capital limit)? (Round your answer to the nearest whole number.)
- A firm has prepared the following binary integer program to evaluate a number of potential locations for new warehouses. The firm’s goal is to maximize the net present value of their decision while not spending more than their currently available capital. Max 15x1 + 15x2 + 15x3+ 30x4s.t. 7x1 + 13x2 + 11x3 + 10x4 ≤ 20 {Constraint 1}x1 + x2 + x3 + x4 ≥ 2 {Constraint 2}x1 + x2 ≤ 1 {Constraint 3}x1 + x3 ≥ 1 {Constraint 4}x2 = x4 {Constraint 5} xj = 1, if location j is selected0, otherwise Solve this problem to optimality and answer the following questions: Which of the warehouse locations will/will not be selected?Mitch just built 4 franchise locations for his newest pizzerias and wants to decide where to put his headquarters. He makes 1 weekly visit to his Northside store (X = 3, Y = 10), 2 visits to his Eastside store (X = 4, Y = 6), 3 visits to his Southside store (X = 2, Y = 5) & 4 visits to his Westside store (X = 1, Y = 4). __________ 1. Using the store visits as weights, compute the coordinates of the center of gravity to help him with his location decision.An electronics firm located near Phoenix, Arizona, is considering where to locate a new phone switch that will link five buildings. The buildings are located at (0, 0), (2, 6), (10, 2), (3, 9), and (0, 4). The objective is to locate the switch to minimize the cabling required to those five buildings.a. Determine the gravity solution.b. Determine the optimal location assuming a straight-line distance measure. (If you are solving this problem by hand, iterate the appropriate equations at least five times and estimate the optimal solution.)
- The Palestinian ministry of sports has four basketball games on a particular night. The ministry wants to assign four teams of officials to the four games in a way that will minimize the total distance traveled by the officials. The supply is always one team of officials and the demand is for only one team of officials at each game. The distances in km for each team of officials to each game location are shown in the following table officials 1 2 3 a 100 150 120 b 130 210 90 c 120 170 90 A) Formulate this problem as Assignment Model (the objective function and constraint equations for the demand and supply) . b) Use QM to solve the Model.Three existing facilities are located at (0, 0), (5, 5), and (10, 10). The weights applied to these facilities are 1, 2, and 3, respectively. Find the location of a new facility that minimizes the weighted Euclidean distance to the existing facilities.Consider the following linear program. Max 2A + 3B s.t. 5A + 5B ≤ 350 Constraint 1 −1A + 1B ≤ 10 Constraint 2 1A + 3B ≥ 90 Constraint 3 A, B ≥ 0 Identify the optimal extreme point. What is the optimal solution? (A, B)= (30, 40) How much slack or surplus is associated with the nonbinding constraint? Constraint 3 is the nonbinding constraint. There is a surplus of _________ associated with this constraint. (THE QUESTION BEING ASKED)