Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods.Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the mostrecent period are:SalesCost of goods soldFrozen Foods$ 238,000221,000Baked Goods Fresh Produce$ 381,000308,000$416,000321,000SFS estimates that store support expenses, in total, are approximately 13% of revenues.The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysisreveals store support activities for these three product lines are:Activity (cost driver)Order processing (number of purchase orders)Receiving (number of deliveries)Shelf-stocking (number of hours per delivery)FrozenBakedFreshFoodsGoodsProduce1162107137525450.227,00038,00076,000Customer support (total units sold)The controller estimates activity-cost rates for each activity as follows:Order processing$ 98per purchase orderReceiving112per deliveryShelf-stocking20.00per hourCustomer support0.25per itemRequired:1. Prepare a product-line profitability report for SFS under the current costing system.2. Prepare a product-line profitability report for SFS using the ABC information the controller provides.Complete this question by entering your answers in the tabs below.Required 1 Required 2Prepare a product-line profitability report for SFS using the ABC information the controller provides. (Loss amounts should beindicated by a minus sign. Round operating margin (loss) to 2 decimal places (i.e. 0.2134 should be entered as 21.34%).Round all other answers to nearest whole dollar)Store support:Frozen FoodBaked GoodsFresh Produce0$0Total store support costOperating income (loss)Operating margin (loss)0%%96Proi

Name: Supermart Food Stores (SFS) has experienced net operating losses in i
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods.Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from t

Product Line Profitability report calculates the total amount of profit gained from all products…

Business

Accounting

Required: 1. Prepare a product-line profitability report for SFS under the current costing system. 2. Prepare a product-line profitability report for SFS using the ABC information the controller provides.

