Reference no: EM132798853

BTEC Higher National Diploma in Business - Unit 5 Management Accounting Assignment

Learning Outcomes -

LO1. Demonstrating and understanding of management accounting system.

LO2. Appling a range of management accounting techniques.

LO3. Explaining the use of planning tools used in management accounting.

LO4. Comparing ways in which organisations could use management accounting to respond to financial problems.

Assignment Brief and Guidance - Scenario - ABC Co. Ltd. specialises in manufacturing electronic products. The range comprises of 2 products, Personal Computers ('PC') and Video Players ('VP'). The company's products have the data shown below.

The company has adopted the OAR in term of direct labour hour. The total estimated fixed cost and direct hours during the year is $2.4m and 30,000 hours respectively.

The company is planned to manufacture a new product, I-Phone ('IP') with estimated contribution of $600 per unit.

The manager wants to prepare the budgets for the coming January to March, assuming that the company will manufacture only IP to fulfill a confirmed special order for 3,000, 3,000 and 4,000 units for Jan, Feb and March respectively. The only variable cost is direct raw material. To produce one unit of IP, the standard usage of raw material is 2 units at standard price of $70 per unit of IP.

Noted: The Production Department is responsible for the planning, organising and control of the manufacturing process while the Procurement Department is responsible for the purchase of all raw materials.

1. You need to advise the manager the following issues:

- Explain the meaning of management accounting, various management accounting tools and role of management accountants.

- Explain the classification of costs that would help the management decision-making.

- Calculate the unit costs of PC and VP based on absorption costing and marginal costing methods.

- There is a special order for 10,000 units of PC at $1050 per unit: which costing method should be used for the accept or reject decision; calculate the costs using the costing method recommended above;

- Given that direct labour available is limited to 60,000 hours per month, advise the optimum production mix of PC and VP to maximise profit.

- Calculate the break-even units of IP and if the manager is confident that a target profit of $1,200,000 is achievable, what would be the corresponding target units sold.

- Evaluate the proposal to spend an additional $600,000 to promote the IP so that selling price can be increased by $60 per unit to sell 6,300 units per month and discuss the corresponding pricing decisions.

Prepare a proposal to advise the manager who has no management accounting knowledge and background.

2. Give your advice on the following issues:

Part A: Analyse and evaluating ABC's financial performances by using the various management accounting technique, and make the possible recommendations in dealing with the financial problems and the price strategies in revising its price.

Part B: Budgeting Process:

- the major functions of budgeting process

- the advantages and disadvantages in operating a budgetary control system;

Part C: Budgetary Planning:

- whether fixed or flexible budgets should be prepared for the coming January to March

- based on information provided in question, prepare the monthly budgets as follows:

• sales budget
• cash collection budget from sales (assuming 40% of current month sales being paid within the same month with the remaining 60% payable in the following month)
• production budget (assuming monthly production units equals to monthly sales units)
• raw material purchase budget (assuming the company purchases the exact quantity of raw material in each month to meet the monthly production requirement)
• cash payment budget for raw material purchases (assuming payment being made in the month following the month of purchase)

- prepare the monthly cash budget (assuming that the only other item is cash payment of $300,000 in January for the purchase of production equipment and that the projected cash and bank balance as at 1 January is $20,000)

Part D: Budgetary Control:

If the actual purchase and usage of raw material amounted to $435,600 in January, calculate the raw material variance

It is found that the actual purchase price of raw material is $66 per unit and the actual purchase and usage quantity is 6,600 units to produce 3,000 units of IP in January. Compute the raw material price and usage variances to analyse the raw material variance in question

Prepare a cost reconciliation statement reconciling budgeted and actual raw material costs for the month of January

It is discovered that raw material was purchased in January from a new supplier not on the company's approved vendor list. Report your findings to the manager in accordance with the responsibilities of the relevant departments and recommend possible corrective actions for the identified variance.

Part E: Compare ways in using management accounting tools

In addition to the budgeting and variance analysis methods stated above, discuss other possible ways in using management tools to respond to financial problems.

Prepare a proposal to advise the manager.