AIN SHAMS UNIVERSITY
FACULTY OF ENGINEERING
iCREDIT HOURS ENGINEERING PROGRAMS
Mechatronics and Automation Engineering Program
Manufacturing Engineering Program
Assignment
MDP 231 Engineering Economy
Dr. Ghada E. Shedeed 1/1
Introduction:
This coursework is to be carried out in groups of 5 – 7 students. Two case studies will be
given (attached). Each group must work as a team and conduct brainstorming sessions to
carefully read the given information, discuss their opinions and findings, and present a
single technical report addressing all the related case study raised questions.
What you should hand-in by the end of the 12th week:
Only the group team leader is asked to upload the following to the LMS
1. The team report as a single pdf file, titled as “teamleaderID"_MDP231”.
2. The excel sheet file that has been used in generating the report contents. Name it
also “teamleaderID"_MDP231”
3. The cover page must include all team members names and their IDs.
4. A participation percentage should be included in front of each team member. For
example, if all team members have equally participated in all report elements; then
each one should write 100%.
Helping material:
Available on the LMS, an appendix that presents techniques and specific functions needed
to formulate spreadsheet models for solving engineering economy problems.
Assessment:
Check the attached report course assessment feedback sheet and you MUST consider the
following:
1. Use Microsoft Excel and its financial functions for engineering economy analysis to
solve the case studies.
2. The pdf report must include screen shots of your solution steps, resulting values,
and screenshots that display the formula in each cell instead of the numerical values
(In your Excel worksheet, go to the Formulas tab> Formula Auditing group and click
the Show Formulas button.)
AIN SHAMS UNIVERSITY
FACULTY OF ENGINEERING
iCREDIT HOURS ENGINEERING PROGRAMS
Mechatronics and Automation Engineering Program
Manufacturing Engineering Program
Assignment
Case study 01
MDP231- Engineering Economy
1/1
AIN SHAMS UNIVERSITY
FACULTY OF ENGINEERING
iCREDIT HOURS ENGINEERING PROGRAMS
Mechatronics and Automation Engineering Program
Manufacturing Engineering Program
Assignment
Case study 02
MDP231- Engineering Economy
1/2
AIN SHAMS UNIVERSITY, FACULTY OF ENGINEERING
iCREDIT HOURS ENGINEERING PROGRAMS
Case study 02
MDP231: Engineering Economy
2/2
In addition you should include the cash flow diagrams for this case study different cases.
AIN SHAMS UNIVERSITY
FACULTY OF ENGINEERING
i-CREDIT HOURS ENGINEERING PROGRAMS
Assignment Self reading
MDP231: Engineering Economy
Instructor Name: Dr. Ghada E. Shedeed 1/1
1. The team is asked to write a technical report regarding the following:
• How cost estimation is being accomplished (discuss a single cost estimation
method).
• Sensitivity Analysis (use spreadsheet to conduct a sensitivity analysis of an
alternative of your own choosing)
Ain Shams University
Faculty of Engineering
CAF
(Major Task Evaluation Criteria)
Ain Shams University
Faculty of Engineering
Marking Criteria
Course Course Engineering
MDP231 Report No. 01 Date:
Code: Name: Economy
Student Student
Name: ID:
Performance Criteria (100% = 30 Points)
Report Organization Case Study 01 Case Study 02 Self-reading Report
(6.7% = 2 points) (30% = 9 points) (30% = 9 points) (33.3% = 10 points)
Adhering to technical Showing, used Case study Showing, used Case study Sensitivity Analysis Cost estimation
report writing criteria spreadsheet requirements spreadsheet requirements (60% = 6 points) (40% = 4 points)
(cover page, TOC, list of economic (78% = 7 points) economic (78% = 7 points)
tables, list of figures, functions (22% functions
etc.) = 2 points) (22% = 2 points)
Exist in the right All items Missing Exist, in the right All items have Missing Comprehensive Missing Comprehensive Missing
format, and clear have been elements format, and clear been discussed elements with examples numerical with examples numerical
Meets (100%) examples (100%) example
Acceptable (100%) discussed (50%) (100%) with clear steps (50%)
Expectation (50%) (50%)
layout (50%) with clear and cashflow
(100%)
steps diagrams
(100%) (100%)
1st Marker Total 1st marker Signature Ghada Shedeed ASU Agreed Mark
2nd Marker Total 2nd marker Signature Hany El Sayed
