Spread Sheet Modelling Article Example | Topics and Well Written Essays - 1250 words

Spread Sheet Modelling - Article Example Layout plan 1. The user can either click â€Å"Run Random 10 Day Simulation† to generate outputs over 10 days using random values for all inputs OR 2. Enter a temperature for the next day OR click the â€Å"Randomly Generate Temperature† button to generate one. 3. The user then enters their intended: a) Price per cup b) Initial Investment 4. The user also needs to either enter their: a) Amount of Vodka per Jug b) Number of Ice Cubes per Cup OR click the buttons to optimize these variables to maximize demand. 5. Then clicking the â€Å"Calculate Demand† button will automatically take them to sheet 2, calculate the predicted demand and the required quantities of stock to satisfy this demand. 6. The user must enter their intended stock purchases subject to data validation to avoid them trying to purchases items in quantities that are unavailable or that cost more than there is funds available for. Alternatively they can also click the button labeled â€Å"Optimize Purchases† to have the best possible combination of purchases displayed for them. 7. The user can then click the button â€Å"Run Simulation†, this will take them to sheet 3, where the outputs for that day will be displayed. 8. Clicking â€Å"Next day† will then save all the inputs and outputs in sheets 5-7, reset all the values on sheets 1-3 and return them to the front sheet to repeat the process. 9. When the user has cycled through the process 10 times they will automatically be taken to sheet 4 where the cumulative totals are displayed. They can also access this at any earlier point by clicking â€Å"Display Cumulative Totals†. ... 6. The user must enter their intended stock purchases subject to data validation to avoid them trying to purchases items in quantities that are unavailable or that cost more than there is funds available for. Alternatively they can also click the button labeled "Optimize Purchases" to have the best possible combination of purchases displayed for them. 7. The user can then click the button "Run Simulation", this will take them to sheet 3, where the outputs for that day will be displayed. 8. Clicking "Next day" will then save all the inputs and outputs in sheets 5-7, reset all the values on sheets 1-3 and return them to the front sheet to repeat the process. 9. When the user has cycled through the process 10 times they will automatically be taken to sheet 4 where the cumulative totals are displayed. They can also access this at any earlier point by clicking "Display Cumulative Totals". 10. When on sheet 4 the user can click "Reset Model" which will delete all saved data and return them to the front sheet. 2.3. Assumptions - Drinks are sold by the cup only. No requests, doubles/shots etc. will be considered. - The price per cup cannot be set lower than 20p. - Price and temperature are constant over the day. - Demand is the number of people who will definitely purchase a cup. - The user cannot overdraw from their available funds. - There are no storage costs for stock that is carried over to the next day. - Only vodka and lemonade are mixed in jugs and then poured into cups with constant amounts of ice in them. 2.4. Strengths - Simple layout - The user works on the model in a structured manner starting from sheet1. Read and Batson (1999) state that "Using multiple sheets ' creates a model that is much easier to navigate."

Sustainability within National Parks Essay Example | Topics and Well Written Essays - 3500 words - 1

Sustainability within National Parks - Essay Example MICE is commonly organised through meetings, exhibitions, conferences, corporate travels and incentive travels among others as a mechanism to generate awareness among the global communities regarding a particular issue. The special events are organised to attract visitors from global contexts, assisting in generating revenue as well, with the intention to support any developmental need towards sustainable development. It is in this context that these special events are identified to be attached with various environmental issues such as polluting air, water and land immensely. Nevertheless, organising MICE has also been criticised on the ground that holding these special events causes excessive use of non-renewable energy, increased transportation and abundant use of other natural resources such as water among others. According to Zamzuri & et. al. (2011), special events have adversely affected the environment due to increased wastes, inappropriate way of waste management, increased t ransportation and unnecessary materials purchasing among others (Pizam, 2012; Zamzuri & et. al., 2011). However, with a much positive perspective, according to Pao (2004), special events, which include conference and corporate meeting among others are organised in various locations with the intention of generating revenue for economic development. These events are identified to develop the tourism sectors; but on the other hand, they are identified as important sources affecting the ecological environment of a country at large causing pollution, traffic congestion and waste among others, within a short span of time as compared to other sources of similar environmental degradation (Anand, 2013; Wood & Brotherton, 2008). These environmental issues, identified from events organised under MICE, are also classified as those factors accountable for increasing social costs and thereby, affecting the environmental equilibrium (Pao, 2004). Green Business Tourism The tourism industry has aime d at developing an effective and eco-friendly environment with the aim of attracting visitors and making a country an attractive location for organising special events (Lau, 2009). According to Lau (2009), there are three main players that are associated with MICE, which include clients, suppliers and other players like government and sponsors among others. The organisers of MICE thus need to held meetings and exhibitions and other intended functions in an appropriate manner with the aim of ensuring that events are executed with better considerations towards the environmental sustainability responsibilities and societal stability. The organiser should also develop and initiate policies as well as measures on the basis of which, meetings and exhibitions should be conducted. Moreover, the organisers should seek that the site where the MICE events are to be organised,