100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Previously searched by you
Previously searched by you
logo
  • PEARSON (PEARSON)
  • Information Technology 2016/2017 NQF
  • Unit 5 - Data Modelling
To add items to your wishlist, you must be logged in
Other

Improved Spreadsheet

Rating
5,0
(1)
Sold
5
Pages
6
Uploaded on
03-11-2021
Written in
2019/2020

An improved Version of the Cheese Spreadsheet.

Institution
PEARSON (PEARSON)
Course
Unit 5 - Data Modelling









Whoops! We can’t load your doc right now. Try again or contact support.
Report Copyright Violation

Written for

Study Level
BTEC
Publisher
PEARSON (PEARSON)
Subject
Information Technology 2016/2017 NQF
Course
Unit 5 - Data Modelling
All documents for this subject (96)

Document information

Uploaded on
November 3, 2021
Number of pages
6
Written in
2019/2020
Type
Other
Person
Unknown

Subjects

  • spread
  • sheet
  • data
  • predict
  • document

Content preview

Cheese
Camembert
Emmental
Gruyere
Edam
Gouda


Overall Profit/Loss on Cheeses (€)
14000


12000


10000
Profit/Loss (€)




8000


6000


4000


2000


0
Camembert Emmental Gruyere Edam Gouda

Cheese Name



Average monthly sales
900
850
875
825
700

, Overall Profit/Loss (€) Profit/Loss per Sale(€) Profit/Loss per Sale(£)
10080 11 16
10880 13 18
12250 14 20
9570 12 17
8680 12 18


Profit/Loss per sale on Cheeses (€)
16

14

12

10
Profit/Loss (€)




8

6

4

2


0
dam Gouda Camembert Emmental Gruyere Edam Go

Cheese Name



Sale Price per Kilo (£) Cost per Kilo (£) Cost per Kilo (€)
56 40 28
64 46 32
70 50 35
58 41 29
62 44 31

More courses for PEARSON (PEARSON) > Information Technology 2016/2017 NQF

  • Unit 3 - using social media in business
  • Unit 9 - it project management
  • Unit 4 - programming
  • Unit 6 - website development
  • Unit 12 - it technical support and management
  • Unit 17 - digital 2d and 3d graphics
  • Unit 20 - enterprise in it
  • Unit 8 - computer games development
  • Unit 11 - cyber security and incident management
  • Unit 14 - it service delivery
R262,90
Get access to the full document:
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
Get to know the seller
Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Scrumlin
2,5
(22)

Reviews from verified buyers

Showing all reviews
1 year ago

5,0

1 reviews

5
1
4
0
3
0
2
0
1
0
Trustworthy reviews on Stuvia

All reviews are made by real Stuvia users after verified purchases.

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Scrumlin NPTC Group
View profile
Follow You need to be logged in order to follow users or courses
Sold
324
Member since
4 year
Number of followers
172
Documents
182
Last sold
1 week ago
Scrumlins School Supplies

Visit our Other Stores on TES and Payhip for more documents! Are you learning about BTEC Information Technology and need the "right" tools? Look no further! Scrumlin's is the place to shop for past exams, study notes and real essays! We have a large inventory of items that were actually used during college classes. If you are looking for an example of how to structure an essay, Scrumlin's has it! Come and shop today!

2,5

22 reviews

5
3
4
2
3
6
2
4
1
7

Recently viewed by you

Thumbnail
Exam (elaborations)
ECS 1601 Assignment 02 semester 01 year 2022
-
2022
$ 6.01 More info
Thumbnail
Exam (elaborations)
RCFE Test Questions and Answers 100% correct 2023
-
2023
$ 17.39 More info
Thumbnail
Exam (elaborations)
Foundations of Reading Test Wisconsin Questions and Answers 100% Solved
-
2024
$ 11.99 More info
Thumbnail
Class notes
All lecture notes Organization and Power
3,0
(2)
10 2023
R 284,73 More info
Thumbnail
Other
Joint structure & function
-
2021
$ 30.28 More info
Thumbnail
Exam (elaborations)
LGL3702 Assignment 1 (ANSWERS) Semester 1 2024 - DISTINCTION GUARANTEED
-
1 2024
$ 3.03 More info
Thumbnail
Exam (elaborations)
FLT3701 ASSIGNMENT 02 2023- COMPLETE ANSWERS
-
2023
$ 3.64 More info
Thumbnail
Summary
Final Summary of Book: Exploring Strategy
-
1 2024
$ 8.59 More info
Thumbnail
Exam (elaborations)
AWS CPC EXAM PREP TEST QUESTIONS WITH ACCURATE SOLUTIONS
-
2025
$ 17.99 More info

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their exams and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card or EFT and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions