Question 5 of 9 0.13/0.5 View Policies Show Attempt History Current Attempt in Progress Sunland is a manufacturer that specializes in three types of toy instruments, xylophones, electronic keyboards, and drum sets. Grandparents across the globe flock to stores so they can buy their kids kids these especially noisy toys. Company managers 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 tweek Xylophone Keyboard Drums Total Sales $503,000 5903,000 5598.000 $2.004 000 Cost of goods sold 214.000 439.000 332.000 985.000 289.000 464,000 266.000 1.019.000 Gross margin Operating expenses Operating income 811,360 $207,640 Use Excel to complete the following Question 5 of 9 0.13/0.5 = (al Your answer is partially correct. The company has not previously allocated its operating expenses to the three product lines but wants to do so now. Managers believe operating expenses are incurred in a proportion similar to COGS for each product line Allocate the operating expenses using each product line's proportion of its own COGS to totalCOGS, then determine operating income and profit margin percentage by product line. (Round proportion of total cost of goods sold and profit margin percentage to 2 decimal places, ex 15.25% Round final answers to decimal places. e... 5,125, Enter loss using either a negative sign preceding the number eg, -5,145 or -45% or parentheseses (5,145) or (45)%) Xylophone Keyboard Drums Operating income 112725 $ 102389 $ -7476 Profit margin percentage 2183 3 % e Textbook and Media Saforte Attempts: unlimited Submit Aww (b)