answer b plz asap

Metlock is a manufacturer that specializes in three types of toy instruments: xylophones, electronic loeyboards, and drum sets. Grand parents across the globe flock to stores so they can buy their kids' kids these especially noisy toys. Compary maragers are equally excited about their products and await the profit report for this year's performance. The following partial income statement was released to all managers last week. Use Excel to complete the following. (a) The company has not previously allocated its operating expenses to the three product lines but wants to do so now. Managers belicve operating expenses are incurred in a proportion similar to COGS for each product line. Allocate the operating experses using each prodict line's proportion of its own COGS to total COGS, then determine operating income and profit margin percentage by aroduct line. (Round proportion of total cost of goods sold and profit margin percentage to 2 decimal places, ez 1525%. Round finaf answers to 0 decinal places, eg 5.125. Enter loss using either a negutive sign preceding the number eg 5,145 or 45% or pareneheseses. (5.145) or (45)%] After reviewing the profit report, one product line manager was concerned by how the operating expenses were allocated. He felt that a disproportionate amount was being directed at his product line and requested that the accounting team review these expenses. After doing sa, the accounting team observed that while same operating activity usage follown the COGS trend, not all operating activity unage does. The accountants incorporated this new information and prepared the following for product line managers Based on this updated information prepare new allocations and profit analyus by product line Which product line manager(s) will likcly prefer this new ABC version of profitability? (Round onswers to 2 decinal piuces. ey. 15.25\%)