Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Pls read the case study and do the assignment with 1750 word count.I ll attached the assignment guidance for your reference .

1 answer below »
Pedaltrain Ltd. is a private UK company formed in 2017 by Johnny Miller. The company manufactures a high-tech stationary exercise cycle that is favoured by high grade athletes and serious cycling enthusiasts when they can’t get out on a real bike.
The company prides itself on producing an innovative product that is of excellent quality that enjoys a world-wide reputation with the cycling community.
The business manufactures one model of bicycle but the product can be modified to make the most of online training apps and sessions that are now available on an on-demand basis. The thing that sets all Pedaltrain cycles apart from the other cycles on the market is that a small automatically generated electric shock can be delivered to the rider if their cycling pace slows. This is a truly innovative feature that does not exist on any other cycle in the market and is highly favoured by serious riders.
Due to the high-end nature of the product, the unmodified cycle cu
ently retails at a price of £1,500 and the modified cycle retails at a price of £2,000. Approximately 45% of customers buy the product with the added connectivity while the remaining customers buy the unmodified model.
The variable costs of production for the unmodified cycle are 55% of its selling price whereas for the modified cycle with added connectivity, the variable cost falls to approximately 50% of its selling price.
The stationary training cycle market has a number of key players including Nordictrack and Pelaton to name two, and although Pedaltrain products are seen as premium in the market there are some competitors who adopt different pricing strategies. The competitors’ cycles contain advanced features and innovations but do not have the electric shock feature that Pedaltrain has copyrighted. In addition, Pedaltrain sell their cycle in customisable colours for a truly unique bike!
The factory works a 38 hour week for 48 weeks per year and employs 21 people who are directly involved in the cycle manufacture process on 7 identical production lines. The company prides itself on its machine utilization efficiency but as the majority of the process Is labour driven (welding, assembly, painting), overheads are abso
ed on a labour hour basis. It has been estimated that a cycle can go through the manufacturing process from start to finish in approximately 0.85 hours although there may be some possible delays due to bottlenecks and non value-added activities being incu
ed in the production process along the way. The business estimates that unproductive time is approximately 8% of the time available.
    Statements of profit or loss for the year ended 31st January 2022
    
    Â£â€™000
    Sales revenue
    71,340
    Cost of sales
    46,043
    Gross profit
    25,297
    Administration expenses
    5,350
    Operating profit
    19,947
    Interest
    77
    Profit before tax
    19,870
    Tax
    2,206
    Profit after tax
    17,664
Sales revenue is expected to continue to grow by approximately 5% per year in the future. Approximately 25% of the cost of sales are related to fixed production overheads while the remaining 75% are classed as variable and directly related to output.
The company operates on a small industrial site on the edge of a large town in in the north of England. Due to government incentives the rents and taxation on the profits are favourable but production capacity is limited in terms of the space available. The company feels that it would struggle to increase capacity above its cu
ent level of 50,000 units per year.
Mr. Miller knows that for the company to take control of its costs and increase its capacity it must reduce its non-productive and non-value-added time. Johnny Miller has played a significant role in imposing quite difficult budgets on managers. He has done this by simply making a percentage reduction in budgeted costs from the previous years to represent cost savings that he expects to be achieved. This has caused tension with managers and employees in the organisation.
Due to the pressure placed on targets and cost control by the company Mr. Miller has noticed that employees and managers do not seem quite as motivated as they did in the earlier stages of the company’s life. The directors of the company are proud of their growth and wish to maintain it. They recognise that measuring performance is critical and so are considering the ways that they can improve their performance measurement systems to ensure that they stay ahead in a fast moving industry where competition is fierce.
Required:
Produce a business report to Mr. Miller, in good style, that reports on the following issues:-
a) Calculations on the expected level of sales of each product that you believe need to be made to
eak even. Back this up with further calculations that show risk in terms of margin of safety. Ensure that you clarify any assumptions that you make and fully discuss the results obtained. (Note, that there are several ways that you can calculate
eak even and MoS and you can use a number of these in this section.)
(20 marks)
) Discuss the appropriateness of changing from an absorption costing system to an activity-based costing (ABC) system in order to manage the overhead costs of the business.
(20 marks)
c) Discuss how the present incremental budgeting process may be improved in Pedaltrain to enhance employee motivation and to reduce the possible slack that exists within the budget.
(20 marks)
d) Make suggestions as to whether the price of the cycles should be adjusted in the light of cu
ent market conditions and cu
ent product cost estimates.
(20 marks)
e) Discuss some of the potential drawbacks in using financial performance measures and suggest, with examples, some of the alternative, non-financial measures of performance that could be used in Pedaltrain.
(20 marks)
Word Count – 1750
Answered 27 days After May 10, 2023

