Please use the following information to answer the template provided.

Template:

Builders-R-Us continued work on job M-17 this month, until it was finished and sold near the end of the month. The following information pertains to job M-17: Work done in previous periods included $22,000 of raw materials and $64,000 of conversion cost. This month, the company purchased $14,000 of raw materials which gave them a total of $97,000 available for use. Actual material usage for the month was $77,000. The company's average wage rate for assembly workers is $23 per hour. This month, there were a total of 1,200 man-hours incurred for this type of work. Overhead is applied to production based on man hours. The budget for the month called for $140,000 of overhead and 1,400 man-hours. Actual overhead costs were tabulated at the end of the month and totaled $110,000. Use the preceding information to complete the CH 19 tab in the excel book provided. Calculate the pre- determined overhead rate (POHR) and put your answer in the appropriate cell (be sure to include units). Each T-account should be completed by inputting a beginning balance (sometimes this may be zero), adds, subtracts, and an ending balance. After recording all entries pertaining to the information above, review the account for overhead to determine if it is over or under-applied (fill in the cell provided with the word and the dollar amount). Then, make the appropriate adjustment to address this issue. C. t2 T-Accounts for job M-17 Raw Materials WIP Finished Goods 12 13 14 123 16 17 18 19 20 21 Manufacturing Overhead COGS Prior to adjustment overhead is: The POHR is: 24 25 26 28 29