Calculate cost driver rates for each of five activity areas

Assignment Help Managerial Accounting
Reference no: EM131187635

Task 1: Cost behaviours and cost classifications

Jason Day, financial controller for Nilstrom Industries, was reviewing production cost reports for the year. One type of costs in these reports continued to bother him- fixed manufacturing overhead such as rental cost of the companies' factories, and some of the electricity and other utility costs. This total fixed manufacturing overhead cost had grown sharply in recent years and is now approaching 30% of total manufacturing cost.

There had been much internal debate as how to report this overhead cost, both internally and externally. The Vice President of Operations, Maria Crane, argued that the current approach to these costs of reporting them as a cost of production, just like direct materials and direct labour should continue. She therefore recommended that this cost be identified as manufacturing overhead and reported as part of inventory costs until sold - saying "I'm not a qualified accountant but from my MBA I remember that all manufacturing costs must go to inventory and be expensed only when sold. To be consistent, this approach also needs to be followed for internal reporting."

Day, however, was unsure and thought that perhaps this cost should be reported as an expense of the current period - and that perhaps Maria Crane had a vested interest in not wishing to do so. He was also unsure why Maria had insisted on increasing production recently even though sales demand had fallen. Others argued that fixed manufacturing overhead be reported differently internally than externally. The president finally had to decide the issue and asked each executive to submit a formal opinion on the matter.

Required

Jason Day approaches you as a trusted advisor to draft some advice for him evaluating the arguments as to how the cost should be accounted for both externally in the financial statements and internally for performance evaluation purposes. He is also keen to understand if there could be any reason why Maria Crane chose to build up inventories. Discuss all relevant points of view, but come to a conclusion as to the most appropriate way to account for fixed manufacturing overhead costs.

Task 2: Understanding Overheads

Cinto Ltd, a distributor of special pharmaceutical products, operates at capacity and has three main market segments:

a) General supermarket chains
b) Pharmacy chains
c) Pharmacist-owned single-store pharmacies.

John Best, the new management accountant of Cinto, reported the following data for 2014:

 

 

 

 

 

Cinto Ltd, 2014

General

 

Pharmacist.

 

 

supermarket

Pharmacy

owned

 

 

chains

chains

single stores

Cinto Ltd

Revenues

$3 708 000

$3150 000

$1980 000

$8 838 000

Cost of goods sold

3 600 000

3 000 000

1 800 000

8 400 000

Gross margin

$108000

$150000

$180000

438 000

Other operating costs

 

 

 

301 080

aerating profit

 

 

 

$136 920

For many years, Cinto has used gross margin percentage ((Revenue - Cost of goods sold) ÷ Revenue) to evaluate the relative profitability of its market segments. But John recently attended a seminar on activity-based costing and is considering using it at Cinto to analyse and allocate ‘other operating costs'. He meets with all the key managers and several of his operations and sales staff and they agree that there are five key activities that drive other operating costs at Cinto:

Activity area Cost driver
Order processing Number of customer purchase orders 
Line-item processing Number of line items ordered by customers 
Delivering to stores Number of store deliveries
Cartons shipped to store Number of cartons shipped
Stocking of customer store shelves Hours of shelf-stocking

Each customer order consists of one or more line items. A line item represents a single product (e.g. Nurofen Plus tablets). Each product line item is delivered in one or more separate cartons. Each store delivery entails the delivery of one or more cartons of products to a customer. Cinto's staff stacks cartons directly onto display shelves in customers' stores. Currently, there is no additional charge to the customer for shelf-stocking, and not all customers use Cinto for this activity. The level of each activity in the three market segments and the total cost incurred for each activity in 2014 is shown below:

 

 

 

 

 

Activity-based cost data

 

Activity level

 

 

Cinto 2014

General

 

Pharmacist-

Total cost

 

supermarket

Pharmacy

owned

of activity

Activity

chains

chains

single stores

in 2014

Orders processed (number)

140

360

1 500

$80 000

Line-items ordered (number)

1 960

4 320

15 000

63 840

Store deliveries made (number)

120

360

1 000

71 000

Cartons shipped to stores (number)

36 000

24 000

16 000

76 000

Shelf-stocking (hours)

360

180

100

10 240

 

 

 

 

$301 080

Required

a) Calculate the 2014 gross-margin percentage for each of Cinto's three market segments.

b) Calculate the cost driver rates for each of the five activity areas.

c) Use the activity-based costing information to allocate the $301 080 of ‘other operating costs' to each of the market segments. Calculate the operating profit for each market segment as a dollar number and a percentage of revenues.

d) Comment on the results. What new insights are available with the activity- based costing information?

Task 3: Human aspects of budgeting

Jack Milatic owns three upscale hair salons: Hair Suite I, II and III. Each salon has a manager and 10 stylists who rent space in the salons as independent contractors and who pay a fee of 10% of each week's revenue to the salon as rent. In exchange, they get to use the facility and utilities but must bring their own equipment.

The manager of each salon schedules (budgets) each customer appointment to last an hour, and then allows the stylist 10 minutes between appointments to clean up, rest and prepare for the next appointment. The salons are open from 10 am to 6 pm, so each stylist can serve seven customers per day. Stylists each work five days a week on a staggered schedule, so the salon is open seven days a week. Everyone works on Saturdays, but some stylists have Sunday and Monday off, some have Tuesday and Wednesday off and some have Thursday and Friday off.

Jack Milatic knows that utility costs are rising. Jack wants to increase revenues to cover at least some part of rising utility costs, so he tells each of the managers to find a way to increase productivity in the salons so that the stylists will pay more to the salons. Jack does not want to increase the rental fee above 10% of revenue for fear the stylists will leave, and each salon has only 10 stations, so he feels each salon cannot hire more than 10 full-time stylists.

