Question: Studemeir Paint & Floors (SPF) has experienced net operating losses in its Other Flooring Products line during the last few periods. SPFs management team thinks

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 they discontinue the Other Flooring Products line. The operating results from the most recent period are:

 


Paint & Paint Supplies
Other Flooring Products

Carpet
Sales$285,000$235,000$175,550
Cost of goods sold$165,000$150,000$135,250


SPF estimates that store support expenses are approximately 28.5 percent of revenues. Harish Rana, SPF’s controller, states that 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:

 


Paint & Paint Supplies
Other Flooring Products

Carpet
Order Processing (# of purchase orders)11020025
Receiving (# of deliveries)4012010
Inventory management (# of hours per delivery)10406
Customer support (hours required per sale)0.508.500.25


Harish estimates activity-cost rates for each activity as follows:

Order processing ........$135 per purchase order

Receiving ........... 180 per delivery

Inventory management ..... 30 per hour

Customer support ....... 15 per hour


Required

1. Prepare a product-line profitability report for SPF under the current costing system.

2. Prepare a product-line profitability report for SPF using the ABC information the controller provides.

3. What new insights does the ABC system in requirement 2 provide to SPFmanagers?

Step by Step Solution

3.30 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Product line profitability report for SPF under the current costing system Paint Paint Supplies Ca... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

249-B-M-L-S-M (527).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!