Scribd Logo
Upload

Welcome to Scribd!

    • 276 views

    Business Simulation Excel Sheet - Alesa

    Uploaded by

    Gaurav Lahoti
    This document provides production details for two products - Alesa and Bordo. For Alesa, 114711.9 units need to be produced over 86033.9 hours using 162 machines working 10 hours per day over 60 days. For Bordo, 31985.78 units need to be produced over 10661.93 hours using the same 162 machines. After producing Alesa, 1166.1 hours of machine capacity remain available.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Business Simulation Excel Sheet - Alesa

    Uploaded by

    Gaurav Lahoti
    276 views10 pages
    This document provides production details for two products - Alesa and Bordo. For Alesa, 114711.9 units need to be produced over 86033.9 hours using 162 machines working 10 hours per day over 60 days. For Bordo, 31985.78 units need to be produced over 10661.93 hours using the same 162 machines. After producing Alesa, 1166.1 hours of machine capacity remain available.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides production details for two products - Alesa and Bordo. For Alesa, 114711.9 units need to be produced over 86033.9 hours using 162 machines working 10 hours per day over 60 days. For Bordo, 31985.78 units need to be produced over 10661.93 hours using the same 162 machines. After producing Alesa, 1166.1 hours of machine capacity remain available.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    276 views10 pages

    Business Simulation Excel Sheet - Alesa

    Uploaded by

    Gaurav Lahoti
    This document provides production details for two products - Alesa and Bordo. For Alesa, 114711.9 units need to be produced over 86033.9 hours using 162 machines working 10 hours per day over 60 days. For Bordo, 31985.78 units need to be produced over 10661.93 hours using the same 162 machines. After producing Alesa, 1166.1 hours of machine capacity remain available.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 10

    Particulars

    Production time per unit


    No. of units to be made

    45 min.
    114711.9

    Total Time Required


    Hour required

    5162034 Min.
    86033.9 Hrs.

    No. of Machines Availble


    No. of Working Hr per day
    No. of working days in a period
    Total Machine capacity Availbale

    Machine Capacity Left after Alesa made

    162 Mach.
    10 Hrs.
    60
    97200

    11166.1

    Particulars
    Demand in period 0
    a) State of economy
    Forecast no.1
    b)PLC
    Forecast no.2
    c) Change in Sale price
    Effect of S.P on demand
    Forecast no.3
    d) Change in Commumnication Policy
    Effect of change in C.P on demand
    Forecast no.4
    e) Product Policy
    Effect of change in Product Policy
    Forecast no.5
    f) TQM
    Effect of change in TQM
    Forecast no.6
    g) Image
    Forecast no.7
    less : Closing Stock
    Min Qty Required
    Total Transortable Qty
    Stock of aleas at central store
    Min Qty To be produced
    Planned production(Impt. Fromula*)(after Rejection)
    Planned production(Impt. Fromula*)(before Rejection)

    Germany
    36000
    96
    34560
    98
    33868.8
    0%
    -3%
    32852.736
    -5%
    -8%
    30224.5171
    0%
    0%
    30224.5171
    0%
    0%
    30224.5171
    100.00
    30224.5171
    1000
    29224.5171
    98521.7928
    62200
    36321.7928
    108976.276
    114711.87

    U.S.A
    23943
    98
    23464.14
    100
    23464.14
    -1%
    1%
    23698.78
    2%
    0%
    23698.78
    3%
    2%
    24172.76
    0%
    0%
    24172.76
    100.00
    24172.76
    557
    23615.76

    China
    18100
    104
    18824
    104
    19576.96
    -3%
    5%
    20555.81
    4%
    2%
    20966.92
    5%
    2%
    21386.26
    2%
    0%
    21386.26
    98.00
    20958.54
    400
    20558.54

    India
    20816
    106
    22064.96
    103
    22726.91
    -5%
    7%
    24317.79
    5%
    3%
    25047.33
    5%
    3%
    25798.75
    3%
    3%
    26572.71
    99.00
    26306.98
    1184
    25122.98

    Parameter
    (Units)

    Factors effecting demand


    1. state of economy (Index)
    2. PLC
    (Index)
    3. Sales
    Assumption
    4. commumnication policy
    Assumption
    5. Product Policy
    Assumption
    6. TQM
    Assumption
    7. image
    ( INDEX)

    Deliever= 60-40/40
    33.33%
    Rejection rate = 5%

    Particular
    No. of machiNES Available
    No. of workers per Machines
    No. of Workers present in co.
    Working hour per day
    No. of days in one period
    No. of Working hrs in 1 period
    Wages Per hour
    Amt. of wages per worker in 1 period
    Total wages per period

    169
    2
    338
    10
    60
    600
    16
    9600
    3244800

    Extra Hrs Req.


    12129
    No. of workers Required To complete Extra Hrs. 20.215
    Wages for xtra shift per worker per Hr
    17
    Total Extra Payment to be made

    212160

    Particulars
    Demand in period 0
    a) State of economy
    Forecast no.1
    b)PLC
    Forecast no.2
    c) Change in Sale price
    Effect of S.P on demand
    Forecast no.3
    d) Change in Commumnication Policy
    Effect of change in C.P on demand
    Forecast no.4
    e) Product Policy
    Effect of change in Product Policy
    Forecast no.5
    f) TQM
    Effect of change in TQM
    Forecast no.6
    g) Image
    Forecast no.7
    less : Closing Stock
    Min Qty Required
    Total Transortable Qty
    Stock of bordo at central store
    Min Qty To be produced
    Planned production(Impt. Fromula*)(after Rejection)
    Planned production(Impt. Fromula*)(before Rejection)

    Germany
    15000
    96
    14400
    98
    14112
    0%
    -3%
    13688.64
    -5%
    -8%
    12593.55
    0%
    0%
    12593.55
    0%
    0%
    12593.55
    100.00
    12593.55
    500
    12093.55
    37027.82
    26900
    10127.82
    30386.49
    31985.78

    U.S.A
    9906
    98
    9707.88
    100
    9707.88
    -1%
    2%
    9902.038
    2%
    2%
    10100.08
    3%
    2%
    10302.08
    1%
    1%
    10405.1
    100.00
    10405.1
    694
    9711.101

    China
    5039
    104
    5240.56
    104
    5450.182
    -3%
    5%
    5722.692
    4%
    5%
    6008.826
    5%
    2%
    6129.003
    2%
    3%
    6312.873
    98.00
    6186.615
    461
    5725.615

    India
    7316
    106
    7754.96
    105
    8142.708
    -5%
    7%
    8712.698
    5%
    7%
    9322.586
    5%
    3%
    9602.264
    3%
    5%
    10082.38
    99.00
    9981.553
    484
    9497.553

    Units

    units

    Particular
    No. of units needed(per unit bordo)
    No. of units to be produced
    Total Raw Material Req.
    Closing stock of raw material Available
    Deleveries expected
    Urgent order to be made

    Aurit

    Belkat
    Calot
    Dimut
    0
    2
    2
    31985.78
    0 63971.56 63971.56
    3000
    2500
    -41135.6 67788.13
    38135.61 -3816.57

    0
    0

    1000
    90000
    -27028.4

    63971.56

    62971.56

    Particular
    No. of units needed(per unit alesa)
    No. of units to be produced
    Total Raw Material Req.
    Closing stock of raw material Available
    Deleveries expected
    Urgent order to be made

    Aurit

    Belkat
    Calot
    3
    1
    114711.9
    344135.6 114711.9
    3000
    300000
    41135.61

    2500
    180000
    -67788.1

    Dimut
    0

    1000
    90000

    0
    0

    176184

    Units

    1584.66
    10735.95

    Particulars
    Production time per unit
    No. of units to be made

    20 min.
    31985.78

    Total Time Required


    Hour required

    639715.6
    10661.93 hrs

    No. of Machines Availble


    No. of Working Hr per day
    No. of working days in a period
    Total Machine capacity Availbale
    Total Machine capacity Availbale

    Machine Capacity Left after bordo made

    162 mach.
    10 hrs
    60
    97200
    11166.1

    504.1704

    162
    2
    60
    19440

    You might also like