'As Ict\r'

'Edexcel GCE Applied instruction and Communication Technology Unit 3: The experience Worker January 2013 Scenario Paper Reference 6953/01 The scenario should be distri thoed to candidates at least three working weeks before the examination. expend files: whitecaps_practice. xls, fixtures_practice. txt, ha trend_practice. txt This scenario should be apply for the purposes of preparing candidates for the examination. This copy must not be taken into the examination. The information contained in the scenario exit be included in the examination paper.Further expound argon in the Instructions of the Conduct of Examinations (ICE), available from the Edexcel website for this qualification. Edexcel get out not accept any signal for special consideration should candidates be given the false scenario for the examination they ar sitting. Turn over W41049A ©2013 Pearson fosterage Ltd. 6/ *W41049A* Scenario Havering Whitecaps Maddy Wright and Katy Parrish defend supported Haverin g Whitecaps since their boyfriends played for the team. Their boyfriends’ careers and the immature romances are now very much in the past but their support of the team the Great Compromiser as strong as ever.Until 15 age ago the Whitecaps were a struggling non- partnership team with humble support. There were time, on wet and cold November afternoons, when Maddy and Katy were the barely supporters. In 1999 a magical thing happened to the Whitecaps. At that time the team’s position, both in footb either terms and financially, was perilous to say the least. However, a financial backer appeared in the form of Harold Adenyi. Harold had analyze at the local college and even played a few games for the Whitecaps. His progress as a football player was hampered by a lack of ability.He gave up on a career as a football player to concentrate on what he was wide-cut at, which was IT and mathematics. He made a large amount of cash by creating an online accountancy website called lesstax. com. Harold was looking for things he could starting signal against a huge tax bill and a loss-making football club seemed to be a good start. He bought the Whitecaps from the previous owners for ? 1 and immediately started to buy the farm money on it. Harold’s flair for concern meant that the loss-making football club did not stay loss-making for long.Harold subscribe a talented former football league manager and with his advice, spent money on players who all turned out to be good investments. The way the manager had the team playing soon started to step-up its fan base, so Harold built a tender stadium. The team continued to be masteryful and the impertinent stadium was soon filled at any mark, putting the club on a hearty financial footing. Financial success and playing success went hand-in-hand and, in 2001, Havering Whitecaps was elected to the Football union. After a few tempers, when the Whitecaps struggled to establish themselves, there followed a eriod of sluggish success including promotion to the 1st Division and two years later the Championship. Last season the Whitecaps won the Championship and are currently looking before to their first season in the phase modulation federation. throughout this period of development, Maddy and Katy construct been screaming encouraging words to their team (and the occasional discouraging one to the opposition) and they have hardly missed a twosome. It was inevitable that as the Whitecaps’ two most dedicated supporters they would become the chairwoman and secretary of the supporters’ club.One of their main tasks is to organise away trips for fans. This involves buying the tickets, booking the coaches and deciding what to charge for the ticket and outrage packages. With 14,678 registered supporters, organising the away trips is not an easy task. With the possibility of over 400 coaches traveling to an away match, the fare of enrapture firms the pair cou ld use was limited. Since the Whitecaps were promoted to the Championship Maddy and Katy have used ‘point of no return Transport’ whose rates are bonnie and who can supply enough coaches on a match day. 2 W41049ARubicon charge a located sum of ? 350 per coach, plus a ? 1. 50 provoke surcharge for every 100 miles travelled. In addition, Rubicon’s regulations state that a device driver cannot be in charge of the coach for more than than 9 hours a day. Should the whole trip last more than 9 hours (including the match time) a second driver would be required. There is a charge of ? 75 for the second driver. Premier League ticket prices set off greatly and Maddy has been quoted a range of prices varying in the midst of ? 30 and ? 54 by the Premier League clubs. Maddy and Katy do not need to make an boilers suit scratch.Their main aim is to get as many fans as possible to away matches. Although they can brook to make a loss on exclusive trips, they cannot affo rd to make a loss general. thusly an accurate prediction of the issuing of raft who leave want to go to a particular match is vital. They are also aware that more people go forth want to go to some matches than some others. To alleviate attend out how many people are likely to go to each match they ran an online survey. This was absolute by 94% of their registered supporters. To make data compend easier, Katy has classified the teams as shown in the table.EG Teams fighting for European glory MT Mid-table teams RD Teams likely to be mired in the relegation dogfight PR impudently promoted teams In addition to the classification of the team, she found that other things affect the number of people likely to go to away matches. Fewer people would go if the match was played on a weekday rather than a Saturday (or Sunday). The longer the travelling time, the fewer supporters were prepared to travel. Finally, the boilersuit cost of the package would discourage some from aid cer tain matches. W41049A 3 Turn over definition of the modelMaddy and Katy have to be as accurate as they can when setting the prices as they don’t need to make a remuneration but cannot afford to make a loss. Maddy and Katy need a model to help them decide on prices. Therefore, Maddy has persuaded her pal Kieran, who works in IT, to create a model. Kieran wanted to make the model reusable so that he could sell it to other supporters’ clubs. Unfortunately, before he could turn back the model, the company Kieran worked for sent him to Dubai on a three-year contract. Maddy has asked you to double-dyed(a) the model and use it to suggest prices for the next season’s away matches.Kieran has left you these notes. Worksheet Description Teams This is the worksheet that will be used to set the package prices. I have listed the teams in the Premier League along with Katy’s classifications. For ease of viewing I have included information from other worksheets and have cypher the total costs, revenue and profit. There is a profit for each trip and a total profit for the season. The worksheet will also wait the total number of supporters going to away matches. Cell B2 contains a drop-down concussion to choose the team you support. FixturesThis worksheet is a calculated scalawag which lists the dates of the dwelling and away fixtures. Lookups This worksheet contains a number of hunting tables. There are two blank areas, these will contain the fixture information provided by the Premier League. There are other tables to look up the day of the week, the likely support based on the teams’ classification, the number of registered supporters and the ticket costs for the various clubs. Distances, time These worksheets contain the distances between the grounds and the average times it would take a coach to travel those journeys.I got these from a very helpful man at the RAC. client This worksheet is incomplete. Once completed it will pr edict the number of supporters who would travel to each away match. This is based on the number of registered supporters and then adjusted according to the home team classification, then package price and in the end the travel time. I haven’t immaculate the analysis of the survey yet so I cannot put in formulae to take into account the travelling time and the overall cost. A friend of mine is doing the analysis for me and he will forward the results to you as soon as he has them. TransportIn this worksheet I calculate how many coaches are needed, the cost per coach and the overall transport cost for the trip. Transport Rates In this worksheet I have entered the transport rates as quoted by Rubicon Transport. I hope you find it easy to understand my notes. Good luck finish it. Kieran Wright 4 W41049A Some cells in the model are password saved. Should you wish to experiment with the model, the password is edexcel. Be aware that if you change the contents of any protected cel l the model may not work. enchant note that the Football League and Premier League referred to in this scenario are fictitious. W41049A 5\r\n'