
HI6006 Competitive Strategy Editing Service
Delivery in day(s): 4
Cost | Amount ($) |
Payroll | 180,000 |
Employee on costs | 36,000 |
Telephone | 38,000 |
Other Utilities | 22,000 |
Material and supplies | 6,000 |
Depreciation | 6,000 |
Total material handling costs | 288,000 |
The predecessor of Eloise Smith has been using the allocation rate as the percentage of direct material dollar value for the allocation of material handling costs (Bach, et. al 2013). The rate can be calculated as follows:
Material handling rate = Total material handling cost/Total direct material cost
= 288,000/2,880,000 = 10%
| Number of purchase orders | Calculation | Material Handling costs on per purchase order basis |
Government contracts | 80,000 | 80/242*288
| 95,207 |
Commercial products | 156,000 | 156/242*288
| 185,653 |
Marketing | 1,800 | 1.8/242*288
| 2,142 |
Finance and administration | 2,700 | 2.7/242*288 | 3,213 |
Human Resource | 500 | 0.5/242*288 | 595 |
Maintenance | 1,000 | 1/242*288 | 1,190 |
Total | 242,000 |
| 288,000 |
3. As material handling costs are directly proportional to the number of purchase orders for the material, it will be more appropriate cost driver as compared to dollar amount of direct material (Bach, et. al 2013). The dollar amount of direct material allocates more costs to the contracts than justified since the costs related to other departments such as manage finance, administration, marketing; human resources etc. are also covered in the allocated costs to the government contracts and commercial products. The costs related to these departments included in the material handling costs shall be allocated to the respective departments which can be done only through activity based costing using the purchase orders as cost drivers.
4. The difference in the allocated costs to the government contracts by traditional method using percentage of direct material dollar value and new method of using purchase orders as cost driver under activity based costing is calculated as follows:
Government costs as per old method = $200,600
Government contract cost as per new method = $95,207
Difference in government contract cost due to change = $200,600 - $95,207 = $105,393 (Bilousova, 2011).
5.
Forecast | Amount in $ | ||
| Year1 | Year2 | Year3 |
Number of purchase orders | 242000 | 254100 | 266805 |
Government purchase orders | 80,000 | 83853 | 88045.65 |
Commercial purchase orders | 162000 | 170247 | 178759.4 |
Direct material costs | 2880000 | 2952000 | 3025800 |
Material handling costs | 288000 | 295200 | 302580 |
Direct government cost | 46000 | 46000 | 46000 |
Total cost | 3214000 | 3293200 | 3374380 |
Allocation as per old method |
|
|
|
Government contracts | 2006000 | 2066400 | 2118060 |
Commercial contracts | 874000 | 885600 | 907740 |
Allocation as per new method |
|
|
|
Government contracts | 952066.1 | 974160 | 998514 |
Commercial contracts | 1927934 | 1977840 | 2027286 |
Difference |
|
|
|
Government contracts | 1053934 | 1092240 | 1119546 |
(Bilousova, 2011
6. (A)Eloise Smith is a newly hired cost accounting manager and she was asked by the manager of ECM’s government contract unit, Paul jones, to find a more appropriate method of allocating material handling cost with a view to reduce the number of government contracts (Segrest, 2013). This has resulted into ethical conflict as per ethical standards for accounting requires a cost accounting manager to present an independent view while providing services to client organisation. The independence of Eloise smith was affected as Paul jones have asked her to allocate expense as per a different method which is different from what she has selected as per her professional judgement.
(b)To avoid this ethical conflict smith should perform function as per her professional knowledge and judgement. She should use her skills to find out the best possible method of allocation of cost (Segrest, 2013). She should also follow the code of conduct issued for ethical standards issued by appropriate authority.
1. Best option for the Handy Household Products Ltd is to produce 80000 standard units and 100000 commercial units. Profit from standard units before fixed selling and administrative cost will be $ 160000 and from commercial units will be $ 400000. Fixed selling and administration cost is $600000. Overall net loss before tax from the above mentioned combination would be $ 40000. This loss will be the least from all given alternatives. During the first six months company has incurred overall loss of $ 200000. Therefore total loss of company during the year will be $240000. Relevant calculations are shown with the help of following tables (Shkrobot, 2011).
Relevant Cost for first 6 months-
Particular | Standard | Commercial | Total |
Units sold in first 6 months | 100000 | 100000 |
|
Total manufacturing cost ( per unit) | 16 | 19 | 35 |
Variable selling and administration cost | 4 | 7 | 11 |
Total fixed cost( six months) | $ 600000 |
Profit/loss from given alternatives for standard compound-
Standard | |||||
Units sold | 120000 | 100000 | 90000 | 80000 | 50000 |
Selling price per unit | 18 | 20 | 21 | 22 | 23 |
Sales | 2160000 | 2000000 | 1890000 | 1760000 | 1150000 |
Cost of goods sold | 1920000 | 1600000 | 1440000 | 1280000 | 800000 |
Gross profit | 240000 | 400000 | 450000 | 480000 | 350000 |
Selling and Administration cost |
|
|
|
|
|
Variable | 480000 | 400000 | 360000 | 320000 | 200000 |
Profit before fixed S & Distribution cost | -240000 | 0 | 90000 | 160000 | 150000 |
Profit/loss from given alternatives for Commercial compound-
Commercial | |||||
Units sold | 175000 | 140000 | 100000 | 55000 | 35000 |
Selling price per unit | 25 | 27 | 30 | 32 | 35 |
Sales | 4375000 | 3780000 | 3000000 | 1760000 | 1225000 |
Cost of goods sold | 3325000 | 2660000 | 1900000 | 1045000 | 665000 |
Gross profit | 1050000 | 1120000 | 1100000 | 715000 | 560000 |
Selling and Administration cost |
|
|
|
|
|
Variable | 1225000 | 980000 | 700000 | 385000 | 245000 |
Profit before fixed S & Distribution cost | -175000 | 140000 | 400000 | 330000 | 315000 |
(Shkrobot, 2011)
Profit for the last six months from selected best alternatives-
Resulted Profit from best alternative | |||
Particular | Standard | Commercial | Total |
Sales | 1760000 | 3000000 | 4760000 |
Cost of goods sold | 1280000 | 1900000 | 3180000 |
Gross profit | 480000 | 1100000 | 1580000 |
Selling and distribution expense |
|
|
|
Variable | 320000 | 700000 | 1020000 |
Fixed | 221849 | 378151 | 600000 |
Total Selling and distribution expense | 541849 | 1078151 | 1620000 |
Net Profit | -61849 | 21849 | -40000 |
2. Resulted Loss from above mentioned alternative would be $ 135000 for the last six months.
Particular | Standard | Commercial | Total |
Sales | 1150000 | 1225000 | 2375000 |
Cost of goods sold | 800000 | 665000 | 1465000 |
Gross profit | 350000 | 560000 | 910000 |
Selling and distribution expense |
|
|
|
Variable | 200000 | 245000 | 445000 |
Fixed | 290526 | 309474 | 600000 |
Total Selling and distribution expense | 490526 | 554474 | 1045000 |
Net Profit | -140526 | 5526 | -135000 |
A. Resulted loss from the given alternative is $135000. Fixed cost for last six month will be $600000. Since the optimum alternative of selling price for the next six months is resulting in losses for the company, therefore the company shall close its operations. Total fixed cost is exceeding the total contribution earned by company. (Siano, et. al 2010).
B. Following are some of the factors which are to be considered before deciding whether company should close the plant for the last six months or not:
1. Unavoidable fixed cost- If the loss incurred during the last six month exceeds fixed cost during this period than company should shut the business for six months to cover the excess loss.
2. Market behaviour- market behaviour also plays an important role in determining whether to shut business for short period or not. If the demand for the improved productivity during the period is low than it is better to close business during these 6 months.
3. Current losses or profit of organisation.
4. The net profit or loss that can be generated from operating plant
5. Annual capacity and annual production of plant.
6. Savings or decrease in losses due to closure of plant.
7. Shut down cost for the project (Siano, et. al 2010).
1. Yes with the introduction of new fees structure Hawthorn Leisure works will be able to improve cash flow management. Current fees structure of HLW includes membership fees as well as the hourly rate for using tennis court. HLW has eliminated the payment for separate fees for using tennis. Rather club has included such fess into membership fees of club. With such scheme there is a fixed cash flow whether club members uses the tennis court of not. These fees will be paid in five instalments over the financial year (Siano, et. al 2010). Company has also introduced a promotional offer for 2 months in which members can pay reduced membership fees in only one instalment. It is estimated that active members i.e. 45% of total members will opt for this offer. This offer will bring cash inflow in club and it can invest such income in fixed income bearing securities and cash equivalent securities. This will increase the liquidity position of company. It will create a fixed income source for company. This offer will also attract new members in club.
2. Current Fees structure and number of members incompany-
Fees Structure | |
Individual | 45 |
Student | 30 |
Family | 100 |
Members | |
Individual | 500 |
Student | 500 |
Family | 1000 |
Total | 2000 |
Income from membership fees during the year is $137500.
Membership fees | |
Individual | 22500 |
Student | 15000 |
Family | 100000 |
Total | 137500 |
Income from tennis court fees during tennis season is $14625 and during non-season is $3866. Aggregate income from tennis court is $18491. Calculations are shown under given tables-
Season | |||
|
| Non-prime | Prime |
Days |
| 181 | |
Hours |
| 8 | 4 |
Occupancy (%) |
| 55.00% | 95.00% |
Rate/ hour |
| 8 | 12 |
Fees |
| 6371 | 8254 |
Total Fees |
| 14625 |
Off-Season | |||
|
| Non-prime | Prime |
Days |
| 179 | |
Hours |
| 8 | 4 |
Occupancy (%) |
| 30.00% | 30.00% |
Rate/ hour |
| 6 | 6 |
Fees |
| 2578 | 1289 |
Total Fees |
| 3866 |
Total revenue under current arrangement is $155991.
Under new arrangement two new schemes have been introduced. Firstly club has removed the concept of tennis court fees and second club has introduced promotional offers for onetime fees payment at reduced membership fees (Siano, et. al 2010).
Membership fees for current period will be $ 650000. Calculations are as follows-
Fees Structure | |
Individual | 300 |
Family | 500 |
Old Members | |
Individual | 700 |
Family | 700 |
Total | 1400 |
New Members | |
Individual | 300 |
Family | 300 |
Total | 600 |
Feesfor Current Period | |
Individual | 225000 |
Family | 425000 |
Total | 650000 |
It is given that company will receive membership fees for the next financial year during last two months i.e. August and September (Weaver, 2014). Total advance received for next financial year would be $220500.
Individual | |
Total old members | 700 |
Active members (45%) | 315 |
Promotional Fees | 250 |
Total fees | 78750 |
|
|
Family | |
Total old members | 700 |
Active members (45%) | 315 |
Promotional Fees | 450 |
Total fees | 141750 |
1. Total number of days is 360.
2. It is given in the question that 70 % of old members have retained in company and loss of current members will be set off by introduction of new members. Hence it is assumed that 600 members will take membership during the year and they have taken membership after 6 months. Fees for 6 month would be 150 for individual and 250 for family.
3. It is assumed that new members who have taken membership during current year are not active members hence such members are not taken in calculation of advance received from promotional offers by club (Weaver, 2014).
3. A) Following are the key factors that HLW should consider while before doing evaluating new membership plan and structure-
1. Preference of members- HLW should consider whether the new plans will be preferable for the members. Club have increased membership fees with a considerable amount and removed the tennis court fees. This might not be preferable to students as they might not be able to pay such high fees and prefer hourly rate for tennis court and low membership fee.
2. Competitors- Club should evaluate the fees structure of other clubs which are in competition to HLW. It should see that overall fees are not very high as compared to competitors (Weaver, 2014).
3. Questionnaire or interview- During evaluation process HLW should take suggestions from current members through with the help of Questionnaire and personal Interviews. Optional fees structures can be presented before them and most preferred should be selected.
4. Active Partners- Special preference should be given to active partners as they loss of these members can effect reputation of club in market.
5. Effect on sales- HLW should analyse the possible effect of proposed changes on the revenue of company.
B) To obtain a compete evaluation of proposed offers company should conduct cost benefit analysis, changes in cash management practices, working capital management analysis etc.
Following are the types of financial analysis which HLW should prepare-
1. Horizontal analysis-it involves comparison of expected revenue from given proposal with the prior period results. If the expected results are better than prior period than it would be adopted.
2. Vertical Analysis-in this analysis expenses incurred by club will be analysed as percentage of total revenue earned by the club.
3. Multi-company comparison- this type of financial analysis involves expense be expense comparison of financial items with that of other organisations. HLW should compare the financial results of its given proposal with that of other companies in same business.
4. Industry comparison- In this financial analysis company will compare the financial results of itself with that of average results of same industry (Weaver, 2014).
In current scenario the company was not able to get sufficient amount of cash inflows. Cash inflows were distributed all over the year and also as per use of tennis court. Income of the club was not fixed and it was not equally distributed all over the financial year (as income was different during season and off season). In previous scheme HLW received cash in form of membership fees in maximum of five instalments but in proposed scheme club is taking a lump sum payment. With introduction of new fees structure and promotional offer cash flows of HLW has increased and the reserve of cash is also increased. Due to these changes, company had to bring changes inclient managementpractices. HLW should follow following practices during this period-
1. Onetime payment to creditors.
2. Invest in fixed income bearing securities.
3. Investment in highly liquid securities (Weaver, 2014).
1. Bach, S. & Edwards, M.R. 2013;2012;, Managing human resources: human resource management in transition, 5th;Fifth;5; edn, Wiley, Chichester.
2. Bilousova, O.S. 2011, "Financial planning in managing corporate finances to balance the real sector", Marketing ì MenedžmentInnovacìj, vol. 2, no. 3/1, pp. 45-54.
3. Segrest, D.M. 2013, "Integrated fund management: a strategic approach to managing financial resources", Public Management, vol. 95, no. 6, pp. 14.
4. Shkrobot, M.V. 2011, "The essence and foundation of the system for managing financial resources of enterprises", Marketing ì MenedžmentInnovacìj, vol. 2, no. 3/2, pp. 236-240.
5. Siano, A., Kitchen, P.J. & Confetto, M.G. 2010, "Financial resources and corporate reputation: Toward common management principles for managing corporate reputation",Corporate Communications, vol. 15, no. 1, pp. 68-82.
6. Weaver, L. 2014, Managing the Transition to IFRS-Based Financial Reporting: A Practical Guide to Planning and Implementing a Transition to IFRS or National GAAP, 1st edn, John Wiley & Sons Inc, GB.