At the Green Tech Company, the cost of the IT support department has always been charged to production departments based upon the number of employees. Recently, feedback from department managers suggests that the number of system tickets submitted might be a better predictor of IT support costs. Total IT support department costs are $250,000. Department Number of Employees AB C 2015080 Number of System Tickets Submitted 15 60 45 If the number of employees is considered the cost driver, what amount of IT support costs will be allocated to Department B?

At the Green Tech Company, the cost of the IT support department has always been charged to production departments based upon the number of employees. Recently, feedback from department managers suggests that the number of system tickets submitted might be a better predictor of IT support costs. Total IT support department costs are $250,000. Department Number of Employees AB C 2015080 Number of System Tickets Submitted 15 60 45 If the number of employees is considered the cost driver, what amount of IT support costs will be allocated to Department B?

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 10P: The management of Hartman Company is trying to determine the amount of each of two products to...

See similar textbooks

Similar questions

The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: Labor-Hours Required(hours/unit) Department Product 1 Product 2 Hours Available A 1.00 0.35 95 B 0.30 0.20 36 C 0.20 0.50 50 Profit contribution/unit $30.00 $15.00 (a) Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. If required, round your answer to two decimal places. Product 1 Product 2 Production (b) In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for…
Objective: Consider that you are an analyst at Regeneron Pharmaceuticals. You need to decide how to allocate administrative overhead costs to Regeneron's main commercial products (Eylea, Dupixent, Kevzara and Praluent). Determine how to appropriately allocate the costs in the table below to each of the commercial products using an allocation methodology of your choice. Department2019 Annual Operating ExpenseTime spent supporting Commercial productsCommercial$200MM100%IT$100MM25%Facilities$150MM0%Finance$25MM20%Human Resources$75MM10% Use the supporting document Net Product Sales of REGN Products to facilitate your analysis. Provide a written summary of how you allocated the overhead costs to each product in an outline of no more than one page. As a starting point, it's recommended that you revisit the material we covered in Chapter 12. Guidance on calculations:Start off with Net Product Sales of REGN Products. Your objective pertains to 2019 expenses, so you should be reviewing 2019…
Chrom Company manufactures two models, the XL and RD. It also has two departments, Assembly and Finishing. The company wants to assign budgeted overhead costs to its two different models to better understand the profitability of each model. The Tableau Dashboard provides data for our analysis. ***My table is wrong, please give me the right answers for it.**
You are employed as a research and development manager for a production company. The chief ex- ecutive officer of the company has asked you to generate costing data to better assist in expansionary planning for the company. You are required to generate costs data from the equation below. C(y)=23y2 +12y+8 assume10
The company is considering using a two-stage cost allocation system and wants to assess the effects on reported product profits. The company is considering using Engineering Hours and Users as the allocation base. Additional information follows. Toot! TiX Total Engineering hours 7,650 5,650 13,300 Users 9,500 17,100 26,600 Engineering – hour related administrative cost $ 114,380 User-related administrative cost $…
The management of Hartman Company is trying to determine the amount of each of two products to produce over the coming planning period. The following information concerns labor availability, labor utilization, and product profitability: a. Develop a linear programming model of the Hartman Company problem. Solve the model to determine the optimal production quantities of products 1 and 2. b. In computing the profit contribution per unit, management does not deduct labor costs because they are considered fixed for the upcoming planning period. However, suppose that overtime can be scheduled in some of the departments. Which departments would you recommend scheduling for overtime? How much would you be willing to pay per hour of overtime in each department? c. Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is 18 in department A, 22.50 in department B, and 12 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. What are the optimal production quantities, and what is the revised total contribution to profit? How much overtime do you recommend using in each department? What is the increase in the total contribution to profit if overtime is used?
Refer to the data in Exercise 7.22. The company has decided to simplify its method of allocating support service costs by switching to the direct method. Required: 1. Allocate the costs of the support departments to the producing departments using the direct method. (Round allocation ratios to four significant digits. Round allocated costs to the nearest dollar.) 2. Using direct labor hours, compute departmental overhead rates. (Round to the nearest cent.)
Refer to the data in Exercise 7.18. When the capacity of the HR Department was originally established, the normal usage expected for each department was 20,000 direct labor hours. This usage is also the amount of activity planned for the two departments in Year 1 and Year 2. Required: 1. Allocate the costs of the HR Department using the direct method and assuming that the purpose is product costing. 2. Allocate the costs of the HR Department using the direct method and assuming that the purpose is to evaluate performance.
Garrell Corporation is conducting a time-driven activity-based costing study in its Customer Support Department. The company has provided the following data to aid in that study: Time-driven activity rate (cost per unit of activity) Activity cost pool: Receiving Calls Resolving Issues Settling Disputes Cost Object Data: Number of calls received Number of issues resolved Number of disputes settled Customer P 31 17 1 $5.46 $8.58 $13.26 Customer Q 21 10 Required: Using time-driven activity-based costing, determine the total Customer Support Department cost assigned to cach customer.
dont uplode images in answer
financial accounting question
Answer in step by step with explanation. Don't use Ai and chatgpt.