Accounting Assignment

Accounting Assignment

ORDER A PLAGIARISM FREE PAPER NOW

Don't use plagiarized sources. Get Your Custom Essay on
Accounting Assignment
Just from $15/Page
Order Essay

Nusajaya Sdn. Bhd. is preparing budgets for the quarter ending September 30.  Related information is shown as below:

 

  1. Budgeted sales for the next few months are:

 

Month Units
May 15,000
June 20,000
July 30,000
August 40,000
September 50,000
October 35,000
November 25,000

 

 

  1. The selling price is RM12 per unit.

 

  1. All sales are on credit and the collection methods are:
  2. 50% collected in the month of sales
  3. 30% collected in the month following sales
  • 20% collected in two month following sales

 

  1. The management at Nusajaya Sdn. Bhd. determines the ending inventory in units to be equal to 20% of the following month’s budgeted sales.

 

  1. To produce one unit of output, 2 kilograms of direct material are needed.

 

  1. Nusajaya decides to have direct materials on hand at 10,000 kilograms every month

 

  1. Cost of direct material is estimated at RM1.50 per kg.

 

  1. The payment of direct materials is below:
  2. 50% purchases is paid in the month of purchase
  3. 50% purchases is paid in the following month of purchase

 

  1. To produce one unit of output, 0.1 hours of direct labor are required.

 

  1. Nusajaya pays RM8 per hour to its direct labor.

 

  1. All wages are paid at the end of the month.

 

 

  1. Manufacturing is divided into variable and fixed overhead.

 

  1. Variable overhead is applied to each unit of output on the basis of direct labor hours.

 

  1. The variable overhead rate is RM10 per direct labor hour.

 

  1. Fixed overhead is estimated at RM40,000 per month.

 

  1. Ending Finished Goods Inventory is made up from direct material, direct labor and manufacturing Overhead.

 

  1. Cost of Goods Sold is computed based on the unit production cost of RM5.79 per unit.

 

  1. Selling and administrative cost is divided into variable and fixed components.

 

  1. Variable selling and administrative cost is estimated at RM1.50 per unit sold.

 

  1. Fixed selling and administrative cost is estimated at RM50,000 per month, where RM5,000 is the depreciation and it is not a cash expense.

 

  1. Nusajaya has the following cash policy :
  2. Minimum cash balance of RM50,000 is required for every month.
  3. Any deficiency of cash will be covered by loans with repayment in the following month.
  • The interest on loan is charged at 15% per year.
  1. Purchased an equipment in August totalling RM150,000.
  2. Cash balance on 1 July is RM55,000.

 

  1. Nusajaya’s account balances are as follows:

 

RM

Property                                              458,047.50

Equipment                                          150,200 (net)

Ordinary Shares                               500,000

Retained earnings                            335,777.50

 

Required:

 

To prepare the master budget (sales budget up to budgeted Statement of Financial Position) for Nusajaya Sdn. Bhd. for July, August and September.

(GRAND TOTAL : 30)

 

 

 

The following data has been taken from the records of Senkyo Sdn. Bhd.

 

Senkyo Sdn. Bhd.
Comparative Balance Sheet as at 31 December
2014 2015
(RM) (RM)
Assets:
Cash 48,000 33,000
Account receivable 21,000 25,000
Inventory 220,000 195,000
Property, plant and equipment 70,000 70,000
Total assets 359,000 323,000
Liabilities and shareholder’s funds
Current liabilities 62,000 46,000
Non-current liabilities 185,000 180,000
Shareholders’ funds 112,000 97,000
Total liabilities and shareholders’ funds 359,000 323,000
Senkyo Sdn. Bhd.
Comparative Income Statement for the years ended 31 December
2014 2015
(RM) (RM)
Sales 473,000 355,000
Cost of goods sold (240,000) (182,000)
Gross margin 233,000 173,000
Operating expenses (133,000) (121,000)
Interest expenses (15,000) (10,000)
Income tax (30,000) (12,000)
Net income 55,000 30,000

 

 

Required:

 

  1. Using the above information, compute the following ratios for the two years:
  2. Gross profit margin.
  3. Net profit margin before tax.
  • Return on capital employed.
  1. Return on shareholder’s funds.
  2. Long term debt to equity ratio.
  3. Current ratio.
  • Quick ratio.
  • Inventory turnover.
  1. Receivable turnover.
  2. Average collection period.
  3. Average inventory holding period.
  • Non-current assets turnover.

(12)

 

  1. Discuss the qualitative information that may enhance your analysis of the performance of the company.

(3)

 (Total marks : 15)

 

 

TASK 2 Topic 5: Cost-Volume Profit Analysis
Objectives To be able to identify the relevant and irrelevant costs and benefits associated with each feasible alternative with the greatest overall net benefit to aid decision making.
Marks allocated 20 marks

 

Linen Fasterners Sdn. Bhd. makes three different clothing fasteners in its manufacturing facility in Klang.  Data concerning these products is as follows:

 

Velcro Metal Nylon
Normal annual sales volume 100,000 200,000 400,000
Unit selling price (RM) 1.65 1.50 0.85
Variable expense per unit 1.25 0.70 0.25

 

All three products are sold in highly competitive markets, so the company is unable to raise its prices without losing unacceptable numbers of customers.

 

