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 probabilities of selecting multiples of fixed numbers

Probabilities of Selecting Multiples of Fixed Numbers. Let N = 1000 and let S = {1, 2, ... , N}. Let D_i = {m belongs to S: i|m} for integers i between 1 and N.

  Find the equation of the straight line from the given

find the equation of the straight line from the given data.find the equation of the indicated curve subject to the

  The amplitude of a given sine function fx asinxd is 6 if

the amplitude of a given sine function fx asinxd is 6. if the maximum value of f is 8 which is the minimum value of

  What is the probability of returning a shipment

When a large shipment of alternators is received at the plant, 100 are tested, if more than two are nonconforming, the shipment is returned to the alternator manufacturer. What is the probability of returning a shipment?

  Find the work required to pump the water out of the spout

Find the work required to pump the water out of the spout. Consider the tank being half-filled with oil (density of 900 kg/m3). Find the amount of work needed to empty the tank.

  Calculate the monthly payment

A loan of $9,800 is to be repaid with monthly payments for 12 years at 3.2% interest compounded monthly. Calculate the monthly payment.

  Consider the linear programming problem

Let A be a symmetric square matrix, i.e., A 0 = A. Consider the linear programming problem min c'x s.t. Ax ≥ c

  Information about ellipse

Transform each equation to standard form. Then find the center, foci, major and minor axes, and ends of each latus rectum. Draw the curve

  Find what are the dimensions of the largest rectangular

The side bordering the stream is not to be fenced. If 1000 yards of fencing material is to be used, what are the dimensions of the largest rectangular field that can be fenced. what is the maximum area.

  Find the third quartile q3

assume that adults have iq scores that are normally distributed with a mean of 102 and a standard deviation of 15. find the third quartile Q3 which is the iq score separating the top 25% from the others.

  What is the probability that one of these resistors picked

what is the probability that one of these resistors picked at random will have a resistance of 16 ohms or more?

  Find the true course and the ground speed of the plane

The ground speed of the plane is the magnitude of the resultant. Find the true course and the ground speed of the plane.

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