Scribd Logo
Upload

Welcome to Scribd!

  • 107 views

    Group - 5 - Midwest Case Study

    Uploaded by

    Hardeep Singh
    The document provides case study data for a Midwest company including costs for shipping 75,000 cartons commercially and 5,000 through desktop delivery. It details expenses like payment to drivers and operators, order entry times and costs, and acquisition vs selling prices. Financial information is also presented, such as total sales, costs of goods purchased, expenses, margins, and net income.

    Copyright:

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

    Group - 5 - Midwest Case Study

    Uploaded by

    Hardeep Singh
    107 views3 pages
    The document provides case study data for a Midwest company including costs for shipping 75,000 cartons commercially and 5,000 through desktop delivery. It details expenses like payment to drivers and operators, order entry times and costs, and acquisition vs selling prices. Financial information is also presented, such as total sales, costs of goods purchased, expenses, margins, and net income.

    Original Title

    Group_5_Midwest case study

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides case study data for a Midwest company including costs for shipping 75,000 cartons commercially and 5,000 through desktop delivery. It details expenses like payment to drivers and operators, order entry times and costs, and acquisition vs selling prices. Financial information is also presented, such as total sales, costs of goods purchased, expenses, margins, and net income.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    107 views3 pages

    Group - 5 - Midwest Case Study

    Uploaded by

    Hardeep Singh
    The document provides case study data for a Midwest company including costs for shipping 75,000 cartons commercially and 5,000 through desktop delivery. It details expenses like payment to drivers and operators, order entry times and costs, and acquisition vs selling prices. Financial information is also presented, such as total sales, costs of goods purchased, expenses, margins, and net income.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 3

    MIDWEST CASE STUDY

    Data Sheet

    Cartons processed by commercial freight 75000


    Cartons processed under desktop delivery option 5000
    Total Cartons processed 80000

    Total payment given to drivers (for desktop delivery) 250000

    1 Driver working hours/year 1500

    No. of Operators for order entry 16


    Payment given to operators 840000
    1 operator working hours / year 1750
    1 operator productive working hours / year 1500
    Manual Order
    Time required to enter basic information 0.15
    Set up time 0.075
    Electronic Order
    Time to verify information 0.1

    A B
    Price 610 634
    Acuisition price 500 500
    Cost for shipping commercially 6 0
    Cost for desktop delivery 0 300
    Cost for manual enrty 0 7
    Cost of electronic order 3 0
    Warehouse expenses 43.2 43.2
    Profit 58 -216
    MIDWEST CASE STUDY

    Income statement data Workings

    Sale 42700000 Cost for shipping 1 carton by (commercial)


    Cost of item purchased 35000000 deliver truck exp + driver payment
    Gross Margin 7700000 Total number of hours of 4 drivers
    Personnel expense
    2570000 cost of shipping by deskktop delivery/hour
    (warehouse,truck drivers)

    Warehouse exp (excluding


    2000000 manual entry cost per hour
    personel)
    Freight 450000 Cost of manual entry per order
    Deliver truck exp 200000 Cost of electronic entry
    Order entry expense 840000 Personel exp exluding driver payment
    General and selling exp 1600000 Warehouse exp
    Intrest exp 120000 total exp of warehouse
    Net income 80000 warehouse exp / carton

    C D E
    6100 6340 6100
    5000 5000 5000
    60 0 60
    0 300 0
    0 68 68
    30 0 0
    594 432 432
    416 541 541
    6
    450000
    6000

    75

    30

    6.75
    3
    2320000
    2000000
    4320000
    54

    You might also like