Problem 1: Family Supermarkets (FS) has decided to increase the size of its Memphis store. It...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 1: Family Supermarkets (FS) has decided to increase the size of its Memphis store. It wants information about the profitability of individual product lines: soft drinks, fresh produce, and packaged food. FS provides the following data for 2011 for each product line: Revenues Cost of goods sold Cost of bottles returned Number of purchase orders placed Number of deliveries received 120 216 Hours of shelf-stocking time Items sold 50,400 FS also provides the following information for 2011: Activity (1) 1. Bottle returns Soft Drinks $317,400 $240,000 $ 4,800 144 2. Ordering 3. Delivery 4. Shelf-stocking 5. Customer support Total Required Description of Activity (2) Returning of empty bottles to store Placing of orders for purchases Physical delivery and receipt of merchandise Stocking of merchandise on store shelves and ongoing restocking Assistance provided to customers, including checkout and bagging Fresh Produce $840,240 $600,000 $ 0 336 876 2,160 441,600 Total Support Costs (3) $ 4,800 $ 62,400 $100,800 $ 69,120 $122,880 $360,000 Packaged Food $483,960 $360,000 $ 0 144 1,080 122,400 Cost-Allocation Base (4) Direct tracing to soft- drink line 624 purchase orders 1,260 deliveries 3,456 hours of shelf- stocking time 614,400 items sold 1. Family Supermarkets currently allocates store support costs (all costs other than cost of goods sold) to product lines on the basis of cost of goods sold of each product line. Calculate the operating income and operating income as a percentage of revenues for each product line. 2. If Family Supermarkets allocates store support costs (all costs other than cost of goods sold) to product lines using an ABC system, calculate the operating income and operating income as a percentage of revenues for each product line. Problem 1: Family Supermarkets (FS) has decided to increase the size of its Memphis store. It wants information about the profitability of individual product lines: soft drinks, fresh produce, and packaged food. FS provides the following data for 2011 for each product line: Revenues Cost of goods sold Cost of bottles returned Number of purchase orders placed Number of deliveries received 120 216 Hours of shelf-stocking time Items sold 50,400 FS also provides the following information for 2011: Activity (1) 1. Bottle returns Soft Drinks $317,400 $240,000 $ 4,800 144 2. Ordering 3. Delivery 4. Shelf-stocking 5. Customer support Total Required Description of Activity (2) Returning of empty bottles to store Placing of orders for purchases Physical delivery and receipt of merchandise Stocking of merchandise on store shelves and ongoing restocking Assistance provided to customers, including checkout and bagging Fresh Produce $840,240 $600,000 $ 0 336 876 2,160 441,600 Total Support Costs (3) $ 4,800 $ 62,400 $100,800 $ 69,120 $122,880 $360,000 Packaged Food $483,960 $360,000 $ 0 144 1,080 122,400 Cost-Allocation Base (4) Direct tracing to soft- drink line 624 purchase orders 1,260 deliveries 3,456 hours of shelf- stocking time 614,400 items sold 1. Family Supermarkets currently allocates store support costs (all costs other than cost of goods sold) to product lines on the basis of cost of goods sold of each product line. Calculate the operating income and operating income as a percentage of revenues for each product line. 2. If Family Supermarkets allocates store support costs (all costs other than cost of goods sold) to product lines using an ABC system, calculate the operating income and operating income as a percentage of revenues for each product line.
Expert Answer:
Answer rating: 100% (QA)
1 Calculation of operating income when support costs are allocated on the basis of cost of goods sol... View the full answer
Related Book For
Modeling the Dynamics of Life Calculus and Probability for Life Scientists
ISBN: 978-0840064189
3rd edition
Authors: Frederick R. Adler
Posted Date:
Students also viewed these accounting questions
-
1. What are the ways marketers might use colo r, sound and scent to stimulate your purchasin g? 2. Provide examples when marketers may wan t to ensure that consumers notice a change a nd examples...
-
On December 31, 2015, a franchise that is owned by Southgate Inc., an ASPE company, has a remaining life of 27 years and a carrying amount of $1,000,000. Management estimates the following...
-
What is the probability that both of the molecules remain inside after 2 seconds (using parameters from Section 6.2, Exercise 3)? Consider again the molecules in Section 6.2, Exercises 1-4. Suppose...
-
You are considering an investment that will be valued at $1,000 one year from now. Your next best alternative investment opportunity would yield an annual rate of return of 8%, In other words, if you...
-
List the revenue cycle audit objectives derived from the existence or occurrence management assertion.
-
Explain why employees who are very satisfied with their jobs might not be better performers than those who are less satisfied.
-
What is the role of the paralegal during trial? What ethical considerations should govern your conduct during the trial?
-
Kendall Jackson, CPA, is examining the operating effectiveness of the internal control of Town Mo, a large conglomerate in the music industry. As part of the evaluation, Jackson determined a...
-
Your inquiry Topic: Financial Accounting Course number: 305: On January 1, 2020, ACC Larkspur Leasing Company announces an arrangement to contract assets to Cole Company. The agreement is described...
-
The average grain diameter for a brass material was measured as a function of time at 650°C, which is tabulated below at two different times: (a) What was the original grain diameter? (b) What...
-
You are part of the way through a project, but before you can move to the next stage, you need to get approval from a local government agency. What direction of influence does this government agency...
-
Using one of the queries you created in BITS from previous assignments, create a report. You will need to use a different font, include a logo; ensure that your report "looks good" (using appropriate...
-
What happens when the following C++ processes? int pay = 15; if(pay > 15 && pay < 3) { cout < < "Hi"; } Nothing will display The pay rate will be updated A compiler error will occur The word Hi will...
-
Differentiate between a Sensitivity Analysis, Scenario Analysis, and Monte Carlo Simulation. Also, what type of risk do these techniques measure?
-
Will cyber espionage become the primary intelligence collection INT of the future using hybrid HUMINT-SIGINT collection techniques, or be considered a modification of traditional SIGINT collection?
-
Magenta Corporation has 1,000 shares of stock outstanding. Julie owns 400 of these shares, and unrelated individuals own the remaining 600 shares. Magenta redeems 100 of Julie's shares for $200,000....
-
Based on your understanding about business intelligence and/or data analytics, 1. In what way can a government (e.g. HK Government) make use of data analytics ? Name some examples of government...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
Sodium concentration (with rate of change equal to the rate at which sodium enters and leaves). For each of the following measurements, give circumstances under which you could measure the following.
-
One value of r between the value found in Exercise 47 and r = e2. Find values of r satisfying the following conditions for the Ricker model. In each case, graph and cobweb.
-
(From Section 7.1, Exercises 3 and 7) For the following joint distributions, find the covariance of X and Y using the direct method, If the covariance is zero, are the random variables independent?...
-
Key comparative figures ($ millions) for both Best Buy and Circuit City follow. Required 1. Which company is largest in terms of assets? Which company is largest in terms of sales? 2. Which company...
-
William Shakespeare wrote, The evil that men do lives after them; the good is oft interred wih their bones. Business people are oft not remembered for their outstanding ethics, but rather reviled for...
-
The Financial Accounting Standards Board (FASB) sets accounting standards. The FASBs mission is described at its Website (FASB.org) under the tab Facts about FASB. Required Prepare a half-page report...
Study smarter with the SolutionInn App