Photo AI

Using the data in Extract D, calculate the values of A, B, and C and, using other non-financial information, evaluate these two options Live the Adventure Ltd should choose in order to grow - Edexcel - A-Level Business - Question 1 - 2019 - Paper 3

Question icon

Question 1

Using-the-data-in-Extract-D,-calculate-the-values-of-A,-B,-and-C-and,-using-other-non-financial-information,-evaluate-these-two-options-Live-the-Adventure-Ltd-should-choose-in-order-to-grow-Edexcel-A-Level Business-Question 1-2019-Paper 3.png

Using the data in Extract D, calculate the values of A, B, and C and, using other non-financial information, evaluate these two options Live the Adventure Ltd should... show full transcript

Worked Solution & Example Answer:Using the data in Extract D, calculate the values of A, B, and C and, using other non-financial information, evaluate these two options Live the Adventure Ltd should choose in order to grow - Edexcel - A-Level Business - Question 1 - 2019 - Paper 3

Step 1

Calculate A and C

96%

114 rated

Answer

To calculate the value of A, we use the sales data from the previous quarters. For the 8-period moving average for 2016 Q4:

A=(490+550+570+590+610+630+630+320)8=590A = \frac{(490 + 550 + 570 + 590 + 610 + 630 + 630 + 320)}{8} = 590

The value for C (Q4 of 2017) is derived from the quarter sales figure, which is 630.

Step 2

Calculate B

99%

104 rated

Answer

To calculate B (the 4 quarter moving average, 2017 Q2), we use the sales figures from the last four quarters (Q1-Q4):

For Q4 of 2016 to Q2 of 2017:

B=(590+610+630+320)4=612.5B = \frac{(590 + 610 + 630 + 320)}{4} = 612.5

Step 3

Evaluate Growth Options

96%

101 rated

Answer

Live the Adventure Ltd should consider offering winter activity holidays in Europe. This option diversifies its offerings and potentially attracts a new customer base. Additionally, capturing the winter market can help balance revenue throughout the year, smoothening cash flow. However, entering new markets involves risks, such as understanding local regulations and competition. Maintaining operations in existing locations ensures they continue to leverage their established reputation while exploring new opportunities.

Join the A-Level students using SimpleStudy...

97% of Students

Report Improved Results

98% of Students

Recommend to friends

100,000+

Students Supported

1 Million+

Questions answered

;