Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please make formula sheets for the attached files in excell format. begin{tabular}{rr} hline Sodal Socurty Raw:: & 6.20% Soclal Securty Limit: & 122.700
please make formula sheets for the attached files in excell format.
\begin{tabular}{rr} \hline Sodal Socurty Raw:: & 6.20% \\ Soclal Securty Limit: & 122.700 \\ Modicare Rate: & 1.45% \\ PUTA Rate: & 0.60% \\ PUTA Limit: & 7,000 \\ BUTA Rate: & 2.00% \\ SUTA Umit: & 22,000 \end{tabular} Annual Cash Flow from Operations FlGURE 9-6 General Overhead Budget \begin{tabular}{|cccccc} \hline Aug & Sept. & Oct. & Nov. & Dec. & \multicolumn{1}{c}{ Total } \\ \hline 391,000 & 342,000 & 460,000 & 492,000 & 516,000 & 6,840,000 \\ & & & & & \\ \hline & & & & & \\ \hline, 910 & 3,420 & 4,600 & 4,920 & 5,160 & 68,400 \\ & & & & 15,000 & 23,000 \\ 1,300 & 1,300 & 1,300 & 1,300 & 1,300 & 15,600 \\ & & & & & 18,000 \\ 26,017 & 26,017 & 26,017 & 26,017 & 26,017 & 312,201 \\ 2,250 & 2,250 & 2,250 & 2,250 & 2,250 & 27,000 \\ 781 & 781 & 781 & 781 & 781 & 9,366 \\ 2,043 & 2,011 & 1,990 & 1,990 & 1,990 & 26,293 \\ 2,525 & 2,280 & 2,870 & 3,030 & 3,150 & 41,042 \\ & & & & & 100 \\ 500 & 500 & 500 & 500 & 500 & 6,000 \\ 1,500 & 1,500 & 1,500 & 1,500 & 1,500 & 18,000 \\ 350 & 250 & 250 & 350 & 350 & 3,700 \\ 100 & 100 & 100 & 100 & 100 & 1,200 \\ 433 & 433 & 433 & 433 & 433 & 5,200 \\ 440 & 440 & 440 & 440 & 440 & 5,280 \\ & & & & 3,000 & 3,000 \\ & & & & & 1,500 \\ & & 1,000 & & & 6,000 \\ 867 & 867 & 867 & 867 & 867 & 10,400 \\ 50 & 50 & 50 & 50 & 50 & 600 \\ 100 & 100 & 100 & 100 & 100 & 1,700 \\ \hline 43,165 & 42,298 & 45,048 & 44,628 & 62,988 & 603,082 \\ \hline & & & & & \\ \hline \end{tabular} \begin{tabular}{rr} \hline Sodal Socurty Raw:: & 6.20% \\ Soclal Securty Limit: & 122.700 \\ Modicare Rate: & 1.45% \\ PUTA Rate: & 0.60% \\ PUTA Limit: & 7,000 \\ BUTA Rate: & 2.00% \\ SUTA Umit: & 22,000 \end{tabular} Annual Cash Flow from Operations FlGURE 9-6 General Overhead Budget \begin{tabular}{|cccccc} \hline Aug & Sept. & Oct. & Nov. & Dec. & \multicolumn{1}{c}{ Total } \\ \hline 391,000 & 342,000 & 460,000 & 492,000 & 516,000 & 6,840,000 \\ & & & & & \\ \hline & & & & & \\ \hline, 910 & 3,420 & 4,600 & 4,920 & 5,160 & 68,400 \\ & & & & 15,000 & 23,000 \\ 1,300 & 1,300 & 1,300 & 1,300 & 1,300 & 15,600 \\ & & & & & 18,000 \\ 26,017 & 26,017 & 26,017 & 26,017 & 26,017 & 312,201 \\ 2,250 & 2,250 & 2,250 & 2,250 & 2,250 & 27,000 \\ 781 & 781 & 781 & 781 & 781 & 9,366 \\ 2,043 & 2,011 & 1,990 & 1,990 & 1,990 & 26,293 \\ 2,525 & 2,280 & 2,870 & 3,030 & 3,150 & 41,042 \\ & & & & & 100 \\ 500 & 500 & 500 & 500 & 500 & 6,000 \\ 1,500 & 1,500 & 1,500 & 1,500 & 1,500 & 18,000 \\ 350 & 250 & 250 & 350 & 350 & 3,700 \\ 100 & 100 & 100 & 100 & 100 & 1,200 \\ 433 & 433 & 433 & 433 & 433 & 5,200 \\ 440 & 440 & 440 & 440 & 440 & 5,280 \\ & & & & 3,000 & 3,000 \\ & & & & & 1,500 \\ & & 1,000 & & & 6,000 \\ 867 & 867 & 867 & 867 & 867 & 10,400 \\ 50 & 50 & 50 & 50 & 50 & 600 \\ 100 & 100 & 100 & 100 & 100 & 1,700 \\ \hline 43,165 & 42,298 & 45,048 & 44,628 & 62,988 & 603,082 \\ \hline & & & & & \\ \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