Provide details on what you need help with along with a budget and time limit. Questions are posted anonymously and can be made 100% private.
Match with a Tutor
Studypool matches you to the best tutor to help you with your question. Our tutors are highly qualified and vetted.
Get Quality Help
Your matched tutor provides personalized help according to your question details. Payment is made only after you have completed your 1-on-1 session and are satisfied with your session.
MGT 425 Saudi Electronic University Linear and Nonlinear Programming Questions
User Generated
Nynabhq
Business Finance
mgt 425
Saudi electronic university
MGT
Description
Unformatted Attachment Preview
College of Administrative and Financial Sciences
Assignment # 2
Deadline: 31/07/2021 @ 23:59
Course Name: Spreadsheet Decision Modeling
Student’s Name:
Course Code: MGT 425
Student’s ID Number:
Semester: Summer
CRN:
Academic Year: 1441/1442 H
For Instructor’s Use only
Instructor’s Name:
Students’ Grade: Out of 10
Level of Marks: High/Middle/Low
Instructions – PLEASE READ THEM CAREFULLY
•
The Assignment must be submitted on Blackboard (WORD format only) via allocated
folder.
•
Assignments submitted through email will not be accepted.
•
Students are advised to make their work clear and well presented; marks may be reduced
for poor presentation. This includes filling your information on the cover page.
•
Students must mention question number clearly in their answer.
•
Late submission will NOT be accepted.
•
Avoid plagiarism, the work should be in your own words, copying from students or other
resources without proper referencing will result in ZERO marks. No exceptions.
•
All answered must be typed using Times New Roman (size 12, double-spaced) font. No
pictures containing text will be accepted and will be considered plagiarism).
•
Submissions without this cover page will NOT be accepted.
Assignment # 2:
Learning outcomes:
1. Enable the students to find some structured ways of dealing with complex managerial
decision problems. (CLO1)
2. Introduce students to simple decision models and management science ideas that provide
powerful and (often surprising) qualitative insights about a large spectrum of managerial
problems. (CLO2)
3. Provide students with tools for deciding when and which decision models to use for the
specific problems. (CLO3)
4. Give the students a feel for the kinds of problems that can be tackled using spreadsheet
modeling and decision analysis. (CLO4)
5. Provide the students with more powerful ways of using spreadsheets which will be a
ubiquitous tool in their managerial careers. (CLO5)
Assignment Questions
(10 Marks)
Answer the following questions:
1) Define the different between linear and nonlinear optimization with example each? (6 marks)
Answer:
2)
A- How to calculate forecast error? (1 mark)
B- Calculate forecast error for December? (1 mark)
Month
September
October
November
December
Sales
5500
7200
8600
9300
Forecast
3000
4150
9100
7900
Error
-------------------------
Answer:
3)
A- How to calculate forecast weighted moving average? (1 mark)
B- Apply forecast weighted moving average formula for week 2. (1 mark)
(n = 2, W1 = 0.5, W2 = 0.8)
Week
1
2
3
4
Answer:
Demand
7000
4000
3000
5000
Purchase answer to see full
attachment
Would you like to help your fellow students? Are you in need of an additional source of income? Apply to become a tutor on Studypool! Our best tutors earn over $7,500 each month!