Question: please the solution should contain introduction body tasks 1-8, conclusion . referance if needed should be done on excel only . calculation on word a
please the solution should contain introduction
Objectives: To optimize (minimize) the perimeter of a fence surrounding parking space with a given area. Background A rectangular parking space with a surface area A (A is given, you can substitute it with a reasonable positive number) has to be created along the strait road. The parking area will have a fence around its 3 sides (there is no need for a fence on the road side). Your goal is to find the width and length of the parking space that will minimize the perimeter of the fence. The width and length are continuous variables and are defined as follows: W = width of the area in meters L = length of the area in meters Based on these definitions, the restrictions of the situation can be expressed as: (Length of the rectangle) X (Width of the rectangle) = (Area of the rectangle) (Length of the rectangle) + 2 x (Width of the rectangle) = (Perimeter of the fence) Width and length cannot be negative Tasks: 1. Read the problem carefully and sketch a simple layout of the problem 2. Identify the decision variable(s) 3. Write the objective function for the quantity to be optimized 4. Identify the constraints the solution must satisfy 5. Reduce the problem in one decision variable 6. Solve the problem using basic calculus knowledge a. Find the domain of the objective function b. Find the critical points c. Determine the absolute max and min of the objective function d. Identify the optimal value(s) 7. Solve the problem in EXCEL by enumerating possible values of the decision variable(s) a. In this approach, you first have to fix the input of the problem A to a specific value b. Insert the objective function C Enumerate possible values of the decision variable(s) d. Identify the optimal value(s) e. Provide an EXCEL graph of the objective function Please provide the screenshots of Excel. No need to submit the Excel file separately. 8. How much the optimal parameter of the fence will change if the area (A) of the parking lot is decreased two times(A/2)? Justify your answer. 9. In-Lab Activity laboratory report format: o Introduction o Tasks (1-8) O Conclusion References (if needed) Grading Scheme: 1. Description and formulation of the problem (Tasks 1-5) 2. Analytical solution (with calculus) (Tasks 6) 3. Numerical solution (using EXCEL) (Tasks 7) 4. What if question (Tasks 8) 5. Proper report organization and use of language 6. In-Lab Activity 15% 15% 15% 10% 5% 40% body tasks 1-8, conclusion . referance if needed
should be done on excel only . calculation on word a picture of written

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
