Using the reciprocal method in Excel, allocate the support costs to the operating segments, showing the total support costs that that each operating segment will be accountable for as your final result. (Round answers to 2 decimal ploces, es. 15.25) (c1) The parts of this question mast be completed in order, This part will be avallable when you complete the part above Bramble's Market United (BMU) is an umbrella organization for all individuals who are go-getters in home-grown produce, homemade jams/jellies, artisan breads, and other hand-crafted items to be sold on local street corners. It represents a proud group of folks who are trying to keep the small producer and the health-conscious consumer top-of-mind when it comes to filling the refrigerator and pantry. As a large organization that provides a variety of services for its regional member clubs, BMU continually strives to better understand its own profitability. BMU has four key support services to assist its members: Member Services, Social Medla, Resource Deplorment. and Administrative Services. These four support departments exist for the benefit of the three operating segments, which are organized geographically: East, Central, and West. While the support services primarily assist the operating segments, they also cross over and assist each other. The services offered by the support departments, along with the original cost of each support department. are as follows