art DS Luke Corporation produces a variety of products, each within their own division. Last year, the managers at Luke developed and began marketing a new chewing gun. Bubbis, to sell in ling machines. The product, which sells for 55.50 per caso, has not had the market success that managers expected, and the company is considering dropping Bubbs The product line income statement for the last month follows: 5 1,415,975 5 Revenue Costs Production costs Product line margin Allowance for tax 20%) Product line profit (los) 5 (1.285,451) 130.524 (26.104.NO) $ 104.419.30 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 ca production costs for Bubbs for the past 12 months More Cases 1 220.000 2 219 200 3 216.900 4 233,000 Production Costs 51.156.250 1.174205 1.172918 1,103523 (loss) 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 production costs for Bubbs for the past 12 months Month Cases Production Costs 1 220,000 $1,155,250 2 219,200 1,174 265 3216,900 1.172.018 4 233.000 1.193523 5 238,100 1.195 627 0 241.000 1216,673 7 222 200 1.195.000 8 209 200 1 215 210 9242.000 1233.226 10 254,000 1.250,377 11 249.500 1.249.700 12 254,300 1.285 451 1 Assume that the relevant range of production is between 150,000 and 350,000 cases Required: Respond to the following 1. How many cases of Dubbs doel kelute to see the wake on the product De Regionice to find the fined and be pois of the production Cwe will be the variable Prices will be able Toda line-fit plot with the output and white labeled Submit your passe les part of the assignet Roundtable cost per unit and total fred cost you find them to decimal places to Se questions Nonnd your real number of cases) ap to the west a whole sumber Ustroende best 2. What is the current margle of safety percentage besede cell pole income staround your newer to decimal poate XX.XX 3. Suppose that all product means per percent of total sales per tother they will be dropped flow of Builder Andre need to meeth to avoid seeing as dropped on the maker of caters to the nearest wolber Use Selveri Excel this problem 1: Scle with peradabahierschritte Mar ther to each is clearly labeled for the wood to be ve this correctly labeled off on the year work for the problemet een the problemi aferecede 1. Make sure you cel file in die bestand to solve the file muscle the watelineft powerthy head tie, text you contre les des the Bank art DS Luke Corporation produces a variety of products, each within their own division. Last year, the managers at Luke developed and began marketing a new chewing gun. Bubbis, to sell in ling machines. The product, which sells for 55.50 per caso, has not had the market success that managers expected, and the company is considering dropping Bubbs The product line income statement for the last month follows: 5 1,415,975 5 Revenue Costs Production costs Product line margin Allowance for tax 20%) Product line profit (los) 5 (1.285,451) 130.524 (26.104.NO) $ 104.419.30 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 ca production costs for Bubbs for the past 12 months More Cases 1 220.000 2 219 200 3 216.900 4 233,000 Production Costs 51.156.250 1.174205 1.172918 1,103523 (loss) 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 production costs for Bubbs for the past 12 months Month Cases Production Costs 1 220,000 $1,155,250 2 219,200 1,174 265 3216,900 1.172.018 4 233.000 1.193523 5 238,100 1.195 627 0 241.000 1216,673 7 222 200 1.195.000 8 209 200 1 215 210 9242.000 1233.226 10 254,000 1.250,377 11 249.500 1.249.700 12 254,300 1.285 451 1 Assume that the relevant range of production is between 150,000 and 350,000 cases Required: Respond to the following 1. How many cases of Dubbs doel kelute to see the wake on the product De Regionice to find the fined and be pois of the production Cwe will be the variable Prices will be able Toda line-fit plot with the output and white labeled Submit your passe les part of the assignet Roundtable cost per unit and total fred cost you find them to decimal places to Se questions Nonnd your real number of cases) ap to the west a whole sumber Ustroende best 2. What is the current margle of safety percentage besede cell pole income staround your newer to decimal poate XX.XX 3. Suppose that all product means per percent of total sales per tother they will be dropped flow of Builder Andre need to meeth to avoid seeing as dropped on the maker of caters to the nearest wolber Use Selveri Excel this problem 1: Scle with peradabahierschritte Mar ther to each is clearly labeled for the wood to be ve this correctly labeled off on the year work for the problemet een the problemi aferecede 1. Make sure you cel file in die bestand to solve the file muscle the watelineft powerthy head tie, text you contre les des the Bank