Hello All
Request help with formula on Cost Spread between specific dates of Months. The dates & actions are dynamic in nature but able to derive the overall action cost. not able to spread the cost in Months
My Cost Savings is available in
Your help will be highly appreciated to complete my annual project
Request help with formula on Cost Spread between specific dates of Months. The dates & actions are dynamic in nature but able to derive the overall action cost. not able to spread the cost in Months
My Cost Savings is available in
Column
AE2, this needs to be bifurcated Month on Month basis the Column T & Column S in conjunction with Column AG 2 - AO2 to populate the cost Savings under Column AG3 - AO3Your help will be highly appreciated to complete my annual project
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO |
E.ID | EM | ET | WA | EN | CA | LOB | Country | Anualized CTC $USD | Hourly Rate $ USD | W Hrs | L% | LCTC $ | Hourly Loaded Rate $ USD | Weekly Loaded CTC $USD | MLCTC | Action Type | Action Date | Start Date | End Date | Action Duration (WKs) | Interm Furlough Working Period ( Wks) | Action (Saved Weeks ) | % Week's Saved | APL% | Effective Loaded Rate by Action Type | Hour reduction per week (in %) | Saved Hrs | Base Salary/Wage/ Rate reduction (in %) | Weekly Salary Savings | Action Period Savings | Average Monthly Savings | 30-Apr-20 | 31-May-20 | 30-Jun-20 | 31-Jul-20 | 31-Aug-20 | 30-Sep-20 | 31-Oct-20 | 30-Nov-20 | 31-Dec-20 |
51620396 | ABC | P | Y | GF | PPE | NN | US | 41600 | 20 | 40 | 18.00% | 49088 | 24 | 944 | 4091 | Furlough - continuous | 20-Apr-20 | 27-Apr-20 | 4-Jul-20 | 14 | 0 | 14 | 100% | 18% | 24 | 0% | 0 | 0% | 944 | 12838 | 5664 | ? | ? | ? | ? | ? | ? | ? | ? | ? |