Question

Part A MelSwin is an accounting consultancy firm that provides its services to small, medium and...

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,952

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, 40% 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.

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

Homework Answers

Answer #1

Activity-based costing is often practiced in the production industry because it improves the security of cost data, originating almost real costs including more beneficial analyzing the costs acquired by the firm while its manufacturing process.

I can say Yes, I recommend practicing the ABC at MelSwin. Because of the total cost of service following ABC-Activity-Based Costing method which is more moderate than the method Traditional Costing.

The traditional method of costing computes a medium overhead price to the direct costs of producing goods and is suitably done during the overhead of a firm is moderately associated with the direct costs of production. ABC-Activity-based costing recognizes each of the particular overhead actions compared to the production of a specific product.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mel Snow is the manager of a firm, Taxation Matters, which specialises in the preparation of...
Mel Snow is the manager of a firm, Taxation Matters, which specialises in the preparation of income tax returns. The firm offers two basic products: the preparation of income tax returns for wage and salary earners, and the preparation of income tax returns for small businesses. Any clients requiring more complex services are referred to Snow’s brother Roger, who is a partner in a large firm of chartered accountants. The processing of wage and salary tax returns is quite straightforward,...
You have been employed by a medium-sized building services engineering firm. One of their potential clients,...
You have been employed by a medium-sized building services engineering firm. One of their potential clients, a property developer and management company which owns a number of commercial and multi-occupancy residential properties, is interested in the potential of Building Management Systems (BMS) to help them save money through better monitoring and control. Before hiring your firm to undertake the design and specification of BMS for their properties, they require further information and would like an example design. LO3: Discuss the...
Urban Elite Cosmetics has used a traditional cost accounting system to apply quality-control costs uniformly to...
Urban Elite Cosmetics has used a traditional cost accounting system to apply quality-control costs uniformly to all products at a rate of 18 percent of direct-labor cost. Monthly direct-labor cost for Satin Sheen makeup is $111,000. In an attempt to more equitably distribute quality-control costs, management is considering activity-based costing. The monthly data shown in the following chart have been gathered for Satin Sheen makeup. Activity Cost Pool Cost Driver Pool Rates Quantity of Driver for Satin Sheen Incoming material...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to small businesses in their local and regional area. NewForm employs 83 people, 61 of whom are IT professionals/ consultants. NewForm is struggling financially; it has not met its revenue projections in the last five quarters. NewForm has suffered excessive leadership turnover in the past three years. The original founders sold NewForm in 2015; one of them, James Stanton, remained on as CHRO but sold...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to...
INTRO NewForm IT is a seven-year-old IT consulting company founded in 2012 that provides services to small businesses in their local and regional area. NewForm employs 83 people, 61 of whom are IT professionals/ consultants. NewForm is struggling financially; it has not met its revenue projections in the last five quarters. NewForm has suffered excessive leadership turnover in the past three years. The original founders sold NewForm in 2015; one of them, James Stanton, remained on as CHRO but sold...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors....
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting...
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas...
Score for this attempt: 69 out of 75 Submitted Apr 10 at 10:59am This attempt took...
Score for this attempt: 69 out of 75 Submitted Apr 10 at 10:59am This attempt took 74 minutes. Question 1 1.5 / 1.5 pts Process manufacturing usually reflects a manufacturer that produces small quantities of unique items.    True Correct!   False Question 2 1.5 / 1.5 pts On a common-sized income statement, all items are stated as a percent of total assets or equities at year-end. Correct!   False     True Question 3 1.5 / 1.5 pts A single plantwide overhead...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater access to the internet has allowed consumers in the region to be a major force in the global digital economy. The expansion looks set to continue at a rapid pace. According to a November 2018 report by Fitch Solutions, e-commerce sales in the region are forecast to increase by 14.2% this year, with an estimated average annual increase of 14% over the medium term...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT