Accounting 311 In class #1 Based on Case 5-14 in text 5-64. Cost Estimation, CVP Analysis, and Decision Making (LO 5-4.5.8) 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 gum, Bubbs, to sell in vending machines. The product, which sells for $5.25 per case, has not had the market success that managers expected and the company is considering dropping Bubbs. The product-line income statement for the past 12 months follows: $14,682,150 Table 1 Revenue.. Costs Manufacturing costs ......... Allocated corporate costs (5%)... Product-line margin... Allowance for tax (20%).... . Product-line profit (loss)... $14.440.395 734,108 15,174,503 $ (492,353) 98.470 $ (393,883) All products at Luke receive an allocation of corporate overhead costs, which is computed as 5 percent of product revenue. 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: Table 2 Corporate Revenue Most recent year.... $106.750,000 Previous year. ...... 76,200.000 Corporate Overhead Costs $5,337,500 4,221,000 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 above, Mr. Andre provides you with the following data on product costs for Bubbs Table 3 Month Cases 207.000 217,200 214,800 228.000 224,400 237,000 220.200 247,200 238,800 252.600 250,200 259,200 Production Costs $1.139.828 1.161,328 1,169,981 1,185,523 1.187.827 1,208,673 1,183,699 1,226,774 1.225 226 1,237,325 1.241.760 1,272,451 Table 4 Linear regression model for variable Cost Filters: Cost = 2.236 Units + 6.823E5 + c Obs = 12 RMSE = 7,969.9643 R? = 0.96107694 Adjusted R2 = 0.95718464 Model does a good job explaining variation in Cost. Consider removing variables with insignificant coefficients as they may hurt more than they help. Frequency TTTT Histogram of Residuals ROC Curve 10000.0 1 5000.0 + 0.07 -5000.0 -10000.0 - 15000 10000 50000 5000 1000 1150000 1200000 Residual Son Predicted Cost Variable Coefficient p>It Significance Units 2.236 15.71 2.235E-8 Constant 6.823E5 20.53 1665E-9 1250000 Std Err 0.1423 3.324E4 Proclution = c c. cases read bin Cost Ho J ao 38-E-BNC 7. What is the total variable cost per case of Bubbs? 8. What is the contribution margin per case of Bubbs? 9. What is the monthly average number of cases of Bubbs that Lukes sold last year? Round to the nearest whole number. 10. What is the monthly break-even number of cases of Bubbs7 Consider whether or not to include some portion of the allocated costs. Round to the nearest whole number. 11. What is the fixed production cost per case based on the current average sales volume per month? Round to four decimals. 12. Reformat the Income Statement shown in Table 1 to separate the fixed from the variable costs. What is the total annual contribution margin of Bubbs? 13. What is the annual pre-tax net income from Bubbs ignoring any allocation of corporate costs? 14. What is the annual pre-tax net income from Bubbs assuming the fixed corporate costs are allocated to products / divisions based on total revenues? 15. What is the price per case that is required for Bubbs to break-even at the given volume of sales in the current year? Round up to the nearest $.01. Assume that fixed corporated costs are on the basis of Revenues as in 14. Keep in mind that increasing the price per unit will increase both the Revenues for Bubbs and for Lukes in total. Accounting 311 In class #1 Based on Case 5-14 in text 5-64. Cost Estimation, CVP Analysis, and Decision Making (LO 5-4.5.8) 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 gum, Bubbs, to sell in vending machines. The product, which sells for $5.25 per case, has not had the market success that managers expected and the company is considering dropping Bubbs. The product-line income statement for the past 12 months follows: $14,682,150 Table 1 Revenue.. Costs Manufacturing costs ......... Allocated corporate costs (5%)... Product-line margin... Allowance for tax (20%).... . Product-line profit (loss)... $14.440.395 734,108 15,174,503 $ (492,353) 98.470 $ (393,883) All products at Luke receive an allocation of corporate overhead costs, which is computed as 5 percent of product revenue. 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: Table 2 Corporate Revenue Most recent year.... $106.750,000 Previous year. ...... 76,200.000 Corporate Overhead Costs $5,337,500 4,221,000 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 above, Mr. Andre provides you with the following data on product costs for Bubbs Table 3 Month Cases 207.000 217,200 214,800 228.000 224,400 237,000 220.200 247,200 238,800 252.600 250,200 259,200 Production Costs $1.139.828 1.161,328 1,169,981 1,185,523 1.187.827 1,208,673 1,183,699 1,226,774 1.225 226 1,237,325 1.241.760 1,272,451 Table 4 Linear regression model for variable Cost Filters: Cost = 2.236 Units + 6.823E5 + c Obs = 12 RMSE = 7,969.9643 R? = 0.96107694 Adjusted R2 = 0.95718464 Model does a good job explaining variation in Cost. Consider removing variables with insignificant coefficients as they may hurt more than they help. Frequency TTTT Histogram of Residuals ROC Curve 10000.0 1 5000.0 + 0.07 -5000.0 -10000.0 - 15000 10000 50000 5000 1000 1150000 1200000 Residual Son Predicted Cost Variable Coefficient p>It Significance Units 2.236 15.71 2.235E-8 Constant 6.823E5 20.53 1665E-9 1250000 Std Err 0.1423 3.324E4 Proclution = c c. cases read bin Cost Ho J ao 38-E-BNC 7. What is the total variable cost per case of Bubbs? 8. What is the contribution margin per case of Bubbs? 9. What is the monthly average number of cases of Bubbs that Lukes sold last year? Round to the nearest whole number. 10. What is the monthly break-even number of cases of Bubbs7 Consider whether or not to include some portion of the allocated costs. Round to the nearest whole number. 11. What is the fixed production cost per case based on the current average sales volume per month? Round to four decimals. 12. Reformat the Income Statement shown in Table 1 to separate the fixed from the variable costs. What is the total annual contribution margin of Bubbs? 13. What is the annual pre-tax net income from Bubbs ignoring any allocation of corporate costs? 14. What is the annual pre-tax net income from Bubbs assuming the fixed corporate costs are allocated to products / divisions based on total revenues? 15. What is the price per case that is required for Bubbs to break-even at the given volume of sales in the current year? Round up to the nearest $.01. Assume that fixed corporated costs are on the basis of Revenues as in 14. Keep in mind that increasing the price per unit will increase both the Revenues for Bubbs and for Lukes in total