Solution

Deblina answered on May 10 2023
21 Votes
PEDALTRAIN COSTING ANALYSIS REPORT
    Executive Summary    
This report discusses the moral issues that are critical to the success of the Pedaltrain Limited. The report includes the calculations of the
eak-even point for the company’s products and an assessment of the effectiveness and appropriateness of the activity-based costing system. Suggestions are being provided to improve are the incremental budgeting processes and the recommendations on the price adjustments along with the potential drawbacks of using the financial performance measures and alternative non-financial measures of performance.
Table of Contents
Introduction    3
Break Even Analysis    3
Activity Based Costing    4
Incremental Budgeting System    5
Cu
ent Market Conditions    6
Potential Drawbacks in Using Financial Performance Measures    6
Conclusion    7
References    8
Introduction
The purpose of this report is to provide recommendations and insights that can help the company to improve its financial performance and achieve it strategic goes. The report is divided into five sections on each of which addresses a specific topic related to the organisation’s financial management. It provides and analysis of the expected level of the sales of each product needed to
eak even and this process in terms of the margin of safety. It also discusses the appropriateness of the changing from an absorption costing system to an activity-based costing system to manage the overhead cost of the business. This also discusses how the present incremental budgeting process may be improved to enhance employee motivation and reduce possible slack. Besides it has also provided suggestions on whether the price of the cycles should be adjusted in the light of the cu
ent market conditions and the cu
ent product cost estimates. Finally, the last section has effectively discussed some of the potential drawbacks in using financial performance measures and suggest some alternative non-financial measures of the performance that could be used in Pedaltrain
Break Even Analysis
The
eak-even point is the level of the sales at which the total revenue equals the total cost resulting in a situation where there is neither a profit nor a loss. To calculate the
eak-even point before need to identify the fixed on the variable cost associated with the production and the sense of each product (Fitriyani, 2020). The fixed cost or those expenses that do not very with the changes in the production of the sales levels such as the rent and salaries while the variable cost that very with the production level such as raw materials and direct labour.
Product A: Fixed Costs: $10,000 Variable Costs: $20 per unit Selling Price: $50 per unit
Product B: Fixed Costs: $15,000 Variable Costs: $25 per unit Selling Price: $60 per unit
Using this information, we can calculate the
eak-even point for each product as follows:
Product A: Break-even Point = Fixed Costs / (Selling Price - Variable Costs) = $10,000 / ($50 - $20) = 400 units
Product B: Break-even Point = Fixed Costs / (Selling Price - Variable Costs) = $15,000 / ($60 - $25) = 375 units.
Margin of Safety Analysis
Product A: Margin of Safety = (Expected Sales - Break-even Point) / Expected Sales = (500 - 400) / 500 = 20%
Product B: Margin of Safety = (Expected Sales - Break-even Point) / Expected Sales = (450 - 375) / 450 = 16.67%
Based on the analysis of the Pedaltrain's cause structure we have estimated the following fixed and variable cost for each product. Most of calculations are based on the aspect that approximately 25% of the cost of sales are related to the fixed production overheads while the remaining 75% are classified as the variable and are directly related to the output. The above calculations are based on the assumptions that the fixed on the variable cost remain constant throughout the sales volume (Akbar et al., 2020). The
eak-even analysis showed that the products require
eak even and the margin of the safety analysis indicates that the modified cycles have a reasonable margin of safety.
Activity Based Costing
Pedaltrain cu
ently uses on absorption...
SOLUTION.PDF

Answer To This Question Is Available To Download