Calculate cost driver rates for each of the activity areas

Assignment Help Managerial Accounting
Reference no: EM131189082 , Length:

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

This paper talks about how the management can record their financial information for the purposes of decision making. The information that are provided by the accountant to the company is useful to the managers when deciding on the budgeting and estimation of the costs of production or manufacturing.The information available can be is effective when choosing between alternative products, the product that will not costs much to the clients as well as it is profitable to the organization. The information in this paper also will assist the manager of Cinto ltd in forecasting and planning on the three different departments, based on the profits generated by each, and in evaluating the costs drivers so that they can budget for it.

Reference no: EM131189082

Questions Cloud

How do these modifications differ from the 1938 law : Research and identify the salient features of the Fair Labor Standards Act (FLSA). Provide a definition of exempt and nonexempt employees. State at least three criteria that differentiate an exempt and nonexempt employee. Research and discuss the ..
Which hormone stimulates the thirst mechanism most : Which hormone stimulates the thirst mechanism most? Which hormone plays a role in determining the rate of sodium absorption and potassium loss?
What are examples of illusions of control in your daily life : What are examples of "Illusions of Control" in your daily life? In your work life?- How has Doc X MD Funny Feelings helped you recognize and understand Illusion of Control behavior in yourself and others?
What is neutral macroeconomic management : What is "neutral" macroeconomic management? Give one example of neutral fiscal and one example of neutral monetary policy. Which is likely to be more neutral, a tax cut or a change in the discount rate? Why?
Calculate cost driver rates for each of the activity areas : 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
Describe the incentive program of nucor steel : Research and describe the incentive program of Nucor Steel, Inc. Analyze and list the important features of the program. Evaluate its impact on the workforce and the organization. Do you think it has had a positive or a negative influence? Explain..
Evaluate the importance of marketing to two other functions : Discuss and explain how three example business use marketing within their organization to carry out a specific role. For example you could look at how marketing is used to focus on a specific target customer, Evaluate the importance of marketing to t..
Contributed to the recent subprime mortgage crisis : Mortgage-backed securities are believed to have contributed to the recent subprime mortgage crisis. Assess the fairness of this statement, providing a rationale for your reasoning and a recommendation for future use of this type of investment.
Presentation on the company risk management : You have been hired as a consultant and asked to provide a presentation on the company's risk management to the CIO.

Reviews

inf1189082

9/3/2016 6:19:06 AM

My most deepest apreciation of the work all of u put in this task. my assigned essayist made a remarkable showing with regards to assisting with the motivation and the structure of the paper I needed.His work is an excelent uplifting paper.I wish to proceed with the connection with this site as i will require different sorts of papers.Thank u so much and i figure until further notice its all we need to do. With my apreciation and respect.

len1189082

9/1/2016 4:54:20 AM

Hi there. Can you help me with this assignment? How much would you charge me?Find the 2014 gross-margin percentage for each of Cinto’s three market segments - I need the solution as soon as possible.

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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