Question

In: Finance

:Roan Bicycle Manufactures Mountain, BMX, and Hybrid bicycles. Sales and expense data for the past month...

:Roan Bicycle Manufactures Mountain, BMX, and Hybrid bicycles. Sales and expense data for the past month follow:

Total

Mountain Bicycle

BMX

Bicycle

Hybrid Bicycle

Revenue

$ 880,000

$ 190,000

$430,000

$260,000

Variable expense

420,000

80,000

220,000

120,000

Contribution Margin

460,000

110,000

210,000

140,000

Fixed Expenses:

Advertising-traceable

168,000

55,000

      60,000

53,000

Depreciation of special equipment

85,000

25,000

30,000

30,000

Line Supervisors’ salaries

68,000

28,000

24,000

16,000

General Administrative overhead*

99,000

32,000

45,000

22,000

Total Fixed expenses

420,000

140,000

159,000

121,000

Net Operating Income (loss)

40,000

(30,000)

51,000

19,000

* A common fixed cost that is allocated on the basis of sales dollars

Management is concerned about the continued losses shown by the round Mountain Bicycle and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce the mountain bicycle has no resale value. If the mountain bicycle model is dropped, the two-line supervisors assigned to the model would be discharged.

REQUIREMENT

1. What is the financial advantage (disadvantage) of discontinuing the mountain bicycle? The company has no other use for the capacity now being used to produce the mountain bicycle. Show computations to support your answer.

2. Recast the above data in a format that would be more useful to management in assessing the
profitability of the various product lines

Solutions

Expert Solution

AS PER QUESTION
A
Total Mountain Bicycle BMX Bicycle Hybrid Bicycle TOTAL
AMOUNT IN $
Revenue 190000 430000 260000 880000
Variable expense 80000 220000 120000 420000
Contribution Margin 110000 210000 140000 460000
Fixed Expenses Own Division
Advertising-traceable 55000 60000 53000 168000
Depreciation of special equipment 25000 30000 30000 85000
Line Supervisors’ salaries 28000 24000 16000 68000
TOTAL FIXED OH OWN DIVISION 108000 114000 99000 321000
PROFIT BEFORE ALLOCATION OF GENERAL FIXED OH 2000 96000 41000 139000
General Administrative overhead* 32000 45000 22000 99000
NET OPERATING INCOME -30000 51000 19000 40000
AS PER QUESTION
B
Total Mountain Bicycle BMX Bicycle Hybrid Bicycle TOTAL
AMOUNT IN $
Revenue 190000 430000 260000 880000
Variable expense 80000 220000 120000 420000
Contribution Margin 110000 210000 140000 460000
% on Sales 58% 49% 54% 52%
Fixed Expenses Own Division
Advertising-traceable 55000 60000 53000 168000
% on Sales 29% 14% 20% 19%
Depreciation of special equipment 25000 30000 30000 85000
% on Sales 13% 7% 12% 10%
Line Supervisors’ salaries 28000 24000 16000 68000
% on Sales 15% 6% 6% 8%
TOTAL FIXED OH OWN DIVISION 108000 114000 99000 321000
PROFIT BEFORE ALLOCATION OF GENERAL FIXED OH 2000 96000 41000 139000
General Administrative overhead* 21375 48375 29250 99000
NET OPERATING INCOME -19375 47625 11750 40000
If General Administrative overhead allocated on the basis of revenue
IF WE DROPPED Mountain Bicycle
C
Total Mountain Bicycle BMX Bicycle Hybrid Bicycle TOTAL
AMOUNT IN $
Revenue 430000 260000 690000
Variable expense 220000 120000 340000
Contribution Margin 210000 140000 350000
Fixed Expenses:
Advertising-traceable 60000 53000 113000
Depreciation of special equipment 30000 30000 60000
Line Supervisors’ salaries 24000 16000 40000
General Administrative overhead* 61696 37304 99000
TOTAL FIXED EXPENSE 175696 136304 312000
NET OPERATING INCOME 34304 3696 38000
*GENERAL ADMN OVER HEADS ALLOCATED ON THE BASIS OF REVENUE
BASED ON ANSWER B
As per the question, it is mentioned that allocation of Administarive over heads is on the baisis of revenue ,the calculation
is not correct if the allocation of General Admn OH is based on revenue , the Net income is shown below
Mountain Bicycle BMX Bicycle Hybrid Bicycle

Related Solutions