The company has an extremely effective lean production system, so there is no beginning or ending work in process or finished goods inventories.

 

You are required to answer in a contribution income statement format, the following:

 

 

 

  1. What is the company’s overall break-even point in dollar sales?

(4)

  1. Of the total fixed expenses of RM400,000, RM20,000 could be avoided if the Velco product is dropped, RM80,000 if the Metal product is dropped, and RM60,000 if the Nylon product is dropped. The remaining fixed expenses of RM240,000 consist of common fixed expenses such as administrative salaries and rent on the factory building that could be avoided only by going out of business entirely.

 

  1. What is the break-even point in unit sales for each product?

 

  1. If the company sells exactly the break-even quantity of each product, what will be the overall profit of the company?

 

  • If the managers drop the Velcro and Metal products, what will be the overall profit or loss of the company? Explain your result.

 

  1. Prepare a segmented income statement of all three products to prove your answer in (iii) above.

(16)

(Total marks : 20)

 

 

TASK 3 Topic 6: Short Term Decision Making
Objectives To enable the learner to identify relevant and irrelevant costs and benefits associated to assist in decision making.
Marks allocated 15 marks

 

Konstruck Sdn. Bhd. offers three products for the construction industry: blocks, bricks and tiles. The following income statement shows the projected results, by products, for 2015 (in RM thousands) :

 

  Blocks (‘000) Bricks (‘000) Tiles (‘000) Total
Sales revenue RM500 RM800 RM150 RM1450
Less: Variable expenses 250 480 140 870
Contribution margin 250 320 10 580
Less direct fixed expenses:        
    Advertising 10 10 10 30
    Salaries 37 40 35 112
    Depreciation 53 40 10 103
     Total direct expenses 100 90 55 245
Product margin RM 150 RM230 RM(45) RM335
Less: common fixed  expenses       125
Operating income       RM210

 

This is the third consecutive year that the tiles segment is reporting losses. The managing director is considering dropping the product line as it would mean saving RM45,000 by dismissing the line’s supervisor and also eliminating depreciation.

 

  1. Do you agree that the tiles division should be closed based on the above information?

(7)

 

  1. What qualitative factors would need to be considered before a decision on whether to keep or drop a product is adopted?

(6)

 

  1. The marketing manager suggested that if the tile product is dropped, sales and variable costs of blocks would reduce by 10%, and sales and variable costs of bricks by 8% since customers tend to buy all three products together. Hence if the tile product is dropped, customers will buy blocks and bricks elsewhere. Does this mean it is better to keep the tile product line?

(2)

(Total marks : 15)

 

 

TASK 4 Topic 9: Standard Costing and Variance Analysis
Objectives To enable the learner to identify variance analysis and be able to benchmark for the purpose of performance evaluation for organisational efficiency and sustainability.
Marks allocated 20 marks

 

Cahaya Enterprise, a sole proprietor, is a registered contractor with Majlis Perbandaran Kajang (MPK) and operates a residential landscaping business. Besides business from MPK he has a diverse range of clients in the affluent residential areas of Ampang. In an effort to provide quality service, he has concentrated solely on the design and installation of landscaping covering  trees, shrubs, fountains and lighting. With his clients continually requesting additional services, Cahaya Enterprise recently expanded into lawn maintenance, including fertilisation.

 

The following data relate to his first year’s experience with 53 fertilisation upmarket residential clients.  Each residential client required six applications throughout the year and was billed RM40 per application.

 

  • Two applications involved Type A fertiliser, which contains a special ingredient for weed control. The remaining four applications involved Type B fertiliser.
  • Cahaya Enterprise purchased 5,000 kg of Type A fertiliser at RM0.53 per kg and 10,000 kg of Type B fertiliser at RM0.40 per kg. Actual usage amounted to 3,700 kg of Type A and 7,800 kg of Type B.
  • A new part-time employee was hired to spread the fertiliser at the rate of RM11.50 per hour. The employee logged a total of 165 hours at client residences.
  • Based on previous knowledge of his operations and conversations with other landscapers, Cahaya Enterprise established the following standards:
  • Typical hourly rate of landscape personnel: RM9
  • Labour time per application: 40 minutes
  • Fertiliser purchase price per kg: Type A, RM0.50; Type B, RM0.42
  • Fertiliser usage: 40 kg per application

 

Unfortunately, Cahaya Enterprise’s new lawn fertilisation business did not go as smoothly as planned, with customer complaints being much higher than expected.

 

You are required to:

  1. Compute Cahaya Enterprise’s direct material variances (price, quantity and purchase price) for each type of fertiliser.

(11)

  1. Compute the direct labour variances (rate and efficiency).

(4)

  1. Compute the actual cost of the client applications. (Note: exclude any fertiliser in inventory, as  remaining fertiliser can be used next year.)  Was the new service a success?

(1.5)

  1. Analyse the variances you have computed in requirements (a) and (b).
  2. Was the new service a success from an overall cost control perspective? Briefly discuss.
  3. What seems to have happened that would give rise to customer complaints?

(3)

  1. In view of the complaints, should the fertiliser service be continued next year? Why?

(0.5)

(Total marks : 20)

 

(GRAND TOTAL : 70)