Please help with H. Include formulas.

A B C E G K M N 0 P Q R 5 e. Variable FOH 7x $59,300 $63,000 $60,000 76 50,4001.25 48,0001.25 77 78. AH SR SHSR 79 80 81 B2 83 84 Actual 85 66 Fixed FOH n7 Bg $33,220 $43,200 $51,840 90 40,0001.20.90 48,0001.20.90 Actual Budgeted Overhead Applied nt 92 93 94 95 96. f. What should management be looking into for further investigation? 00 g. Do you think they should have waited until the end of the year to analyze the differences 01 02 between actual results and planned results? Why or why not? 03 04 05 h. Is FOH over or underapplied? And by how much? Draw a T-account and show FOH. 06 07 08 09 10 11 12 13 14 Budget/Spending Volume $700 F $9,980 Favorable Total Spending Efficiency Unfavorable 15. Does your answer match with the answers you calculated for Variable and Fixed FOH variances? 16 17 18 (FOH Amoun or Linfav? VFOH Spending \begin{tabular}{|l|l|} \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Inserted for reference: Various parts of the Master Budget \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|c|}{ Inserted for reference: Various parts of the Master Budget } \\ \hline \multicolumn{5}{|l|}{ Vaughan Company } \\ \hline Sales Budget & & & & Total \\ \hline 3rd Quarter & July & August & September & 3rd Quarter \\ \hline Sales in Units & 10,000 & 7,500 & 15,000 & 32,500 \\ \hline Selling Price per Unit & 50 & 50 & 50 & 50 \\ \hline Total Sales in \$ & 500,000 & 375,000 & 750,000 & 1,625,000 \\ \hline \multicolumn{5}{|l|}{ Vaughan Company } \\ \hline RM Budget & & & & Total \\ \hline 3rd Quarter & July & August & September & 3rd Quarter \\ \hline Required Production & 9,500 & 9,000 & 13,000 & 31,500 \\ \hline RM per Unit & 5 & 5 & 5 & 5 \\ \hline Production Needs & 47,500 & 45,000 & 65,000 & 157,500 \\ \hline Add: Desired End Inventory & 13,500 & 19,500 & 7,800 & 7,800 \\ \hline Total Needs & 61,000 & 64,500 & 72,800 & 165,300 \\ \hline Less: Beginning Inventory & (14,250) & (13,500) & (19,500) & (14,250) \\ \hline RM to be Purchased & 46,750 & 51,000 & 53,300 & 151,050 \\ \hline Cost of RM per pound & $0.70 & X$0.70 & X$0.70 & X$0.70 \\ \hline Cost of RM to be Purchased & 32,725 & 35,700 & 37,310 & 105,735 \\ \hline \multicolumn{5}{|l|}{ Vaughan Company } \\ \hline DL Budget & & & & Total \\ \hline 3rd Quarter & July & August & September & 3rd Quarter \\ \hline Budgeted Production in Units & 9,500 & 9,000 & 13,000 & 31,500 \\ \hline DLH per Unit & 1.2 & X 1.2 & 1.2 & X1.2 \\ \hline Total DLH needed & 11,400 & 10,800 & 15,600 & 37,800 \\ \hline Cost per DLH & 16 & X16 & 16 & 16 \\ \hline Total Direct Labor Cost & 182,400 & 172,800 & 249,600 & 604,800 \\ \hline Vaughan Company & & & & \\ \hline FOH Budget & & & & Total \\ \hline 3rd Quarter & July & August & September & 3rd Quarter \\ \hline Budgeted DLH & 11,400 & 10,800 & 15,600 & 37,800 \\ \hline Variable FOH rate & X$1.25 & X$1.25 & X$1.25 & X$1.25 \\ \hline Total Variable FOH & 14,250 & 13,500 & 19,500 & 47,250 \\ \hline Fixed FOH & 11,340 & 11,340 & 11,340 & 34,020 \\ \hline Total FOH & 25,590 & 24,840 & 30,840 & 81,270 \\ \hline Less: Depreciation & (4,000) & (4,000) & (4,000) & (12,000) \\ \hline Cash Needed for FOH & 21,590 & 20,840 & 26,840 & 69,270 \\ \hline & & & & \\ \hline Total FOH per Budget & & & & 81,270 \\ \hline Budgeted DLH this period & & & & 37,800 \\ \hline Predetermined FOH per DLH & & & & 2.15 \\ \hline Vaughan Company & & & & \\ \hline S\&A Budget & & & & Total \\ \hline 3rd Quarter & July & August & September & 3rd Quarter \\ \hline Budgeted Sales in units & 10,000 & 7,500 & 15,000 & 32,500 \\ \hline Variable S\&A Expenses & X$8.00 & X$8.00 & X$8.00 & X$8.00 \\ \hline Budgeted Variable S\&A Exp. & 80,000 & 60,000 & 120,000 & 260,000 \\ \hline Budgeted Fixed S\&A & 125,200 & 125,200 & 125,200 & 375,600 \\ \hline Total Selling \& Admin. & 205,200 & 185,200 & 245,200 & 635,600 \\ \hline Less: Depreciation & (3,000) & (3,000) & (3,000) & (9,000) \\ \hline Less: Bad Debt Expense & (50,000) & (37,500) & (75,000) & (162,500) \\ \hline Budgeted Cash S\&A Expenses & 152,200 & 144,700 & 167,200 & 464,100 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Budgeted Cash S\&A Expenses & 152,200 & 144,700 & 167,200 & 464,100 \\ \hline \multicolumn{5}{|l|}{ Vaughan Company } \\ \hline \multicolumn{5}{|l|}{ Cash Budget } \\ \hline 3rd Quarter & July & August & September & \\ \hline Beginning Cash Balance & 50,000 & 50,872 & 50,587 & \\ \hline \multicolumn{5}{|l|}{ Add: } \\ \hline Cash Receipts & 390,000 & 375,000 & 562,500 & \\ \hline Total Cash Available & 440,000 & 425,872 & 613,087 & \\ \hline \multicolumn{5}{|l|}{ Less: Disbursements } \\ \hline Direct Materials WHAM & 35,938 & 33,915 & 36,344 & \\ \hline Direct Labor & 182,400 & 172,800 & 249,600 & \\ \hline FOH & 21,590 & 20,840 & 26,840 & \\ \hline S\&A Expenses & 152,200 & 144,700 & 167,200 & \\ \hline Total Disbursements & 392,128 & 372,255 & 479,984 & \\ \hline Cash Balance (Deficit) & 47,872 & 53,617 & 133,103 & \\ \hline Borrowings & 3,000 & & & \\ \hline RePayments & & (3,000) & & \\ \hline Interest & & (30) & & \\ \hline Ending Cash Balance & 50,872 & 50,587 & 133,103 & \\ \hline \multicolumn{5}{|l|}{ Vaughan Company } \\ \hline Budgeted Income Statement & & & & Total \\ \hline 3rd Quarter & July & August & September & 3rd Quarter \\ \hline Sales & 500,000 & 375,000 & 750,000 & 1,625,000 \\ \hline Less: CGS & (252,800) & (189,600) & (379,200) & (821,600) \\ \hline Gross Margin & 247,200 & 185,400 & 370,800 & 803,400 \\ \hline Less: S\&A Expenses & (205,200) & (185,200) & (245,200) & (635,600) \\ \hline Net Operating Income & 42,000 & 200 & 125,600 & 167,800 \\ \hline Less: Interest Expense & - & (30) & - & (30) \\ \hline Net Income & 42,000 & 170 & 125,600 & 167,770 \\ \hline \end{tabular}