Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    LAL03 Task

    Uploaded by

    ScribdTranslations
    The document calculates costs for a warehouse including building rental, electricity, racking, insurance, taxes, forklift and pallet truck maintenance, order picking, packaging and transportation. It determines the cost per pallet stored, cost per pallet handled, cost per order line, and total annual costs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    LAL03 Task

    Uploaded by

    ScribdTranslations
    30 views3 pages
    The document calculates costs for a warehouse including building rental, electricity, racking, insurance, taxes, forklift and pallet truck maintenance, order picking, packaging and transportation. It determines the cost per pallet stored, cost per pallet handled, cost per order line, and total annual costs.

    Original Description:

    LAL TASK 03 TRANSPORTATION AND LOGISTICS

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document calculates costs for a warehouse including building rental, electricity, racking, insurance, taxes, forklift and pallet truck maintenance, order picking, packaging and transportation. It determines the cost per pallet stored, cost per pallet handled, cost per order line, and total annual costs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    30 views3 pages

    LAL03 Task

    Uploaded by

    ScribdTranslations
    The document calculates costs for a warehouse including building rental, electricity, racking, insurance, taxes, forklift and pallet truck maintenance, order picking, packaging and transportation. It determines the cost per pallet stored, cost per pallet handled, cost per order line, and total annual costs.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    1. Determine warehouse costs.

    2. Determine the warehouse cost per pallet.

    Building area: 2,000 m2.

    Building rent: 8 €/ m2 per month.

    Annual electricity consumption: 1,200,000 KWh At 0.09 €/Kwh

    Conventional pallet racking, with a capacity for 2,200 pallets and a useful life of 20
    years. Acquired 6 years ago for 80.000 €.

    Insurance: €3,000 per year.

    Taxes: 1,000 € per year.

    252,000 pallets are stored and moved annually.

     Annual rental price: 8 x 2,000 x 12 = 192,000 €.


     Annual electricity: 1,200,000 x 0.09 = 108,000 €.
     Annual racking: 80,000: 20 = €4,000.
     Insurance and taxes = 4,000 €.

    Total annual cost = 192,000 + 108,000 + 4,000 + 4,000 = 308,000.

     Cost per square meter: 308,000: 2,000 = 154€ m2 per year


     Cost per square meter per month: 154: 12 = 12.83€ m2 per month

    Cost per pallet: 308,000: 252,000 = €1.22 per pallet.

    3. Calculate the cost of maintenance.

    4. Indicates the handling cost per pallet.

    The work is performed with 2 electric forklifts and 3 pallet trucks. We have the following
    information on the costs of each:
    CONCEPTS ELECTRIC FORKLIFT TRANSPALET
    Price 20.000 € 6.000 €
    Residual value 15 % 15 %
    Useful life (years) 12,00 8,00
    Energy (€ / hour) 0,8 0,7
    Maintenance (percentage of purchase
    2% 2%
    price)
    Wages and salaries 18.000 € 18.000 €
    Hours per year 1.200 1.200
    Productivity (pallets per hour) 105 70

     Annual depreciation of electric forklift: (20,000 - 3,000) : 12 = 1,416.66 €/year


     Annual electricity consumption: 1,200 x 0.8 = 960€.
     Annual maintenance: 20,000 x 0.05 = 400€.
     Wages and salaries = 18,000 €.

    TOTAL MAINTENANCE COSTS FOR ELECTRIC FORKLIFT = 20,776.66 €.

     Handling costs per pallet:

    1,200 x 105 = 126,000 pallets per year / 20,776.66 = 0.165€ handling per pallet.

     Annual depreciation of pallet truck: (6,000 - 900): 8 = €637.50 per year.


     Annual electricity consumption: 1,200 x 0.7 = €840.
     Annual maintenance: 6,000 x 0.05 = €120.
     Wages and salaries = 18,000 €.

    TOTAL MAINTENANCE COSTS FOR PALLET TRUCK = 19.597,50€.

     Handling costs per pallet:

    1,200 x 70 = 84,000 pallets per year / 19,597.50€ = 0.233€ handling per pallet.

    5. Indicates the cost of picking.


    6. Calculates the number of order lines per hour.

    Machinery rental = 20,000 € per year.


    Annual depreciation of machinery in property= 12,000 € per year.
    Consumption = 20.000 €
    Personnel = 130.000 €
    Annual maintenance = 12.500 €
    They work 20 days a month, in 2 shifts of 8 hours.
    In the year, they have issued 45,000 orders, representing 280,320 order lines.

     Total costs = 20,000 + 12,000 + 20,000 + 130,000 + 12,500 = 194,500 euros


     Cost per order line : 194,500 : 280,320 = 0.69
     Productivity: 16 hours x 20 days per month x 12 months = 3,840 hours

    Hourly order lines: 280,320 : 3,840 = 73 lines per hour

    7. Calculate packaging costs (pallets plus boxes).


    Pales. In property. Pales are purchased at 8,50 €, valid for 6 uses. Retrieval of 350
    pales from customers' warehouses costs 400 €.

    Cardboard boxes. Each order line is stored in cartons with an average price of 0.20 €
    per carton.

     Unit price: 8,50€ Uses: 6 Cost per use: 8,5 / 6 = 1,416€.


     Transportation cost: 400€ Units transported: 350 pallets Returns: 5
     Transportation cost: 400/350 = 1,14€ x 5 returns = 5,71€ / 6 uses = 0,95€.
     Cost per use: 1.416 + 0.95= 2.36€.
     Packaging cost: 45,000 orders x 2.36 = 106,200€.
     Cost of cases: 280,320 order lines x 0.20€ = 56,064€.

     TOTAL PACKAGING: 106,200 + 56,064 = 162,264 €.

     Transportation costs. Total costs of €180,000

     Administrative costs. Total costs of €22,000

    8. Determine the total costs for all items.

    Comments:

    Of the activities performed you have only failed in the item of Packaging costs
    that should amount to 653,064.00€. Thus the total costs would be a total of
    €1,457,909.83.

    You might also like