Fnsacc507 - provide management accounting information -


WRITTEN QUESTIONS

For questions 1, 2 and 3, refer to the scenario provided below:

A factory producing and supplying automobile parts to local distributors has identified the months of December, January, and February to be the busiest months for orders, deliveries and services, with a sharp decline of orders during the months of April, May, and June.

During the peak months, the factory employs a fixed number of contractual delivery personnel, factory workers, and project-based supervisors, to meet this demand.
For the purpose of this assessment, consider the following elements of production and delivery costs:
a. Factory rent
b. Salary for contractual employees
c. Raw materials purchased
d. Salary for regular employees

1. Describe the cost behaviour characteristics of each of the different cost elements listed below:
Factory Rent
Salary for contractual employees
Raw materials purchased
Salary for regular employees

2. Determine whether the cost being described is a Fixed Cost, a Variable Cost, or a Mixed Cost.

An example of this is office rent expenses.

This cost increases when more units are produced and decreases when fewer units are produced.

These costs will incur even if no units are produced.

An example of this is cost for raw materials.

An example of this is cost for telephone expense.

3. In your own words, briefly explain the following terminologies:
a. Cost Element
b. Cost Behaviour

4. Briefly describe the following principles:
a. Double entry bookkeeping
b. Accrual based accounting

5. List two key features of typical organisational policies and procedures applying to costing systems, and discuss how they apply to organisations using different costing systems.

6. Match the following costing systems to their correct descriptions.
a. Direct Costing
b. Activity-Based Costing
c. Process Costing
d. Operation Costing

It focuses on processes that incur costs and enables management to view costs from the perspective of what causes the cost

The fixed manufacturing overhead is not debited to the work in process account but is written off as an expense in the period within which it is incurred

A hybrid cost accounting system and is suitable for organisations that manufacture batches of similar products

Costs accumulated by each department or step through which the product passes are allocated to inventories according to the number of units completed by each department.

7. Match the following management accounting information to their correct descriptions.
a. Forecast
b. Budget
c. Variance Analysis

This is the comparison of the actual realised expenses with the budgeted expenses.

This is the analysis of past revenue, sales and growth statistics, used to predict outcome of future operations.

This is the allocation of money for the estimated future costs and liabilities.

8. List two key principles of budget preparation and explain how their implementation helps business organisations.

Principle 1

Principle 2

How do these principles help budget preparation?

9. List two examples of best practices in budget preparation and explain how their implementation helps business organisations.

How do these practices help business organisations?

10. Briefly discuss how variance analysis relates to costing system integrity.

11. Describe appropriate system procedures to manage, record and safeguard inventory and materials including:
a. the storage of inventory;
b. the purchase of new materials;
c. the issue of new stock.

PRACTICAL ASSESSMENT

The following exercises involve the calculation and analysis of cost data within a manufacturing and service organisation.

1. Pretori Industries Pty Ltd is a small manufacturing company that does not use a perpetual inventory system. 15,000 units were produced in the month of July. The following information was provided with respect to factory operations for 31 August XXXX:

 

$

Work in process 1/8/XX

9,300

Machine maintenance

800

Depreciation on machinery

1,500

Supervisor's wages

8,500

Wages for machine operators

36,000

Rent for the factory

4,000

Cleaning costs for the factory

800

Purchases of raw materials

70,000

Freight inwards on raw materials

1,800

Stock of raw materials on hand 1/8/XX

7,500

Stock of raw materials on hand 31/8/XX

8,600

Work in process 31/8/XX

5,800

Accrued wages for machine operators

9,000

Electricity

1,200

You are required to:

a) Prepare a manufacturing statement for Pretori Industries Pty Ltd for month of August XX. Assume that all Direct Materials, Direct Labour, and Factory Overheads are added to the Work in Progress Asset account.
b) Calculate the cost per unit for the month for:
a) Direct materials
b) Direct labour
c) Factory overhead
c) Perform a percentage analysis of each element of production based on the cost of production.
d) Prepare the journal entry to record the transfer of the Assets "Work In Progress" (WIP) to the Cost of Goods Sold "Transfers from WIP" account.

2. Montville Products Pty Ltd, a manufacturing company, has the following transactions for the month of April XXXX.

 

 

