I attached my project, and my responses. I now need help identifying if this is the correct model to use for this problem.

1 answer below »
I attached my project, and my responses. I now need help identifying if this is the correct model to use for this problem.
Answered Same DayOct 09, 2021

Answer To: I attached my project, and my responses. I now need help identifying if this is the correct model to...

Himanshu answered on Oct 14 2021
144 Votes
Sheet1 (4)
     M/s STEELCO                                                                                                Computaion of Profit
     Weekly Production Planning                                                                                     (In MT)
    Weeks    Beginning Inventory            Production            Total Production    Demand            Total Demand     Ending Inventory            Total Inventory    Backorder            Prod-(E.I. - B.I.) + Backord
ers            Total Production (MT)        Week    Revenue($)            Steel cost($)    Inventory Carrying cost($)            Back Order cost($)            Profit Product wise            Total Profit($)
        Nail     Rebarb    I-Beam    Nail    Rebarb    I-Beam        Nail    Rebarb    I-Beam        Nail    Rebarb    I-Beam        Nail     Rebarb     I-Beam    Nail    Rebarb    I-Beam                Nail    Rebarb    I-Beam        Nail    Rebarb    I-Beam    Nail    Rebarb    I-Beam    Nail    Rebarb    I-Beam
    1    - 0    - 0    - 0    - 0    230    270    500    10    240    270    520    - 0    - 0    - 0    - 0    10    10    - 0    10    240    270    500        Price/ton    1000    750    1500    500    40    40    40    100    300    1000
    2    - 0    - 0    - 0    20    40    440    500    10    30    240    280    - 0    - 0    200    200    - 0    - 0    - 0    20    40    240    500        1    - 0    172500    405000    250000    - 0    - 0    - 0    1000    3000    - 0    (1,000)    54,500    270,000    323,500.00        647.00
    3    - 0    - 0    200    70    90    340    500    70    90    310    470    - 0    - 0    230    230    - 0    - 0    - 0    70    90    310    500        2    20000    30000    660000    250000    - 0    - 0    8,000    - 0    - 0    - 0    10,000    10,000    432,000    452,000.00        904.00
    4    - 0    - 0    230    140    80    280    500    140    80    160    380    - 0    - 0    350    350    - 0    - 0    - 0    140    80    160    500        3    70000    67500    510000    250000    - 0    - 0    9,200    - 0    - 0    - 0    35,000    22,500    330,800    388,300.00        776.60
    5    - 0    - 0    350    200    230    70    500    200    140    360    700    - 0    90    60    150    - 0    - 0    - 0    200    140    360    500        4    140000    60000    420000    250000    - 0    - 0    14,000    - 0    - 0    - 0    70,000    20,000    266,000    356,000.00        712.00
    6    - 0    90    60    190    - 0    310    500    200    90    370    660    - 0    - 0    0    0    10    - 0    - 0    200    90    370    500        5    200000    172500    105000    250000    - 0    3,600    2,400    - 0    - 0    - 0    100,000    53,900    67,600    221,500.00        443.00
    7    - 0    - 0    0    110    90    300    500    100    90    200    390    - 0    - 0    100    100    0    0    - 0    110    90    200    500        6    190000    0    465000    250000    - 0    - 0    - 0    1000    - 0    - 0    94,000    - 0    310,000    404,000.00        808.00
    8    - 0    - 0    100    170    100    230    500    170    100    310    580    - 0    - 0    20    20    0    0    - 0    170    100    310    500        7    110000    67500    450000    250000    - 0    - 0    4,000    0    0    - 0    55,000    22,500    296,000    373,500.00        747.00
        - 0    - 0    - 0    900    860    2240    4000    900    860    2220    3980    - 0    - 0    20    20    0    0    - 0                4000        8    170000    75000    345000    250000    - 0    - 0    800    0    0    - 0    85,000    25,000    229,200    339,200.00        678.40
                                                                                                        900,000    645,000    3,360,000    2,000,000    - 0    3,600    38,400    2,000    3,000    - 0    448,000    208,400    2,201,600    2,858,000.00
                                                                                                                                                497.78    242.33    982.86
                                                                                                                4,905,000                42,000            5,000                2,858,000.00
                                                                                                                5,282,500                91,600            185,000.00                3,005,900.00
                                                                                                                (377,500)                49,600            180,000                2500000
                                                                                                                                            (147,900)                147,900.00
                                                                                                                                                            14.32%
Sheet1 (3)
     M/s STEELCO                                                                                                Computaion of Profit
     Weekly Production Planning                                                                                     (In MT)
    Weeks    Beginning Inventory            Production            Total Production    Demand            Total...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here