Hello, I need help with Budget #6-7

fx=72000 Custom A Direct labor hours (DLHr) Predetermined overhead allocation rate per DLHr B .00.00 .00 Conditiona Formatting Thunder Creek Company uses the first-in, first-out (FIFO) inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. Begin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Labor, and 67 Manufacturing Overhead budgets.) 68 Use '=ROUND' function to round the fixed manufacturing overhead cost per unit to two decimal places. Prepare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget. In cell F78 use a cell reference. Do 69 not type in the amount or you will be marked wrong.) 70 71 Direct material cost per unit 72 Direct labor cost per unit 73 Manufacturing overhead cost per unit 74 Total projected manufacturing cost per unit 75 76 77 Budget \#6: Cost of Goods Sold Budget 78 Beginning Finished Goods Inventory, 3,600 units. 79 Units produced and sold in 2018 80 Cost per unit 81 Units per month 82 Total cost of units produced and sold in 2018 83 Total budgeted cost of goods sold \begin{tabular}{|c|} \hline Cost per unit \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} 84 85 Depreciation: $28,000 87 88 Budget \#7: Selling and Administrative Expense Budget 89 Salaries expense 90 Advertising expense 91 Depreciation expense 92 Supplies expense 93 Total budgeted S\&A expense \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{2018} \\ \hline Jan & Feb & Mar & Q1 Total \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \hline \end{tabular} 94 95 96 97 \begin{tabular}{|l|l|l|l|} \hline \multicolumn{5}{|c|}{2018} \\ \hline Jan & Feb & Mar & Q1 Total \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \hline \end{tabular} fx=72000 Custom A Direct labor hours (DLHr) Predetermined overhead allocation rate per DLHr B .00.00 .00 Conditiona Formatting Thunder Creek Company uses the first-in, first-out (FIFO) inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. Begin by calculating the projected cost to produce each unit in 2018 based on projected sales. (Hint: In "Cost per unit" table, cell references come from Direct Materials, Direct Labor, and 67 Manufacturing Overhead budgets.) 68 Use '=ROUND' function to round the fixed manufacturing overhead cost per unit to two decimal places. Prepare a Cost of Goods Sold Budget. (Hint: Units per month calculated using cell references to both sales budget and production budget. In cell F78 use a cell reference. Do 69 not type in the amount or you will be marked wrong.) 70 71 Direct material cost per unit 72 Direct labor cost per unit 73 Manufacturing overhead cost per unit 74 Total projected manufacturing cost per unit 75 76 77 Budget \#6: Cost of Goods Sold Budget 78 Beginning Finished Goods Inventory, 3,600 units. 79 Units produced and sold in 2018 80 Cost per unit 81 Units per month 82 Total cost of units produced and sold in 2018 83 Total budgeted cost of goods sold \begin{tabular}{|c|} \hline Cost per unit \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} 84 85 Depreciation: $28,000 87 88 Budget \#7: Selling and Administrative Expense Budget 89 Salaries expense 90 Advertising expense 91 Depreciation expense 92 Supplies expense 93 Total budgeted S\&A expense \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{2018} \\ \hline Jan & Feb & Mar & Q1 Total \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \hline \end{tabular} 94 95 96 97 \begin{tabular}{|l|l|l|l|} \hline \multicolumn{5}{|c|}{2018} \\ \hline Jan & Feb & Mar & Q1 Total \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \hline \end{tabular}