Calculate the operating profit for each market segment

Assignment Help Accounting Basics
Reference no: EM131193989

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 supermarket chains

Pharmacy chains

Pharmacist-owned single stores

Cinto Ltd

Revenues

$3,708,000

$3,150,000

$1,980,000

$8,838,000

Cost of goods sold

3,600,000

3,000,000

1,800,000

8,400,000

Gross margin

$108,000

$150,000

$180,000

438,000

Other operating costs

 

 

 

301,080

Operating 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 Activity

General supermarket chains

Pharmacy chains

Pharmacist-owned single stores

Total cost of activity 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

Self-stocking (hours)

360

180

100

10,240

 

 

 

 

$301,080

Required-

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

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

3. 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.

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

Reference no: EM131193989

Questions Cloud

Implications for strategic planning related to project : You have been asked to share information with your supervisor as to the potential ways in which the product can be affected by supply, demand, and market equilibrium and the implications for strategic planning related to this project. Apply your u..
Calculate the direction and magnitude of the magnetic : Calculate the direction and magnitude of the magnetic flux density in materials (2) and (3). Assume there are no surface currents on the interfaces.
Describe how a manager who derives satisfaction from income : Describe how a manager who derives satisfaction from both income and shirking allocates a 10-hour day between these activities when paid an annual, fixed salary of $110,000.
Car in the stadium parking lot : After a baseball game, Randy cannot find his car in the stadium parking lot. For the life of him, he cannot remember where he parked. He wanders down row after row for an hour, and then another hour. Eventually, he gives up and calls a cab.
Calculate the operating profit for each market segment : 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
Examples of how you would manage innovation : Determine whether or not innovation is a manageable resource. Provide specific examples of how you would manage innovation or why you believe it is unmanageable.
Calculate the self-inductance per unit length of solenoid : The solenoid carries a current I and has n turns per unit length. Calculate the self-inductance per unit length of the solenoid.
Xample of expressions or labels : What organization metaphors or metal models are at work in your organization? Give example of expressions or labels used in your organization to support your answer.
Write an introductory paragraph on wealth disparity : Write an introductory paragraph which clearly explains the topic,the importance of further research. - The topic is: "Wealth Disparity".-

Reviews

Write a Review

Accounting Basics Questions & Answers

  Budgeted contribution margin per carabiner

What was the budgeted contribution margin per carabiner? What was the actual contribution margin per carabiner?

  In 2009 jed james began planting a vineyard the cost of the

in 2009 jed james began planting a vineyard. the cost of the land preparation labor rootstock and planting were

  Part-1university loan funds can readily be accounted for

part-1university loan funds can readily be accounted for within the general framework applicable to not-for-pro?t

  What effect does this transaction have on revenue or expense

What effect does this transaction have on revenue or expense of the period?

  The requirements to elect s corporation status

1)In 2014, Tony and Rhonda acquired land for $600,000, with Tony furnishing $200,000 and Rhonda $400,000 of the purchase price. Title to the property is listed as equal joint tenancy with right of survivorship.

  A company uses fifo method in its process costing system

a company uses fifo method in its process costing system. all materials are introduced at the beginning of the process

  Customers deliveries are made and the customers are billed

the following events take place at dillons delivery service 1. supplies are ordered from vendors who will deliver the

  Calculate the change in contribution margin to each

word wizard is a publishing company with a number of different book lines. each line has contracts with a number of

  How much was the company return on assets

Lake Coffee Company reported net income of $54,000 and net sales totals $800,000. The company's asset turnover ratio is 4.5 times. How much was the company's return on assets?

  Totals on cash register dials are as follows groceries 200

jan. 3. totals on cash register dials are as follows groceries 200 meats 50 vegetable and fruits 20. note enter the

  For anyone that has or is working with sunsystem accounting

For anyone that has or is working with SunSystem accounting software, could you give me a description of what it is used for?

  Determine the effect of the errors on retained earnings at

In 2016, Winslow International, Inc.'s controller discovered that ending inventories for 2014 and 2015 were overstated by 5,380,000 and 5680.000, respectively. Determine the effect of the errors on retained earnings at January 1, 2016.

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