Urban Gila Cosmetics preparing their budget for the next year. They are a manufacturer and they are requesting your help to finalize the preparation. Here is a sample of their expected numbers: a - They are expecting quarterly revenues presented in the sample below. 4th quarter 1st quarter revenues 2nd quarter revenues 3rd quarter revenues revenues 2 200 2 425 2 500 000,00 000,00 000,00 2 545 000,00 The direct materials expense is 3S per unit while a unit manufactured costs 7$ in direct labor. We applied a predetermined overhead rate to our actual production of units. That rate is 2$ per unit manufactured. 1st quarter 115 000,00 2nd quarter 3rd quarter 4th quarter 150 000,00 100 000,00 125 000.00 - The sales and research budget are the equivalent of 12% of the quarterly sales. - The administration cost is stable every quarter at 450 000 and the R&D budget is 100 000 per quarter. Urban Gila cosmetics wants you to offer certain precisions on several budgeting aspects. Their questioning is as follows: 1) What is a predetermined overhead rate? Explain why it is used. 2) Using excel, please present the budget for the four quarters, including the overhead allocation. 3) At the end of the year, it was noticed that the actual overhead rate was closer 2.25$. What do you suggest the company does to deal with this situation