Other
Logistiek concept Excel
- Course
- Institution
Logistiek concept Excel
[Show more]
Seller
Follow
bramdemeij008
Reviews received
Content preview
Deze Excel tabel heeft uitsluitendbetrekking op de situatie in het DC in
Athene
1. Verkocht aantal blikjes of flesjes in een week, uitgedrukt in % van de jaarafzet; totaal van het jaar is dus 100% 2. Gemiddelde omvang van de voorraad in een week,
Seizoenspatroon
uitgedrukt in aantal weken verwachte afzet (zie bij 1.) dat men in voorraad heeft
Kostprijs verkopen DC --> Week
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
Athene (in € per krat / Markt aandeel verkoop in nummers
tray) in liters stuks
1, Premium Pilsner bottle 33 cl 13 20% 3,030,303 1% 1% 1% 1% 1% 1% 1% 1% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 2% 2% 2% 2% 2% 2% 2% 3% 3% 3% 3% 3% 4% 4% 5% 5% 4% 2% 1.5% 1.5% 2% 2% 1.5% 1% 2% 1% 1% 1% 1% 1% 1% 1% 3% 3% Totaal
Aantal verkopen in stuks 30,303 30,303 30,303 30,303 30,303 30,303 30,303 30,303 45,455 45,455 ### 45,455 45,455 45,455 45,455 45,455 45,455 45,455 60,606 60,606 60,606 60,606 60,606 60,606 60,606 90,909 90,909 90,909 90,909 90,909 121,212 121,212 151,515 151,515 121,212 60,606 45,455 45,455 60,606 60,606 45,455 30,303 60,606 30,303 30,303 30,303 30,303 30,303 30,303 30,303 90,909 90,909 3,045,458
2. Omvang voorraad in DC Athene , 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 6 6 7 7 6 4 3 2 3 3 2 2 3 2 2 2 2 2 2 2 4 5 2
uitgedrukt in aantal weken verkopen die
men in voorraad heeft
Omvang van de gemiddelde voorraad 60606 60606 60606 60606 60606 60606 75758 136365 136365 136365 136365 136365 136365 136365 151516 166667 242424 242424 242424 242424 272727 303030 333333 454545 484848 515151 575757 636363 727272 651515 636364 545455 393940 212122 151516 106061 166667 136364 75758 90909 121212 60606 60606 60606 60606 60606 60606 121212 242424 212121
136365 60606 11409101
uitgedrukt in de verwachte afzet per
week.
15152 15152 15152 15152 15152 15152 15152 22728 22728 22728 22728 22728 22728 22728 22728 22728 22728 30303 30303 30303 30303 30303 30303 30303 45455 45455 45455 45455 45455 60606 60606 75758 75758 60606 30303 22728 22728 30303 30303 22728 15152 30303 15152 15152 15152 15152 15152 15152 15152 45455 45455 15152 1522729
Cyclusvoorraad
45455 45455 45455 45455 45455 45455 60607 113638 113638 113638 113638 113638 113638 113638 113638 128789 143940 212121 212121 212121 212121 242424 272727 303030 409091 439394 469697 530303 590909 666666 590909 560607 469698 333334 181819 128789 83334 136364 106061 53031 75758 90909 45455 45455 45455 45455 45455 45455 106061 196970 166667 45455 9886372
Veiligheidsvoorraad
1. Blikje Premium Pilsner 33 cl 7 25% 3,787,879 1% 1% 1% 1% 1% 1% 1% 1% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 2% 2% 2% 2% 2% 2% 2% 3% 3% 3% 3% 3% 4% 4% 5% 5% 4% 2% 1.5% 1.5% 2% 2% 1.5% 1% 2% 1% 1% 1% 1% 1% 1% 1% 3% 3%
Aantal verkopen in stuks 37,879 37,879 37,879 37,879 37,879 37,879 37,879 37,879 56,818 56,818 ### 56,818 56,818 56,818 56,818 56,818 56,818 56,818 75,758 75,758 75,758 75,758 75,758 75,758 75,758 113,636 113,636 113,636 113,636 113,636 151,515 151,515 189,394 189,394 151,515 75,758 56,818 56,818 75,758 75,758 56,818 37,789 75,758 37,789 37,789 37,789 37,789 37,789 37,789 37,789 113,636 113,636
2. Omvang voorraad in DC Athene ,
uitgedrukt in aantal weken verkopen die 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 6 6 7 7 6 4 3 2 3 3 2 2 3 2 2 2 2 2 2 2 4 5 2
men in voorraad heeft
Omvang van de gemiddelde voorraad
uitgedrukt in de verwachte afzet per 75758 75758 75758 75758 75758 75758 94697 170454 170454 170454 170454 170454 170454 170454 170454 189394 208334 303032 303032 303032 303032 340910 378788 416666 568180 606059 643938 719696 795454 909091 814394 795455 681819 492425 265152 189394 132576 208334 170365 94607 113547 151336 75578 75578 75578 75578 75578 75578 151425 303030 265152 75758 14259752
week.
Cyclusvoorraad
18940 18940 18940 18940 18940 18940 18940 28409 28409 28409 28409 28409 28409 28409 28409 28409 28409 37879 37879 37879 37879 37879 37879 37879 56818 56818 56818 56818 56818 75758 75758 94697 94697 75758 37879 28409 28409 37879 37879 28409 18895 37879 18895 18895 18895 18895 18895 18895 18895 56818 56818 18940 1903051
Veiligheidsvoorraad
56819 56819 56819 56819 56819 56819 75758 142045 142045 142045 142045 142045 142045 142045 142045 160985 179925 265153 265153 265153 265153 303031 340909 378787 511362 549241 587120 662878 738636 833334 738637 700758 587122 416668 227273 160985 104167 170455 132486 66198 94653 113457 56684 56684 56684 56684 56684 56684 132531 246212 208334 56819 12356702
1. Blikje Hick malt 33cl 10 25% 3,787,879 1% 1% 1% 1% 1% 1% 1% 1% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 2% 2% 2% 2% 2% 2% 2% 3% 3% 3% 3% 3% 4% 4% 5% 5% 4% 2% 1.5% 1.5% 2% 2% 1.5% 1% 2% 1% 1% 1% 1% 1% 1% 1% 3% 3%
Aantal verkopen in stuks 37,879 37,879 37,879 37,879 37,879 37,879 37,879 37,879 56,818 56,818 ### 56,818 56,818 56,818 56,818 56,818 56,818 56,818 75,758 75,758 75,758 75,758 75,758 75,758 75,758 113,636 113,636 113,636 113,636 113,636 151,515 151,515 189,394 189,394 151,515 75,758 56,818 56,818 75,758 75,758 56,818 37,789 75,758 37,789 37,789 37,789 37,789 37,789 37,789 37,789 113,636 113,636
2. Omvang voorraad in DC Athene ,
2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 6 6 6 6 5 4 3 3 3 3 2 2 2 2 2 2 2 2 2 2 2 2
uitgedrukt in aantal weken verkopen die
men in voorraad heeft
Omvang van de gemiddelde voorraad
75762 75758 75758 75758 75758 75758 94697 170454 170454 170454 170454 170454 170454 170454 170454 189394 208334 303032 303032 303032 303032 340910 378788 416666 568180 606059 643938 719696 795454 833333 814394 719697 606061 492425 340910 265152 208334 208334 170365 170365 113547 113547 75578 75578 75578 75578 75578 75578 151425 227272 151515 75758 14108330
uitgedrukt in de verwachte afzet per
week.
18940 18940 18940 18940 18940 18940 18940 28409 28409 28409 28409 28409 28409 28409 28409 28409 28409 37879 37879 37879 37879 37879 37879 37879 56818 56818 56818 56818 56818 75758 75758 94697 94697 75758 37879 28409 28409 37879 37879 28409 18895 37879 18895 18895 18895 18895 18895 18895 18895 56818 56818 18940 1903051
Cyclusvoorraad
56823 56819 56819 56819 56819 56819 75758 142045 142045 142045 142045 142045 142045 142045 142045 160985 179925 265153 265153 265153 265153 303031 340909 378787 511362 549241 587120 662878 738636 757576 738637 625000 511364 416668 303031 236743 179925 170455 132486 141956 94653 75668 56684 56684 56684 56684 56684 56684 132531 170454 94697 56819 12205280
Veiligheidsvoorraad
1. Flesje Hick 8.6 Red 33cl 22 10% 1,515,152 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1% 1.5% 1.5% 1.5% 1.5% 1.5% 2% 2% 2% 2% 2% 3% 3% 3% 3% 4% 4% 4% 4% 5% 5% 3% 4% 4% 3% 3% 2% 1% 1% 1% 1% 1% 0.5% 0.5% 0.5% 0.5% 0.5% 1% 3%
Aantal verkopen in stuks 15,152 15,152 15,152 15,152 15,152 15,152 15,152 15,152 15,152 15,152 ### 15,152 15,152 15,152 22,727 22,727 22,727 22,727 22,727 30,303 30,303 30,303 30,303 30,303 45,455 45,455 45,455 45,455 60,606 60,606 60,606 60,606 75,758 75,758 45,455 60,606 60,606 45,455 45,455 30,303 15,152 15,152 15,152 15,152 15,152 7576 7576 7576 7576 7576 15,152 45,455
2. Omvang voorraad in DC Athene ,
2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 6 6 6 5 5 5 5 5 4 3 3 2 2 2 2 2 2 2 2 2 2
uitgedrukt in aantal weken verkopen die
men in voorraad heeft
Omvang van de gemiddelde voorraad
30304 30304 30304 30304 30304 30304 30304 30304 30304 30304 30304 30304 60606 68181 68181 68181 75757 83333 90909 90909 136364 151516 166668 181820 196971 212122 227273 318182 333334 318183 318183 363638 333335 287880 242425 196971 151517 121214 90911 60608 45456 45456 30304 22728 15152 15152 15152 15152 22728 60607 60607 30304 5757618
uitgedrukt in de verwachte afzet per
week.
7576 7576 7576 7576 7576 7576 7576 7576 7576 7576 7576 7576 7576 11364 11364 11364 11364 11364 15152 15152 15152 15152 15152 22728 22728 22728 22728 30303 30303 30303 30303 37879 37879 22728 30303 30303 22728 22728 15152 7576 7576 7576 7576 7576 3788 3788 3788 3788 3788 7576 22728 7576 757583
Cyclusvoorraad
22728 22728 22728 22728 22728 22728 22728 22728 22728 22728 22728 22728 53030 56818 56818 56818 64394 71970 75758 75758 121213 136365 151517 159093 174244 189395 204546 287879 303031 287880 287880 325759 295456 265153 212122 166668 128790 98487 75760 53032 37880 37880 22728 15152 11364 11364 11364 11364 18940 53031 37880 22728 5000036
Veiligheidsvoorraad
1. Flesje Hick Claro 33 cl 12 10% 1,515,152 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 5% 5% 5% 5% 5% 6% 7% 7% 7% 7% 7% 7% 6% 6% 5% 5% 5% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Aantal verkopen in stuks 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75,758 75,758 75,758 75,758 75,758 90,909 106,061 106,061 106,061 106,061 106,061 106,061 90,909 90,909 75,758 75,758 75,758 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2. Omvang voorraad in DC Athene ,
0 0 0 0 0 0 0 1 1 1 1 2 2 2 2 3 3 3 4 4 5 6 6 6 6 6 6 6 6 6 5 5 5 5 5 4 2 2 1 1 2 1 1 1 1 1 1 1 1 1 1 1
uitgedrukt in aantal weken verkopen die
men in voorraad heeft
Omvang van de gemiddelde voorraad
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151516 227274 378790 500002 530305 560608 590911 621214 636366 621214 606062 575759 469698 439395 409092 318183 227274 151516 75758 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8090937
uitgedrukt in de verwachte afzet per
week.
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37879 37879 37879 37879 37879 45455 53031 53031 53031 53031 53031 53031 45455 45455 37879 37879 37879 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 757579
Cyclusvoorraad
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151516 227274 340911 462123 492426 522729 553032 575760 583336 568184 553032 522729 416668 386365 363638 272729 189395 113637 37879 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7333359
Veiligheidsvoorraad
1. Flesje Hick Original Brew 33cl 13 10% 1,515,152 1% 1% 1% 1% 1% 1% 1% 1% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 1.5% 2% 2% 2% 2% 2% 2% 2% 3% 3% 3% 3% 3% 4% 4% 5% 5% 4% 2% 1.5% 1.5% 2% 2% 1.5% 1% 2% 1% 1% 1% 1% 1% 1% 1% 3% 3%
Aantal verkopen in stuks 15,152 15,152 15,152 15,152 15,152 15,152 15,152 15,152 22,727 22,727 ### 22,727 22,727 22,727 22,727 22,727 22,727 22,727 30,303 30,303 30,303 30,303 30,303 30,303 30,303 45,455 45,455 45,455 45,455 45,455 60,606 60,606 75,758 75,758 60,606 30,303 22,727 22,727 30,303 30,303 22,727 15,152 30,303 15,152 15,152 15,152 15,152 15,152 15,152 15,152 45,455 45,455
2. Omvang voorraad in DC Athene,
uitgedrukt in aantal weken verkopen die 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 5 5 5 5 5 5 6 6 6 6 5 4 3 3 3 3 2 2 2 2 2 2 2 2 2 2 2 2
men in voorraad heeft
Omvang van de gemiddelde voorraad
uitgedrukt in de verwachte afzet per 30304 30304 30304 30304 30304 30304 37879 68181 68181 68181 68181 68181 68181 68181 68181 75757 83333 121212 121212 121212 121212 136364 151516 166668 227275 242426 257577 287880 318183 333334 325758 287879 242424 196969 136363 106060 83333 83333 68182 68182 45455 45455 30304 30304 30304 30304 30304 30304 60607 90910 60607 30304 5643957
week.
7576 7576 7576 7576 7576 7576 7576 11364 11364 11364 11364 11364 11364 11364 11364 11364 11364 15152 15152 15152 15152 15152 15152 15152 22728 22728 22728 22728 22728 30303 30303 37879 37879 30303 15152 11364 11364 15152 15152 11364 7576 15152 7576 7576 7576 7576 7576 7576 7576 22728 22728 7576 761368
Cyclusvoorraad
22728 22728 22728 22728 22728 22728 30303 56818 56818 56818 56818 56818 56818 56818 56818 64394 71970 106061 106061 106061 106061 121213 136365 151517 204548 219699 234850 265153 295456 303031 295455 250000 204545 166666 121212 94697 71970 68182 53031 56819 37879 30304 22728 22728 22728 22728 22728 22728 53031 68183 37880 22728 4882590
Veiligheidsvoorraad
Totaal aantal liter bier dat vanuit
Oosterhout naar DC Athene wordt
vervoerd 5,000,000
Totaal aantal flesjes en blikjes dat vanuit
Oosterhout naar DC Athene wordt 15,151,515
vervoerd
Levertijd (Oosterhout - DC Athene): 1 week
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 bramdemeij008. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.89. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67474 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now