I can't figure this out.

ment Print View et matin.com.tm.ed cisimleri ve 4 Awo points Integrative Cose 5-72 (Alga) Cost Estimation, CVP Analysis, and Decision Making (LO 5-4,5,9) Luke Corporation produces a variety of products, each within their own division Last year, the managers allure developed and began marketing a new chewing gum, Bubbs to sell in vending machine The product, which is for $5.05 perc, has to had the market success that managers expected and the company is considering dropping Bukit The product line income statement for the past 12 months follows $ 14,700 150 Reverse Costs Manufacturing costs Allocated corporales (5) Product line margin Nilowance for taxi@20) Product-ne profitos) 14,448 305 735 306 15 183,703 (477,553) 15 510 (382.0431 S All products Luke recevean location of corporale overhead conswich is computed 5 percent of producten The 5 percent rate is computed based on the most recent year's corporate cost as a percentage of revenue. Data on Corporate costs and revenues for the past two years follow Most recent year Corporate Revenue Corporate Overhead Costs $ 122,750,000 Previous year $ 6,137.500 77.800.000 5.180.066 Roy O. Andre, the product manager for Bubbs, is concerned about whether the product will be dropped by the company and has employed you as a financial consultant to help with some analysis. In addition to the information given, Mr. Andre provides you with the following data on product costs for Bubbs. Month Cases Production Costs 1 223,000 $1,165,640 2 225.200 1.187.340 3-222.900 1.195.993 4 244,000 1.211,535 5 224,500 1.213,831 6 253,000 1.234,685 7 228.250 1.209,711 8 255,200 1,252,786 240.800 1.251.238 10 260.650 1.263,337 11 258.200 1 267.772 12 -267,200 1.298,463 Required: a. Bunk Stores has requested a quote for a special order of Bubbs. This order would not be subject to any corporate allocation (and would not affect corporate costs). What is the minimum price Mr. Andre can offer Bunk without reducing profit any further? b. How many cases of Bubbs does Luke have to sell in order to break even on the product? c. Suppose Luke has a requirement that all products have to earn 5 percent of sales (after tax and corporate allocations) or they will be dropped. How many cases of Bubbs does Mr. Andre need to sell to avoid seeing Bubbs dropped? d. Assume all costs and prices will be the same in the next year. If Luke drops Bubbs, how much will Luke's profits increase of decrease? Assume that fixed production costs can be avoided if Bubbs is dropped, 11/11/2020, 11:5 Assignment Print View hip hcm.com.tr Complete this question by entering your answers in the tabs below Bunk Stores are a fora poder of Butts. These were le spect to any content (and would not affect corporate casts). What is the minimum price Mr. Andre can offer Bunk without reducing profit any MA References Worksheet Difficulty: 3 Hard Leaming Objective. Os interpret the results of regression output Integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making [LO 54, 5,9) Learning Objective: 05-04 Leaming Objective: 05-09 (Appendix Al Use Microsoft Estimate costs using Excel to perform a regression analysis statistical analysis hips eromhedon.com Complete this question by entering your answers in the tabs below. Required Regards Reque Required D How many cases of Bubts does Luke have to sell in order to break even on the product? (Round variable cost percenta decimal places, fixed costs to whole dollar amount and profit per case to 3 decimal places for intermediate calculations your final answer up to the nearest whole unit.) Number of References Worksheet Difficulty: 3 Hard Learning Objective: 05-05 Interpret the results of regression output Leaming Objective: 05-04 Learning Objective: 05-09 (Appendix A) Use Microsoft Estimate costs using Excel to perform a regression analysis statistical analysis Integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making (LO 5-4,5,9) Complete the tien hy entering our answers in the below. Tegund Suppo has a reputrement that all pots have to sam primit of sale (after tax and corporate locations) will be red many of the does Andre need to sell to avoid hutt dropped on your can not in your other de calcuna voce cu to Show Mamta- References Worksheet Difficulty: 3 Hard Learning Objective: 05-05 Interpret the results of regression output integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making (LO 54, 5,9) Leaming Objective: 05-04 Estimate costs using statistical analysis Learning Objective: 05-09 (Appendix A) Use Microsoft Excel to perform a regression analysis. References Worksheet Difficulty: 3 Hard Learning Objective: 05-05 Interpret the results of regression output Learning Objective: 05-04 Estimate costs using statistical analysis Leaming Objective: 05-09 (Appendix Al Use Microsoft Excel to perform a regression analysis integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making (LO 54, 5,9) ment Print View et matin.com.tm.ed cisimleri ve 4 Awo points Integrative Cose 5-72 (Alga) Cost Estimation, CVP Analysis, and Decision Making (LO 5-4,5,9) Luke Corporation produces a variety of products, each within their own division Last year, the managers allure developed and began marketing a new chewing gum, Bubbs to sell in vending machine The product, which is for $5.05 perc, has to had the market success that managers expected and the company is considering dropping Bukit The product line income statement for the past 12 months follows $ 14,700 150 Reverse Costs Manufacturing costs Allocated corporales (5) Product line margin Nilowance for taxi@20) Product-ne profitos) 14,448 305 735 306 15 183,703 (477,553) 15 510 (382.0431 S All products Luke recevean location of corporale overhead conswich is computed 5 percent of producten The 5 percent rate is computed based on the most recent year's corporate cost as a percentage of revenue. Data on Corporate costs and revenues for the past two years follow Most recent year Corporate Revenue Corporate Overhead Costs $ 122,750,000 Previous year $ 6,137.500 77.800.000 5.180.066 Roy O. Andre, the product manager for Bubbs, is concerned about whether the product will be dropped by the company and has employed you as a financial consultant to help with some analysis. In addition to the information given, Mr. Andre provides you with the following data on product costs for Bubbs. Month Cases Production Costs 1 223,000 $1,165,640 2 225.200 1.187.340 3-222.900 1.195.993 4 244,000 1.211,535 5 224,500 1.213,831 6 253,000 1.234,685 7 228.250 1.209,711 8 255,200 1,252,786 240.800 1.251.238 10 260.650 1.263,337 11 258.200 1 267.772 12 -267,200 1.298,463 Required: a. Bunk Stores has requested a quote for a special order of Bubbs. This order would not be subject to any corporate allocation (and would not affect corporate costs). What is the minimum price Mr. Andre can offer Bunk without reducing profit any further? b. How many cases of Bubbs does Luke have to sell in order to break even on the product? c. Suppose Luke has a requirement that all products have to earn 5 percent of sales (after tax and corporate allocations) or they will be dropped. How many cases of Bubbs does Mr. Andre need to sell to avoid seeing Bubbs dropped? d. Assume all costs and prices will be the same in the next year. If Luke drops Bubbs, how much will Luke's profits increase of decrease? Assume that fixed production costs can be avoided if Bubbs is dropped, 11/11/2020, 11:5 Assignment Print View hip hcm.com.tr Complete this question by entering your answers in the tabs below Bunk Stores are a fora poder of Butts. These were le spect to any content (and would not affect corporate casts). What is the minimum price Mr. Andre can offer Bunk without reducing profit any MA References Worksheet Difficulty: 3 Hard Leaming Objective. Os interpret the results of regression output Integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making [LO 54, 5,9) Learning Objective: 05-04 Leaming Objective: 05-09 (Appendix Al Use Microsoft Estimate costs using Excel to perform a regression analysis statistical analysis hips eromhedon.com Complete this question by entering your answers in the tabs below. Required Regards Reque Required D How many cases of Bubts does Luke have to sell in order to break even on the product? (Round variable cost percenta decimal places, fixed costs to whole dollar amount and profit per case to 3 decimal places for intermediate calculations your final answer up to the nearest whole unit.) Number of References Worksheet Difficulty: 3 Hard Learning Objective: 05-05 Interpret the results of regression output Leaming Objective: 05-04 Learning Objective: 05-09 (Appendix A) Use Microsoft Estimate costs using Excel to perform a regression analysis statistical analysis Integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making (LO 5-4,5,9) Complete the tien hy entering our answers in the below. Tegund Suppo has a reputrement that all pots have to sam primit of sale (after tax and corporate locations) will be red many of the does Andre need to sell to avoid hutt dropped on your can not in your other de calcuna voce cu to Show Mamta- References Worksheet Difficulty: 3 Hard Learning Objective: 05-05 Interpret the results of regression output integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making (LO 54, 5,9) Leaming Objective: 05-04 Estimate costs using statistical analysis Learning Objective: 05-09 (Appendix A) Use Microsoft Excel to perform a regression analysis. References Worksheet Difficulty: 3 Hard Learning Objective: 05-05 Interpret the results of regression output Learning Objective: 05-04 Estimate costs using statistical analysis Leaming Objective: 05-09 (Appendix Al Use Microsoft Excel to perform a regression analysis integrative Case 5-72 (Algo) Cost Estimation, CVP Analysis, and Decision Making (LO 54, 5,9)