Question

ACC20007 Assignment

Case

Part A

MelSwin is an accounting consultancy firm that provides its services to small, medium and large sized clients. The client size is determined by the number of employees as follows:

	Small sized clients	Medium sized clients	Large sized clients
Number of employees	<50	50 to 100	>100

MelSwin uses a traditional overhead cost driver of “data analysis hours” to estimate the cost of providing its services. Although MelSwin does not operate in a competitive environment, the Finance Manager, Grainne, advocates to use advance costing methods like the activity-based costing. Otto, the CEO, argues that the current method provides an acceptable cost estimation and given the high cost of implementing ABC, it will not beneficial. However, he agreed to hire a university graduate to examine the costs and benefits of implementing ABC. To do so, Mary, a recent Swinburne graduate, has been hired to establish an activity-based costing system. The activities and associated costs are estimated as follows:

Activity	Activity cost	Activity driver	Quantity of activity driver
Visiting small sized clients	45,000	Number of small sized clients	20
Visiting medium sized clients	120,000	Number of medium sized clients	50
Visiting large sized clients	150,000	Number of large sized clients	60
Data collection	200,000	Number of hours	10,000
Data analysis	800,000	Number of hours	20,000
Report Writing	50,000	Number of words	1,000,000
Printing	10,000	Number of papers	50,000
Correcting errors	10,000	Number of errors	50
Total cost	1,385,000

Mary has collected the following information about the average activity usage of three groups of clients:

Activity	small sized client	medium sized client	large sized client
Data collection	55	70	90
Data analysis	120	142	175
Report Writing	5500	7000	9000
Printing	200	320	500
Correcting errors	0.2	0.32	0.5

Mary has also collected the following information about a client, Hawthorn Cabinet, with 60 employees.

Activity	Quantity
Data collection	65
Data analysis	122
Report Writing	6,794
Printing	321
Correcting errors	0

Mary has been asked to prepare a report about the implementation of ABC and answer some relevant questions.

Part B

Mary has also become responsible to prepare cash budgets for the next six months. 15 % of the clients are small sized, 41% medium sized and the rest are large sized.

The patterns of billing receipts for each group of clients are presented as follows:

	Small sized clients	Medium sized clients	Large sized clients
During month of service	30%	30%	20%
During month following service	70%	40%	40%
During second month following service		30%	40%

Estimated billings for the last six months of this year are listed below.

Month	Estimated billings
July	140000
August	130000
September	145000
October	150000
November	180000
December	120000

Estimated cash outflows for the last three months of this year are listed below.

Month	Estimated cash outflows
October	100000
November	140000
December	85000

MelSwin expects to have a cash balance of $50,000 on 1 October and has a policy of maintaining a minimum cash balance of $40,000 at the end of each month.

Mary has been asked to prepare a cash budget report for the next six months including answering some relevant questions.

Question 2

Calculate the average costs for each group of clients using the traditional method used in MelSwin?

Question 3

Calculate the average costs for each group of clients using the activity-based costing?

Question 4

Assume that the direct cost of visiting Hawthorn Cabinet is $2100. Estimate the cost of providing services for this client using both the activity-based costing and the traditional method used by MelSwin?

Question 5

Do you recommend using the activity-based costing at MelSwin? Briefly explain your reason.

Question 66

Prepare a cash budget for the last quarter of the year that includes monthly budgeted cash receipts and payments.

  

Question 7

MelSwin considers an investment to improve its productivity in the future including upgrading software and hardware equipment. Determine the amount of short-term borrowing, if any, necessary on 1 November for that potential investment which requires $350,000 cash on 1 November.

Question 8

The CEO is interested to know the impact of Covid-19 outbreak in their monthly budget considering a likely reduction of 50% in estimated billings from July. In addition, assume that 20% reduction in cash outflows is possible and cash balance will be $5,000 on 1 October and no minimum cash balance is required at the end of each month. . Prepare a cash budget for the last quarter of the year that includes budgeted monthly cash receipts and payments.

Question 9

What percentage reduction in cash outflows will be required in previous question to ensure no monthly cash shortfall will happen in the last quarter of the year.

Answer 1

We are only allowed to answer 1 questions at a time. I am answering the Part B cash Budget and its related questions i.e.   Question 7, Question 8 & Question 9. Please repost the reming question to get the answer for the same.

Question 1 Part B

Question 7

Estimated cash Balance on November 1	$    107,980
Minimum required Cash balance	$      40,000
Excess cash balance	$      67,980
Proposed investment on November 1	$    350,000
Cash Available for investment	$      67,980
Short term borrowings necessary	$    282,020

Question 8

Question 9

In order to ensure that no monthly cash shorfall happens in the last quater, the cash outflow should be reduced by 36%.

The resulting cash budget would be as follows:

Cash Budget for the last quarter of the year
Particulars	October	November	December
Opening Cash	$         5,000	$      11,898	$            390
Add: Collection from billing	$      70,898	$      78,093	$      77,835
Less: Cash Outflow	$      64,000	$      89,600	$      54,400
Closing Cash balance	$      11,898	$            390	$      23,825

For any clarification, please comment. Kindly Up Vote