Assessment Test 1.a.3: Forecasting and Corkscrews
Please start the Assessment Test only after you have completed the previous modelling exercise.
Assessment Test Summary
0 of 3 Questions completed
Questions:
Information
You have already completed the assessment test before. Hence you can not start it again.
Assessment Test is loading…
You must sign in or sign up to start the assessment test.
You must first complete the following:
Results
Results
0 of 3 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
-
There are only three questions, but you need to get all of them correct, to ensure that you have built the model correctly!! Please try again.
-
Well done! Please continue with the course.
- 1
- 2
- 3
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 3
1. Question
Q1: What is the value of the Year 3 Cumulated Profit (cell G21), to the nearest decimal place, in the case that: Sales Growth (cell C5) is set to 1%, Fixed Cost Growth (cell C8) is set to 2%, and Variable Cost is set to 18% of Sales Revenue?
CorrectIncorrect -
Question 2 of 3
2. Question
Q2: What is the value of the Year 3 Cumulated Profit (cell G21), to the nearest decimal place, in the case that: Sales Growth (cell C5) is set to 6%, Fixed Cost Growth (cell C8) is set to 4%, and Variable Cost is set to 22% of Sales Revenue?
CorrectIncorrect -
Question 3 of 3
3. Question
Q3: What is the value of the Year 3 Cumulated Profit (cell G21), to the nearest decimal place, in the case that: Sales Growth (cell C5) is set to 5%, Fixed Cost Growth (cell C8) is set to 5%, and Variable Cost is set to 15% of Sales Revenue?
CorrectIncorrect