Concept explainers
Exercise 24-3
Service department expenses allocated to operating departments P2
The following is a partially completed lower section of a departmental expense allocation spreadsheet for Cozy Bookstore. It reports the total amounts of direct and indirect expenses allocated to its five departments. Complete the spreadsheet by allocating the expenses of the two service departments (advertising and purchasing) to the three operating departments.
Advertising and purchasing department expenses are allocated to operating departments on the basis of dollar sales and purchase orders, respectively. Information about the allocation bases for the three operating departments follows.
Want to see the full answer?
Check out a sample textbook solutionChapter 24 Solutions
Loose Leaf for Fundamentals of Accounting Principles and Connect Access Card
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardChapter 5 Activity-Based Costing and Management Problem 5-57 Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by custom- er type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer catego- ries and their associated annual costs are as follows: Opening and closing accounts Issuing monthly statements Processing transactions Customer inquiries $ 300,000 450,000 3,075,000 0000 Providing automatic teller machine (ATM) services 600,000 Total cost 1,680,000 $6,105,000 Additional data concerning the usage of the activities by the various customers are also provided: Account Balance Low Medium High Number of accounts opened/closed 22,500 4,500 3,000 Number of statements issued 675,000 150,000 75,000 Processing transactions 27,000,000 3,000,000 750,000 Number of telephone minutes 1,500,000 900,000 600,000 Number…arrow_forwardDATA ENVELOPMENT ANALYSIS OUTPUT INPUT STORE LOCATION SALES EBITDA STORE ARE(SQ.FT) #EMPLOYEES 1 A 47,682,116 7,459,291 35,523.00 62.0 2 B 42,612,114 3,880,099 39,493.00 75.00 3 C 44,187,228 4,215,221 39,731.00 79.00 4 D 30,487,610 4,201,924 35,833.00 77.00 5 E 41,535,542 5,182,632 36,552.00 75.00 6 F 24,497,561 3,079,086 37,328.00 61.00 7 G 43,749,818 6,485,312 38,709.00 79.00 8 H 24,081,113 1,820,738 37,827.00 66.00 9 K 44,711,757 6,310,682 35,631.00 66.00 10 L 32,138,829 125,696…arrow_forward
- Please do not give solution in image format thankuarrow_forward(Appendix 4B) Support Department Cost Allocation MedServices Inc. is divided into two operating departments: Laboratory and Tissue Pathology. The company allocates delivery and accounting costs to each operating department. Delivery costs include the costs of a fleet of vans and drivers that drive throughout the state each day to clinics and doctors offices to pick up samples and deliver them to the centrally located laboratory and tissue pathology offices. Delivery costs are allocated on the basis of number of samples. Accounting costs are allocated on the basis of the number of transactions processed. No effort is made to separate fixed and variable costs; however, only budgeted costs are allocated. Allocations for the coming year are based on the following data: Required: 1. Assign the support department costs by using the direct method. (Note: Round allocation ratios to four decimal places.) 2. Assign the support department costs by using the sequential method, allocating accounting costs first. (Note: Round allocation ratios to four decimal places.)arrow_forwarde Preview 4) F3 $ R 01- Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Category Price Cost of goods sold Gross profit F4 Customer service Project bidding Engineering support Total costs In addition, the company incurs selling and administrative expenses of $226,250. The company wishes to assign these costs to its three major customers, Gough Industries, Breen Inc., and The Martin Group. These expenses are related to three major nonmanufacturing activities: customer service, project bidding, and engineering support. The engineering support is in the form of engineering changes that are placed by the customer to change the design of a product. The budgeted activity costs and activity bases associated with these activities are: S⁰5 Activity Number of service requests Number of bids Number of customer design changes Unit volume % Activity 3:0 F5 T Activity-base usage and unit volume information for the…arrow_forward
- Lucia Company has two service departments: Office and Purchasing. Total expenses for the Office is $38,900 and for Purchasing is $38,900. Expenses for the Office are allocated to operating departments based on sales. Expenses for Purchasing are allocated to operating departments based on purchase orders. Department Books Magazines Newspapers Total Sales $ 180,000 108,000 72,000 Purchase Orders 984 600 816 $ 360,000 2,400 Allocate the expenses from (a) the Office and (b) Purchasing to each of the company's three operating departments using the given information.arrow_forwardssarrow_forwardNew Mode Delay Employee A Employee B Employee C Employee D Employee E Employee F Employee G Order Inventory 150 Employee H 306 Employee 15.7 The following table presents the results of using a CAAT tool to interrogate the XYZ Company's ERP system for expenditure cycle activities. It shows the number of times each employee performed a specific task. Maintain Supplier Master Approve Supplier File (Add, Delete, Edit) Receive Inventory Invoices for Payment Pay Suppliers Via EFT Recon Sign Checks Mail Checks cile Bank Account 5 100 100 100 10 10 10 10 425 150 125 400 25 300 REQUIRED Identify three examples of improper segregation of duties and explain the nature of each problem you find. All Bookmasarrow_forward
- Layout Formulas Data Review View Calibri 11 2Wrap Text Paste BIU EEBE E Merge & C Clipboard Font Alignment A54 F. H. 1. Practice Quiz Job Order Costing The information below is for ABC Co.'s first month of operations. The following jobs were begun during the month 9. Number of Direct Job & Products Materials Labor Labor Hours 8. 100 140 $ 1,200 $ 1,100 100 10 11. 101 144 $1,500 $1,500 120 12 13 102 80 $ 1,100 900 80 14 15 103 150 800 $ 1,000 100 16 Indirect 500 700 18 Additional Information: 20 1. Jobs #100, #101 and #102 were completed during the month; Job #103 remained unfinished at the EOM. 2. Other factory overhead incurred during the month amounted to $60, 3. Factory overhead is applied to jobs on the basis of a predetermined rate of $5 per direct labor hour. 24 Required. 1 Prepare the journal entries to record: a. the requisition of materials during the month b. labor incurred during the month c application of factory overhead to jobs d. cost transferred to finished goods…arrow_forward8arrow_forwardQS 22-6 (Algo) Allocating costs to departments LO P2 Macee Store has three operating departments, and it conducts advertising that benefits all departments. Advertising costs are $120,000. Sales for its operating departments follow. Department 1 2 3 Sales $ 267,000 445,000 178,000 How much advertising cost is allocated to each operating department if the allocation is based on departmental sales? Note: Do not round your intermediate calculations. Department 1 Sales Percent of Total Cost Allocated % 2 % 3 % Total %arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Accounting (Text Only)AccountingISBN:9781285743615Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningAccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,