1 answer

Luke Corporation produces a variety of products, each within their own division. Last year, the managers...

Question:

Luke Corporation produces a variety of products, each within their own division. Last year, the managers at Luke developed anRequired: a. Bunk Stores has requested a quote for a special order of Bubbs. This order would not be subject to any corporate

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 $6.00 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,704,650 $ Revenue Costs Manufacturing costs Allocated corporate costs (25%) Product-line margin Allowance for tax (@20%) Product-line profit (loss) 14.447.895 735 233 $ 15,183,128 (478.478) 95,695 (382,783) $ 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 parcentage of revenue. Data on corporate costs and revenues for the past two years follow: Most recent year Previous year Corporate Revenue $ 121,750,000 $ 77.700.000 Corporate Overhead Costs S6,087,500 5,109,590 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 222.000 224,700 222,400 243.000 250,450 252,000 227,750 254,700 246,300 260,150 257,700 266,700 Production Costs $1,164.340 1,185,840 1,194,493 1,210,035 1,212,339 1,233,185 1,208,211 1,251,286 1,249,738 1,261,837 1,266,272 1,296,963
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? (Round your answer to 2 decimal places.(i.e., 32.21) Minimum Price b. How many cases of Bubbs does Luke have to sell in order to break even on the product? (Round variable cost percentage to 2 decimal places, fixed costs to whole dollar amount and profit per case to 3 decimal places for intermediate calculations. Round your final answer up to the nearest whole unit.) Number of cases c. Suppose Luke has a requirement that all products have to earn 5 percent of sales (before tax after corporate allocations) or they will be dropped. How many cases of Bubbs does Mr. Andre need to sell to avoid seeing Bubbs dropped? (Round your minimum price per case to 2 decimal places and do not round your other intermediate calculations. Round your final answer up to the nearest whole unit.) Number of cases 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 or decrease? Assume that fixed production costs can be avoided if Bubbs is dropped. (Use variable cost percentage to 2 decimal places. Round intermediate calculations and final answers to nearest whole dollar amount.) Profits

Answers

a)
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.91400386
R Square 0.835403056
Adjusted R Square 0.818943362
Standard Error 16389.42803
Observations 12
ANOVA
df SS MS F Significance F
Regression 1 1.36E+10 1.36E+10 50.75446939 3.2E-05
Residual 10 2.69E+09 2.69E+08
Total 11 1.63E+10
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 687301.3722 76026.13 9.04033 3.97492E-06 517904.6 856698.2 517904.6 856698.2
X Variable 1 2.215592511 0.310995 7.124217 3.20155E-05 1.522654 2.908531 1.522654 2.908531
The minimum price Mr. Andre can offer Bunk without reducing profit any further is equal to variable cost per unit $               2.22
b)
High-low method:
Variable cost estimate = (Cost at highest activity – Cost at lowest activity)/(Highest activity – Lowest activity)
Corporate Revenue Corporate Overhead Costs
Most recent year 121,750,000 6,087,500
Previous year 77,700,000 5,109,590
Difference 44,050,000 977,910
Variable cost corporate estimate = 977,910/$44,050,000 2.22% of revenue
Let Q be number of cases sold
Profit = Revenues - Variable Product Cost - Variable Corporate costs - Fixed Production Costs
Profit = $6 x Q - $2.22 x Q - ($6 Q x 2.22%) - $687301.37
Break Even Point (Q) = $687301.37/ $3.65 $    188,239.47 cases
c)
Profit = $6 x Q - $2.22 x Q - ($6 Q x 5%) - $687301.37
Break Even Point (Q) = $687301.37/ $3.48        120,579.19 cases
d)
Lost Revenue -14,704,650
Product Cost Avoided 14,447,895
Loss Before corporate overhead savings -256,755
Allocated corporate costs (2.22% x 14704650) 326,443
Increase profits before Tax 69,688
Allowance for tax (@20%) 13,938
Increased  Profits 55,751
.

Similar Solved Questions

