Submission Date: 7th April 2018 before 23.59 pm
Weighting: The assignment is worth 40% of the total unit weight.
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.
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!
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
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.
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:
|Depreciation on equipment||5 000|
|Rent and property taxes||9 000|
|Other department costs||12 000|
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:
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
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.
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.