1.
Prepare a segmented income statement for Company S.
1.
Explanation of Solution
Segment reporting: Segment reporting refers to the process of preparing accounting report by segment and for the entire organization. Several organizations prepare segmented income statements to show the income for major segments and for the enterprise as a whole.
Prepare a segmented income statement:
Figure (1)
Working notes:
(1)Calculate the sales revenue for Segment L:
(2)Calculate the sales revenue for Segment R:
(3)Calculate the sales revenue for Segment S:
(4)Calculate the cost of goods sold for Segment L:
(5)Calculate the cost of goods sold for Segment R:
(6)Calculate the cost of goods sold for Segment S:
(7)Sales commissions for Segment L:
(8)Sales commissions for Segment R:
(9)Sales commissions for Segment S:
2.
Find out the weakest-performing store and present an analysis of the probable causes of poor performance.
2.
Explanation of Solution
- Segment S is the weakest segment due to the several factors.
- Segment L and Segment R has greater markups on cost 118% and 100% correspondingly. However, markups on cost for Segment S are only 58%.
- Segment S is the only store which has a sales manager and spends more on advertising than segment L and segment R.
- Segment S is having the lowest gross dollar sales while compared to the other two stores and Segment R’s return on these outlays seems inadequate.
- Segment S’s “other” non-controllable costs are much higher than Segment L and Segment R.
3.
Explain whether CEO should use a store’s segment contribution margin, identify whether the profit margin is controllable by the store manager or a stores’ segment profit margin while evaluation the performance of store manager.
3.
Explanation of Solution
- Incorporation S uses responsibility accounting system wherein, the managers and centers are measured on the basis of items under their control.
- Decision should be made by studying the profit margin controllable by the store, since this is a personnel type of decision making.
- The contribution margin of the segment not include fixed costs under the control of the store manager, in contrast , a profit margin of the segment reflects all traceable costs whether controllable or not.
Want to see more full solutions like this?
Chapter 12 Solutions
Loose-Leaf for Managerial Accounting: Creating Value in a Dynamic Business Environment
- The following information is from Dessert Dynasty. The company runs three stores and the December Income Statement for all stores is shown. A. Find the missing values for retail revenue, ingredients, and operating income. B. Comment on the financial performance of each store. C. Identify a limitation of analyzing the information provided. You may want to consider using Microsoft Excel or another spreadsheet application for the numerical data. This information will be used in a subsequent question.arrow_forwardThe general merchandise retail industry has a number of segments represented by the following companies: For a recent year, the following cost of goods sold and beginning and ending inventories are provided from corporate annual reports (in millions) for these three companies: a. Determine the inventory turnover ratio for all three companies. Round all calculations to one decimal place. b. Determine the number of days sales in inventory for all three companies. Use 365 days and round all calculations to one decimal place. c. Interpret these results based on each companys merchandising concept.arrow_forwardWelcome Inns is a chain of motels serving business travelers in New Mexico and southwest Texas. The chain has grown from one motel several years ago to five motels. In 20x1, the owner of the company decided to set up an internal Accounting Department to centralize control of financial information. (Previously, local CPAs handled each motels bookkeeping and financial reporting.) The accounting office was opened in January 20x1 by renting space adjacent to corporate headquarters in Ruidoso, New Mexico. All motels have been supplied with personal computers and internet access to transfer information to central accounting on a daily basis. The Accounting Department has budgeted fixed costs of 135,000 per year. Variable costs are budgeted at 20 per hour. In 20x1, actual cost for the Accounting Department was 223,000. Further information is as follows: Required: 1. Suppose the total actual costs of the Accounting Department are allocated on the basis of 20x1 sales revenue. How much will be allocated to each motel? 2. Suppose that Welcome Inns views 20x0 sales figures as a proxy for budgeted capacity of the motels. Thus, fixed Accounting Department costs are allocated on the basis of 20x0 sales, and variable costs are allocated according to 20x1 usage multiplied by the variable rate. How much Accounting Department cost will be allocated to each motel? 3. Comment on the two allocation schemes. Which motels would prefer the method in Requirement 1? The method in Requirement 2? Explain.arrow_forward
- The following information is from Daves Sporting Goods. Daves is a Midwest sporting goods store with three regional stores. The August income statement for all stores is shown. A. Comment on the operating income results for each store. B. Now assume the costs allocated from corporate is an uncontrollable cost for each store. How does this change your assessment of each store?arrow_forwardBay Book and Software has two sales departments: Book and Software. After recording and posting all adjustments, including the adjustments for merchandise inventory, the accountant prepared the adjusted trial balance (shown on the next page) at the end of the fiscal year. Merchandise inventories at the beginning of the year were as follows: Book Department, 53,410; Software Department, 23,839. The bases (and sources of figures) for apportioning expenses to the two departments are as follows (rounded to the nearest dollar): Sales Salary Expense (payroll register): Book Department, 45,559; Software Department, 35,629 Advertising Expense (newspaper column inches): Book Department, 550 inches; Software Department, 450 inches Depreciation Expense, Store Equipment (property and equipment ledger): Book Department, 7,851; Software Department, 2,682 Store Supplies Expense (requisitions): Book Department, 205; Software Department, 199 Miscellaneous Selling Expense (volume of gross sales): Book Department, 240; Software Department, 110 Rent Expense and Utilities Expense (floor space): Book Department, 9,000 square feet; Software Department, 7,000 square feet Bad Debts Expense (volume of gross sales): Book Department, 1,029; Software Department, 441 Miscellaneous General Expense (volume of gross sales): Book Department, 364; Software Department, 156 Required Prepare an income statement by department to show income from operations, as well as a nondepartmentalized income statement (using the Total columns) to show net income for the entire company.arrow_forwardCathy’s Classic Clothes is a retailer that sells to professional women in the northeast. The firm leases space for stores in upscale shopping centers, and the organizational structure consists of regions, districts, and stores. Each region consists of two or more districts; each district consists of three or more stores. Each store, district, and region has been established as a profit center. At all levels, the company uses a responsibility-accounting system focusing on information and knowledge rather than blame and control. Each year, managers, in consultation with their supervisors, establish financial and nonfinancial goals, and these goals are integrated into the budget. Actual performance is mea-sured each month.The New England Region consists of the Coastal District and the Inland District. The Coastal District includes the New Haven, Boston, and Portland stores. The Coastal District’s performance has not been up to expectations in the…arrow_forward
- Camila’s Classic Clothes is a retailer that sells to professional women in the northeast. The firm leases space for stores in upscale shopping centers, and the organizational structure consists of regions, districts, and stores. Each region consists of two or more districts; each district consists of three or more stores. Each store, district, and region has been established as a profit center. At all levels, the company uses a responsibility-accounting system focusing on information and knowledge rather than blame and control. Each year, managers, in consultation with their supervisors, establish financial and nonfinancial goals, and these goals are integrated into the budget. Actual performance is measured each month. The New England Region consists of the Coastal District and the Inland District. The Coastal District includes the New Haven, Boston, and Portland stores. The Coastal District’s performance has not been up to expectations in the past. For the month of May, the district…arrow_forwardColleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Incorporated Kate Company Number of orders 4 50 Units per order 3,000 160 Sales returns: Number of returns 2 5 Total units returned 40 120 Number of sales calls 14 3 Colleen sells its products at $280 per unit. The firm’s gross margin ratio is 25%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $600 per visit Order processing 240 per order Deliveries 480 per order Sales returns 270 per return and $6 per unit returned Sales salary 94,000 per month Required: 1. Using customers as the cost objects, classify the activity costs into cost categories (unit-level, batch-level,…arrow_forwardThe following expenses were incurred by a merchandising business during the year. In which expense section of the income statement should each be reported: (a) selling,(b) administrative, or (c) other?1. Advertising expense2. Depreciation expense on store equipment3. Insurance expense on office equipment4. Interest expense on notes payable5. Rent expense on office building6. Salaries of office personnel7. Salary of sales manager8. Sales supplies usedarrow_forward
- Situation: To pump up sales of all brands, Chapman Inc. is moving aggressively to ship extra cases of inventory into distributors’ warehouses and record them as sales, a practice generally known as “trade loading.” Chapman’s president has asked you whether these shipments may be recognized as revenue. Directions: Research the related generally accepted accounting principles and prepare a short memo to the president. Cite your references and applicable paragraph numbers.arrow_forwardSaimdang Co. has the following business rules.1. Customers place many orders during the period2. Each sales order consists of one or more line items of inventory3. Customers are billed twice a month for the purchases that they made during the period4. Customers make payments once a month to settle their accountsRequired: Prepare an entity-relationship diagram (must include entities and cardinalities) for eachbusiness rulearrow_forwardIndicate in the following chart the most likely source of information for each business decision. Use M for managerial accounting information and F for financial accounting information. Business Decision 1. Determine whether to lend to a company 2. Evaluate a purchasing department’s performance 3. Report financial performance to board of directors . 4. Estimate product cost for a new line of shoes 5. Plan the budget for next quarter . 6. Measure profitability of an individual store 7. Prepare financial reports according to GAAP . 8. Determine location and size for a new plantarrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning