Part A
1.
|
Particular |
practical flat |
classic high heel |
|
|
Revenue |
$ 480,450.00 |
$ 408,170.00 |
$ 418,660.00 |
|
Less: Expenses |
|||
|
Upper (Mesh) |
$ 19,320.00 |
$ 36,300.00 |
$ 17,280.00 |
|
Upper (Leather) |
$ 48,300.00 |
$ 60,500.00 |
$ 48,000.00 |
|
Sole (Rubber) |
$ 104,650.00 |
$ 4,840.00 |
$ 7,680.00 |
|
Sundry direct material |
|||
|
Contact cement and glue |
$ 2,576.00 |
$ 2,178.00 |
|
|
Nails, tacks and glue |
$ 1,920.00 |
||
|
Labour cost |
|||
|
Machine operators |
$ 144,900.00 |
$ 145,200.00 |
$ 144,000.00 |
|
Total prime cost |
$ 319,746.00 |
$ 249,018.00 |
$ 218,880.00 |
|
Margin |
$ 160,704.00 |
$ 159,152.00 |
$ 199,780.00 |
|
Less: Other expenses |
|||
|
Overhead expenses |
$ 66,483.53 |
$ 51,026.87 |
$ 56,737.07 |
|
Operating profit/Contribution |
$ 94,220.47 |
$ 108,125.13 |
$ 143,042.93 |
|
Contribution per unit |
$ 29.42 |
$ 45.03 |
$ 75.17 |
|
Contribution Margin |
20% |
26% |
34% |
|
Selling and administrative cost |
|||
|
Advertising cost |
$ 853.34 |
$ 639.67 |
$ 506.99 |
|
Administrative staff salaries |
$ 36,203.70 |
$ 27,208.99 |
$ 21,587.30 |
|
Selling staff salaries |
$ 16,213.40 |
$ 12,153.72 |
$ 9,632.88 |
|
Other expenses |
$ 2,069.34 |
$ 1,551.20 |
$ 1,229.46 |
|
Total selling and admin cost |
$ 55,339.78 |
$ 41,553.59 |
$ 32,956.63 |
|
Gross profit |
$ 38,880.69 |
$ 66,571.54 |
$ 110,086.30 |
|
Gross profit margin |
8% |
16% |
26% |
(a) From the above calculation it can be seen from the gross profit that Classic High heel is the most profitable as the gross profit margin of that product is 26% as compared to the 16% for Practical flat and 8% for casual sneaker.
(b) Contribution margin per unit for Casual sneaker is $29.42, for Practical flat is $ 45.03 and Classic high heel is $ 75.17. Therefore, Classic high heel is more profitable.
(c )
|
Previous Revenue |
$ 1,307,280.00 |
|
Previous profit |
$ 215,538.52 |
|
Profit margin |
16% |
|
Revised revenue |
$ 826,830.00 |
|
Previous profit |
$ 176,657.83 |
|
Savings in cost |
|
|
Production supervisor cost |
$ 18,000.00 |
|
Warranty cost |
$ 585.00 |
|
consumables |
$ 5,100.00 |
|
Insurance |
$ 612.50 |
|
Utilities |
$ 2,085.00 |
|
Total savings |
$ 26,382.50 |
|
Revised profit |
$ 203,040.33 |
|
Profit margin |
25% |
It can be seen from the above table that if the least profitable unit is discontinued to improve the profitability, then the profit will increase from 16% to 25%
|
Particular |
casual sneaker |
practical flat |
classic high heel |
|
Total fixed expenses |
$ 55,339.78 |
$ 41,553.59 |
$ 32,956.63 |
|
Contribution margin per item |
$ 29.42 |
$ 45.03 |
$ 75.17 |
|
Break-even unit |
1881.26 |
922.73 |
438.45 |
|
Particular |
casual sneaker |
practical flat |
classic high heel |
|
Revenue |
$ 480,450.00 |
$ 408,170.00 |
$ 418,660.00 |
|
Less: Expenses |
|||
|
Upper (Mesh) |
$ 19,320.00 |
$ 36,300.00 |
$ 17,280.00 |
|
Upper (Leather) |
$ 48,300.00 |
$ 60,500.00 |
$ 48,000.00 |
|
Sole (Rubber) |
$ 104,650.00 |
$ 4,840.00 |
$ 7,680.00 |
|
Sundry direct material |
|||
|
Contact cement and glue |
$ 2,576.00 |
$ 2,178.00 |
|
|
Nails, tacks and glue |
$ 1,920.00 |
||
|
Labour cost |
|||
|
Machinbe operators |
$ 144,900.00 |
$ 145,200.00 |
$ 144,000.00 |
|
Total prime cost |
$ 319,746.00 |
$ 249,018.00 |
$ 218,880.00 |
|
Margin |
$ 160,704.00 |
$ 159,152.00 |
$ 199,780.00 |
|
Less: Other expenses |
|||
|
Overhead expenses |
$ 66,483.53 |
$ 51,026.87 |
$ 56,737.07 |
|
Operating profit/Contribution |
$ 94,220.47 |
$ 108,125.13 |
$ 143,042.93 |
|
Contribution per unit |
$ 29.42 |
$ 45.03 |
$ 75.17 |
|
Contribution Margin |
20% |
26% |
34% |
|
Selling and administrative cost |
|||
|
Adverising cost |
$ 853.34 |
$ 639.67 |
$ 506.99 |
|
Administrative staff salaries |
$ 36,203.70 |
$ 27,208.99 |
$ 21,587.30 |
|
Selling staff salaries |
$ 16,213.40 |
$ 12,153.72 |
$ 9,632.88 |
|
Other expenses |
$ 2,069.34 |
$ 1,551.20 |
$ 1,229.46 |
|
Total selling and admin cost |
$ 55,339.78 |
$ 41,553.59 |
$ 32,956.63 |
|
Gross profit |
$ 38,880.69 |
$ 66,571.54 |
$ 110,086.30 |
|
Gross profit margin |
8% |
16% |
26% |
|
Accountant fees |
$ 340.74 |
$ 256.08 |
$ 203.17 |
|
depreciation |
|||
|
office equipment |
$ 745.37 |
$ 560.19 |
$ 444.44 |
|
Office furniture |
$ 340.74 |
$ 256.08 |
$ 203.17 |
|
rent for office |
$ 6,388.89 |
$ 4,801.59 |
$ 3,809.52 |
|
Salaries executive managemner |
$ 34,074.07 |
$ 25,608.47 |
$ 20,317.46 |
|
Total other expenses |
$ 41,889.81 |
$ 31,482.41 |
$ 24,977.78 |
|
Net profit/(Loss) |
$ (3,009.13) |
$ 35,089.13 |
$ 85,108.52 |
Total profit = 117,188.52
Required profit = 150,000
More profit required = $ 26,793.23
As the Classic high heel item is more profitable, then the company shall opt for producing more this tem to achieve the shortfall of profit amounted to $ 26,793.23. Therefore, the sale shall be increased by = $ 26,793.23/$ 220 = 121.79 or 122 numbers.
The management accounting techniques assist the business leaders to measure and increase the level of profit with minimization of operating costs (Liu & Santos, 2015). The scope of the analytical technique is large and covers the certification value for the accounting organization. Among various techniques for management accounting the one that Maryon can use is the break-even analysis (Morano & Tajani, 2017).
The break-even analysis enables the member of the management to assess how much the for a product or service they require to sell to cover the operating costs and turn into the profit. This includes the calculation of expected sales volume with fixed costs and variable cost. Though the measurement calculation is simple, determination of fixed cost and variable cost requires careful analysis. Insurance, administration cot and rent are among the crucial expenses that are needed to be taken into consideration. However, if the break-even analysis is performed properly then it will assist the management is forecasting the profit budget with the expected expenditures (Lee et al., 2017).
This approach is perfect for Maryon as they deal with various items that has various profit margin and costs. Therefore, to assess the profitability of each product, the break-even analysis of each product is necessary to forecast the cost and profit (Hatch et al., 2017).
If the cost and profit can be analysed in better way then it will definitely add value to the business as the owner will be able to analyse which product is to continue an dwhich is required to be discontinued.
References
Hatch, M. D., Daniels, S. D., Glerum, K. M., & Higgins, L. D. (2017). The cost effectiveness of vancomycin for preventing infections after shoulder arthroplasty: a break-even analysis. Journal of Shoulder and Elbow Surgery, 26(3), 472-477.
Lee, M., Hong, T., Koo, C., & Kim, C. J. (2017). A break-even analysis and impact analysis of residential solar photovoltaic systems considering state solar incentives. Technological and Economic Development of Economy, 1-25.
Liu, J., & Santos, G. (2015). Decarbonizing the road transport sector: Break-even point and consequent potential consumers’ behavior for the US case. International Journal of Sustainable Transportation, 9(3), 159-175.
Morano, P., & Tajani, F. (2017). The break-even analysis applied to urban renewal investments: A model to evaluate the share of social housing financially sustainable for private investors. Habitat International, 59, 10-20.
