if possible please use an excel sheet or a similar format

Required information [The following information applies to the questions displayed below.] The following information is available for ADT Company, which produces special-order security products and uses a job order costing system. Overhead is applied using a predetermined overhead rate of 55% of direct labor cost. 1. In the Raw Materials Inventory T-account, insert amounts for beginning and ending balances along with purchases and indirect materials used. Solve for direct materials used in the period. 2. Compute the cost of direct labor used for the period. 3. In the Work in Process Inventory T-account, insert amounts for beginning and ending balances along with direct materials used (from part 1), direct labor used (from part 2), and applied overhead. Solve for cost of goods manufactured in the period. 4. In the Finished Goods Inventory T-account, insert amounts for beginning and ending balances along with cost of goods manufactured (from part 3). Solve for cost of goods sold in the period (do not consider any under- or overapplied overhead). 5. In the Factory Overhead T-account, insert amounts for indirect materials used, indirect labor used, other overhead costs, and applied overhead. Solve for underapplied or overapplied overhead. Complete this question by entering your answers in the tabs below. goods manufactured in the period. under-or overapplied overhead). Complete this question by entering your answers in the tabs below. Compute the cost of direct labor used for the period