Required information [The following information applies to the questions displayed below.] National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent Advertising Insurance Total The company occupies 4,000 square feet of a rented building. In prior periods, the company divided the $80,000 of indirect expenses by 4,000 square feet to find an average cost of $20 per square foot, and then allocated indirect expenses to each department based on the square feet it occupied. The company now wants to allocate indirect expenses using the allocation bases shown below. Department Housevares Sporting Total $ 45,000 25,000 10,000 $80,000 Square Feet 2,160 1,840 4,000 Housewares Sporting Allocate $45,000 of rent using square feet occupied Sales $ 190,000 310,000 $500,000 2. Allocate indirect expenses to the two departments. Rent expense is allocated based on square feet occupled. Advertising expense is allocated based on total sales. Insurance expense is allocated based on the value of insured assets. Value of Insured. Assets $ 41,000 59,000 $ 100,000 Square Footage Percent of Total Cost Allocated

Required information [The following information applies to the questions displayed below.] National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent Advertising Insurance Total The company occupies 4,000 square feet of a rented building. In prior periods, the company divided the $80,000 of indirect expenses by 4,000 square feet to find an average cost of $20 per square foot, and then allocated indirect expenses to each department based on the square feet it occupied. The company now wants to allocate indirect expenses using the allocation bases shown below. Department Housevares Sporting Total $ 45,000 25,000 10,000 $80,000 Square Feet 2,160 1,840 4,000 Housewares Sporting Allocate $45,000 of rent using square feet occupied Sales $ 190,000 310,000 $500,000 2. Allocate indirect expenses to the two departments. Rent expense is allocated based on square feet occupled. Advertising expense is allocated based on total sales. Insurance expense is allocated based on the value of insured assets. Value of Insured. Assets $ 41,000 59,000 $ 100,000 Square Footage Percent of Total Cost Allocated

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter25: Segment Income Statement (dept)

Section: Chapter Questions

Problem 1R

See similar textbooks

Similar questions

[The following information applies to the questions displayed below.] National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent $ 45,000 Advertising 25,000 Insurance 10,000 Total $ 80,000 The company occupies 4,000 square feet of a rented building. In prior periods, the company divided the $80,000 of indirect expenses by 4,000 square feet to find an average cost of $20 per square foot, and then allocated indirect expenses to each department based on the square feet it occupied. The company now wants to allocate indirect expenses using the allocation bases shown below. Department Square Feet Sales Value of Insured Assets Housewares 1,840 $ 270,000 $ 49,000 Sporting 2,160 230,000 Total 4,000 $ 500,000 $100,000 2. Allocate indirect expenses to the two departments. Rent expense is allocated based on square feet occupied. Advertising expense is allocated based on total sales. Insurance expense is allocated based on the value of insured…
[The following information applies to the questions displayed below] National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent Advertising Insurance Total $45,000 25,000 10.000 $80,000 The company occupies 4,000 square feet of a rented building. In prior periods, the company divided the $80,000 of indirect expenses by 4,000 square feet to find an average cost of $20 per square foot, and then allocated indirect expenses to each department based on the square feet it occupied. The company now wants to allocate indirect expenses using the allocation bases shown below. Department Sporting Hotal Square Feet 1,400 2,600 4,000 Value of Insured 40,000 $100,000 Problem 22-2A (Algo) Part 1 Required: 1. Allocate indirect expenses to the two departments using the allocation method used in prior periods. Department Square Footage Sparting Total
3
S2.
Subject:- accounting
Arctic Air Inc. manufactures cooling units for commercial buildings. The price and cost of goods sold for each unit are as follows: Category Per Unit Dollar Amount Price $60,000 Cost of goods sold Gross profit 28,000 32,000 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: Budgeted Activity Cost Activity Base $51,500 Number of service requests Activity Customer service Project bidding Engineering support 64,000 Number of bids 110,500 Number of customer design changes Total costs 226,000…
Lalia rents 110,000 square feet of store space for $358,000 per year. The amount of square footage by department is shown below: Department A 45,000 square feet Department B 30,000 square feet Department C 18,000 square feet Department D 17,000 square feet Help allocate the annual rent expense among the four departments on the basis of relative square feet of floor space occupied.
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,950
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.
Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.
Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer 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 categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.
Marks Corporation has two operating departments, Drilling and Grinding, and an office. The three categories of office expenses are allocated to the two departments using different allocation bases. The following information is available for the curfent period: office Expenses Salaries Depreciation Advertising Item Number of employees Net sales Cost of goods sold Multiple Choice O The amount of the advertising cost that should be allocated to Grinding for the current period is: O O $24,400 $68.000 $36.600 $360.000 Total $46,000 27,000 61,000 $81,000. Allocation Basis Number of employees Cost of goods sold Net sales Drilling Grinding Total 1,200 1,800 3,000 $360,000 $540,000 $900,000 $114,000 $186,000 $300,000