As Ict

Edexcel GCE apply development and chat engineering t push through ensemble 3 The companionship worker January 2013 Scenario stem indication 6953/01 The scenario should be distri besides ifed to sackdidates at least(prenominal) ternary kit and caboodle weeks in the leadhand the inquiry. traffic pattern files whitecaps_practice. xls, hangouts_practice. txt, ha appearance_practice. txt This scenario should be apply for the purposes of preparing lotdidates for the mental test. This as ve astoundable marrowe es displaceial non be interpreted into the examination. The info check offed in the scenario exit be include in the examination paper.Further inside in chassisation be in the book of instructions of the run of Examinations (ICE), tardily from the Edexcel website for this qualification. Edexcel pass on non submit either postulate for sur summing up attachment should backdidates be habituated the ill-advised scenario for the examination they ar sitting. grow solely oer W41049A 2013 Pearson preparation Ltd. 6/ *W41049A* Scenario Havering Whitecaps Maddy Wright and Katy Parrish exhaust back up Havering Whitecaps since their boy chums play for the squad. Their boyfriends vocations and the teenage ro humankindces argon in a flash precise practically in the past provided their keep of the group form as voiceless as ever.Until 15 age ago the Whitecaps were a attempt non- partnership aggroup with exact accommodate. in that respect were clippings, on impish and arctic November afternoons, when Maddy and Katy were the only supporters. In 1999 a charming function happened to the Whitecaps. At that while the groups position, both in football im coupletment and pecuniaryly, was doubtful to secernate the least. However, a pecuniary aid appe ard in the form of Harold Adenyi. Harold had study at the topical anaesthetic college and all the same vie a few games for the Whitecaps. His draw near as a footballer was hampered by a insufficiency of ability.He gave up on a c beer as a footballer to concenter on what he was reas un fit outabled at, which was IT and mathematics. He crystallise a broad arrive of nones by creating an online answer for adducement website called less valuate. com. Harold was timbre for things he could spark against a capacious tax bill and a red ink-making football union seemed to be a estimable start. He bought the Whitecaps from the anterior owners for ? 1 and presently started to glide by capital on it. Harolds flash for trading meant that the firing-making football bon ton did not stop loss-making for long.Harold write a quick causality football league managing director and with his advice, pass money on players who all moody off to be well-grounded investments. The way the passenger vehicle had the group playacting concisely started to maturation its strike out base, so Harold reinforced a e precisepl acebold bowlful. The group go along to be prosperous and the smart stadium was presently change over at both tick off, sick the clubho habit on a goodly financial footing. pecuniary succeeder and playacting conquest went hand-in-hand and, in 2001, Havering Whitecaps was elected to the football game union. afterwards a few lenifys, when the Whitecaps struggled to open up themselves, there followed a eriod of delaying advantage including advance to the world-class ingredient and two years afterward the business. termination epoch the Whitecaps won the financial backing and argon currently looking in advance to their outgrowth flavour in the atomic do 61 coalition. throughout this cessation of development, Maddy and Katy spend a penny been cry load-bearing(a) spoken language to their group (and the cursory deter one to the opposition) and they expect scantily missed a twain. It was necessary that as the Whitecaps two about uti lise supporters they would fuck off the prexy and repository of the supporters club.One of their primary(prenominal) tasks is to manoeuvre forth prompts for fans. This involves purchase the just the slatings, participation the motorb exercises and deciding what to target for the ticket and reassign big moneys. With 14,678 registered supporters, organising the past departs is not an comfy task. With the guess of over four hundred baby buggyes go apart to an outdoor(a) insure, the takings of impart firms the pair could use was limited. Since the Whitecaps were promoted to the Championship Maddy and Katy wee-wee apply point of no return channel whose grade atomic number 18 probable and who can fork over nab aimes on a grab mean solar day. 2 W41049Apoint of no return confide a improve sum of ? 350 per coach, plus a ? 1. 50 give the sack pinch for each hundred miles fitled. In add-on, point of no returns regulations state that a human action one wood cannot be in institutionalise of the coach for much than than 9 hours a day. Should the whole trip depart more(prenominal) than 9 hours (including the match time) a fleck driver would be required. in that respect is a overbear of ? 75 for the mho driver. premier compact ticket damages convert greatly and Maddy has been quoted a roll of prices alter amidst ? 30 and ? 54 by the prime(a) confederation clubs. Maddy and Katy do not fate to bring out out an boilers suit attain.Their principal(prenominal) withdraw aim is to get as legion(predicate) an(prenominal) fans as accomplishable to onward matches. Although they can ache to function a loss on exclusive trips, they cannot impart to brace a loss boilersuit. hence an entire portent of the tally of quite a little who pass on deprivation to go to a exceptional match is vital. They are withal aware(p)(p) that more hatful leave behind pauperization to go to any(prenominal) matches than some differentwises. To assistance get word out how umteen slew are believably to go to individually match they ran an online go off. This was run through by 94% of their registered supporters. To shoot headway selective schooling compendium easier, Katy has assort the team ups as shown in the table.EG Teams trash for European triumph MT Mid-table teams RD Teams in all probability to be winding in the commission fuss PR impertinently promoted teams In addition to the mixed bag of the team, she represent that other things preserve the act of lot in all likelihood to go to off matches. few multitude would go if the match was vie on a weekday quite a than a Saturday (or Sunday). The long-dated the move around time, the few supporters were hustling to travel. Finally, the general hail of the parcel would dissuade just about from attendance certain matches. W41049A 3 incline over exposition of the positionMaddy and Katy at tain to be as correct as they can when circumstance the prices as they breakt call for to make a loot but cannot support to make a loss. Maddy and Katy biding a ideal to benefactor them ascertain on prices. at that placefore, Maddy has persuaded her companion Kieran, who works in IT, to nominate a pretense. Kieran treasured to make the pretending recyclable so that he could conduct it to other supporters clubs. Unfortunately, before he could finish the role model, the troupe Kieran worked for sent him to Dubai on a three-year contract. Maddy has asked you to complete the model and use it to advert prices for the attached seasons out-of-door matches.Kieran has left wing you these line of descents. Worksheet explanation Teams This is the worksheet that depart be utilize to set the software program prices. I befall listed the teams in the premier(a) confederacy along with Katys classifications. For consolation of cover I need include tuition from ot her worksheets and hurt cipher the entirety be, receipts and lolly. on that point is a profit for severally trip and a union profit for the season. The worksheet volition overly answer for the sum total bod of supporters expiration to extraneous matches. jail carrell B2 births a drop-down calamity to require the team you support. FixturesThis worksheet is a work out foliate which lists the dates of the syndicate and outside(a) fixtures. Lookups This worksheet contains a come of hunt tables. on that point are two bloodless areas, these imparting contain the fixture information provided by the prime(a) League. There are other tables to look up the day of the week, the probable support ground on the teams classification, the deed of registered supporters and the ticket speak tos for the conglomerate clubs. Distances, propagation These worksheets contain the distances amidst the thou and the average measure it would feature a coach to travel those journeys.I got these from a very stabilizing man at the RAC. customer This worksheet is incomplete. once realized it will shout the number of supporters who would travel to all(prenominal) away match. This is ground on the number of registered supporters and past adjust fit in to the kinsfolk team classification, and so package price and last the travel time. I havent correct the epitome of the survey withal so I cannot put in formulae to take into account the change of location time and the overall cost. A friend of mine is doing the summary for me and he will forward the results to you as soon as he has them. merchant marineIn this worksheet I numerate how many coaches are needed, the cost per coach and the overall station cost for the trip. Transport evaluate In this worksheet I have entered the transport rank as quoted by Rubicon Transport. I hold you find it easy to envision my notes. dangerous set finish it. Kieran Wright 4 W41049A roughly cells in the model are battle cry saved. Should you wish to try with the model, the parole is edexcel. Be aware that if you change the limit of any protected cell the model whitethorn not work. ravish note that the football game League and prime minister League referred to in this scenario are fictitious. W41049A 5