Solution
Himanshu answered on
Oct 14 2021
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.) + Backorders Total Production (MT) Week Revenue($) Steel cost($) Inventory Ca
ying cost($) Back Order cost($) Profit Product wise Total Profit($)
Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
I-Beam Nail Reba
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...