Need help to calculate proposal

[asifprpt]

Hi All

I have a proposal sheet in excel.

can anyone help me to get the total salary for 24 months = 49,000,000 (without any decimals) by adjusting the unit price (monthly salary)?

S/N	Designation	Qty	Salary/Month	Total salary	24 Months
1	Project Manager (Engineer)	1​	50,000.00	50,000.00	1,200,000.00
2	Personnel Affairs Supervisor	1​	29,000.00	29,000.00	696,000.00
3	Workshop Supervisor	4​	24,500.00	98,000.00	2,352,000.00
4	Quality Controller	4​	23,000.00	92,000.00	2,208,000.00
5	Senior Accountant	1​	27,000.00	27,000.00	648,000.00
6	Technical Clerk	28​	18,000.00	504,000.00	12,096,000.00
7	Auto-mechanical Technician	50​	14,835.00	741,750.00	17,802,000.00
8	Armored and Tracked vehicles Repair Technician	6​	22,985.00	137,910.00	3,309,840.00
9	Auto-electrical Technician	22​	15,500.00	341,000.00	8,184,000.00
10	Washing Bay Operator	3​	11,000.00	33,000.00	792,000.00
Total		120​		2,053,660.00	49,287,840.00

thanks in advance

 

[lev888]

Add 2 columns to the left of Salary/Month: Original salary and Adjustment. Salary = Original - Adjustment. Play with adjustment values until you get 49,000,000.00.

 

[asifprpt]

Add 2 columns to the left of Salary/Month: Original salary and Adjustment. Salary = Original - Adjustment. Play with adjustment values until you get 49,000,000.00.

hi
thanks for your reply

tried a lot but not getting exact 49,000,000.

 

[lev888]

Try to get as close as you can with the same adjustment (absolute or percentage), e.g. $10 for every salary. Let's say this results in $49,000,247. Then just subtract $247 from Project Manager.