Question
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
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}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started