$

Apr 2

Purchase of materials on credit. GST paid $5,000

55,000

Apr 5

Issue of direct materials to production

34,000

Apr 10

Indirect materials issued to production

4,500

Apr 12

Gross amount of factory payroll paid

46,000

Apr 15

Direct labour incurred

28,000

Apr 18

Indirect labour incurred

18,000

Apr 20

Invoices for factory overhead on credit. GST $3,000

33,000

Apr 23

Accrued telephone factory charges

1,200

Apr 28

Cost of finished goods in April     

95,000

Apr 29

Sales in April on credit. GST collected $14,000

154,000

Apr 29

Goods returned WIP to Raw Materials Inventory

800

Apr 30

??

??

You are required to first discuss this exercise with your supervisor, (Trainer) and then prepare journal entries for these transactions for the month of April in accordance with instructions.

You know an additional transaction occurred on Apr 30, however it is not listed above. Ask your supervisor (trainer) for the missing transaction data.

3. Oswald Lighting Products Pty Ltd has 20 employees. Fifteen (15) employees are employed in the factory and five (5) employees are employed in the administration department. The average wage rate for each factory employee is $23 per hour. The average wage rate for each office worker is $30 per hour. Each factory employee works a 40 hour week and the administration workers work a 37½ hour week. Each employee is entitled to four (4) weeks' annual leave plus 17 ½% loading and two (2) weeks' sick leave per year. The gross factory wages for the month of October are $82,387 made up of the following:

Direct labour $55,200
Direct labour overtime $2,300
Indirect labour $22,500
Annual leave for one factory worker for 2 weeks plus 17½% loading
One day's sick leave for one office worker
Deductions from gross wages are as follows:
PAYG withholding $18,432
Superannuation deductions to Sunsuper $975
Union fees $480

You are required to:
a. Calculate (to the nearest dollar amount) the provision for annual and sick leave for October;
b. Prepare journal entries for:
a. Monthly provision for annual and sick leave for October;
b. Allocations to the work in process and factory overhead accounts (time sheet analysis).
c. Accruals, deductions and payroll clearing (Factory payroll for October).

4. ACI Computer Services has the following income statement for the year ended 30 June XXXX.

 

 

$

Sales

 

900,000

Less cost of goods sold:

 

 

Direct materials

384,000

 

Direct labour

204,000

 

Variable factory overhead

88,000

 

Fixed factory overhead

28,000

704,000

Gross profit

 

196,000

Less operating expenses:

 

 

Selling

 

 

Variable expenses

66,000

 

Fixed expenses

11,040

77,040

Administration

 

118,960

Variable expenses

50,000

 

Fixed expenses

23,200

73,200

Net profit

 

45,760

You are required to:
a) Recast the income statement to determine the contribution margin;
b) Perform cost volume profit ("CVP") analysis to determine the breakeven point e.g. the number of units that must be sold in order to break even and the dollar value at breakeven point if 180, 000 units are produced;
c) Confirm your calculations in (b) are approximately correct by performing a break even analysis using the contribution margin ratio method;
d) What if net profit increased by $30,000, determine the new breakeven point for no of units to be sold;
e) If the new net profit figure is required after tax, calculate the new profit before tax if the company pays tax at the rate of 30%;
f) What is the margin of safety between budgeted sales and break even sales amounts expressed as a percentage?
g) What are three (3) limitations with respect to the assumptions made in cost volume profit ("CVP") analysis?

5. A manufacturer has the following areas of activity, cost drivers and application rates:

Activity area

Cost driver

Application rate

Design of product

Changes to design

$1,000 per change

Materials

No of requisitions

$150 per requisition

Assembly

Machine hours

$100 per machine hrs

Packing

Labour hours

$60 per labour hour

Sales and distribution

No of sales orders

$50 per unit

During an accounting period the following cost driver information is gathered:
No of design changes - 4
No of material requisitions - 40
Machine hours for assembling - 3,000 hours
Labour hours - 1,800 labour hours
Sales orders - 60
If 500 units are produced and using activity based costing ("ABC") calculate:
a) total cost of production;
b) cost per unit for activity level.

6. Below are two costs incurred for two months by a printing company. Identify the cost behaviour for each cost.

