Reference no: EM131919018

You are required to finish each of these questions, total 40 marks. Please give the solutions in detail, show calculations and submit the solutions to Moodle using a single file, it can be Excel format, Word format or PDF format, no requirement on word limits, if use any references, please refer to Harvard style.

Question 1: Designing a new management accounting system

You have just been appointed as the new management accountant to manage the transition of the existing Royal Adelaide Hospital to the proposed new site. The hospital has a number of separate departments responsible for direct patient care, such as Accident and Emergency, Intensive Care, Neurology, and Cardiology, as well as a number of support departments such as Radiology and Patient Records. You are a little uncertain as to what your role will be in this new hospital, as consultants have been engaged to design the new management accounting systems. You thought that as a management accountant you would be responsible for developing the new systems

Required:

1. Write a report to senior management explaining how you, as the management accountant, may contribute to the design and operation of the new management accounting systems for the new hospital.

2. Outline the types of management accounting information that you believe senior managers may require on a regular basis (say, weekly and monthly) to manage the operations of the new hospital. Consider both financial and non-financial information.

3. The new hospital plans to invest in the latest computer technology to run various aspects of the organisation, including the management information systems. Discuss the opportunities that this may present for the way in which you supply weekly and monthly reports to managers.

Question 2: Schedules of cost of goods manufactured and sold; income statement

The following data refer to Flintoff Fashions for the current year:

Sales revenue                                         $570 000

Work in process inventory, 31 December      18 000

Work in process inventory, 1 January          24 000

Selling and administrative expenses             90 000

Income tax expense                                  54 000

Purchases of raw materials                         108 000

Raw material inventory, 31 December            15 000

Raw material inventory, 1 January                24 000

Direct labour                                            120 000

Electricity: plant                                       24 000

Depreciation: plant and equipment               36 000

Finished goods inventory, 31 December        30 000

Finished goods inventory, 1 January            12 000

Indirect material                                       6 000

Indirect labour                                         9 000

Other manufacturing overhead                    48 000

Required:

1 Prepare the schedule of cost of goods manufactured for Flintoff Fashions.

2 Prepare the schedule of cost of goods sold for Flintoff Fashions.

3 Prepare the income statement for Flintoff Fashions.

4 Construct an Excel spreadsheet to solve all the preceding requirements. Include formulas in your spreadsheet wherever possible. Show how both cost schedules and the income statement will change if:

(a) raw material purchases amounted to $110 400.

(b) indirect labour was $9600.

Question 3: Job costing; department overhead cost allocation: tour operator

Asian Adventure Holidays offers a series of holiday packages aimed at families, seniors and corporate groups. The financial controller, Jack Tallis, is preparing for the annual board meeting and is concerned about the loss that the business sustained in the past year. He has examined the profits for each of the three departments of the business-family, seniors and corporate-and it seems that the corporate department is the source of the problem.

Jack has asked you to assist him to look more closely at the three packages offered by the corporate department to see which holiday packages are yielding profits and which are not. The three packages are to Thailand, Malaysia and Indonesia. The sales and direct costs of each corporate package for last year are as follows:

	Bali Adventure	Thailand Discovery	Malaysian Orienteering
Number of packages sold	10	20	10
Number of people per package	5	6	8
Revenue per person	$18 000	$12 000	$14 000
Direct cost per package:
Tour leader	$5 000	$12 000	$9 000
Tour assistant	2 000	3 000	6 000
Air travel	28 000	30 000	32 000
Accommodation	15 000	26 000	24 000
Equipment hire	4 000	0	9 000
Meals	18 000	15 000	8 000

To calculate the profitability of each package, a proportion of the overhead costs of running the corporate department needs to be allocated to the three packages. Jack has suggested that these costs could be allocated to each package in proportion to actual sales revenue. For last year these overhead costs were as follows:

Salaries	$200 000
Phone	2 000
Depreciation on equipment	5 000
Utilities	2 000
Rent and property taxes	9 000
Other department costs	12 000
Total	$230 000

Required:

1. Calculate the profit per package and the total profitability of each of the three corporate packages.

2. Compare the profitability of the three corporate packages.

3. Do you consider that the allocation of the corporate department overhead to packages using actual sales revenue is appropriate? Can you suggest a better method?

4. Suggest what actions the company could take in regard to the three corporate packages.

Question 4: Cost of goods manufactured; overapplied or underapplied overhead; journal entries

Cool Cooking Tools Ltd, manufacturer of gourmet cooking utensils, uses job costing. Manufacturing overhead is applied to production at a predetermined overhead rate of 150 per cent of direct labour cost. Any overapplied or underapplied manufacturing overhead is closed to cost of goods sold at the end of each month.

Additional information:
Page 163
Job SR22, consisting of ceramic spoon rests, was the only job in process on 31 January, with accumulated costs as follows:

Direct material                                $4000

Direct labour                                  2000

Applied manufacturing overhead        3000

Total                                            $9000

Jobs BS67, TR29 and GT108 were started during February.
Direct materials requisitions during February totalled $26 000.
Direct labour cost of $20 000 was incurred during February.
Manufacturing overhead incurred in February was $32 000.

The only job still in process on 28 February was job number GT108, with costs of $2800 for direct material and $1800 for direct labour.

Required:

1 Calculate the cost of goods manufactured for February.

2 Calculate the amount of overapplied or underapplied overhead to be closed to cost of goods sold on 28 February.