1.36 Overhead application using predetermined overhead rate; practical capacity versus normal volume: manufacturer LO 7.8 usage is 120 o00 hours in an average year. During November the following jobs were completed: (a) job number 77: small koalas (b) job number 78: large kangaroos. Required 1. Construct an Excel spreadsheet to: (a) Calculate the predetermined overhead rate for the current year, using as denominator volumes: (i) practical capacity (ii) normal volume. (b) Calculate the total cost of job number 77, using both overhead rates calculated in part (a). (c) Calculate the amount of manufacturing overhead applied to job number 78 during November, using both overhead rates