70.2K

Verified Solution

Link Copied!

The invoice is from a travel agency and the way it works is that they take care of booking airfare for participants of a certain project. When it is time for them to bill us how we pay is that we have to separate the costs per project to make sure that the right project is paying for their participants airfare. I am paying an invoice which totaled to $37,140.80, since it wasn't paid in the 30 day time span, it was considered late (with a late fee of $3211.22 and the new total is now $40,352.02. On the top it has each project code and under every expense. On the bottom of every project I totaled up the cost to make it easier. Since there was a late fee, which affects every project, I need to distribute the $3211.22 to each project accordingly, by the percentage of what was spent per project.. Since there are projects that spent more on airfare it would obviously have more allocated to it. Can someone help me find the percentage, what is being added, and the new total per account.

\begin{tabular}{|c|c|c|c|c|} \hline MW02P & Total & Percentage & Being Added & New Total \\ \hline \multicolumn{5}{|l|}{35} \\ \hline \multicolumn{5}{|l|}{1,112.78} \\ \hline \multicolumn{5}{|l|}{-990.89} \\ \hline \multicolumn{5}{|l|}{0} \\ \hline \multicolumn{5}{|l|}{35} \\ \hline \multicolumn{5}{|l|}{934.2} \\ \hline \multicolumn{5}{|l|}{1,029.20} \\ \hline \multicolumn{5}{|l|}{35} \\ \hline \multicolumn{5}{|l|}{0} \\ \hline \multicolumn{5}{|l|}{-990.89} \\ \hline \multicolumn{5}{|l|}{0} \\ \hline \multicolumn{5}{|l|}{-990.89} \\ \hline \multicolumn{5}{|l|}{-990.89} \\ \hline \multicolumn{5}{|l|}{0} \\ \hline \multicolumn{5}{|l|}{661.6} \\ \hline \multicolumn{5}{|l|}{661.6} \\ \hline \multicolumn{5}{|l|}{661.6} \\ \hline \multicolumn{5}{|l|}{661.6} \\ \hline \multicolumn{5}{|l|}{140} \\ \hline \multicolumn{5}{|l|}{0} \\ \hline \multicolumn{5}{|l|}{35} \\ \hline \multicolumn{5}{|l|}{35} \\ \hline 1,097.40 & 3171.42 & & & \\ \hline \end{tabular} MOR05 \begin{tabular}{|r|r|r|} \hline 35 \\ \hline 1,171.90 & \\ 0 & \\ \hline 0 & \\ \hline 926.91 & \\ \hline 35 & 2168.81 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline 199.2 & 2712.76 & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline MOR05 & \\ \hline 1,171.90 & & \\ \hline 0 & & \\ \hline 0 & & \\ \hline 926.91 & & \\ \hline 35 & 2168.81 & \\ \hline & & \\ \hline MOR04 & & \\ \hline 35 & & \\ \hline 1,003.59 & & \\ \hline 35 & & \\ \hline 227.97 & & \\ \hline 35 & & \\ \hline 1,142.00 & & \\ \hline 35 & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline 199.2 & 2712.76 & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline JM24NP & \\ \hline 559.6 & & \\ \hline 35 & & \\ \hline 35 & & \\ \hline 558.1 & & \\ \hline 35 & & \\ \hline 559.6 & & \\ \hline 558.1 & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline 35 & & \\ \hline 436.41 & & \\ \hline 35 & & & \\ \hline 476.4 & & & \\ \hline 35 & & \\ \hline 35 & 3819.61 & & \\ \hline 426.4 & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline 669.89 & & \\ \hline 198.98 & & \\ \hline 268.2 & & \\ \hline 35 & & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer