Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Consider an entertainment park which is open only on Friday, Saturday and Sunday due to Covid-19 pandemic

Consider an entertainment park which is open only on Friday, Saturday and Sunday due to Covid-19 pandemic

Accounting

Consider an entertainment park which is open only on Friday, Saturday and Sunday due to Covid-19 pandemic. We have the last four weeks' actual number of visitors for these days. The number of visitors who visited the park on Fridays is Di, D4, D and Dro; the number of visitors who visited the park on Saturdays is D2, Ds, D. and Di; and the number of visitors who visited the park on Sundays is D, Do Do and D12 respectively for the past weeks 1,2,3,4. Select an integer number for daily number of visitors from the given intervals below. Before solving the question, fill in the following table and copy it into your answer sheet. Period Interval No of visitors Selected value Friday-Weekl [35,40] D Saturday-Week! (50,60) D Sunday-Week 1 [70,90] D Friday-Week2 [41.45) D: Saturday-Week2 [61.70] D D Sunday-Week2 [91.110] Friday-Week 3 [46,50] Saturday-Week 3 171.80] D D Sunday-Week3 1111.1301 D Friday-Week4 [81.901 D: Saturday-Week4 [35,401 D Sunday-Weck4 131.1501 D2
Dio Friday-Week4 [81,90) Saturday-Week4 [35,40] Sunday-Week4 [131.150] D D2 Use the most appropriate forecasting technique and forecast the number of visitors on Friday, Saturday and Sunday of week 5. Show each step explicitly. (Do not write magic numbers, show your computations. If some computations are similar to each other, then it is enough to show the way only the first one as an example.) Note: In your computations, do NOT round any numbers up or down. Please always use 2-digits for all non-integer values. (For instance: You can have a value such as 123.45 but not 123.4567)

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Solving for the Fri, Sat sun for week 5 by Linear regression forecasting method:

Fri-w1 36 1 Fri-w1 36 1 Sat-w1 56 1 sun-w1 76
Sat-w1 56 2 Fri-w2 43 2 Sat-w2 65 2 Sun-w2 95
sun-w1 76 3 Fri-W3 47 3 Sat-W3 77 3 Sun-W3 117
Fri-w2 43 4 Fri-W4 87 4 Sat-W4 37 4 Sun-W4 137
Sat-w2 65                  
Sun-w2 95                  
Fri-W3 47                  
Sat-W3 77                  
Sun-W3 117                  
Fri-W4 87                  
Sat-W4 37                  
Sun-W4 137                  
Fri-W5 92.5   slope 15.7   slope -4.5   slope 20.5
Sat-W5 47.5   intercept 14   intercept 70   intercept 55
Sun-W5 157.5                  

The formula is shown below:

Fri-w1 36 1 Fri-w1 36 1 Sat-w1 56 1 sun-w1 76
Sat-w1 56 2 Fri-w2 43 2 Sat-w2 65 2 Sun-w2 95
sun-w1 76 3 Fri-W3 47 3 Sat-W3 77 3 Sun-W3 117
Fri-w2 43 4 Fri-W4 87 4 Sat-W4 37 4 Sun-W4 137
Sat-w2 65                  
Sun-w2 95                  
Fri-W3 47                  
Sat-W3 77                  
Sun-W3 117                  
Fri-W4 87                  
Sat-W4 37                  
Sun-W4 137                  
Fri-W5 =O18+O17*5   slope =SLOPE(O5:O8,M5:M8)   slope =SLOPE(R5:R8,P5:P8)   slope =SLOPE(U5:U8,S5:S8)
Sat-W5 =R18+R17*5   intercept =INTERCEPT(O5:O8,M5:M8)   intercept =INTERCEPT(R5:R8,P5:P8)   intercept =INTERCEPT(U5:U8,S5:S8)
Sun-W5 =U18+U17*5