Q1 please provide excel formulas

Q1 please answer asap

File Home Insert Draw Page Layout Formulas Data Review View Help 7 v Calibri Light v 11 BEvv Av ... ab Me Thanks for using Office! We've made some updates to the privacy settings to give you more control. Your organization's admin allows you to use nal cloud-backed services are provided to you under the Microsoft Services Agreement. Learn more A B C D E F G PopCorn Corn Nuts Corn Chips Total Sales Traceable Fixed Costs (list alphabetically): + Allocated common fixed costs Operating Income should any of the lines be discontinued? Why or why not? (1 mark) art 2: Calculate the segment margin percentage for each product line PopCorn Corn Nuts Corn Chips ement margin percentage (1 mark total) sing your answers to part 1 and part 2, what is the most profitable segment? This must be in your own words and use estion data. HOW did you determine which is the most profitable segment? (2 marks) > A Cover Sheet Q1 Q2 Q3 04 Q5 Formulas + lation Mode: Automatic Workbook StatisticsFile Home Insert Draw Page Layout Formulas Data Review View Help Calibri Light v 11 B vavAv ... Thanks for using Officel We've made some updates to the privacy settings to give you more control. Your organization's admin allows you to ptional cloud-backed services are provided to you under the Microsoft Services Agreement. Learn more A38 XV f B C D E F Question: Product Line Profitability (17 marks) The SnackCorn Company manufactures three types of snacks - popcorn, corn nuts and corn chips. Data on sales and expenses for the past quarter follow: Total common fixed expenses (Note 1) $ 193,000.00 PopCorn Corn Nuts Corn Chips Total If you S 401.000 S 259.COO $ 921.000 the e Sales 261,000 $ 9 Variable costs (as a percentage of sales dollars) 41% 59% 62% im Fixed Expenses: s+ Pleas Advertising, traceable S 15.233 S 44, 823 S 20,036 Salaries of product line managers 47,325 $ 43,951 $ $7.660 If yo Allocated common fixed expenses (Note 1) S 54 694 S 84 031 S 54,275 Note 1: Currently allocated on the basis of sales dollars. These are costs incurred to run the administrative offices. These costs will exist regardless of which product lines are offered. Management is concerned that not all product lines are profitable and wants a recommendation as to whether or not any of the lines should be discontinued. Required: Part 1: Restate the income statement using proper segmented income format, assuming all product lines are kept (13 marks): PopCorn Corn Nuts Corn Chips Total Sales > & Cover Sheet Q1 Q2 Q3 Q4 05 Formulas + alculation Mode: Automatic Workbook StatisticsFile Home Insert Draw Page Layout Formulas Data Review View Help Calibri Light 11 B Evy Av ... ab M Thanks for using Officel We've made some updates to the privacy settings to give you more control, Your organization's admin allows you to us onal cloud-backed services are provided to you under the Microsoft Services Agreement. Learn more V X V fx A B C D E F G Allocated common fixed costs Operating Income Should any of the lines be discontinued? Why or why not? (1 mark) + Part 2: Calculate the segment margin percentage for each product line PopCorn Corn Nuts Corn Chips Segment margin percentage (1 mark total) Using your answers to part 1 and part 2, what is the most profitable segment? This must be in your own words and use question data. HOW did you determine which is the most profitable segment? (2 marks) "As a reminder, this is a dosed book exam." END OF QUESTION TD > = B Cover Sheet Q1 Q2 Q3 04 Q5 Formulas + ulation Mode: Automatic Workbook Statistics