Cost

Month

Cost

Units Produced/Delivered

Printing costs

Month 1

$7,004

778

Month 2

$9,306

1,163

Delivery costs

Month 1

$6,080

800

Month 2

$5,168

680

Advertising and marketing costs

Month 1

$5,600

778

Month 2

$5,600

1,163

6.1 Write the letters corresponding to the correct cost behaviour on the space provided:
a. Fixed Cost
b. Variable Cost
c. Mixed Cost
6.2 Explain your answer briefly

7. Pristine Manufacturing produces a product using a process cost system. Information for December XXXX is as follows: 5,000 units were commenced at the beginning of the month and at the end of the month 400 are 50% complete. Costs for the month are:
$
Direct materials250,000
Direct labour182,400
Factory overhead288,000
You are required to prepare a cost of production report for the month of December XXXX to show the physical and equivalent completed units and the allocation of costs to direct materials, direct labour and factory overhead.

8. Medica Express, a medical equipment manufacturing company, presents the following data for 2016 for their hospital beds:

Opening inventory

0 units

Sales

800 units

Production

10,000 units

Closing inventory

200 units

Direct materials

$240

Direct labour

$280

Variable manufacturing overhead expenses

$100

Variable selling and administrative expenses

$40

Fixed manufacturing overhead expenses

$1,200,000

Fixed selling and administrative expenses

$800,000

Compute the unit product cost of one hospital bed using the variable costing system.

Show your solution on the space provided

CASE STUDIES

1. You are employed in the finance section of Marchioness Industries Pty Ltd, a small manufacturing company. Your role is to assist the manager responsible for the performance of the company. This role involves setting budgets, comparing budgeted figures against actual results, calculating and preparing performance reports and performing an overhead analysis. The manager is responsible for ensuring revenues and costs are in accordance with budget estimates (+ or - 5%) and the organisation's business performance objectives.

A summary of budgeted figures for the month of July XXXX is set out below:

Statement of Income
Net sales $438,000, COGS $252,000, Expenses $145,000

Statement of Financial position
Current assets $236,000, Non-current assets $360,000, Current Liabilities $195,000, Non-current liabilities $200,000.

Actual results obtained are as follows:

Statement of Comprehensive Income
Net sales $452,000, COGS $262,000, Expenses $150,000

Statement of Financial position
Current assets $240,000, Non-current assets $364,000, Current Liabilities $205,000, Non-current liabilities $215,000.

Annual budgeted overhead for Marchioness Industries Pty Ltd was $300,000 consisting of $130,000 fixed overhead and $170,000 variable overhead. Budgeted direct labour hours are 5,000 hours. Actual overhead incurred is $295,000 and actual direct labour hours were 5,500.

You are required to:

a) Prepare a statement of income performance report in summary format for the month of July to show variances and variance percentages as a percentage of sales. Calculate variance percentage to two (2) decimal places.

b) Prepare a statement of financial position performance report in summary format showing variances and variance as a percentage of sales. Calculate variance percentage to two (2) decimal places.

c) With respect to the variance analysis you have performed, summarise any amounts that have deviated significantly from the budget and need to be investigated. Why do you think the variance/s occurred?

d) Perform overhead analysis to show the overhead recovery rates and under or over applied overhead. Calculate spending and capacity variances and reconcile amounts with total under or over applied overhead. How effective is the cost assignment process?

e) Prepare a new Statement of Income budget for the month of August based on the information set out below.

Sales figure of $438,000 to be increased by 4%
COGS figure of $252,000 to be increased by 4%
Selling expenses figure of $30,000 increased by 2%
Administration figure of $104,500 increase by 1%
Financial expenses figure$10,500 increased by 1%

The annual budgeted overhead is $295,000 and the budgeted direct labour hours are 5,500. Fixed overhead is $130,000 and variable overhead is $165,000. Calculate the direct overhead recovery rate per hour for variable and fixed overhead.

Attachment:- Assessment.rar

Solution Preview :

Prepared by a verified Expert
Dissertation: Fnsacc507 - provide management accounting information -
Reference No:- TGS02832350

Now Priced at $80 (50% Discount)

Recommended (98%)

Rated (4.3/5)