Required: 1. Prepare a product-line profitability report for SFS under the current costing system. 2. Prepare a product-line profitability report for SFS using the ABC information the controller provides.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter16: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Baked Goods Fresh Produce Sales $ 164,000 $ 198,000 $ 262,000 Cost of goods sold 150,000 160,000 200,000 SFS estimates that store support expenses, in total, are approximately 15% of revenues. The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are: Activity (cost driver) Frozen Foods Baked Goods Fresh Produce Order processing (number of purchase orders) 11 54 95 Receiving (number of deliveries) 12 71 172 Shelf-stocking (number of hours per delivery) 6 0.2 7 Customer support (total units sold) 20,000 37,000 74,000 The…
Supermart Food Stores (SFS) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are: Frozen Foods Baked Goods Fresh Produce Sales $ 120,000 $ 91,000 $ 158,175 Cost of goods sold 105,000 67,000 110,000 SFS estimates that store support expenses, in total, are approximately 20% of revenues. The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are: Activity (cost driver) Frozen Foods Baked Goods Fresh Produce Order processing (number of purchase orders) 10 45 100 Receiving (number of deliveries) 12 55 120 Shelf-stocking (number of hours per delivery) 2 0.5 4 Customer…
Studemeir Paint & Floors (SPF) has experienced net operating losses in its Other Flooring Products line during the last few periods. SPF’s management team thinks that the store will improve its profitability if it discontinues the Other Flooring Products line. The operating results from the most recent period are: Paint and Paint Supplies Carpet Other Flooring Products Sales $ 375,500 $ 201,000 $ 152,000 Cost of goods sold 151,000 128,000 117,000 SPF estimates that store support expenses are approximately 24% of revenues. Harish Rana, SPF’s controller, states that while every sale has one purchase order, not every sales dollar requires or uses the same amount of store support activities. He conducts a preliminary investigation and his results and analysis are as follows: Activity (cost driver) Paint and Paint Supplies Carpet Other Flooring Products Order processing (number of purchase orders) 360 157 120 Receiving…
Check m Bovine Company, a wholesale distributor of umbrellas, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales Variable expenses Contribution margin Fixed expenses $2,050,000 876,050 1,173,950 1,315,000 $ (141,050) Operating loss In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Accordingly, the Accounting Department has developed the following: Geographic Market Central South North Sales Variable expenses as a percentage of sales Traceable fixed expenses $605,000 $804,000 $641,000 34% $315,000 $500,000 $305,000 53% 44% Required: 1. Prepare a contribution format income statement segmented by geographic market, as requested by the president Geographic Market Total South Central North Company
Bovine Company, a wholesale distributor of DVDs, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement below:Sales $1,500,000 Variable expenses 588,000 Contribution margin 912,000 Fixed expenses 945,000 Net operating loss $ (33,000)In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Accordingly, the Accounting Department has developed the following data:Geographic Market South Central North Sales $400,000 $600,000 $500,000 Variable expenses as a percentage of sales 52% 30% 40% Traceable fixed expenses $240,000 $330,000 $200,000Required: i. Prepare a contribution format income statement segmented by geographic market, as desired by the president. ii. The company’s sales manager believes that sales in the Central geographic market could be increased by 15% if monthly advertising were increased by $25,000. Would you recommend the increased advertising? Show…
Bovine Company, a wholesale distributor of umbrellas, has been experiencing losses for some time, as shown by its most recent monthly contribution format Income statement: In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Accordingly, the Accounting Department has developed the following: Required: Prepare a contribution format Income statement segmented by geographic market, as requested by the president. 2-a. The company's sales manager believes that sales in the Central geographic market could be increased by 15% If monthly advertising is increased by $42, 000. Calculate the incremental net operating income. 2- b. Would you recommend the increased advertising?
Ready Electronics is facing stiff competition from imported goods. Its operating income margin has been declining steadily for the past several years. The company has been forced to lower prices so that it can maintain its market share. The operating results for the past 3 years are as follows: Year 1 Year 2 Year 3 Sales 14,500,000 9,500,000 9,000,000 Operating income 1,200,000 1,145,000 945,000 Average assets 15,000,000 15,000,000 16,750,000 For the coming year, Ready's president plans to install a JIT purchasing and manufacturing system. She estimates that inventories will be reduced by 70% during the first year of operations, producing a 20% reduction in the average operating assets of the company, which would remain unchanged without the JIT system. She also estimates that sales and operating income will be restored to Year 1 levels because of simultaneous reductions in operating expenses and selling prices. Lower selling prices will allow Ready to expand its market share. 1.…
Cullumber Toys' management is considering eliminating product A, which has been showing a loss for several years. The company's annual income statement, is as follows: Sales Variable expenses Contribution margin Advertising expense Depreciation expense Corporate expenses Total fixed expenses Operating income A $2,247,000 1,632,000 $615,000 $517,000 15,900 93,900 $626,800 $(11,800) B $1,404,000 600,400 $803,600 $430,000 10,000 81,600 $521,600 $282,000 C $1,809,300 1,095,200 $714,100 $520,000 20,600 105,000 $645,600 $68,500 Total $5,460,300 3,327,600 $2,132,700 $1,467,000 46,500 280,500 $1,794,000 $338,700 Advertising expense - Specific to each product. Depreciation expense - Specific to each product; no other use available, no resale value. Corporate expenses - Allocated based on number of employees.
Bovine Company, a wholesale distributor of umbrellas, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement: Sales $ 2,070,000 Variable expenses 895,880 Contribution margin 1,174,120 Fixed expenses 1,319,000 Operating loss $ (144,880 ) In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Accordingly, the Accounting Department has developed the following: Geographic Market South Central North Sales $ 607,000 $ 806,000 $ 657,000 Variable expenses as a percentage of sales 50 % 36 % 46 % Traceable fixed expenses $ 320,000 $ 480,000 $ 307,000 Required:1. Prepare a contribution format income statement segmented by geographic market, as requested by the president. 2-a. The company’s sales manager believes that sales in the Central…
Suppose Grainy Day is considering discontinuing its tasty loops product line. Assume that during the past year, the tasty loops' product line income statement showed the following: A B 1 Sales revenue $7,550,000 2 Less: Cost of goods sold 6,400,000 3 Gross profit 1,150,000 4 Less: Operating expenses 1,650,000 5 Operating income (loss) $(500,000) Fixed manufacturing overhead costs account for 40% of the cost of goods, while only 30% of the operating expenses are fixed. Since the tasty loops line is just one of the company's cereal operations, only $780,000 of direct fixed costs (the majority of which is advertising) will be eliminated if the product line is discontinued. The remainder of the fixed costs will still be incurred by the company. If the company decides to discontinue the product line, what will happen to the company's operating income? Should Grainy Day discontinue the tasty loops product line?
Ivanhoe Inc. had a bad year in 2021. For the first time in its history, it operated at a loss. The company's income statement showed the following results from selling 86,400 units of product: net sales $2,160,000; total costs and expenses $2,413,800; and net loss $253,800. Costs and expenses consisted of the following. Cost of goods sold Selling expenses Administrative expenses 1. 2. 3. Break-even point $ 1. Total $1,693,440 558,360 162,000 Management is considering the following independent alternatives for 2022. Increase selling price 2. Change compensation $2,413,800 $1,296,000 3. Purchase machinery Variable Increase unit selling price 25% with no change in costs and expenses. Change the compensation of salespersons from fixed annual salaries totaling $216,000 to total salaries of $43,200 plus a 5% commission on net sales. $1,134,000 99,360 62,640 Purchase new high-tech factory machinery that will change the proportion between variable and fixed cost of goods sold to 50:50. (a)…
Sheridan Inc. had a bad year in 2021. For the first time in its history, it operated at a loss. The company's income statement showed the following results from selling 73,600 units of product: net sales $1,840,000; total costs and expenses $2,056,200; and net loss $216,200, Costs and expenses consisted of the following. Cost of goods sold Selling expenses Administrative expenses 1. 2. 3. Break-even point 1. 2. $1,442,560 3. Total $ 475,640 Management is considering the following independent alternatives for 2022. 138,000 $2,056,200 Increase selling price Change compensation Purchase machinery (a) Compute the break-even point in sales dollars for 2021. (Round contribution margin ratio to 4 decimal places e.g. 0.2512 and final answer to O decimal places, e.g. 2,510.) Variable Increase unit selling price 25% with no change in costs and expenses. Change the compensation of salespersons from fixed annual salaries totaling $184,000 to total salaries of $36,800 plus a 5% commission on net…