Question
6) Based on your findings for a-d above, create the ACTUAL 2018 Income Statement for BRBC using your recommendations. I need help with the questions
6) Based on your findings for a-d above, create the ACTUAL 2018 Income Statement for BRBC using your recommendations.
I need help with the questions 5 and 6
Built Right Bike Company (BRBC) is an established manufacturer of quality bicycles. They manufacture three styles of bicycles.
Bicycle A is a popular racing bicycle primarily sold to dealers in the bicycle racing circuit. Their material is lightweight and durable with detachable joints for easy disassembly and storage. This market has been declining over the past couple years.
Bicycle B is a sturdy leisure bike typically sold to resorts for use by vacationers. This market is stable with regular replacement bikes ordered as well as new resorts and hotel expansions.
Bicycle C is the usual bicycle used by families and children and is the primary bicycle sold by the company outlet store Buy-Right Bike Shop (BRBS).
Budgeted financial Information is provided below.
Operating Budget | ||||
Standard costs | Bicycle A | Bicycle B | Bicycle C | Notes |
Volume in units | 80,000 | 120,000 | 200,000 | |
Per unit: | ||||
Sales price | $ 150 | $ 110 | $ 80 | |
Direct costs: | ||||
Materials | 17 | 10 | 7 | directly related to production volume |
Labor | 21 | 16 | 4 | directly related to production volume |
Subtotal | $ 38 | $ 26 | $ 11 | |
Indirect costs: | ||||
Supplies | 7 | 2 | 1 | directly related to production volume |
Labor | 10 | 8 | 4 | 1/2 varies with direct labor; the rest is fixed |
Supervision | 8 | 3 | 1 | unrelated to production volume |
Energy | 12 | 6 | 4 | 1/2 varies with direct labor; the rest is fixed |
Depreciation | 22 | 7 | 5 | unrelated to production volume |
Head office support | 12 | 6 | 3 | corporate office allocation* |
All other | 11 | 2 | 1 | unrelated to production volume |
Subtotal | 82 | 34 | 19 | |
Total product cost | $ 120 | $ 60 | $ 30 | |
Product-line profitability | $ 30 | $ 50 | $ 50 | |
* This category comprises accounting, IT, H/R, legal, and others supporting the production of this bicycles. | ||||
Allocations were made using multiple drivers. Corporate office budgets are unrelated to production levels. |
Instructions:
Add two new sheets to your Excel workbook: one for BRBC calculations and one for BRBC Income Statement.
1) Compare using process costing, job costing, or activity-based costing to determine the best costing for BRBC.
2) Calculate the profitability of each product line if the volume increases by 10% each.
3) Calculate the profitability of each product line if the volume decreases by 10% each.
4) Explain the results of 1 & 2 above.
5) Based on this information determine the answers to the following:
a) Should BRBC stop making bicycle A? What is the impact of dropping Bike A from the line of products? Assume the other two product lines will not change in volumes or selling prices.
b) Should the price of Bike C be lowered? Consider the volume sold to sister company BRBS at only $52 per bike, which is eliminated when the corporation financial statements are consolidated. What happens if the price to all others is reduced to $75, and an additional 20,000 bikes were sold at this lower price (not counting the intercompany BRBS sales)
c) Should the company change its advertising focus? What would be the impact of increasing Bike C's volume and decrease in Bike A's volume by 10,000 units each? Disregard units sold to sister company BRBS.
d) Should the price of Bike C be lowered with the change to advertising focus? What is the impact if we lower the price of Bike C to $75 and shift advertising focus more to Bike C, potentially decreasing Bike A volume by 10,000 bikes and increasing Bike C volume by 30,000 bikes.
6) Based on your findings for a-d above, create the ACTUAL 2018 Income Statement for BRBC using your recommendations.
Activity based costing | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Bicycle A | Bicycle B | Bicycle C | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sales Price | 150 | 110 | 80 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Variable cost | (56) | (35) | (16) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Profit | 94 | 75 | 64 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Ranked | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
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