Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed \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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Design Of Cost Management Systems The Text Cases And Readings

Authors: Robin Cooper

1st Edition

0132041243, 978-0132041249

More Books

Students also viewed these Accounting questions

Question

=+6. What need does it fulfill?

Answered: 1 week ago

Question

=+8. How can you differentiate your product in their eyes?

Answered: 1 week ago