EBK EXCEL APPLICATIONS FOR ACCOUNTING P
4th Edition
ISBN: 8220100456848
Author: SMITH
Publisher: CENGAGE L
expand_more
expand_more
Solutions are available for other sections.
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
A company has two departments, Y and Z that incur delivery expenses. An analysis of the total delivery expense of $17,000 indicates that Dept. Y had a direct expense of $1,800 for deliveries and Dept. Z had no direct expense. The indirect expenses are $15,200. The analysis also indicates that 45% of regular delivery requests originate in Dept. Y and 55% originate in Dept. Z. Departmental delivery expenses for Dept. Y and Dept. Z, respectively, are:
Yozamba Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 20Y7, are as follows:
Tech Support Department
$567,000
Purchasing Department
96,900
Other corporate administrative expenses
590,000
Total corporate expense
$1,253,900
The other corporate administrative expenses include officers’ salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department charges divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows:
Tech Support
Purchasing
Consumer Division
360 computers
1,990 purchase orders
Commercial Division
270
3,710
Total
630 computers
5,700 purchase orders
The service department charges of…
In divisional income statements prepared for Iguana Construction Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll checks, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $62,704, and the Purchasing Department had expenses of $31,860 for the year. The following annual data for the Residential, Commercial, and Government Contract divisions were obtained from corporate records:
Residential
Commercial
GovernmentContract
Sales
$666,000
$883,000
$2,026,000
Number of employees:
Weekly payroll (52 weeks per year)
125
75
80
Monthly payroll
28
39
26
Number of purchase requisitions per year
2,300
1,600
1,500
Using the activity base information in (a), determine the annual amount of payroll and purchasing costs charged back to the Residential, Commercial, and Government Contract divisions from…
Chapter 25 Solutions
EBK EXCEL APPLICATIONS FOR ACCOUNTING P
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
- Championship 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_forwardRelco 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…arrow_forwardPower Sports Company has two divisions, Wholesale and Retail, and two corporate service departments, Tech Support and Accounts Payable. The corporate expenses for the year ended December 31, 20Y7, are as follows: Tech Support Department $1,146,600 Accounts Payable Department 522,000 Other corporate administrative expenses 717,000 Total corporate expense $2,385,600 The other corporate administrative expenses include officers' salaries and other expenses required by the corporation. The Tech Support Department charges the divisions for services rendered, based on the number of computers in the department, and the Accounts Payable Department charges divisions for services, based on the number of checks issued. The usage of service by the two divisions is as follows: Tech Support Accounts Payable Wholesale Division 480 computers 6,100 checks Retail Division 300 11,300 Total 780 computers 17,400 checks The service department charges of the Tech Support…arrow_forward
- eBook Service Department Charges In divisional income statements prepared for Iguana Construction Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll checks, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $46,248, and the Purchasing Department had expenses of $26,840 for the year. The following annual data for the Residential, Commercial, and Government Contract divisions were obtained from corporate records: Residential Commercial GovernmentContract Sales $561,000 $743,000 $1,707,000 Number of employees: Weekly payroll (52 weeks per year) 130 70 75 Monthly payroll 28 39 26 Number of purchase requisitions per year 2,600 1,800 1,700 a. Determine the total amount of payroll checks and purchase requisitions processed per year by each division and the company in total.…arrow_forwardArctic Software Inc. has two product lines. The income statement for the year ended December 31 shows the following: The products, Num 1 and Num 2, are sold in two territories, North and South, as follows: The common fixed expenses are traceable to each territory as follows: The direct expenses of Num 1, 160,000, and of Num 2, 140,000, are not identifiable with either of the two territories. Required: 1. Prepare income statements for the year, segmented by territory and including a column for the entire company. 2. Why are direct expenses of one type of segment report not direct expenses of another type of segment report?arrow_forwardThe following data were summarized from the accounting records for Jersey Coast Construction Company for the year ended June 30, 20Y8: Cost of goods sold: Service department charges: Commercial Division $422,110 Commercial Division $57,560 Residential Division 218,470 Residential Division 37,840 Administrative expenses: Net sales: Commercial Division $76,750 Commercial Division $639,560 Residential Division 78,030 Residential Division 390,130 Prepare divisional income statements for Jersey Coast Construction Company. Jersey Coast Construction CompanyDivisional Income StatementsFor the Year Ended June 30, 20Y8 Commercial Division Residential Division $Net sales $Net sales Cost of goods sold Cost of goods sold $Gross profit $Gross profit Administrative expenses Administrative expenses $Income from operations before service department charges $Income from operations before service department charges…arrow_forward
- For the purpose of process analysis, which of the following measures would be considered an appropriate flow unit for analyzing the main operation of a local accountingfirm? Instructions: You may select more than one answer.a. Number of accountants working each weekb. Number of tax returns completed each weekc. Number of customers with past-due invoicesd. Number of reams of paper received from suppliersarrow_forwardThe following data were summarized from the accounting records for Jersey Coast Construction Company for the year ended June 30, 20Y8: Cost of goods sold: Service department charges: Commercial Division $331,840 Commercial Division $45,250 Residential Division 163,310 Residential Division 28,290 Administrative expenses: Net sales: Commercial Division $60,330 Commercial Division $502,790 Residential Division 58,320 Residential Division 291,620 Prepare divisional income statements for DeSalvo Construction Company. JERSEY COAST CONSTRUCTION COMPANY Divisional Income Statements For the Year Ended June 30, 20Y8 Commercial Division Residential Division $ $ $ $ $ $ $ $arrow_forwardChampionship Sports Inc. operates two divisions—the 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: Sales—Winter Sports Division $34,020,000 Sales—Summer Sports Division 37,584,000 Cost of Goods Sold—Winter Sports Division 20,412,000 Cost of Goods Sold—Summer Sports Division 21,708,000 Sales Expense—Winter Sports Division 5,832,000 Sales Expense—Summer Sports Division 5,184,000 Administrative Expense—Winter Sports Division 3,402,000 Administrative Expense—Summer Sports Division 3,337,200 Advertising Expense 997,000 Transportation Expense 438,200 Accounts Receivable Collection Expense 211,400 Warehouse Expense 3,240,000 The bases to be used in allocating expenses, together with other information, are as follows: Advertising expense—incurred…arrow_forward
- Can I please get help with this question including an explaination of how to categorize?? A review of the accounting records of Baird Manufacturing indicated that the company incurred the following payroll costs during the month of March. Assume the company's financial statements are prepared in accordance with GAAP. Salary of the company president—$75,000. Salary of the vice president of manufacturing—$50,000. Salary of the chief financial officer—$42,000. Salary of the vice president of marketing—$40,000. Salaries of middle managers (department heads, production supervisors) in manufacturing plant—$147,000. Wages of production workers—$703,500. Salaries of administrative personnel—$60,000. Salaries of engineers and other personnel responsible for maintaining production equipment—$133,500. Commissions paid to sales staff—$146,000. Required What amount of payroll cost would be classified as SG&A (selling, general, and administrative) expense? Assuming that Baird made 5,000…arrow_forwardAssume you are a newly appointed accountant in a local fashion Company named Al Rahim clothing Company based in Oman. Currently, the Company has five different departments include Accounting and Finance, Marketing, Human Resources, Information Technology and Sales & Distribution. Managers in each department are given the authority regarding operational decisions, and their performance is measured on the Company’s profit, and all the other employees receive the fixed salary package. You have been asked to answer the following tasks in preparation for the assignment that you will perform internally for the Company. II. Discussion : a. As an accountant of the Al Rahim clothing Company, prepare a report of the Income Statement and Balance Sheet. b. Discuss the differences between the Straight Line Method of Depreciation and Diminishing Balance Method of Depreciation. Give examples.arrow_forwardAssume you are a newly appointed accountant in a local fashion Company named Al Rahim clothing Company based in Oman. Currently, the Company has five different departments include Accounting and Finance, Marketing, Human Resources, Information Technology and Sales & Distribution. Managers in each department are given the authority regarding operational decisions, and their performance is measured on the Company’s profit, and all the other employees receive the fixed salary package. You have been asked to answer the following tasks in preparation for the assignment that you will perform internally for the Company. a. Explain the meaning of Accounting Standards and discuss its main objectives. b. Discuss the difference between Financial Accounting and Management Accounting. c. Discuss the differences between the Straight Line Method of Depreciation and Diminishing Balance Method of Depreciation. Give examples.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
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