This week there is only one GHA exercise to complete. This is because this one exercise may take you a substantial amount of time. It is important that you start early in the week so that you can email me with any questions. While this exercise can take some time, if you complete it one step at a time you will get to the end! Start by reading the chapter carefully and then work your way through the course materials that I have provided to you in this week's Module. If you need help with how to allocate costs using excel, please click here , How do t use freht to incerate costa? Examplet Let' cary that you have $300,000 of food costs that need to be allocoted scross the five deportments of a hospital. The depertments Are: Pedistrict, Obstetrics, General Medicine and Orthopedica. The cout of food servicet is goind to tee allocated based on the number of natients. The number of petients are as followst Pediatrics - 5,000 patients Obstetrics - 15,000 patients General Medicine 30,000 patients Orthopedics 10,000 patients First, you need to set up a proper data table. Next you need to establish what percentage of the patients come from each department. e sure that the column totais to 100%. Then, use the percentages to allocate the costs. In this case we are allocating $300,000. B.te of 5300,000 is 25,000 25% of 300,000 is 75,000 50% of 300,000 is 150,000 17% of 300,000 is 50,000 Our total needs to come to $300,000 It is also possible to complete the table without as many columns using more complex formulas. Click on each cell to see the formulas that I use. This approach will be the most effective in completing your assignment for this week. Cost to allocate: 300,000