Analysis of costs for a shipping department
Sales volume has been dropping at Mumford Industries. During this time, the Shipping Department manager has been under severe financial constraints. Most of the Shipping Department’s efforts are related to pulling inventory from the warehouse for each order and performing the paperwork. The paperwork involves preparing shipping documents for each order. Thus, the pulling and paperwork effort associated with each sales order is essentially the same, regardless of the size of the order. The Shipping Department manager has discussed the financial situation with senior management. Senior management has responded by pointing out that because sales volume has been dropping, the amount of work in the Shipping Department also should be dropping. Thus, senior management told the Shipping Department manager that costs should be decreasing in the department.
The Shipping Department manager prepared the following information:
Given this information, how would you respond to senior management?
Want to see the full answer?
Check out a sample textbook solutionChapter 20 Solutions
Financial and Managerial Accounting - CengageNow
- Assume you are the warehouse manager for Vinnies Vinyls, a multi-location business specializing in vinyl records. Vinniess operates under a cost-based transfer structure and the warehouse supplies all stores with the records. The stores can purchase records only from the warehouse, and the warehouse can only sell to Vinnies stores. The manager of the West store has some concerns relating to the stores financial performance and has asked for your help analyzing transfer costs. After calculating the operating income in dollars and the operating income percent, analyze the following financial information to determine costs that may need further investigation. (Hint: it may be helpful to perform a vertical analysis.)arrow_forwardKimball Company has developed the following cost formulas: Materialusage:Ym=80X;r=0.95Laborusage(direct):Yl=20X;r=0.96Overheadactivity:Yo=350,000+100X;r=0.75Sellingactivity:Ys=50,000+10X;r=0.93 where X=Directlaborhours The company has a policy of producing on demand and keeps very little, if any, finished goods inventory (thus, units produced equals units sold). Each unit uses one direct labor hour for production. The president of Kimball Company has recently implemented a policy that any special orders will be accepted if they cover the costs that the orders cause. This policy was implemented because Kimballs industry is in a recession and the company is producing well below capacity (and expects to continue doing so for the coming year). The president is willing to accept orders that minimally cover their variable costs so that the company can keep its employees and avoid layoffs. Also, any orders above variable costs will increase overall profitability of the company. Required: 1. Compute the total unit variable cost. Suppose that Kimball has an opportunity to accept an order for 20,000 units at 220 per unit. Should Kimball accept the order? (The order would not displace any of Kimballs regular orders.) 2. Explain the significance of the coefficient of correlation measures for the cost formulas. Did these measures have a bearing on your answer in Requirement 1? Should they have a bearing? Why or why not? 3. Suppose that a multiple regression equation is developed for overhead costs: Y = 100,000 + 100X1 + 5,000X2 + 300X3, where X1 = direct labor hours, X2 = number of setups, and X3 = engineering hours. The coefficient of determination for the equation is 0.94. Assume that the order of 20,000 units requires 12 setups and 600 engineering hours. Given this new information, should the company accept the special order referred to in Requirement 1? Is there any other information about cost behavior that you would like to have? Explain.arrow_forwardMaglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,237,000 based on production of 290,000 handheld consoles and 100,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $ 1,135,250 $ 411,000 $ 1,546,250 Materials 700,000 671,000 1,371,000…arrow_forward
- Maglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,125,000 based on production of 310,000 handheld consoles and 110,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $ 1,022,250 $ 384,000 $ 1,406,250 Materials 700,000 712,000 1,412,000…arrow_forwardMaglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to Investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1.337,000 based on production of 310,.000 handheld consoles and 95,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home $409,000 696,000 Total $1,671,250 1,476,000 Direct labor $1,262,250 780,000 Materials Management has determined that overhead costs are…arrow_forwardMaglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing. Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,262,000 based on production of 320,000 handheld consoles and 114,000 home consoles. Direct labor and direct materials costs were as follows. Handheld Home Total Direct labor $1,192,500 $385,000 $1,577,500 Materials 780,000 711,000 1,491,000 Management has determined that…arrow_forward
- Asbury Coffee Enterprises (ACE) manufactures two models of coffee grinders. Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $1,929,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Direct materials Direct labor Cost Driver Number of production runs Quality tests performed Shipping orders processed Total overhead Management has determined that overhead costs are caused by three cost…arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $1,902,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Direct materials Direct labor Personal $ 1,437,000 1,020,000 Commercial $ 517,500 565,000 Total $ 1,954,500 1,585,000 Management has determined that overhead costs are caused by three cost drivers. These…arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $2,037,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Personal Commercial Total Direct materials $ 1,445,000 $ 620,000 $ 2,065,000 Direct labor 1,030,000 667,500 1,697,500 Management has determined that overhead costs are caused by three cost…arrow_forward
- Asbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $2,023,500 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Personal Commercial Total Direct materials $ 1,444,200 $ 609,750 $ 2,053,950 Direct labor 1,029,000 657,250 1,686,250 Management has determined that overhead costs are caused by three cost…arrow_forwardAsbury Coffee Enterprises (ACE) manufactures two models of coffee grinders: Personal and Commercial. The Personal grinders have a smaller capacity and are less durable than the Commercial grinders. ACE only recently began producing the Commercial model. Since the introduction of the new product, profits have been steadily declining, although sales have been increasing. The management at ACE believes that the problem might be in how the accounting system allocates costs to products. The current system at ACE allocates manufacturing overhead to products based on direct labor costs. For the most recent year, which is representative, manufacturing overhead totaled $2,145,000 based on production of 30,000 Personal grinders and 10,000 Commercial grinders. Direct costs were as follows: Direct materials Direct labor Personal $ 1,451,400 1,038,000 Commercial $ 702,000 749,500 Total $ 2,153,400 1,787,500 Management has determined that overhead costs are caused by three cost drivers. These…arrow_forwardWithin a company is a (micro)economy that is monitored by the accounting procedures. In terms of the accounts, the various departments "produce" costs, some of which are internal and some of which are direct costs. This problem shows how an open Leontief model can be used to determine departmental costs. The sales department of an auto dealership charges 10% of its total monthly costs to the service department, and the service department charges 20% of its total monthly costs to the sales department. During a given month, the direct costs are $88,200 for sales and $29,400 for service. Find the total costs (in dollars) of each department. (Round your answers to the nearest whole number.) sales department $ service department $arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning