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 |
 jeff jeffy answered 2 years agoRelated 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...
A company manufactures mountain bikes, hybrid bikes and road bikes. Each bicycle passes through three departments:...A company manufactures mountain bikes, hybrid bikes and
road bikes. Each bicycle passes through three departments:
fabrication, painting, and final assembly. The total labor hours
available for fabrication are 100, for painting are 120 and for
final assembly are 140. The labor requirements and profit are given
in the following table.
Type
Fabrication (hr)
Painting (hr)
Assembly (hr)
Profit ($)
Mountain
3
5
3
90
Hybrid
4
2
7
110
Road
3
6
3
70
Formulate the linear programming model...
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...
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
720 hrs.
Actual rate for direct labor
$13.6 per hr.
Bicycles completed in April
340 bicycles
Standard direct labor per bicycle
2 hrs.
Standard rate for direct labor
$13.9 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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|