100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
UNIT 42 - P1, D1 - Spreadsheet Modelling - Assignment 1 $6.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. PEARSON (PEARSON)
  4.  
  5. Information Technology 2010 QCF
  6.  
  7. Unit 42 - Spreadsheet Modelling

Essay

UNIT 42 - P1, D1 - Spreadsheet Modelling - Assignment 1

5 reviews
 5 purchases
  • Course
  • Unit 42 - Spreadsheet Modelling
  • Institution
  • PEARSON (PEARSON)
  • Book
  • Pearson BTEC Level 3 in Information Technology: Unit 1

BTEC LEVEL 3 UNIT 42 - Spreadsheet Modelling - Assignment 1 | P1 explain how spreadsheets can be used to solve complex problems | D1 discuss how organisations can use interpretation methods to analyse data | ALL CRITERIA WERE MET

Preview 2 out of 8  pages

Document information

  • April 3, 2020
  • 8
  • 2018/2019
  • Essay
  • Unknown
  • Unknown

Subjects

  • btec
  • level 3
  • unit 42
  • spreadhseet modelling
  • assignment 1
  • detailed
  • distinction
  • p1
  • d1

Connected book

book image

Book Title:

Author(s):

  • Edition:
  • ISBN:
  • Edition:

Written for

  • BTEC
  • PEARSON (PEARSON)
  • Information Technology 2010 QCF
  • Unit 42 - Spreadsheet Modelling
All documents for this subject (17)

5  reviews

review-writer-avatar

By: mahmodissam • 3 year ago

review-writer-avatar

By: lovepreetsingh1 • 3 year ago

review-writer-avatar

By: kenneildouglas • 3 year ago

review-writer-avatar

By: rutviksamant • 4 year ago

review-writer-avatar

By: arslanarshad865 • 4 year ago

Seller

avatar-seller
Boyan67

Reviews received

Content preview

Boyan Yonkov




Spreadsheet
Modeling –
Assignment 1
Contents
Task 1 - Report on what spreadsheets are used for and how they can solve complex problems........................1
Cash flow forecasting..................................................................................................................................... 2
Budget control............................................................................................................................................... 2
Sales forecasting............................................................................................................................................ 3
Manipulating Complex Data........................................................................................................................... 3
Payroll Projections.......................................................................................................................................... 4
Perform Calculations...................................................................................................................................... 4
Present information clearly and effectively.................................................................................................... 5
Support Decision making................................................................................................................................ 5
Goal Seeking................................................................................................................................................... 5
What If Scenarios........................................................................................................................................... 6
Task 2 – Extended Report................................................................................................................................... 6
Statistical Analysis.......................................................................................................................................... 6
Trend Analysis................................................................................................................................................ 7




Task 1 - Report on what spreadsheets are
used for and how they can solve complex
problems


1

, Boyan Yonkov


Spreadsheets are a powerful tool that can solve complex problems. Some of the features and tools that
spreadsheets offer are:

Cash flow forecasting
Cash flow forecasting is very important to businesses as they allow them to plan and show how much money
their business is expected to make and spend over a given period of time. Spreadsheets allow you to do this




efficiently and as accurate as possible by providing a couple of functions. One of these functions is the
FORECAST function the returns a prediction on a future value by using existing values that have been
provided, this is a built in Excel function. The other thing that spreadsheets provide you with is What if
analysis which allows you to try out with a number of different values or scenarios in order to calculate the
end result. This means you can try a number of different situations you think might happen and it will
calculate the results quickly and efficiently. If you were to try and do this using a paper system, it will take
you a very long time and you would have to do all calculations and writing out yourself over and over.

Budget control
Another tool that spreadsheets offer is budget control. This is a system that allows you to compare actual
income and spending to planned income and spending in order for you to see if the plans are being followed
and if something needs to change. This can also help businesses figure out whether or not the members of
staff are doing their jobs as they should be. The functions in excel that can help you with budget planning and
budget control are the SUM function – which is used very often to add up the total of a number of values
(e.g. sum of all incomes), Charts – that can help you visualise things and make the analysis easier for you,
difference calculations – you can use excel to calculate the differences in values to help you compare actual
expenses and income to planned expenses and income. This can be a very useful tool to the business as they
can do this on paper but if they just used spreadsheets it would make their job a lot easier and the
information can be presented better for easier analysis.




2

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Boyan67. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $6.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$6.49  5x  sold
  • (5)
Add to cart
Added