PLEASE SOLVE NUMBER 3 using excel n show formulas, please use the data below

3. The lab manager at Sulfur Springs lab complains that the corporate overhead allocation scheme is unfair, because Sulfur Springs is a much smaller facility focused on fewer testing services, and thus requires very little support from Martin House headquarters when compared to the Queens and Niagara labs. Corporate management has considered this observation and agrees: Sulfur Springs should be assigned only half the overhead burden that the two larger labs are assigned, which means it should receive 20% of the overall amount while the other two labs receive 40%. Will this change the multifactor productivity ranking among the three labs? If so, how? Martin House estimates the lab tech labor cost to be $25 per hour at the Sulfur Springs and Niagara labs, and $30 per hour at the Queens lab. In addition, Martin House has determined that $30,000 in monthly corporate overhead should be divided among the three laboratories