Bianca Bicycle Company manufactures mountain bikes with a variable cost of $1,600. The bicycles sell for...
Bianca Bicycle Company manufactures mountain bikes with a variable cost of $1,600. The bicycles sell for $2,350 each. Budgeted fixed manufacturing overhead for the most recent year was $11,600,000. Planned and actual production for the year were the same. State whether income is higher under variable or absorption costing and the amount of the difference in reported opearting income under the two methods. Treat each condition as an independent case. (Round intermediate calculations to 2 decimal places.) 1. Production 22,600...
Michael’s Bicycles manufactures different types of bicycles: mountain, road, and youth. Sales of the road bikes...
Michael’s Bicycles manufactures different types of bicycles: mountain, road, and youth. Sales of the road bikes have fallen. The firm is considering two options: (1) drop the road bike line; or (2) replace the road bike line with fat tire bikes. Price and cost data are as follows: Mountain Road Youth Fat Tire Price/unit $400 $1200 $120 $600 Variable cost/unit $300 $600 $75 $400 Total Fixed costs $3,000,000 $2,500,000 $500,000 $1,000,000 Number of units 15,000 4,000 20,000 10,000 If the...
Glacier Bicycle Company manufactures commuter bicycles from recycled materials. The following data for October are available:...
Glacier Bicycle Company manufactures commuter bicycles from recycled materials. The following data for October are available: Quantity of direct labor used 5,000 hrs. Actual rate for direct labor $22.75 per hr. Bicycles completed in October 800 bicycles Standard direct labor per bicycle 6.0 hrs. Standard rate for direct labor $24.00 per hr. a. Determine for October the direct labor rate variance, direct labor time variance, and total direct labor cost variance. Enter a favorable variance as a negative number using...
Direct Labor Variances Glacier Bicycle Company manufactures commuter bicycles from recycled materials. The following data for...
Direct Labor Variances Glacier Bicycle Company manufactures commuter bicycles from recycled materials. The following data for October of the current year are available: Quantity of direct labor used 550 hrs. Actual rate for direct labor $12.80 per hr. Bicycles completed in October 260 bicycles Standard direct labor per bicycle 2 hrs. Standard rate for direct labor $13.10 per hr. a. Determine for October the direct labor rate variance, direct labor time variance, and total direct labor cost variance. Enter a...
Direct labor variance La Batre Bicycle company manufactures commuter bicycles from recycled materials. The following data...
Direct labor variance La Batre Bicycle company manufactures commuter bicycles from recycled materials. The following data for july of the current year are available: Quantity of direct labor used 760 hr Actual rate for direct labor. $11.2 per hr. Bicycles completed in April. 360 bicycles Standard direct labor per bicycle. 2 hrs. standard rate for direct labor. $11.4 per hr. a. Determine the direct labor rate variance, direct labor time variance, and total direct labor cost variance. Enter a favorable...
Direct Labor Variances La Batre Bicycle Company manufactures commuter bicycles from recycled materials. The following data...
Direct Labor Variances La Batre Bicycle Company manufactures commuter bicycles from recycled materials. The following data for July of the current year are available: Quantity of direct labor used 550 hrs. Actual rate for direct labor $13.4 per hr. Bicycles completed in April 260 bicycles Standard direct labor per bicycle 2 hrs. Standard rate for direct labor $13.7 per hr. a. Determine the direct labor rate variance, direct labor time variance, and total direct labor cost variance. Enter a favorable...
Peak Bikes, a national bicycle manufacturing company that specializes in producing off-road bicycles (mountain bikes), has...
Peak Bikes, a national bicycle manufacturing company that specializes in producing off-road bicycles (mountain bikes), has hired you as an outside consultant. Peak Bikes currently has 170 both full-time and part-time employees. The firm’s management is organized as follows: Frontline managers: Oversee bike production and production staff. This is the part of the company that actually manufacturers the bicycles. Middle-level managers: Manage frontline managers, track performance versus company’s goals and strategy, and report to top level managers Top-level managers: Set...
The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle...
The quarterly sales of the TRK-50 mountain bike for the previous four years by a bicycle shop in Switzerland are presented in the table: Year   Quarter   Q = Sales   2010 1 10 2 31 3 43 4 16 2011 1 11 2 33 3 45 4 17 2012 1 13 2 34 3 48 4 19 2013 1 15 2 37 3 51 4 21 PLEASE USE EXCEL AND SHOW ALL WORK. Plot the sales against time. Use the data...
Jon Hoke owns a bicycle shop. He stocks three types of bicycles: road-racing, cross-country and mountain....
Jon Hoke owns a bicycle shop. He stocks three types of bicycles: road-racing, cross-country and mountain. A road-racing bike costs $1,200, a cross-country bike costs $1,700 and a mountain bike costs $900. He sells road-racing bikes for $1,800, cross-country bikes for $2,100 and mountain bikes for $1,200. He has $12,000 available this month to purchase bikes. Each bike must be assembled: a road-racing bike requires 8 hours to assemble, a cross-country bike requires 12 hours and a mountain bike requires...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes Sales $ 927,000 $ 262,000 $ 407,000 $ 258,000 Variable manufacturing and selling expenses 475,000 117,000 200,000 158,000 Contribution margin 452,000 145,000 207,000 100,000 Fixed expenses: Advertising, traceable 69,400 8,200 40,300 20,900 Depreciation of special equipment 44,700 21,000 7,900 15,800 Salaries of product-line managers 114,400...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT