9 cesMillard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distributes themin the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales staff.The company has been experiencing losses for many months. In an effort to improve performance, management has requested thatthe monthly income statement be segmented by sales region. The company's first effort at preparing a segmented income statementfor May is given below.SalesRegional expenses (traceable):Cost of goods soldAdvertisingSalariesUtilitiesDepreciationShipping expenseTotal regional expensesRegional income (loss) before corporate expensesCorporate expenses:Advertising (general)General administrative expenseVariable expenses:Total CompanyAmountWest$ 313,000%98,000104,00053,0008,90019,00013,000295,90017,100Sales RegionCentral$ 797,000West244,000237,00053,00016,00034,00027,00014,00040,00019,00019,00033,00059,000$ (15,900) $ 127,000Amount611,000186,000Total corporate expensesNet operating income (loss)The cost of goods sold and shipping expense are both variable. All other costs are fixed.Required:3. Prepare a new contribution format segmented income statement for May. (Round percentage answers to 1 decimal place.)East$ 696,000%311,000245,000110,00013,70029,00037,000745,700(49,700)35,00019,00054,000$ (103,700)CentralAmount%AmountEast%

Introduction:-A contribution segment format income statement is a type of income statement that…

Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distribute: in the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales st The company has been experiencing losses for many months. In an effort to improve performance, management has requested the monthly income statement be segmented by sales region. The company's first effort at preparing a segmented income stat for May is given below. Sales Regional expenses (traceable): West $ 313,000 Sales Region Central $ 797,000 East $ 696,000

Millard Corporation is a wholesale distributor of office products. It purchases office products from manufacturers and distribute: in the West, Central, and East regions. Each of these regions is about the same size and each has its own manager and sales st The company has been experiencing losses for many months. In an effort to improve performance, management has requested the monthly income statement be segmented by sales region. The company's first effort at preparing a segmented income stat for May is given below. Sales Regional expenses (traceable): West $ 313,000 Sales Region Central $ 797,000 East $ 696,000

College Accounting (Book Only): A Career Approach

13th Edition

ISBN:9781337280570

Author:Scott, Cathy J.

Publisher:Scott, Cathy J.

ChapterE: Departmental Accounting

Section: Chapter Questions

Problem 3P

See similar textbooks

Similar questions

Shannon, Inc., has two divisions. One produces and sells paper party supplies (napkins, paper plates, invitations); the other produces and sells cookware. A segmented income statement for the most recent quarter is given below: On seeing the quarterly statement, Madge Shannon, president of Shannon, Inc., was distressed and discussed her disappointment with Bob Ferguson, the companys vice president of finance. MADGE: The Party Supplies Division is killing us. Its not even covering its own fixed costs. Im beginning to believe that we should shut down that division. This is the seventh consecutive quarter it has failed to provide a positive segment margin. I was certain that Paula Kelly could turn it around. But this is her third quarter, and she hasnt done much better than the previous divisional manager. BOB: Well, before you get too excited about the situation, perhaps you should evaluate Paulas most recent proposals. She wants to spend 10,000 per quarter for the right to use familiar cartoon figures on a new series of invitations, plates, and napkins and at the same time increase the advertising budget by 25,000 per quarter to let the public know about them. According to her marketing people, sales should increase by 10 percent if the right advertising is doneand done quickly. In addition, Paula wants to lease some new production machinery that will increase the rate of production, lower labor costs, and result in less waste of materials. Paula claims that variable costs will be reduced by 30 percent. The cost of the lease is 95,000 per quarter. Upon hearing this news, Madge calmed considerably and, in fact, was somewhat pleased. After all, she was the one who had selected Paula and had a great deal of confidence in Paulas judgment and abilities. Required: 1. Assuming that Paulas proposals are sound, should Madge Shannon be pleased with the prospects for the Party Supplies Division? Prepare a segmented income statement for the next quarter that reflects the implementation of Paulas proposals. Assume that the Cookware Divisions sales increase by 5 percent for the next quarter and that the same cost relationships hold. 2. Suppose that everything materializes as Paula projected except for the 10 percent increase in salesno change in sales revenues takes place. Are the proposals still sound? What if the variable costs are reduced by 40 percent instead of 30 percent with no change in sales?
Posavek is a wholesale supplier of building supplies building contractors, hardware stores, and home-improvement centers in the Boston metropolitan area. Over the years, Posavek has expanded its operations to serve customers across the nation and now employs over 200 people as technical representatives, buyers, warehouse workers, and sales and office staff. Most recently, Posavek has experienced fierce competition from the large online discount stores. In addition, the company is suffering from operational inefficiencies related to its archaic information system. Posavek revenue cycle procedures are described in the following paragraphs. Revenue Cycle Posaveks sales department representatives receive orders via traditional mail, e-mail, telephone, and the occasional walk-in customer. Because Posavek is a wholesaler, the vast majority of its business is conducted on a credit basis. The process begins in the sales department, where the sales clerk enters the customers order into the centralized computer sales order system. The computer and file server are housed in Posaveks small data processing department. If the customer has done business with Posavek in the past, his or her data are already on file. If the customer is a first-time buyer, however, the clerk creates a new record in the customer account file. The system then creates a record of the transaction in the open sales order file. When the order is entered, an electronic copy of it is sent to the customers e-mail address as confirmation. A clerk in the warehouse department periodically reviews the open sales order file from a terminal and prints two copies of a stock release document for each new sale, which he uses to pick the items sold from the shelves. The warehouse clerk sends one copy of the stock release to the sales department and the second copy, along with the goods, to the shipping department. The warehouse clerk then updates the inventory subsidiary file to reflect the items and quantities shipped. Upon receipt of the stock release document, the sales clerk accesses the open sales order file from a terminal, closes the sales order, and files the stock release document in the sales department. The sales order system automatically posts these transactions to the sales, inventory control, and cost-of-goods-sold accounts in the general ledger file. Upon receipt of the goods and the stock release, the shipping department clerk prepares the goods for shipment to the customer. The clerk prepares three copies of the bill of lading. Two of these go with the goods to the carrier and the third, along with the stock release document, is filed in the shipping department. The billing department clerk reviews the closed sales orders from a terminal and prepares two copies of the sales invoice. One copy is mailed to the customer, and the other is filed in the billing department. The clerk then creates a new record in the accounts receivable subsidiary file. The sales order system automatically updates the accounts receivable control account in the general ledger file. CASH RECEIPTS PROCEDURES Mail room clerks open customer cash receipts, reviews the check and remittance advices for completeness, and prepares two copies of a remittance list. One copy is sent with the checks to the cash receipts department. The second copy of the remittance advices are sent to the billing department. When the cash receipts clerk receives the checks and remittance list, he verifies the checks received against those on the remittance list and signs the checks For Deposit Only. Once the checks are endorsed, he records the receipts in the cash receipts journal from his terminal. The clerk then fills out a deposit slip and deposits the checks in the bank. Upon receipt of the remittances, the billing department clerk records the amounts in the accounts receivable subsidiary ledger from the department terminal. The system automatically updates the AR control account in the general ledger Posavek has hired your public accounting firm to review its sales order procedures for internal control compliance and to make recommendations for changes. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.
Jarriot, Inc., presented two years of data for its Furniture Division and its Houseware Division. Required: 1. Compute the ROI and the margin and turnover ratios for each year for the Furniture Division. (Round your answers to four significant digits.) 2. Compute the ROI and the margin and turnover ratios for each year for the Houseware Division. (Round your answers to four significant digits.) 3. Explain the change in ROI from Year 1 to Year 2 for each division.
Suppose that Kicker had the following sales and cost experience (in thousands of dollars) for May of the current year and for May of the prior year: In May of the prior year, Kicker started an intensive quality program designed to enable it to build original equipment manufacture (OEM) speaker systems for a major automobile company. The program was housed in research and development. In the beginning of the current year, Kickers accounting department exercised tighter control over sales commissions, ensuring that no dubious (e.g., double) payments were made. The increased sales in the current year required additional warehouse space that Kicker rented in town. (Round ratios to four decimal places. Round sales dollars computations to the nearest dollar.) Required: 1. Calculate the contribution margin ratio for May of both years. 2. Calculate the break-even point in sales dollars for both years. 3. Calculate the margin of safety in sales dollars for both years. 4. CONCEPTUAL CONNECTION Analyze the differences shown by your calculations in Requirements 1, 2, and 3.
Rizzo Goal Inc. produces and sells hockey equipment, often custom made for online orders. The company has the following performance metrics on its balanced scorecard: days from ordered to delivered, number of shipping errors, customer retention rate, and market share. A measure map illustrates that the days from ordered to delivered and the number of shipping errors are both expected to directly affect the customer retention rate, which affects market share. Additional internal analysis finds that: Every shipping error over three shipping errors per month reduces the customer retention rate by 1.5%. On average, each day above three days from ordered to delivered yields a reduction in the customer retention rate of 1%. Each day before three days from order to delivery yields an increase in the customer retention rate of 1%, on average. Rizzo Goal Inc.s current customer retention rate is 60%. The company estimates that for every 1% increase or decrease in the customer retention rate, market share changes 0.5% in the same direction. Rizzo Goal Inc.s current market share is 21.4%. Ignoring any other factors, if the company has six shipping errors this month and an average of 3.5 days from ordered to delivered, determine (a) the new customer retention rate and (b) the new market share that Rizzo Goal Inc. expects to have.
The Home Depot is a leading specialty retailer of hardware and home improvement products and is the second-largest retail store chain in the United States. It operates large warehouse-style stores. Despite declining sales and difficult economic conditions in 20X1 and 20X2, The Home Depot continued to invest in new stores. The following table provides summary hypothetical data for The Home Depot. REQUIRED a. Use the preceding data for The Home Depot to compute average revenues per store, capital spending per new store, and ending inventory per store in 20X2. b. Assume that The Home Depot will add 100 new stores by the end of Year +1. Use the data from 20X2 to project Year +1 sales revenues, capital spending, and ending inventory. Assume that each new store will be open for business for an average of one-half year in Year +1. For simplicity, assume that in Year +1, Home Depots sales revenues will grow, but only because it will open new stores.
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?
Determine the operating income for Vinnies Vinyls West score, assuming the warehouse allocation is reduced to 10% of sales for the warehouse and the difference will be charged to the West store. Management has determined that the warehouse takes fewer corporate resources and the allocation to the West store was lower than it should have been.
Forchen, Inc., provided the following information for two of its divisions for last year: Required: 1. For the Small Appliances Division, calculate: a. Average operating assets b. Margin c. Turnover d. Return on investment (ROI) 2. For the Cleaning Products Division, calculate: a. Average operating assets b. Margin c. Turnover d. Return on investment (ROI) 3. What if operating income for the Small Appliances Division was 2,000,000? How would that affect average operating assets? Margin? Turnover? ROI? Calculate any changed ratios (round to four significant digits).
Bannister Company, an electronics firm, buys circuit boards and manually inserts various electronic devices into the printed circuit board. Bannister sells its products to original equipment manufacturers. Profits for the last two years have been less than expected. Mandy Confer, owner of Bannister, was convinced that her firm needed to adopt a revenue growth and cost reduction strategy to increase overall profits. After a careful review of her firms condition, Mandy realized that the main obstacle for increasing revenues and reducing costs was the high defect rate of her products (a 6 percent reject rate). She was certain that revenues would grow if the defect rate was reduced dramatically. Costs would also decline as there would be fewer rejects and less rework. By decreasing the defect rate, customer satisfaction would increase, causing, in turn, an increase in market share. Mandy also felt that the following actions were needed to help ensure the success of the revenue growth and cost reduction strategy: a. Improve the soldering capabilities by sending employees to an outside course. b. Redesign the insertion process to eliminate some of the common mistakes. c. Improve the procurement process by selecting suppliers that provide higher-quality circuit boards. Required: 1. State the revenue growth and cost reduction strategy using a series of cause-and-effect relationships expressed as if-then statements. 2. Illustrate the strategy using a strategy map. 3. Explain how the revenue growth strategy can be tested. In your explanation, discuss the role of lead and lag measures, targets, and double-loop feedback.
Costco is the largest chain of membership warehouse clubs in the world, based on sales volume, and it is the fifth largest general retailer in the United States. Costco focuses on selling products at low prices, often at a very high volume. These goods are usually bulk-packaged and marketed primarily to large families and businesses. Costco became the first company to grow from zero to 3 billion in sales in less than six years. In a recent fiscal year, Costcos sales totaled 116 billion, a 2 percent increase from 2015, and its net income reached 2.35 billion, an 1 percent decrease from 2015. This information, and much more, can be derived from the financial statements that merchandising firms such as Costco prepare on a regular basis to provide shareholders and other interested parties information about the companys activities and financial performance. 1. What type of information would a classified income statement provide to shareholders and other interested parties? 2. What type of information would a classified balance sheet provide to shareholders and other interested parties? Why would this information be important for calculating the working capital and the current ratio, for example?
In 20X1, Don Blackburn, president of Price Electronics, received a report indicating that quality costs were 31% of sales. Faced with increasing pressures from imported goods. Don resolved to take measures to improve the overall quality of the companys products. After hiring a consultant in 20X1, the company began an aggressive program of total quality control. At the end of 20X5, Don requested an analysis of the progress the company had made in reducing and controlling quality costs. The accounting department assembled the following data: Required: 1. Compute the quality costs as a percentage of sales by category and in total for each year. 2. Prepare a multiple-year trend graph for quality costs, both by total costs and by category. Using the graph, assess the progress made in reducing and controlling quality costs. Does the graph provide evidence that quality has improved? Explain. 3. Using the 20X1 quality cost relationships (assume all costs are variable), calculate the quality costs that would have prevailed in 20X4. By how much did profits increase in 20X4 because of the quality improvement program? Repeat for 20X5.