Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have the following: 1. 2,796,600 cases 2. 0.03655 3. 0.19189 4. 102,848,287.5 ? 5. 2.236 ? 6. 682,300 ? 5-64. Cost Estimation, CVP Analysis,
I have the following:
1. 2,796,600 cases
2. 0.03655
3. 0.19189
4. 102,848,287.5 ?
5. 2.236 ?
6. 682,300 ?
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 vendin 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 Costs Allocated corporate costs (@5%).. 734,108 15,174,503 $ (492,353) 98,470 $ (393,883) Allowance for tax (@20%) .. 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: Corporate Revenue Corporate Overhead Costs Most recent year... $106,750,000 $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 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 Corporate Revenue Corporate Overhead Costs $5,337500 4,221,000 Most recent year.... $106,750,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 Month Cases Production Costs $1,139,828 1,161,328 1,169,981 1,185,523 1,187827 1,208,673 1,183,699 1,226,774 1,225,226 1,237,325 1,241,760 ,272,451 2.._ _.. _.... 217,200 6 237,000 9 0. ___.__... 252,600 Please answer the following questions. A regression analysis of the Bubbs p cost data is shown below. You may need the results to answer some of the questions. 1. 2. 3. 4. 5. 6. 7. How many cases of Bubbs did Lukes sell (based on sales revenue)? Using the high low method determine the variable corporate overhead cost per sales dollar. Round your answer to five significant digits. Based on the above what is the variable corporate overhead cost per case. Round your answer to five significant digits. Based on the above what is the fixed corporate overhead cost per month. Round your answer to the nearest dollar. Using the regression given below what is the variable production cost per case of Bubbs? Round your answer to three decimals. Using the regression given below what is the fixed production cost per month of Bubbs? Round your answer to the nearest 100 dollars. What is the total variable cost per case? Round your answer to four decimals. What is the contribution margin per case of Bubbs? Round your answer to four decimals 8. Linear regression model for variable Cost Filters: Cost 2.236 Units+6.823E5+ RMSE 7,969.9643 R2 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. Histogram of Residuals ROC Curve 10000.0 4 3 2 0 5000.0 0 10000.0 15000-10000-5000 05000 1000 1150000 1200000 1250000 Residual Predicted Cost Variable Units Constant Coefficient p>ltl SignificanceStd Err 2.236 6.823E5 15.7 20.53 2.235E-8 0.1423 3.324E4 1.665E
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started