As Ict

txt, haway_practice. txt This scenario should be used 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 struggling 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 team’s 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 offset 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. Harold’s flair for business meant that the loss-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 successful 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 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 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 W41049A Rubicon charge a fixed sum of ? 350 per coach, plus a ? 1. 50 fuel surcharge for every 100 miles travelled. In addition, Rubicon’s 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 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 model Maddy and Katy have to be as accurate as they can when setting the prices as they don’t 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 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 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. Fixtures This 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 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 haven’t 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. Transport In 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 As Ict txt, haway_practice. txt This scenario should be used 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 struggling 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 team’s 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 offset 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. Harold’s flair for business meant that the loss-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 successful 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 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 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 W41049A Rubicon charge a fixed sum of ? 350 per coach, plus a ? 1. 50 fuel surcharge for every 100 miles travelled. In addition, Rubicon’s 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 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 model Maddy and Katy have to be as accurate as they can when setting the prices as they don’t 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 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 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. Fixtures This 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 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 haven’t 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. Transport In 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

Operations Management Assignment Essay Example | Topics and Well Written Essays - 3500 words

Operations Management Assignment - Essay Example The range of technologies used in the modern retail industries have been from softwares to hardwares. The new technologies require that they become fully integrated into the retail operations of the business for their benefits to be maximized. According to McGrane (2007, p. 50-53), some of the key technologies or technological areas within the range are as follows (McGrane 2007, p. 50-53; EPoS 2007; and Prater et al. 2005): Bar-coding/scanning technology/labelling. Bar-coding, scanning, and labelling technologies have been invented years ago but not all of the retail business operations are using them. Nevertheless, the technologies are expected to be available to business operators in the coming years and there are widespread expectations that the technologies will be improved further and will become in more popular use as we go through current decade (McGrane 2007, p. 52). â€Å"Scanners are getting smarter† and â€Å"self-scanning will continue to grow† (McGrane 2007 , p. 52). The new technologies include a touch screen display, barcode scanner, weighing scales, credit card reader, cash reader and deposit unit. Wireless technologies are even being developed for bar-coding and scanning, making possible for inventory and sales monitoring and sales transaction remotely from the goods that are the subject of a transaction. Epos software & hardware. EPoS systems or Electronic Point of Sale Systems provide a way of dealing with customers that is fast and efficient because they can do calculations or total, issue receipts, keep track of inventories, and monitor sales as the sales transaction is being completed (EPoS 2010). Further, the EPoS systems can also keep track of customer information thereby enhancing the seller’s capabilities to execute customer relation management (EPoS 2010). Moreover, the EPoS systems can also directly interface with the credit card system thereby accessing more information on customers and enhancing the ability of t he firm to conduct follow-up sales and strengthen its relationship with customers (EPoS 2010). Simultaneously, the EPoS system can also identify which products are not doing well in the market (EPoS 2010) thereby enhancing a business firm’s ability to make crucial business decisions on what products lines and brands to carry. EPoS systems can make transactions faster and they can be customized to a specific business environment (EPoS 2010). Changing prices, data, quantity and other variables are easy (EPoS 2010). EPoS systems can be operated through keyboards or PDAs or personal digital assistant (EPoS 2010). The systems were designed to be powerful and yet very simple for the business staff to learn and use (EPoS 2010). On the other hand, the EPoS system requires maintenance and backups (EPoS 2010). Data can be backed up off site using another party or service company (EPoS 2010). The backup system must cover â€Å"historical backups† in that one can go back to an old er backup if the most recent backup is corrupted (EPoS 2010). Periodic updates are necessary and businesses using the latest retail technologies may want to have in-house capabilities to do backups. This also implies that somebody in business must focus himself or herself in data security. Wireless hardwares,

Hypothesis Exercise on Green Logistics Chain and Issues (CO2 emissions Essay

Hypothesis Exercise on Green Logistics Chain and Issues (CO2 emissions from Freight Transport in the US) - Essay Example They can end into obliging an increased usage of maintainable skills or alternate energies or merely they can confine individual zones or kinds of cars from being employed. It can be anticipated that the execution of supportable conveyance rules forces the logistic business to use environmentally unsafe means of transportation and consequently apply green logistic tools. Additionally since there are less of fuel efficient vehicles through the car fleet in United States of America, the logistic firm opt for use cargo wagons that are the chief causes of greenhouse gas discharges. Again, the requirement to meet the client’s fulfillment is one of the vital roles of the logistics. Customer fulfillment can be realized by several means such as haste of transport, quality of the transported goods and chattels or the likelihood of returning properties owing to recoveries. It can be assumed that a greater need for the client for justifiable and Green Logistics helps the dissemination of Logistics plans. The growing awareness of environmental problems can result to stimulating task for the logistics firm. As transportation and the involved business are among the vilest contaminators an intensifying consciousness in such a way can lead to weight illogicality and disgrace contrary to it. So as not to create a bad appearance it is undeniably vital to adjust to those inclinations. It can be assumed that it is essential for the logistic firm to conform to a growing environmental awareness in an extensive fragment of the community through executing Green Logistics policies. Has the Green Logistics fully succeeded in reducing the rate of pollution United States of America? Green logistics has both failed and succeed in dressing the environmental issues. Oil is the organic base for vestige energies for example petrol; diesel and paraffin that are the most frequently used powers for