Q1&2 is a big table question please solve with explanation

Prairie Electronics, located in Regina, manufactures three product lines: (1) high-end speakers, (2) personal computers, and (3) handheld devices. For 20x5, it compiled the following budgeted data: Total High-End Speakers 380,000 1,700 Personal Computers 590,000 1,290 Handheld Devices 480,000 415 360 140 100 80 90 WtG Sales (in units) Price (per unit) Variable costs per unit Direct materials Direct labour Overhead Shipping Sales commissions Direct fixed costs: Salaries Utilities Depreciation Common fixed costs Corporate salaries Building depreciation Legal & accounting Other $ 70,640,000 47,330,000 67,700,000 $ 77,770,000 65,890.000 144,650.000 $ 48,690,000 15,100,000 36,520,000 $ 70,380,000 63.690 000 49.960 000 23,690 000 Required: 1. & 2. Prepare a segmented performance report: Compute the contribution margin percentage and segment margin percentage. (Round "Percentage" answers to 1 decimal place, (... 0.123 should be considered as 12.3%).) PRAIRIE ELECTRONICS Segment Performance Report Profit Centres High-End Personal Speakers Computers Handheld Devices Total Company Required: 1. & 2. Prepare a segmented performance report, Compute the contribution margin percentage and segment margin percentage. (Round "Percentage" answers to 1 decimal place, i.e., 0.123 should be considered as 12.3%).) PRAIRIE ELECTRONICS Segment Performance Report Profit Centres High-End P ersonal Speakers Computers Handheld Devices Total Company Less: Variable costs: 11 Total variable expenses Less: Direct fixed costs Totallivadina Less: Variable costs Total variable expenses Less: Direct fixed costs Total fixed expenses Less: Common fixed costs Total common fixed costs 3.a. Allocate the common fixed expenses equally to the three segments and prepare a performance report. (Negative amounts should be indicated with a minus sign.) PRAIRIE ELECTRONICS Profit Centres High-End Personal Speakers Computers Handheld Devices Total Company Less: Common fixed expenses Allocated portion Net income (loss)