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. SPFs 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 & Paint Supplies |
| Carpet |
| Other Flooring Products |
|
Sales | $246,300 |
| $268,000 |
| $170,000 |
|
Cost of goods sold | 118,000 |
| 174,000 |
| 134,000 |
|
|
SPF estimates that store support expenses are approximately 28% of revenues. |
Harish Rana, SPFs 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: |
| Paint & Paint |
|
|
| Other Flooring |
|
Activity (cost driver) | Supplies |
| Carpet |
| Products |
|
Order processing (number of purchase orders) | 348 |
| 197 |
| 107 |
|
Receiving (number of deliveries) | 51 |
| 155 |
| 70 |
|
Customer support (hours required per sale) | 0.40 |
| 7.0 |
| 0.60 |
|
Harish estimates activity-cost rates for each activity as follows: |
|
|
|
Order processing |
| $157 per purchase order |
Receiving |
| 180 per delivery |
Customer support |
| 25 per hour |
|
Required: | |
1. | Prepare a product-line profitability report for SPF under the current costing system. (Loss amounts should be indicated by a minus sign. Round operating margin (loss) to 2 decimal places (i.e. .2134 should be entered as 21.34%).) PLEASE EXPLAIN HOW YOU GOT THE ANSWER!!!! |
Paint & Paint supplies | Carpet | other flooring products | |||||||
sales | |||||||||
COGS | |||||||||
gross margin | $0 | $0 | $0 | ||||||
store support | |||||||||
operating income (loss) | |||||||||
operating margin (loss) | % | % | % |
2. | Prepare a product-line profitability report for SPF using the ABC information the controller provides.(Loss amounts should be indicated by a minus sign. Round operating margin (loss) to 2 decimal places (i.e. .2134 should be entered as 21.34%).) FILL IN THE MISSING ACTIVITIES UNDER STORE SUPPORT. PLEASE EXPLAIN HOW YOU GOT THE ANSWER!!!! |
Paint & Paint supplies | Carpet | other flooring products | |||||||
sales | |||||||||
COGS | |||||||||
gross margin | $0 | $0 | $0 | ||||||
store support | |||||||||
total store support | 0 | 0 | 0 | ||||||
operating income (loss) | |||||||||
operating margin (loss) | % | % | % |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started