I need a formula that works in excel the formula needs to take to production amount for each sub component multiplied by the BOM Ratio and have it remove that amount from the oldest inventory first for finished goods that have multiple purchases.

ANGOLUSEN AHACo-Saed Fle nes Home Page Layout formulas Datar Review O te prsht o wart to do Vew Helor op t mel Normal Me&C $% 4 Conditional fomat nt Bad Good IU -4 Check Call Calaon fomuting Tabie- g thees G H ryLefPuchase n De ons Tetl Co Subcomponans Purchase BOM Bin Oanty Male nventory Dmband Per hed Cost ac a Price 452245000000 N 452459 N Purchase p Sheeto 31.923 21.34 s00 a0065 02300 de4 oeC For 2s 120 0,027 s00 04770 04750 42410500oo00 o heet Auto BottomCerton sipper for 424 31,923 4.0004 000164 z300 434065446 82410 34180N 2590 11450 04245 in Shot 1, 12 t247 sew for 34141 4045479016 N 630 4500S 9413 Sheet 6000 E 14 400 12als a5302777 N Purchane 2 e 22 21 4407oo0 Sheet ner for 0 nesni e Crt or dses ewwwna11322 1024m ty Se 44012 hurhae 20 L5CG8143LLR e $ 7 6 2 3 4 Y T Q W tab. K H J F G D A caps lock V X hift T N E Troopit, Inc., has current assets of $150 million; property, plant, and equipment of $390 million; and other assets totaling $130 million. Current liabilities are $120 million and long-term liabilities total $340 million. Read the requirements (Enter all amounts in millions of dollars.) Requirement 1. Use the data provided to write Troopit's accounting equation. = + +