The manager of Hair Suite I attempts to address the problem by telling the stylists that customers will be scheduled (budgeted) for 40 minute appointments and breaks will be five minutes. This will allow each stylist to add one more customer per day.

The manager of Hair Suite II asks the stylists on a voluntary basis to work one extra hour per day, from 10 am to 7 pm, to add an additional customer per stylist per day.

The manager of Hair Suite III sits down with the stylists and discusses the issue. After considering shortening the appointment and breaks, or lengthening the hours of operation, one of the stylists says: ‘I know we rent stations in your store, but I am willing to share mine. You could hire an eleventh stylist, who will work at whatever station is vacant during our days off. Since we use our own equipment, this will not be a problem for me as long as there is a secure place I can leave my equipment on my days off.' Most of the other stylists agree that this is a good solution.

Required

a) Which manager's style do you think is most effective? Why?

b) How do you think the stylists will react to the managers of salons I and II? If they are unhappy, what actions may they take?

c) In Hair Suite III, if the stylists did not want to share their stations with another party, how else could they find a way to increase revenues?

d) Refer again to the action that the manager of Hair Suite I has chosen. How does this relate to the concept of stretch targets?

Verified Expert

Three questions related to Managerial Accounting has been solved. The first one is a case study that has been analyzed and answered. The second one is related to activity based costing and is practical as well as theoretical.The third one is again case-based discussing human aspects of costing that has been answered as required.

Reference no: EM131187635

Questions Cloud

How much will this account be worth at that time : For the last 19 years, Mary has been depositing $500 in her savings account , which has earned 5% per year, compounded annually and is expected to continue paying that amount.  If Mary closes the account right after she makes the last deposit, how..
Identify main effects and interactions for factorial design : Identify main effects and interactions for the factorial design. Explain if the study has a random sample and/or random assignment. Were there other limitations that were noticed?
What is the purpose of multifunctional teams : Discuss the following topics about performing in a multifunctional team: What is the purpose of multifunctional teams in business decision making? How should decisions be made to obtain the benefits of multifunctional teams
Discuss the advantages associated with the style you chose : Choose one of these techniques to teach the class and describe why you chose the presentation style you did. Discuss the advantages and disadvantages associated with the style you chose.
Calculate cost driver rates for each of five activity areas : He is also keen to understand if there could be any reason why Maria Crane chose to build up inventories. Discuss all relevant points of view, but come to a conclusion as to the most appropriate way to account for fixed manufacturing overhead cost..
Antecedents of target marketing : Antecedents of Target Marketing- discuss antecedents of target marketing as they relate to the video case study on Numi Organic Tea.
What proportion of the variation in listing price : What proportion of the variation in listing price is determined by variation in the square footage?  What proportion of the variation in listing price is due to other factors
Explain how using ashford university library has improved : Explain how using the Ashford University Library has improved your experience in conducting research. For example, you could identify and explain how specific tutorials that you have used have helped improve your ability to conduct research.
What is the solution to this equation : Suppose we have a call option on the square of the stock price. That is the pay-off is What equation does the price of the call option at time t satisfy?

Reviews

inf1187635

9/3/2016 5:38:31 AM

I could read through my solution and I've exceptionally satisfied with the item. You made a great task with regards to!! My expression of remorse for the fit of anxiety. I ought to have known not I've encountered only extraordinary service from this organization. Once more, much obliged for everything. Have an incredible week!

len1187635

8/30/2016 7:43:00 AM

You are required to answer the given three questions. The assignment will need to be submitted electronically through the student portal. The assignment must be completed individually and submitted before the due date to avoid any late penalties - I would like to know how much it would be cost. Thanks

Write a Review

Managerial Accounting Questions & Answers

  A scholarship fund is started on january 1 2000 with an

a scholarship fund is started on january 1 2000 with an initial deposit of 100000 in an account earning i2.08 with

  What would be the total combined direct labor cost

What would be the total combined direct labor cost for the two months? A) $122,752.00B) $120,736.00C) $120,881.60D) $122,606.40

  1 the variable cost of producting one cookie is 075 fixed

1. the variable cost of producting one cookie is 0.75. fixed costs per week are 1000.a. sketch a graph of costs in the

  Demonstrate knowledge of accounting regulatory environment

Demonstrate applied knowledge of the accounting regulatory environment and the accounting and finance processes, systems, concepts and techniques used globally in business practice.

  Distinguish between job costing and process costing

distinguish between job costing and process costing. describe the difficulties associated with each type. what can

  The high growth company last dividend

If High Growth's required rate of return is 13%, what is the company's current stock price?

  Purpose of transfer pricing policies

Calculate the increase or decrease in profits for the three divisions and the company as a whole (four separate computations) if the agreement is enforced. Explain your thought process, comment on the situation, and make a suggestion based on the com..

  Analyze the physical flow for in the doghouse

Analyze the physical flow for In the DoghouseIn the Doghouse produces wooden doghouses with shingled roofs. At the beginning of June, there were 300 units in BWIP with costs of $14,304. During the month, the company completed work on the BWIP and beg..

  Full service station is planning to invest in automatic car

Full Service station is planning to invest in automatic car wash equipment valued at 210,000. the owner estimates that the equipment will increase annual net cash inflows by 40,000. the equipment is  expected to have a 10 year useful life with an est..

  List a possible cause for each variance

Calculate material, labor, and overhead variances. List a possible cause for each variance.

  Prepare a journal entries for each transaction

Considering your result? Which method gives the best picture of the true earning of Jack catering? Why

  Net present value cma adapted lo 3 maybe i should have

net present value cma adapted lo 3 maybe i should have stuck with teaching high school art. no matter what i try i cant

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd