plz help??

SB Exercise 7-16 through Exercise 7-17 (Algo) [The following information applies to the questions displayed below.] Raner, Harris & Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Net operating income Total Company $ 492,000 100% 246,000 508 246,000 500 137, 760 288 108,240 228 68,880 145 $ 39,360 88 Office Chicago Minneapolis $ 171,000 1001 $ 321,000 1000 51,300 306 192,600 60% 119,700 700 128,400 403 88,920 520 51,360 $ 30,780 181 $ 77,040 240 168 Exercise 7-17 (Algo) Working with a Segmented Income Statement (LO7.4) Assume that Minneapolis sales by major market are: Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Het operating income Minneapolis 5321,000 1000 192.600 600 120,400 408 51.360 77.040 245 15,000 5 062, 040 12 Market Medical Dental $ 228,000 1001 $ 120,000 1000 145,920 640 66,560 528 82,080 361 61,440 13.680 26,080 210 68.400 30 9 34,560 278 The company would like to initiate an intensive advertising campaign in one of the two market segments during the next month. The sinton Martina che indistathach sinn din ce in the Martial mathu Exercise 7-17 (Algo) Working with a Segmented Income Statement (LO7-4) Assume that Minneapolis' sales by major market are: 401 219 270 Market Minneapolis Medical Dental Sales $ 321,000 1000 $ 228,000 2008 $ 120,000 1000 Variable expenses 192,600 601 145,920 640 66,560 528 Contribution margin 128,400 82,080 368 Traceable Eixed expenses 61, 440 484 51,360 161 13.680 68 26,880 Ottice segment margin 77,040 248 $ 68,400 301 $ 34,560 Common fixed expenses not traceable to office 15,000 5. Net operating income $ 62,040 19 The company would like to initiate an intensive advertising campaign in one of the two market segments during the next month. The campaign would cost $12,000. Marketing studies indicate that such a campaign would increase sales in the Medical market by $54.000 or increase sales in the Dental market by $56,000. Required: 1. How much would the company's profits increase (decrease) If it implemented the advertising campaign in the Medical Market? 2. How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Dental Market? 3. In which of the markets would you recommend that the company focus its advertising campaign?' Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required How much would the company's profits increase (decrease) it it implemented the advertising campaign in the Medical Market? Company's profits by Exercise 7-17 (Algo) Working with a Segmented Income Statement (L07-4) Assume that Minneapolis sales by major market are: Market Minneapolis Medical Sales Dental $. 321,000 1001 $ 228,000 1001 Variable expenses $ 128,000 1000 192,600 600 145,920 640 66,560 524 Contribution margin 128,400 400 82,080 368 51,440 488 Traceable fixed expenses 51,360 164 13.680 60 26.880 218 Ottico segnent margin 77,040 245 $ 68,400 300 $ 34,560 221 Common fixed expenses not traceable to offices 15.000 5. Het operating income 3.62,040 190 The company would like to initiate an intensive advertising campaign in one of the two market segments during the next month. The campaign would cost $12,000. Marketing studies indicate that such a campaign would increase soles in the Medical market by $54000 or increase sales in the Dental market by $56,000 Required: 1. How much would the company's profits increase (decrease if it implemented the advertising campaign in the Medical Market? 2. How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Dental Market? 3. In which of the markets would you recommend that the company focus its advertising campaign? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Dental Market? Company's profits Assume that Minneapolis' sales by major market are: 1000 Market Minneapolis Medical Dental Sales $ 321,000 1001 $ 228,000 1000 $ 128,000 Variable expenses 192.600 601 145.920 66,560 Contribution margin 524 128,400 400 82,080 361 61,440 488 Traceable fixed expenses 51,360 13,680 68 26,880 210 ottice segment margin 77,040 241 $ 68,400 300 $ 34,560 271 Common fixed expenses not traceable to offices 15.000 Het operating income $ 62,040 193 The company would like to initiate an intensive advertising campaign in one of the two market segments during the next month. The campaign would cost $12,000. Marketing studies indicate that such a campaign would increase sales in the Medical market by $54,000 or increase sales in the Dental market by $56,000 Required: 1. How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Medical Market? 2. How much would the company's profits increase (decrease) if it implemented the advertising campaign in the Dental Market? 3. in which of the markets would you recommend that the company focus its advertising campaign? Complete this question by entering your answers in the tabs below. Required Required 2 Required in which of the markets would you recommend that the company focus its advertising campaign M Don