Prepare a product-line profitability report for spf

Assignment Help Mathematics
Reference no: EM131058937

Product Line Profitability Analysis 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:

 

Sales

Paint & Paint Supplies

$285,000

Carpet

$235,000

Other Flooring Products

$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:

Activity (cost driver) Other Flooring Products

Paint & Paint

Supplies

Carpet

Order processing (number of purchase orders)

110

200

25

Receiving (number of deliveries)

40

120

10

Inventory management (number of hours per delivery)

10

40

6

Customer support (hours required per sale)   

0.5

8.5

0.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 SPF managers?

Verified Expert

The said paper consists of calculation of total cost and profit of different products. Here product cost is calculated by apportionment of overhead costs according to various allocation factor. All the working is done in excel to ensure accuracy.

Reference no: EM131058937

Questions Cloud

Determine the wavelength of light : When light with a wavelength of 235 nm is incident on a certain metal surface, electrons are ejected with a maximum kinetic energy of 3.89 × 10-19 J. Determine the wavelength (in nm) of light that should be used to double the maximum kinetic energ..
Change in the period of the pendulum : A simple pendulum uses a steel wire as the "string." The length of this wire is 1.5 m at room temperature. If the temperature is increased by 10°C, the length of the wire increases by 0.19 mm. What is the change in the period of the pendulum?
Average power of the circuit over one cycle : A series RLC circuit has a peak current of 2 A with a frequency of 22 kHz. If the resistance of the circuit is 60 kΩ, the capacitance of the circuit is 15 μF, and the inductance of the circuit is 21 mH, determine the average power of the circuit o..
What areas are we failing to capture available revenues : What does the restaurant market look like right now in our current economy? I.E: Should we wait longer before jumping in? Should we get it in sooner?
Prepare a product-line profitability report for spf : Product Line Profitability Analysis Studemeir Paint & Floors (SPF) has experienced net operating losses in its Other Flooring Products line during the last few periods. Prepare a product-line profitability report for SPF under the current costing s..
Difference between energy and power : What is the difference between energy and power? What is the difference between centripetal acceleration and centrifugal force?
Use the headings below with the information requested : Real life relation--Relate something in the chapter that you experienced in your real life. Discuss what it is and how it relates and/or exemplifies an idea in the book. Even if you have no CRM, retail, or work experience, think critically about ..
Draw the molecule c6h6 using dots to represent electrons : Find three items in your pantry or in a store that contain the surfactant sodium lauryl sulfate or sodium dodecyl sulfate. Provide the product name and what it's used for.
Least initial mechanical energy : What is the least initial mechanical energy required at launch if the projectile is to escape Earth?

Reviews

Write a Review

Mathematics Questions & Answers

  Find the speed of the plane in still air

An airplane can fly 650 miles with the wind in the same amount of time as it can fly 475 miles against the wind. If the wind speed is 40 mph, find the speed of the plane in still air.

  What is the likely direct of the fias

A random digit dialing telephone survey of 880 drivers asked, "Recalling the last ten traffic lights you drove through, how many of them were red when you entered the intersectinos?" Of the 880 respondents, 171 admitted that at least one light had..

  Express the volume v of the box as a function of z

ith a square base of side z is four times higher than it is wide. Express the volume V of the box as a function of z.

  Evaluate the dimensions of a rectangle

Finding the dimensions of a rectangle using second derivative test - Find length and width should the rectangle have so that its area is a maximum?

  How chocolate candies uses machines to package candies

A manufacturer of chocolate candies uses machines to package candies as they move along a filling line. Although the packages are labeled as 8 ounces, the company wants the packages to contain 8.17 ounces so that virtually none of the packages con..

  Roi for mip based on original estimates

Cost estimates and operating income projections $140 million. Annual operating income is expected to be approximately $25 million

  Explain solving a system of equations

Which method do you prefer when solving a system of equations? Why? What circumstances would cause you to use a different method?

  Statement in symbolic form

Write the statement in symbolic form (Let p: The tent is pitched. q: The bonfire is burning. #40, The bonfire is not burning, however the tent is pitched.

  What dimensions will minimize surface area

Drum Tight Containers is designing an open-top, square-based, rectangular box that will have a volume of 171.5 in3. What dimensions will minimize surface area? What is the minimum surface?

  The mean amount spent by a family of four

The mean amount spent by a family of four on food per month is $500 with a standard deviation of $75. Assuming that the food costs are normally distributed, what is the probability that a family spends less than $410 per month?

  Find the equations of the tangent lines at the given point

A graph of the plane curve x(t) = t3-4t, y(t) = t2. The graph crosses itself at the point (0, 4). Find the equations of the tangent lines at this point.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd