Spread Sheet Modelling - Article Example

Only on StudentShare

Extract of sample
Spread 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”. ...
Download paper


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.

Related Essays

Apple's Balance Sheet
Assets From the provided financial information for Apple for the two six months operating periods taken in 2008 and 2009, it is clear that the company experienced an upward movement in different items regarding assets. Initial cash and its equivalents for the two specified periods represent a significant level of reduction from USD 11.875b in 2008 to USD 4.466b in 2009 (Apple, 2009). Whereas cash and similar cash items growth could not necessarily represent growth in view of liquidity practicality issues, it is appropriate to make the assumption that the materiality of the difference did not...
3 pages (753 words) Essay
Financial Modelling
Computer models are developed through different repetitive steps. Spreadsheet packages are used to implement these computer models.
4 pages (1004 words) Book Report/Review
Profit and loss account and balance sheet
This means that the financial status of the organization can be known by simply looking at these accounts.
9 pages (2259 words) Essay
Spreadsheet Models
The concept of an electronic spreadsheet was first outlined in the 1961 paper "Budgeting Models and System Simulation" by Richard Mattessich.
10 pages (2510 words) Essay
Structural equation modelling
Skill was not found to impact trust. In addition, trust has a significant positive impact on long-term orientation of the relationship among SMEs.
10 pages (2510 words) Research Proposal
Project Modelling and Decision Methods
The approach is primarily to evaluate property realistically of a specific location. In this exercise, we capture the trends in the past, make relevant assumptions of the future, address some challenges that can be foreseen and arrive at a conclusion. The simulation and the spread sheet model rationalize the decision and support the analysis to strengthen the reasoning behind potential investments and an assessment of the associated risks, if any.
6 pages (1506 words) Essay
Got a tricky question? Receive an answer from students like you! Try us!