1 answer
What state of matter has the lowest intrinsic density?
What state of matter has the lowest intrinsic density?...
1 answer
EBook Problem Walk-Through Madsen Motors's bonds have 6 years remaining to maturity. Interest is paid annually,...
eBook Problem Walk-Through Madsen Motors's bonds have 6 years remaining to maturity. Interest is paid annually, they have a $1,000 par value, the coupon interest rate is 6%, and the yield to maturity is 7%. What is the bond's current market price? Round your answer to the nearest cent. Hide ...
1 answer
Please could you answer ALL sub-questions 70 kg/h of a concentrate from an evaporation system containing...
Please could you answer ALL sub-questions 70 kg/h of a concentrate from an evaporation system containing 55 wt.% CaCl2 at 90 °C and 101 kPa enters a continuous crystallizer. The saturated crystals of CaCl2. H20 leave at 10 °C. At 10 °C the solution contains 12.5 kg CaCl2/100 kg H20 and d...
1 answer
Esay recorded the following data for Avogadro's number experiment. He concluded that the average calibration number...
Esay recorded the following data for Avogadro's number experiment. He concluded that the average calibration number of drops from dropper per mL is seventy-seven. Next, Esay determined it took twelve drops of stearic acid solution to form the monolayer. Density of stearic acid = 0, 85 g/mL Conce...
1 answer
A. The following is a set of hypothetical production possibilities for a nation. Cars Computers 0...
a. The following is a set of hypothetical production possibilities for a nation. Cars Computers 0 450 Combination А B с 100 420 330 250 D 380 270 E 510 150 F 550 0 1) Plot the production possibility for the nation. i1) What is the opportunity cost of the first 100 computers produced? iii...
1 answer
Finish attempt ... eBook AP Question 3 Not complete Marked out of 13.00 P Flag question...
Finish attempt ... eBook AP Question 3 Not complete Marked out of 13.00 P Flag question Journal Entries for Purchase, Return, and Remittance-Perpetual System On April 13, the Albert Company purchased $26,000 of merchandise from the Krausman Company, with terms of 1/10, n/30. On April 15, Albert paid...
1 answer
The States and Balanced Budgets. The accompanying figure shows the initial aggregate demand and aggregate supply...
The States and Balanced Budgets. The accompanying figure shows the initial aggregate demand and aggregate supply curves for the US Suppose the national economy experiences a recession, 1) Using the line drawing tool, show the effect of the recession by appropriately shitting the ADAS Curves. Label t...
1 answer
Suppose the US Department of Education is interested in knowing if the proportion of high school...
Suppose the US Department of Education is interested in knowing if the proportion of high school seniors planning on attending college is not 60%. They conduct a hypothesis test with Alpha = 0.05 and get a p-value of 0.039. What interpretation should they make?...
1 answer
A person fishing from a pier observes that 3 wave crests pass by in 9.8 s...
A person fishing from a pier observes that 3 wave crests pass by in 9.8 s and estimates the distance between two successive crests to be 4.7 m. The timing starts with the first wave crest and ends with the last. What is the speed of the wave?...
3 answers
A 0.047 kg aluminum bullet traveling at 459 m/s strikes an armor plate and comes to...
A 0.047 kg aluminum bullet traveling at 459 m/s strikes an armor plate and comes to a stop. If all its energy is converted to heat that is absorbed by the bullet, what is the bullet's temperature change in degrees Celsius?...
1 answer
What would be some examples of Nursing care and Nursing Interventions for ankyloglossia?
What would be some examples of Nursing care and Nursing Interventions for ankyloglossia?...
1 answer
0.7 0.9 81.59 The results of a certain medical test are normally distributed with a mean...
0.7 0.9 81.59 The results of a certain medical test are normally distributed with a mean of 125 and a standard deviation of 19. (A score above 137 is considered unhealthy). Use the given table to find the percentage of people with readings below 134. |z-score 0.1 02 0.3 0.4 0.5 0.6 0.8 Percentile 53...
1 answer
2- (15%) Let X denote the distance (m) that an animal moves from its birth site...
2- (15%) Let X denote the distance (m) that an animal moves from its birth site to the first territorial vacancy it encounters. Suppose that for banner-tailed kangaroo rats, X has an exponential distribution with the mean of 72.15. (McCarthy, 1997) a. What is the probability that the distance is at ...
1 answer
Help solution (a) What is the general formula for vasung araw sieck, irrespective of its dividend...
help solution (a) What is the general formula for vasung araw sieck, irrespective of its dividend pattern? Poran n + P + P Leerzaken A . . China (b) How is the constant growth stock valves? (c) What is the required rate of return on the story of Conany? Assa that the risk-free raie is 9%, the mar...
1 answer
(Compound value) Stanford Simmons, who recently sold his Porsche, placed $10,800 in a savings account paying...
(Compound value) Stanford Simmons, who recently sold his Porsche, placed $10,800 in a savings account paying annual compound interest of 5 percent. a. Calculate the amount of money that will have accrued if he leaves the money in the bank for 3. 6, and 16 years. b. If he moves his money into an acco...
1 answer
Which of the following statements about osmoregulation are NOT true? Select one: a. Osmoregulators can control...
Which of the following statements about osmoregulation are NOT true? Select one: a. Osmoregulators can control their internal osmolarity independent of external environment and thus maintain a constant osmotic pressure in the blood b. Marine fish lose more water from the gills and body surface and e...
1 answer
Determine the LS terms of the ns^2, nd^2, and 4f^2 configurations. Using Hund's rule, determine the...
Determine the LS terms of the ns^2, nd^2, and 4f^2 configurations. Using Hund's rule, determine the lowest LS term of the 4f^2 configuration....