As Ict

Edexcel GCE Applied In regulateation and colloquy Technology Unit 3 The K instantlyledge Worker January 2013 Scenario Paper character 6953/01 The scenario should be distri furthered to candidates at least three working weeks before the run. employ files whitecaps_practice. xls, fixtures_practice. txt, h out-of-door_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 discipline contained in the scenario volition be include in the examination paper.Further details be in the Instructions of the Conduct of Examinations (ICE), available from the Edexcel website for this qualification. Edexcel provide not accept any request for special consideration should candidates be given the incorrect scenario for the examination they be sitting. Turn over W41049A 2013 Pearson rearing Ltd. 6/ *W41049A* Scenario Havering Whitecaps Maddy Wright and Katy Parrish amaze supported Haverin g Whitecaps since their boyfriends played for the group. Their boyfriends careers and the teenage romances are now in truth much in the past but their support of the team re master(prenominal)s as strong as ever.Until 15 years past the Whitecaps were a struggling non-league team with little support. thither were times, on askew and cold November afternoons, when Maddy and Katy were the only supporters. In 1999 a magical thing happened to the Whitecaps. At that time the teams position, both in football game price and financially, was perilous to say the least. However, a financial backer appeared in the form of Harold Adenyi. Harold had studied at the local college and even played a a few(prenominal) games for the Whitecaps. His progress as a footballer was hampered by a miss of ability.He gave up on a career as a footballer to concentrate on what he was good at, which was IT and mathematics. He made a large amount of money by creating an online accountancy website called less tax. com. Harold was looking for things he could offset against a huge tax bill and a loss-making football fiat seemed to be a good start. He bought the Whitecaps from the previous owners for ? 1 and immediately started to spend money on it. Harolds flair for rail line meant that the loss-making football club did not stay loss-making for long.Harold signed a knowing former football league managing director and with his advice, spent money on players who all turned out to be good investments. The way the manager had the team playacting soon started to increase its fan base, so Harold built a refreshed stadium. The team continued to be successful and the new stadium was soon filled at all(prenominal) couple on, personateting the club on a healthy 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 flavors, when the Whitecaps struggled to establish themselves, there follow ed a eriod of gradual success including promotion to the initiative Division and two years later the Championship. Last eon the Whitecaps won the Championship and are currently looking forward to their first season in the premier League. Throughout this period of development, Maddy and Katy have been screaming encourage words to their team (and the occasional discouraging one to the opposition) and they have hardly missed a match. It was inevitable that as the Whitecaps two most sacred supporters they would become the chairman and secretary of the supporters club.One of their main tasks is to organise international trips for fans. This involves purchasing the books, booking the coaches and deciding what to charge for the ticket and transport packages. With 14,678 registered supporters, organising the away trips is not an easy task. With the possibility of over 400 coaches travelling to an away match, the issuing of transport firms the pair could use was limited. Since the Whitecaps were promoted to the Championship Maddy and Katy have used point of no return Transport whose rates are reasonable and who can supply complete coaches on a match day. 2 W41049ARubicon charge a fix sum of ? 350 per coach, plus a ? 1. 50 fuel surcharge for every 100 miles travelled. In addition, Rubicons regulations state that a driver cannot be in charge of the coach for more than 9 hours a day. Should the whole trip last more than 9 hours (including the match time) a second driver would be required. in that respect is a charge of ? 75 for the second driver. Premier League ticket prices vary greatly and Maddy has been quoted a range of prices varying between ? 30 and ? 54 by the Premier League clubs. Maddy and Katy do not need to make an overall gain.Their main aim is to get as slightly(prenominal) fans as possible to away matches. Although they can afford to make a loss on soulfulness trips, they cannot afford to make a loss overall. Therefore an accurate prognos tication of the number of good deal who leave behind want to go to a crabby match is vital. They are also aware that more people will want to go to some matches than others. To dish up find out how many people are likely to go to each match they ran an online survey. This was perfect by 94% of their registered supporters. To make data analysis 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 involved in the relegation dogfight PR Newly 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 overall cost of the package would discourage some from attending certain matches. W41049A 3 Turn over Description of the modelMad dy and Katy have to be as accurate as they can when setting the prices as they dont need to make a profit but cannot afford to make a loss. Maddy and Katy need a model to help them decide on prices. Therefore, Maddy has persuaded her brother Kieran, who works in IT, to create a model. Kieran wanted to make the model reusable so that he could contend it to other supporters clubs. Unfortunately, before he could finish the model, the company Kieran worked for sent him to Dubai on a three-year contract. Maddy has asked you to complete the model and use it to suggest prices for the next seasons 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 Katys classifications. For ease of viewing I have included information from other worksheets and have calculated the total costs, revenue and profit. There is a profit for each trip and a total profit for the season. The worksheet will also calculate the total number of supporters going to away matches. Cell B2 contains a drop-down box to choose the team you support. FixturesThis worksheet is a calculated page which lists the dates of the home and away fixtures. Lookups This worksheet contains a number of lookup 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, Times These worksheets contain the distances between the grounds and the comely times it would take a coach to travel those journeys.I got these from a very helpful man at the RAC. Customer This worksheet is incomplete. Once completed it will predict the number of supporters who would travel to each away match. This is based on the number of registered supporters an d accordingly adjusted according to the home team classification, then package price and finally the travel time. I havent finished 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 place In this worksheet I have entered the transport rates as quoted by Rubicon Transport. I hope you find it easy to understand my notes. ethical luck completing it. Kieran Wright 4 W41049A Some cells in the model are password protected. Should you wish to experiment with the model, the password is edexcel. Be aware that if you counterchange the contents of any protected cell the model may not work. Please note that the Football League and Premier League referred to in this scenario are fictitious. W41049A 5