Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Lackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college’s comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar’s Department, and the Computer Services Department. The comptroller hascompiled the following data for the year just ended.
Department Annual CostAdmissions ................................................................................................... $ 90,000Registrar ............................................................................................................ 150,000Computer Services ......................................................................................... 320,000
Division Budgeted Budgeted Planned Courses Enrollment Credit Hours Requiring Computer WorkLiberal Arts .............…
Relco Industries recently purchased Arbeck, Inc., a manufacturer of electrical components that the construction industry uses. Roland Ford has been appointed as chief financial officer of Arbeck, and the president of Relco, Martha Sanderson, has asked him to prepare an organizational chart for his department at Arbeck. The chart that Ford has prepared is shown in the figure. Ford believes that the treasurer’s department should include the following employees: assistant treasurer, manager of accounts receivable and four subordinates, manager of investments and three subordinates, and manager of stockholder relations and two subordinates—a total of 13 employees besides the treasurer.The controller’s department should consist of an assistant controller, a manager of general accounting and four subordinates, a manager of fixed asset control and three subordinates, and a manager of cost accounting with four subordinates—a total of 15 employees besides the controller.When Ford presented his…
Delaware Medical Center operates a general hospital. The medical center also rents space and beds to separately owned entities
rendering specialized services, such as Pediatrics and Psychiatric Care. Delaware charges each separate entity for common services,
such as patients' meals and laundry, and for administrative services, such as billings and collections. Space and bed rentals are fixed
charges for the year, based on bed capacity rented to each entity. Delaware Medical Center charged the following costs to Pediatrics
for the year ended June 30, 20x1:
Dietary
Janitorial
Laundry
Laboratory
Pharmacy
Repairs and maintenance
General and administrative
Rent
Billings and collections.
Total
Annual Patient Days
Up to 22,000
22,001 to 26,000
26,001 to 29, 200
Aides
20
25
31
Patient Days
(variable)
$ 580,000
270,000
440,000
320,000
Nurses
10
14
16
220,000
$1,830,000
During the year ended June 30, 20x1, Pediatrics charged each patient an average of $300 per day, had a capacity of 50 beds, and…
Chapter 25 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forwardService department charges In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of 64,560, and the Purchasing Department had expenses of 40,000 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: A. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. B. Using the cost driver information in (A), determine the annual amount of payroll and purchasing costs allocated to the Residential, Commercial, and Government Contract divisions from payroll and purchasing services. C. Why does the Residential Division have a larger support department allocation than the other two divisions, even though its sales are lower?arrow_forwardDelaware Medical Center operates a general hospital. The medical center also rents space and beds to separately owned entities rendering specialized services, such as Pediatrics and Psychiatric Care. Delaware charges each separate entity for common services, such as patients’ meals and laundry, and for administrative services, such as billings and collections. Space and bed rentals are fixed charges for the year, based on bed capacity rented to each entity. Delaware Medical Center charged the following costs to Pediatrics for the year ended June 30, 20x1: Patient Days (variable) Bed Capacity (fixed) Dietary $ 540,000 — Janitorial — $ 71,000 Laundry 240,000 — Laboratory 400,000 — Pharmacy 320,000 — Repairs and maintenance — 33,000 General and administrative — 1,320,000 Rent — 1,570,000 Billings and collections 230,000 — Total $ 1,730,000 $ 2,994,000…arrow_forward
- 70. Which of the following is not among the other reports required to be submitted by government entities to COA? Pre-closing trial balances Schedule showing the regional breakdowns of income and expenses Post-closing trial balance A completed 14-column worksheet in yellow colorarrow_forwardChampionship Sports Inc. operates two divisionsthe Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: The bases to be used in allocating expenses, together with other information, are as follows: a. Advertising expenseincurred at headquarters, allocated to divisions on the basis of usage: Winter Sports Division, 375,000; Summer Sports Division, 715,000. b. Transportation expenseallocated to divisions at a rate of 4.00 per bill of lading: Winter Sports Division, 17,500 bills of lading; Summer Sports Division, 30,500 bills of lading. c. Accounts receivable collection expenseincurred at headquarters, allocated to divisions at a rate of 1.00 per invoice: Winter Sports Division, 25,000 sales invoices; Summer Sports Division, 43,000 sales invoices. d. Warehouse expenseallocated to divisions on the basis of floor space used in storing division products: Winter Sports Division, 60,000 square feet; Summer Sports Division, 90,000 square feet. Prepare a divisional income statement with two column headings: Winter Sports Division and Summer Sports Division. Provide supporting computations for support department allocations.arrow_forwardThe following article appeared in the Wall Street Journal. Washington—The Securities and Exchange Commission staff issued guidelines for companies grappling with the problem of dividing up their business into industry segments for their annual reports. An industry segment is defined by the Financial Accounting Standards Board as a part of an enterprise engaged in providing a product or service or a group of related products or services primarily to unaffiliated customers for a profit. Although conceding that the process is a “subjective task” that “to a considerable extent, depends on the judgment of management,” the SEC staff said companies should consider … various factors … to determine whether products and services should be grouped together or reported as segments. Instructions What does financial reporting for segments of a business enterprise involve? Identify the reasons for requiring financial data to be reported by segments. Identify the possible disadvantages of requiring…arrow_forward
- Delaware Medical Center operates a general hospital. The medical center also rents space and beds to separately owned entities rendering specialized services, such as Pediatrics and Psychiatric Care. Dela-ware charges each separate entity for common services, such as patients’ meals and laundry, and for administrative services, such as billings and collections. Space and bed rentals are fixed charges for the year, based on bed capacity rented to each entity. Delaware Medical Center charged the following costs to Pediatrics for the year ended June 30, 20x1" Patient Days Bed Capacity Dietary ....................................................................... $600,000 — Janitorial .......................................................................— $70,000 Laundry…arrow_forwardDuring the month of July, the Town of Lynton recorded the following information related to purchases: General government Public safety Public works Culture and recreation Total purchase orders and invoices At the end of the month, several purchase orders remained outstanding for all functions except Culture and Recreation. Public Works in particular had a large amount of purchase orders outstanding because it had put in an order for delivery of paving materials to be delivered over the months of July and August. For all but Culture and Recreation, consider the amounts for purchase orders received the same as the actual cost of the items. Req a1 Required a. (1) Prepare the general journal entry to record the issuance of the purchase orders. (2) Show entries in subsidiary ledger accounts. b. (1) Prepare the general journal entries to record the receipt of the goods ordered at the actual cost shown and the related payable. (2) Show entries for the subsidiary ledger accounts including the…arrow_forwardMary Tan is the controller for Duck Associates, a property management company in Portland, Oregon. Each year, Tan and payroll clerk Toby Stock meet with the external auditors about payroll accounting. This year, the auditors suggest that Tan consider outsourcing Duck Associates’ payroll accounting to a company specializing in payroll processing services. This would allow Tan and her staff to focus on their primary responsibility: accounting for the properties under management. At present, payroll requires 1.5 employee positions: payroll clerk Toby Stock and a bookkeeper who spends half her time entering payroll data in the system. Tan considers this suggestion, and she lists the following items relating to outsourcing payroll accounting: a. The current payroll software that was purchased for $4,000 three years ago would not be needed if payroll processing were outsourced. b. Duck Associates’ bookkeeper would spend half her time preparing the weekly payroll input form that is…arrow_forward
- You have been assigned to the audit of Carter Brandon Co (CBC), and you are drafting the audit for payables and accruals for the year ended 31 December 20x7. The company operates from a site in West Wendon. All raw materials are received in the stores and all deliveries are checked to the delivery note and purchase order. The stores supervisor raises a goods received note and is also responsible for raising credit requests if there are any problems with the raw materials delivered.When the purchase ledger department staff receive the purchase invoices, they match them to the relevant goods received notes and purchase orders, and post them to the computerised purchase ledger. Suppliers are paid on the last day of each month. Other payables and accruals consist of tax, wages and other statutory deductions, accruals and time- apportioned expenses such as electricity and telephone.a. Assess the audit work you will carry out to compare suppliers' statements with balances recorded on the…arrow_forwardWhich control activity is the entity implementing when at the end of each month, an HR clerk is reviewing the employees hours for payroll calculation ? Select one: a Independent checks on performance b. Adequate separation of duties c. Physical control over assets and records d. Adequate documents and recordsarrow_forwardQuestion 3: (35 Marks) As the in-charge senior auditor on the audit engagement for JA Tire Manufacturing for the year ended December 31, 2019, you are responsible for auditing the revenue cycle. The manager has instructed you to read JA Tire Manufacturing system provided on the first tab of the Excel file "Appendix 1_JATireSales_Data" before attempting this audit to familiarize yourself with the sales process and the relevant worksheets and terminology. This file contains sales transaction information for the year ended December 31, 2019. JA Tire has four sales divisions within Canada and sells primarily to large tire companies with regional warehouses that subsequently distribute to local retailers. Based on some of the risk assessment procedures already performed, you identified risks related to the fact that salespersons receive a commission on sales to distributors and the commission is calculated on a monthly basis. Your manager has asked you to perform analytical procedures as a…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Operating segments; Author: The Finance Storyteller;https://www.youtube.com/watch?v=8IDQtBn902Q;License: Standard Youtube License