In: Finance
: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
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 SolutionsBianca 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
Latest Questions
ADVERTISEMENT
|