please answer using the table template posted in the 2nd picture. thanks
Massey Electronics Massey Electronics manufactures heat sinks. Heat sinks are small devices attached to solid-state circuit boands that dissipate the heat from the circuit board components. Made of aluminum, the devices consist of many small fins cut in the metal to increase its surface area and hence its ability to dissipate the heat. For example, Intel Pentium and Celeron processors are first mounted onto heat sinks and then attached to circuit boards. These processors generate heat that will ultimately destroy the processor and other components on the circuit board without a heat sink to disperse the heat. Massey has two production facilities, one in Texas and the other in Mexico. Both produce a wide range of heat sinks that are sold by the three Massey lines of business: laptops and PCs, servers, and telecommunications. The three lines of business are profit centers, whereas the two plants are cost centers. Products produced by each plant are charged to the lines of business selling the heat sinks at full absorption cost, including all manufacturing overheads. Both plants supply heat sinks to each line of business. The Texas plant produces more complicated heat sinks that require tighter engineering tolerances. The Texas workforce is more skilled, but also more expensive. The Mexico plant is larger and employs more people. Both facilities utilize a set of shared manufacturing resources: a common manufacturing IT system that schedules and controls the manufacturing process, inventory control, and cost accounting, industrial engineers, payroll processing, and quality control. These shared manufacturing overhead resources cost Massey $9.5 million annually. Massey is considering four ways to allocate this $9.5 million manufacturing overhead cost pool: direct labor hours, direct labor dollars, direct material dollars, or square footage of the two plants. The following table summarizes the operations of the two plants: Massey has s liability in any tax jurisdiction where it operates due to prior losses and hence expects no income tax Required: a. Prepare a table showing how the $9.5 million would be allocated using each of the four proposed allocation schemes (direct labor hours, direct labor dollars, direct material dollars, and square footage of the two plants). b. Discuss the advantages and disadvantages of each of the four proposed allocation methods (direct labor hours, direct labor dollars, direct material dollars, and square footage of the two plants). P 7-5: a) Prepare a table showing how the $9.5 million would be allocated using each of the four proposed allocation schemes (direct labor hours, direct labor dollars, direct material dollars, and square footage of the two plants). b) Discuss the advantages and disadvantages of each of the four proposed allocation methods (direct labor hours, direct labor dollars, direct material dollars, and square footage of the two plants)