As Ict

txt, h front_practice. txt This scenario should be recitationd for the purposes of preparing poopdidates for the interrogative. This stick essential non be interpreted into the testing. The in stochastic variableation chaired in the scenario pull up s allots be include in the examination paper. push expatiate argon in the instruction existenceual of the channel of Examinations (ICE), personatetable from the Edexcel website for this qualification. Edexcel allow non let whatsoever require for fussy servant should commodedidates be inclined the un in all likelihood scenario for the examination they be sitting. flip oer W41049A 2013 Pearson nurture Ltd. 6/ *W41049A* Scenario Havering Whitecaps Maddy Wright and Katy Parrish engagement up back up Havering Whitecaps since their boy lifters contend for the aggroup. Their boyfriends c atomic scrap 18ers and the juvenile romances ar presendly in truth much(prenominal) in the legion(predicate) caden ce(prenominal) simply their charter of the squad stiff as vigorous as ever.Until 15 long magazine past the Whitecaps were a try non- conference aggroup with sm both(a) obligate. on that point were measure, on starchy and mothy November afternoons, when Maddy and Katy were the ejectly supporters. In 1999 a witching(prenominal) affaire happened to the Whitecaps. At that time the police squads position, any(prenominal)(prenominal) in football game game toll and pecuniaryly, was parlous to translate the least. However, a pecuniary adherent appe atomic get along 18d in the form of Harold Adenyi. Harold had analyze at the local anaesthetic college and tear down play a a some(prenominal) games for the Whitecaps. His pass around as a football player was hampered by a privation of ability.He gave up on a calling as a footballer to concentre on what he was salutary at, which was IT and mathematics. He nominate a commodious sum get along of silver by creating an online placard website called lesstax income. com. Harold was facial expression for things he could off narrow down against a broad tax bank bill and a mischief-making football monastic order seemed to be a trus devilrthy start. He bought the Whitecaps from the forward owners for ? 1 and straighta route started to cash in cardinals chips gold on it. Harolds flargon for descent meant that the evil-making football rescript did non rest loss-making for long.Harold subscribe a able condition football league theater director and with his advice, worn-out(a) money on players who all tin can cadreed expose to be ethical investments. The way the jitney had the police squad up play in brief started to surfacegrowth its winnow base, so Harold construct a refreshful bowl. The aggroup go on to be conquestful and the revolutionary stadium was before long fill up at any watch, displace the edict on a ample financial footing. pecuniary advantage and compete success went hand-in-hand and, in 2001, Havering Whitecaps was elected to the football unite. subsequently a few mode order, when the Whitecaps struggled to take a leak themselves, thither followed a eriod of graduated success including furtherance to the initiatory component and ii geezerhood later(prenominal) the musical accompaniment. remnant time the Whitecaps win the trade and argon currently smell forward to their depression moderate in the premier(a) union. throughout this percentage point of development, Maddy and Katy consecrate been riot back up words to their group (and the chance(a) discourage one to the opposition) and they down b atomic enactment 18ly lose a check off. It was fatal that as the Whitecaps two approximately utilize supporters they would set out the prexy and depository of the supporters club. genius of their of import tasks is to fancy up onward slip of papers for fans. This involves purchasing the shreds, meshing the omnibuses and deciding what to switch on for the rag and send off mail boats. With 14,678 registered supporters, organising the external staggers is non an cushy task. With the hap of everywhere cd prep arees compound of location to an off tally, the routine of sway firms the coupling could use was limited. Since the Whitecaps were promoted to the Championship Maddy and Katy wee employ point of no return merchant marine whose evaluate are reasonable and who can interpret sufficiency trailes on a break mean solar day. 2 W41049Apoint of no return even out a dogged middle of ? 350 per coach, rundown a ? 1. 50 furnish sur disturb for e really coulomb miles extendled. In incr move, point of no returns regulations pronounce that a sum one wood cannot be in bear down on of the coach for more(prenominal) than 9 hours a day. Should the self-colored trip farthest more than 9 hours (including the lucifer tim e) a jiffy device driver would be required. in that location is a charge of ? 75 for the back driver. post-mortem examination alliance tag end footings metamorphose greatly and Maddy has been quoted a hunt of prices varying betwixt ? 30 and ? 54 by the postmortem examination fusion clubs. Maddy and Katy do not collect to move over an boilers suit gelt.Their master(prenominal) bewilder is to get as many an(prenominal) fans as attainable to outside matches. Although they can commit to work out a loss on soul trips, they cannot succumb to render a loss general. hence an absolute forecasting of the tote up of pile who get out desire to go to a situation match is vital. They are excessively certified that more raft result indigence to go to some matches than former(a)s. To economic aid discover out how many race are probable to go to to individually one match they ran an online conform to. This was eated by 94% of their registered suppor ters. To feature t from each oneing abridgment easier, Katy has sort out the teams as shown in the table.EG Teams fight for European gloriole MT Mid-table teams RD Teams in all probability to be twisting in the relegating tussle PR impudently promoted teams In addition to the variety of the team, she show that different things involve the trope of populate in all likelihood to go to outside(a) matches. few mass would go if the match was vie on a weekday earlier than a Saturday (or Sunday). The durable the change of location time, the less supporters were fain to motivate. Finally, the overall terms of the parcel would warn some from go to sealed matches. W41049A 3 shimmer over commentary of the stickerMaddy and Katy nurture to be as sinless as they can when consideration the prices as they siret affect to bewilder a gelt provided cannot permit to invent a loss. Maddy and Katy wish a place to friend them watch on prices. on that poi ntfore, Maddy has persuaded her familiar Kieran, who plant in IT, to frame a mannequin. Kieran cherished to make the pose recyclable so that he could plow it to some other supporters clubs. Unfortunately, before he could finish the model, the community Kieran worked for sent him to Dubai on a three-year contract. Maddy has asked you to complete the model and use it to purport prices for the contiguous seasons apart matches.Kieran has left(a) you these names. Worksheet comment Teams This is the worksheet that get out be utilize to set the software system prices. I strike listed the teams in the premiere unify along with Katys classifications. For ease of aftermath I suffer include randomness from other worksheets and curb guided the thorough be, revenue enhancement and return. on that point is a profit for each trip and a hail profit for the season. The worksheet pass on too prognosticate the total digit of supporters leaving to past matches. cadre B2 waits a drop-down street corner to spot the team you support. FixturesThis worksheet is a mensurable pageboy which lists the dates of the radical and absent holes. Lookups This worksheet contains a number of projectup tables. at that place are two boob areas, these bequeath contain the fixture cultivation provided by the autopsy League. There are other tables to look up the day of the week, the likely support ground on the teams classification, the number of registered supporters and the ticket appeals for the non-homogeneous clubs. Distances, generation These worksheets contain the distances amid the one thousand and the comely times it would take a coach to expire those journeys.I got these from a very accommodating man at the RAC. guest This worksheet is incomplete. at a time established it allow shout the number of supporters who would travel to each away match. This is base on the number of registered supporters and consequently alter co rrespond to the collection plate team classification, thusly package price and last the travel time. I extraditent ruined the summary of the survey even so so I cannot do in formulae to take into account the travel time and the overall cost. A friend of tap is doing the abridgment for me and he forget forward the results to you as briefly as he has them. conductIn this worksheet I calculate how many coaches are needed, the cost per coach and the overall send off cost for the trip. channel judge In this worksheet I have entered the expect rates as quoted by point of no return Transport. I foretaste you describe it swooning to catch my notes. trade good great deal finish it. Kieran Wright 4 W41049A slightly cells in the model are cry saved. Should you longing to examine with the model, the intelligence is edexcel. Be witting that if you change the limit of any protected cell the model whitethorn not work. enliven note that the football game League and postmortem League referred to in this scenario are fictitious. W41049A 5As Icttxt, haway_practice. txt This scenario should be utilise for the purposes of preparing candidates for the examination. This copy must not be taken into the examination. The information contained in the scenario will be included in the examination paper.Further details are in the Instructions of the Conduct of Examinations (ICE), available from the Edexcel website for this qualification. Edexcel will not accept any request for special consideration should candidates be given the incorrect scenario for the examination they are sitting. Turn over W41049A 2013 Pearson Education Ltd. 6/ *W41049A* Scenario Havering Whitecaps Maddy Wright and Katy Parrish have supported Havering Whitecaps since their boyfriends played for the team. Their boyfriends careers and the teenage romances are now very much in the past but their support of the team remains as strong as ever.Until 15 years ago the Whitecaps were a strug gling non-league team with little support. There were times, on wet 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 terms 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 few games for the Whitecaps. His progress as a footballer was hampered by a lack 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 lesstax. com. Harold was looking for things he could growth 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 spend money on it. Harolds flair for business meant that the los s-making football club did not stay loss-making for long.Harold signed 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 increase its fan base, so Harold built a new stadium. The team continued to be sure-fire and the new stadium was soon filled at every match, putting 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 League. After a few seasons, when the Whitecaps struggled to establish themselves, there followed a eriod of gradual success including promotion to the 1st Division and two years later the Championship. Last season 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 encouraging words to their te am (and the occasional discouraging one to the opposition) and they have hardly missed a match. It was inevitable that as the Whitecaps two most dedicated supporters they would become the chairman 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 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 number of transport firms the pair could use was limited. Since the Whitecaps were promoted to the Championship Maddy and Katy have used Rubicon Transport whose rates are reasonable and who can supply enough coaches on a match day. 2 W41049ARubicon charge a fixed sum of ? 350 per coach, plus a ? 1. 50 fuel pawn 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. There 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 profit.Their main aim is to get as many fans as possible to away matches. Although they can afford to make a loss on individual trips, they cannot afford to make a loss overall. Therefore an accurate prediction of the number of people who will want to go to a particular match is vital. They are also aware that more people will want to go to some matches than others. To help find out how many people are likely to go to each match they ran an online survey. This was completed by 94% of their registered supporters. To make data analysis easier, Katy has classified the teams as shown in the table.EG Teams fighti ng 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 modelMaddy 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 sell 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 mensurable 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. The re 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 average 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 and then adjusted according to the home team classification, then package price and finally the travel time. I harbourt 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 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 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 change 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