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

  Are the two campaigns equally attractive to customers

A separate sample of 500 people is mailed the second brochure; 125 get the credit card. Are the two campaigns equally attractive to customers? Find the test statistic.

  How would you choose x to minimize y

The upper right-hand corner of a piece of paper, 11 in. by 6 in., as in the figure, is folded over to the bottom edge. How would you fold it so as to minimize the length of the fold? In other words, how would you choose x to minimize y?

  How many trees should planted to maximize the yield

An apple orchard has an average yield of 32 bushels of apples/tree if tree density is 24 trees/acre. For each unit increase in tree density, the yield decreases by 4 bushels/tree. How many trees should be planted in order to maximize the yield?

  How many servings of each food should the dietitian provide

How many servings of each food should the dietitian provide for the patient?

  What is the highest possible revenue

If we set the price of a ticket to $20, we can sell 600 tickets. If we raise the price by x dollar, 4x less people will buy the ticket. What is the highest possible revenue that we can obtain.

  What is the rate of depreciation

An office building worth 6 million dollars when it was completed in 2005 and is being depreciated linearly over 30 years. what is the rate of depreciation and what will be the book value in 2015?

  Find the equation of the axis of symmetry and the coordinate

Find the equation of the axis of symmetry and the coordinates of the vertex of the graph of the function.

  Find the surface area of the pool

the length of a rectangular pool is 6 meters less than twice the width. if the pool's perimeter is 126 meters, find the surface area of the pool.

  How amny boxes did the troop sell

of the girl scout cookies which represented 4% of the troops sale. how amny boxes did the troop sell.

  Find the limit from the right and the limit from the left

3x x+2 , if x -2. (a) Find the limit from the right and the limit from the left of f (x) as x approaches -2. (b) Is it possible to define f (-2) so that f is continuous at x = -2?

  Speed and acceleration of vector-valued function

Find the velocity, speed and acceleration of the vector-valued function: Vector r = cost i + sint j - 16t^2 k at t=pi/4

  Discussion on geometrical construction

Given a line L and a point A in the plane, construct the line perpendicular to L that passes through A.

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