Please set up a linear program and solve the problem using the Excel Solver. Thank you very much.
Q: Suppose that material hardness is normally distributed with a mean of 52 and a standard deviation of…
A: Given-Upper specification limit (USL) = 55Lower specification limit (LSL) = 45Standard deviation (σ)…
Q: The control limits for the 3-sigma R-chart are (round all intermediate calculations to three…
A: Control charts are also known as process-behavior charts. It is a statistical process that helps in…
Q: Give more Solution, some of the calculations is missing? please answer as soon as possible
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Based on the sampling done, the control limits for 3-sigma x chart are: Upper Control Limit…
A: For the given data, I would determine the control limits for three sigma Sample mean chart or X bar…
Q: Based on the sampling done, the control limits for 3-sigma x chart are (round all intermediate…
A: Here, for the given data, I could see the value of the sample mean for each sample, and the range…
Q: Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last…
A: Given-
Q: ABC Corporation resells one product to a small isolated community. It has 365 working days. It sells…
A: Reorder Point (ROP) Model: Reorder Point (ROP) is the minimum level of inventory at which a company…
Q: Of the following, which is NOT a detail that managers need to be aware of when conducting…
A: Option A) "Managers may need to fire workers if appraisals show a lack of improvement" This detail…
Q: How has the current cultural environment of our country shaped the way that companies are looking at…
A: More and more famous personalities have been forced into the limelight since 2017 and the #metoo…
Q: Ergonomics problem A work measurement analyst in the Electrical Company took 10 observations (for…
A: a. To determine the standard time and standard output using the information provided, you will need…
Q: Solve the following exercise using dynamic programming: a company distributes an article with a…
A: Dear Student please mention exact criteria to be calculated. Assuming cost minimization:-…
Q: Hello, can someone here help me find the Economic Order Quantity with the given information: Average…
A: The economic order quantity (EOQ) is the order quantity that limits complete holding and ordering…
Q: Assign tasks to workstations using the longest task-time heuristic. Use the table format below
A: Project schedule helps in calculating different values all related to the production cycle like the…
Q: 6 Variable Cells 7 8 9 10 11 12 Constraints 13 14 15 16 17 Cell $C$8 A $D$8 B Name Cell Name $B$15…
A: sensitivity analysis is a report provided by excel solver It helps to analyse various aspects…
Q: Why distribution range negative infinity to positive infinity is transformed to zero to positive…
A: The distribution range from negative infinity to positive infinity is transformed to zero to…
Q: what is Marshall olkin transformation? When it is first used and why we need it? Simply explain…
A: Marshall Olkin Transformation is a mathematical technique used in the field of probability and…
Q: how is a time series module and a causal model used in a business?
A: Time series module is used to measure, analyze and forecast patterns in data. It is used for changes…
Q: When using a project triangle to illustrate conflicting priorities, Microsoft suggests that if the…
A: A project triangle, also known as an "iron triangle," is a visual representation of the three main…
Q: Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an…
A: BOM Diagram:
Q: d. How many customers in total should have been served in a day by all the sales people? e. What is…
A: Given Formulas used :-
Q: What is time management? What are some ways to manage time? Why is time management important. Please…
A: Here, as per this question, I would discuss the concept of time management, I would also include…
Q: 1. Is outsourcing a completely negative activity? How does its reputation tie in with insourcing?.
A: The act of allocating a company's business activities to an outside organization in order to improve…
Q: Do you agree that the Internet has affected consumer and supplier relationship? Discuss how…
A: The supplier is responsible for giving the quality that will satisfy the customer and submitting…
Q: If you worked for an international firm doing business in Asia, is there anything you would suggest…
A: If I worked for an international firm doing business in Asia, I would respect and base my strategy…
Q: Audi Company's Strategic Approach 1. Analyze the company’s strategic approach and why it works for…
A: 1. Audi's strategic approach involves a combination of differentiation and low cost. The…
Q: Consider the following: Activity A B C D Normal time 4 DEFG 238 2 Crash time Normal cost Crash cost…
A: Project crashing is a process which helps to reduce the project duration using additional cost and…
Q: As firms expand and post increasing information about their business activities on their websites,…
A: As mentioned only to list challenges, Three significant challenges for effective knowledge discovery…
Q: QUESTION 2: The Advanced Tech Company has a project to design an integrated information database for…
A: Path Duration Is duration maximum critical A-C-E-F 6+3+6+2 = 17 yes yes B-C-E-F 4+3+6+2 = 15 no…
Q: McDonald’s is a company that is all-in globally, having become a staple in over 100 countries around…
A: McDonald's is a global powerhouse that has become a staple in over 100 countries around the world.…
Q: onal companies considering cultural differences when engaging in Foreign Direct Investment.
A: For developing and rising market nations, foreign direct investment (FDI) is essential. To grow,…
Q: As a tool service centre the arrival rate is two per hour and the service potential is three per…
A:
Q: [LO 5-3] 5-23 The materials handling charge for ABC Corp. is $0.50 per pound of finished product.…
A: Given- Material handling charge rate = $0.50 per poundNo. of units produced = 10,000 unitsWeight…
Q: What is a workflow chart and how is it important for business planning purposes?
A: Workflow chart:- The workflow chart is a graphical representation of the business process. There…
Q: Assume that the normal duration of activity A is 20 days and that it can be shortened to 14 for an…
A: The crash cost of finishing any work is more than the typical cost. The cost of finishing work is…
Q: Technology Trends in Services, except for: As humans travel globally they carry and spread disease…
A: NOTE: We are allowed to do one question only. Technology is transforming the way services are…
Q: A.). What do you think of the statement “Boeing dug its own grave by outsourcing so much of the 787…
A: Supply chain outsourcing refers to the practice of transferring the management and performance of…
Q: Write 5 paragraphs in Answer, Proof, Explain format about which are the most important pillars in…
A: Leadership Leadership means directing and coordinating individuals within an organization to achieve…
Q: Supplier Evatuation and selection. Explain supplier evaluation and selection and how it is used in…
A: *As per the question, not specified any industry, giving general solution.Companies operate supplier…
Q: To measure overtime hours
A: Measuring overtime hours is an important part of managing a business. It helps ensure that employees…
Q: How can we identify inefficient business processes via a reengineering study? Why?
A: Meaning of Business Process Reengineering- Business Process Reengineering includes the revolutionary…
Q: Hello, I was wondering if anyone can help me out with calculating safety stock with the information…
A: Given the data stated below, The average customer demand=100 units The standard deviation of…
Q: Refer to Table S6.1 - Factors for Computing Control Chart Limits (3 sigma) LOADING... for this…
A: Given-
Q: Consider the following product. Draw its product structure (Note: use sub-assemblies).
A: A product structure tree refers to the hierarchical arrangement of components used to make a final…
Q: What is the most important role of the project manager in project staffing? Give one specific…
A: NOTE: We are allowed to do one question only at a time. Staffing is a critical part of any…
Q: [A] Using the following warehouse information, allocate the apples to their appropriate locations.…
A: a) To allocate the apples to the appropriate locations, we can use the following formula for each…
Q: Anna runs a small cafe that’s really busy at lunchtime but quiet at other times. She needs a way to…
A: Introduction: Managing the inventory or capacity according to the demand of the market is a tricky…
Q: d) If the firm operates 11 hours per day, 20 days per month, the monthly capacity of the…
A: Given- The capacity of the sawing station is 2.4 units per hourThe capacity of the sanding station…
Q: The activities needed to replace a broken window pane are given below. Activity Duration (in…
A: (a)
Q: A. Create an excel file. (Show all formulas in one screen shot and the results as another…
A: Given We need 6 Kanbans for the production process. Kanban is a method for managing and…
Q: The relationship between planning and controlling is intimate and mutual. Describe this statement.
A: Planning and controlling are two integral parts of any organization. Planning is the process of…
Please set up a linear program and solve the problem using the Excel Solver. Thank you very much.
Step by step
Solved in 3 steps with 4 images
- Suppose Jack like to solve the following formulation in Excel. And the problem is setup in Excel like this: See attached picture. A B C D E 1 X1 X2 2 decision variable objective 3 coefficient of objective function 2 3 4 Constraints LHS RHS 5 Constraints 1 2 1 3 6 Constraints 2 4 5 20 7 Constraints 3 2 8 16 8 Constraints 4 5 6 60 We want to put our objective function in cell D3. What should we type in D3? In cell D5 to D8, we will put the left hand side of our constraint. What should we type in D8? In OpenSolver, what should we assign to Variable Cell? What should you do to input the non-negativity constraint in OpenSolver?An XYZ company has a W, H, O plant with a monthly production capacity of 60 tons, 50 tons, and 42 tons, respectively; and has 3 sales warehouses in cities A, B, C, D Where each warehouse has a monthly requirement of 30 tons, 34 tons, 44 tons and 25 tons. With shipping cost W to ABCD = IDR 12,000,-, IDR. 8.000,-, Rp. 12.000,-, Rp. 14,000,-; H to A B C D = Rp. 8.000,-, Rp. 18.000,-, Rp. 10,000,-, Rp. 6.000,-; and O to ABCD = Rp. 16.000,-, Rp. 16.000,-, Rp. 2,000, Rp. 10,000,-. Please calculate using Vogel's Approximation Method or VAM Question a. What is the best transportation model in your opinion to solve the above problems? b. What is the minimum transportation cost to solve the shipping transportation problem! c. Based on these calculations, give suggestions regarding the transportation model and the amount of costs incurred by the company!(5) Consider the following linear programming model with 4 regular constraints:Maximize 3X + 5Y (a) Draw your graph in the space below:subject to: 4X + 4Y ≤ 48 (constraint #1) 4X + 3Y ≤ 50 (constraint #2) 2X + 1Y ≤ 20 (constraint #3) X ≥ 2 (constraint #4) X, Y ≥ 0 (non-negativity constraints)(a) Which of the constraints is redundant? Constraint #______.Justify by drawing a graph similar to Figure 7.14 on p.263.(b) Is point (9,3) a feasible solution? _____. Explain your answer (by analyzing each of the constraints).Constraint #1: _______________________________________________________________Constraint #2: _______________________________________________________________Constraint #3: _______________________________________________________________Constraint #4: _______________________________________________________________(c) Which of the following points yields the best solution? Underline the best solution: (7,5), (9,2), (6,6).Justify your answer (using the data from the above LP…
- Consider the following LP problem: Min 6X+ 18Y; Subject to : 3 X + 9Y <= 47, and X + Y <= 141. Which one of the following is true?: a. Slack for each constraint is zero. b. Optimal Obj. function value is 94 c. X=70.5, Y=70.5 is the only optimal solution. d. Optimal Obj. function value is 0Consider the following LP problem: Min 6X+ 27Y Subject to : 2 X + 9Y => 25, and X + Y <= 75. Pick a suitable statement for this problem: a. X=37.5, Y=37.5 is the only optimal solution. b. Optimal Obj. function value is 75 c. X = 0, Y = 0 is the only optimal solution. d. Optimal Obj. function value is 0A company has factories at F1, F2 and F3 which supply to warehouses at W1, W2 and W3. Weekly factory capacities are 200, 160 and 90 units, respectively. Weekly warehouse requiremnet are 180, 120 and 150 units, respectively. Unit shipping costs (in rupess) are as follows: W1 W2 W3 Supply F1 16 20 12 200 F2 14 8 18 160 F3 26 24 16 90 Demand 180 120 150 450 Determine the optimal distribution for this company to minimize total shipping cost.
- 1. Consider the following linear programming formulation: Min 5x + 2y Subject to (1) 3x + 6y ≥ 18 (2) 5x + 4y ≥ 20 (3) 8x + 2y ≥ 16 (4) 7x + 6y ≤ 42 (5) x, y ≥ 0 a. Solve the problem graphically. Specifically, show each constraint and the feasible region, draw an objective function line and identify an optimal point (the solution). When reporting the optimal solution and the corresponding objective function value, you may estimate the optimal x and y values from the graph. b. What are the optimal values of x and y, using the solver add-in? What is the corresponding value of the objective function? c. How many extreme points does the feasible region have? Enumerate them. Hint: It's from the graph. d. Change the objective function to 15x + 12y.. What is the new optimal solution(s)?I will need the excel "solver" solution to be able to solve. #4) Solve the following LP Maximize $5x + $6y Subject to 2x + 3y ≤ 10 (labor, in hours) 6x + 6y ≤ 36 (materials, in pounds) 7x + 5y ≤ 40 (storage, in square feet) x, y ≥ 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution and objective function value if you acquire 2 additional pounds of material? c) What is the optimal solution and objective function value if you acquire 1.5 additional hours of labor? d) What is the optimal solution and objective function value if you give up 1 hour of labor and get 1.5 pounds of material? e) What is the optimal solution and objective function value if you introduce a new product that has a profit contribution of $2? Each unit of this product will use 1 hour of labor, 1 pound of material, and 2 square feet of storage space.Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pen...Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below.Fliptop Model Tiptop Model AvailablePlastic 3 4 36Ink Assembly 5 4 40Molding Time 5 2 30The profit for either model is $1000 per lot.What is the linear programming model for this problem?What are the boundary points of the feasible region?What is the profitability at each boundary point of the feasible region?Find the optimal solution.
- Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $67, $95, and $133, respectively. The production requirements per unit are as follows: Number ofFans Number ofCooling Coils ManufacturingTime (hours) Economy 1 1 8 Standard 1 2 12 Deluxe 1 4 14 For the coming production period, the company has 300 fan motors, 340 cooling coils, and 2000 hours of manufacturing time available. How many economy models (E), standard models (S), and deluxe models (D) should the company produce in order to maximize profit? The linear programming model for the problem is as follows: Max 67E + 95S + 133D s.t. 1E + 1S + 1D ≤ 300 Fan motors 1E + 2S + 4D ≤ 340 Cooling coils 8E + 12S + 14D ≤ 2000 Manufacturing time E, S, D ≥ 0 The computer solution is shown in the figure below. Optimal Objective Value = 17380.00000 Variable Value…Graph all constraints. Label each constraint line to identify which it represents.1.What are the corners point of the feasible region?2.compute the profit at each feasible corners points3.what is the optimal solution?4.What is the maximun profit?Amy Zeng, owner ofZeng's Restaurant Distributions,supplies nonperishable goods to restaurants around the metroarea. She stores all the goods in a storage area with a single dockand one aisle. The goods are divided into five categories accordingto the following table. The table indicates the number of tripsper month to store or retrieve items in each category, as well asthe number of storage blocks taken up by each. The following picture of the storage area provides an identificationnumber for each of the 16 storage blocks. For each item category,indicate into which blocks it should be stored.