Hello
Please help me to set formula in excel sheet for production output
example :
Ration of Production Output
Item A 46 %
Item B 49%
Item C 4 %
Item D 1%
1000 kgs of raw materials produce final products as above ration, to produce 28000 kgs final products as per above ration, how much raw materails is required
Well, maybe
Item A 46 % x 1000 = 460 kg
Item B 49% x 1000 = 490 kg
Item C 4 % x 1000 = 40 kg
Item D 1% x 1000 = 10 kg
So, multiply each of those weights by 28 to get 28000 kg
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Similarly:
and filled down=B1*28000
Dave
Is this resolved now?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks