100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4.2 TrustPilot
logo-home
Class notes

Business Fundamentals Cases - Uitgewerkt excel bestand "T-case"

Rating
-
Sold
2
Pages
39
Uploaded on
13-04-2023
Written in
2022/2023

Tijdens de opleiding werden de verschillende soorten budgetten uitgelegd aan de hand van een case. In mijn geval was dit de "T-case". Dit excel bestand is dan ook de oplossing van de volledige case.

Institution
Course











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

Written for

Institution
Study
Course

Document information

Uploaded on
April 13, 2023
Number of pages
39
Written in
2022/2023
Type
Class notes
Professor(s)
Christine onkelinx
Contains
All classes

Subjects

Content preview

Key Partners Key activities Value proposition



Bedrukken t-shirts - verkopen via
website



leveranciers t-shirts, leveranciers inkt key resources
en papier, banken (lening), parcel (bv Fysisch: t-shirts, inkt, papier, printer, uniek bedrukte kledij
Bpost), websiteontwikkelaar drukmachine,
computerbenodigdheden,
ontwerpprogramma, … Intellectueel:
know-how Menselijk: personeel
Financieel: startkapitaal




cost structure
computer, drukmachine, website, aankoop t-shirts, printer, sociale media, ontwerpprogramma,
printer, papier en inkt, brutoloon personeel, electriciteitskost, verzekeringen, administratie

,Customer relationships customer segments



sociale media, website



channels
iedereen die unieke bedrukte
kledij wil dragen



website, sociale media




revenu streams
verkoop bedrukte t-shirts

,Aflossingstabel Lening
Kapitaal € 6,000.00
i 2%
duurtijd 5

Termijn Intrest Kapitaalafloss Resterende schul
0 € 6,000.00
1 € 1,272.95 € 120.00 € 1,152.95 € 4,847.05
2 € 1,272.95 € 96.94 € 1,176.01 € 3,671.04
3 € 1,272.95 € 73.42 € 1,199.53 € 2,471.51
4 € 1,272.95 € 49.43 € 1,223.52 € 1,247.99
5 € 1,272.95 € 24.96 € 1,247.99 € -




Notities:
* Termijn =PMT(interest%; duurtijd; kapitaal)
* Intrest =IPMT(interest%; jaar waarin je je bevindt; duurtijd; kapitaal)
* Kapitaalaflossing: =PPMT(intrest%; jaar waarin je je bevindt; duurtijd; kapitaal)
* Resterende schuld berekenen = vorige resterende schuld + CUMPRINC
(rate; nper; pv; start_period; end_period; type)
rate = intrest
nper = looptijd
pv = kapitaal
type = 1 bij begin van maand, 0 bij einde van maand

, Jaar 1
Jan Feb Mrt Apr Mei Jun
Aantal:
T-shirt A4 60 60 60 60 60 60
A5 60 60 60 60 60 60
A6 60 60 60 60 60 60
Prijs:
T-shirt A4 € 30 € 30 € 30 € 30 € 30 € 30
A5 € 25 € 25 € 25 € 25 € 25 € 25
A6 € 20 € 20 € 20 € 20 € 20 € 20
Omzet:
T-shirt A4 € 1,800 € 1,800 € 1,800 € 1,800 € 1,800 € 1,800
A5 € 1,500 € 1,500 € 1,500 € 1,500 € 1,500 € 1,500
A6 € 1,200 € 1,200 € 1,200 € 1,200 € 1,200 € 1,200
Totaal per maand: € 4,500 € 4,500 € 4,500 € 4,500 € 4,500 € 4,500
Totaal per jaar: € 54,000




Notities
* A4-formaat = € 30; A5 – formaat = € 25; A6-formaat = € 20
* eerste jaar elke maand 180 bedrukte T-shirts
* elke type evenveel
* afzet groeit jaarlijks met 50% tov het vorige jaar
$3.62
Get access to the full document:

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached


Also available in package deal

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.
femsv Universiteit Antwerpen
Follow You need to be logged in order to follow users or courses
Sold
298
Member since
5 year
Number of followers
128
Documents
66
Last sold
6 hours ago

Samenvattingen van de vakken uit mijn bachelor in Thomas More Mechelen in de richting bedrijfsmanagement (business&management). En van de vakken uit mijn schakeljaar & master aan de UA in de richting Organisatie&Management.

4.6

54 reviews

5
36
4
15
3
2
2
0
1
1

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

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

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card 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