StudentShare solutions

# Spread Sheet Modelling - Article Example

## Extract of sampleSpread Sheet Modelling

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." ...Show more

## Summary

In the paper “Spread Sheet Modelling” the writer gives recommendations
regarding writing and preparation of a Strategic Plan, demonstrating that careful consideration has been given to the business's development. However, the ultimate goal of the Strategic Plan is its own realization.
Save Your Time for More Important Things
Let us write or edit the article on your topic
with a personal 20% discount.
Grab the best paper

### Related Essays

Ecological Footprint Analysis
The most vivid attention of the contemporaries should be paid not only to the development and earning money, but also to the environmental impact, which occurs in the result of technological development. It seem like the modern people are performing Sisyphean labor: no matter how hard they work, a heavy stone of their ecological impact weighs over all their efforts.
3 pages (750 words) Article
Broome County CAFR
The paper tells that financial analysis is a systematic process for assessment of stability, viability and profitability of any business. The analysis is derived from the published financial statements of business organization. The most popular tool for financial analysis is derivation of financial ratios from balance sheet and income statements.
4 pages (1000 words) Article
(WHO web site. 2004). Cranial and facial nerves, the head muscles, and the surface blood vessels of the brain have pain-sensitive nerve fibers which, when stimulated by stress, muscular tension, dilated blood vessels and other 'triggers,' cause headaches.
4 pages (1000 words) Article
Asset Liability Management for Pension Fund
Asset Liability Management deals with the interaction of the sources and uses of funds that rum through banks financial statements. The growth of funded pensions and the increasing emphasis on risk management should strengthen the role of pension funds as stable, long-term institutional investors.
9 pages (2250 words) Article
Describe in detail 3 significant current applications of fluid mechanics (minimum of 100 words per application). This assignment must be typewritten - 12 point font. Please include a list of resources for the information presented
Techniques used for solving the various types of unsteady, 3D Navier-Stokes equations are created and applied to fluid flows. It is important to note that the work
1 pages (250 words) Article
Article
The researchers discovered that there is a connection between digital piracy and low self-control, rational choice theory and value. The results
1 pages (250 words) Article
Modeling cancer biology
For example, Dr. Natalia Komaroa models the inactivation of APC tumour suppressor gene, the initiating event in colon cancer, for estimating the
1 pages (250 words) Article
Literature Review Matrix
(2013). Cost effectiveness of patient education for the prevention of falls in hospital: economic evaluation from a randomized controlled trial. BMC Medicine, 11, 135. doi: 10.1186/1741-7015-11-135. American Nurse Today. (2011, March
1 pages (250 words) Article
Income Statement And Balance Sheet
Both the financial statement has various elements in common that are exhibited through different headings. The answer to the question that how well a company has performed during a particular accounting cycle is exhibited under the heading of an organization’s net income within the income statement and the heading of retained earnings within the balance sheet of the organization
1 pages (250 words) Article
Answering questions from the article Questions number 5 and 6 only
Notably, this ensured that each employee was awarded for his or her individual input. Furthermore, picking orders directly from the supervisor provided workers accountability. Once the workers had checked, packed, and loaded a shipment, they were
1 pages (250 words) Article
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger