2.6 in a goolge sheet or excel doc if possible

I Job Variat Required: 1. Compute th 2. During the following 2. EXERCISE 2-6 Job-Order Costing for a Service Company L02-1, LO2-2, LO2-3 Tech Solutions is a consulting firm that uses a job-order costing system. Its direct materials consi labor includes salaries of consultants that work at the client's job site, and its overhead consists of of hardware and software that it purchases and installs on behalf of its clients. The firm's direa costs such as depreciation, utilities, and insurance related to the office headquarters as well as the office supplies that are consumed serving clients. Tech Solutions computes its predetermined overhead rate annually on the basis of direct labore hours. At the beginning of the year, it estimated that 80,000 direct labor-hours would be required for the period's estimated level of client service. The company also estimated $680,000 of five overhead cost for the coming period and variable overhead of $0.50 per direct labor-hour. The firm's actual overhead cost for the year was $692.000 and its actual total direct labor was 83,000 hours. Required: 1. Compute the predetermined overhead rate. 2. During the year, Tech Solutions started and completed the Xavier Company engagement. The following information was available with respect to this job: Dire Dire Mac Compute 3. Upon com financial I'd turn a Cor oft b fic Direct materials Direct labor cost Direct labor-hours worked $38,000 $21,000 280 EXERCISE 2 Sigma Cor was started $8.000 for cess at yel Compute the total job cost for the Xavier Company engagement. In der Poetinn. Working Rackwards LO2-1, LO2-2, LO2-3 ven