Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

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

Accounting Nov 12, 2020

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)

Expert Solution

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    
Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment