please include the formulas used for each question as how you would input it for excel

2 A company that uses job order costing reports the costs incurred below. Overhead is applied at the rate of 65% of 3 direct materials cost. The company has no beginning Work in Process or Finished Goods inventories. Jobs 1 and 3 4 are not finished by the end of the month, and Job 2 is finished but not sold by month-end. 5 10 Required: 11 1. Prepare job cost sheets that have direct materials, direct labor, and overhead applied for each of the three jobs for the month. 12 13 14 \begin{tabular}{|l|l|} \hline 15 & \multicolumn{2}{|c|}{ JOB COST SHEET } \\ \hline 16 & \\ \hline 17 & Direct materials \\ \hline 18 & Direct labor \\ \hline 19 & Overhead \\ \hline 20 & Total \\ \hline 21 & \\ \hline 22 & 2. Determine the total dollar amount of Work in Process Inventory at the end of the month. \\ \hline 23 & \\ \hline 24 & Work in process inventory \\ \hline 25 & \\ \hline 26 & 3. Determine the total dollar amount of Finished Goods Inventory at the end of the month. \\ \hline 27 & \\ \hline 28 & Finished goods inventory \\ \hline 29 & \end{tabular}