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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanat...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags