Is Window Help B IU SIX X2 | AIA . BIE . BEBE BIG . WISE 3 1 4 1 5 1 6 1 7 18 1 9 1 10 1 11 1 12 1 13 1 14 1 15 1 13 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: They are expecting quarterly revenues presented in the sample below. 1st quarter revenues 2nd quarter revenues 3rd quarter revenues 4th quarter revenues 2 200 000,00 2 425 000,00 2 500 000,00 2 545 000,00 The direct materials expense is 3$ 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 2nd quarter 3rd quarter 4th quarter 115 000,00 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. ers Default Style French (Canada) ASUS VivoBoo