Westfield owns and provides management services for several shopping centers. After five years with the company,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Westfield owns and provides management services for several shopping centers. After five years with the company, James Heller was recently promoted to the position of manager of one of Westfield's smaller malls on the outskirts of a downtown area. When he accepted the assignment, James was told that he would hold the position for only a couple of years because that mall would likely be torn down to make way for a new sports stadium. James was also told that if he did well in this assignment, he would be in line for heading one of the company's new 200-store operations that were currently in the planning stage. While reviewing the mall's financial records for the past few years, James observed that last year's oil consumption was up by 8%, even though the number of heating degree days was down by 4%. Somewhat curious, James uncovered the following information: The mall is heated by forced-air oil heat. The furnace is five years old and has been well maintained. • Fuel oil is kept in four 5,000-gallon underground oil tanks. The oil tanks were installed 25 years ago. Replacing the tanks would cost $80,000. If pollution was found, cleanup costs could go as high as $2,000,000, depending on how much oil had leaked into the ground and how far it had spread. Replacing the tanks would add more congestion to the mall's parking situation. Required What should James do? Explain Part 2: Market Street Soup Company produces ten varieties of soup in large vats, several thousand gallons at a time. The soup is distributed to several categories of customers. Some soup is packaged in large containers and sold to college and university food services. Some is packaged in half-gallon or small containers and sold through wholesale distributors to grocery stores. Finally, some is packaged in a variety of individual servings and sold directly to the public from trucks owned and operated by Market Street Soup Company. Management has always assumed that costs fluctuated with the volume of soup, and cost-estimating equations have been based on the following cost function: Estimated costs = Fixed costs + Variable costs per gallon Production in gallons Lately, however, this equation has not been a very accurate predictor of total costs. At the same time, management has noticed that the volumes and varieties of soup sold through the three distinct distribution channels have fluctuated from month to month. Required: a. What relevant major assumption is inherent in the cost-estimating equation currently used by Market Street Soup Company? b. Why might Market Street Soup Company wish to develop a cost-estimating equation that recognizes the hierarchy of activity costs? Explain. c. Develop the general form of a more accurate cost-estimating equation for Market Street Soup Company. Clearly label and explain all elements of the equation, and provide specific examples of costs for each element. Part 3: Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information on production volume and manufacturing costs since the company started operations Living Room Tables Produced Dining Room Tables Produced June Year 1 July.. August September October. November. December. ****** ****** January Year 2. February. March April May. June July August September October. November. December. Total Manufacturing Costs $71,000 57,500 79,724 64,250 57,300 60,900 62,700 70,130 68,400 57,400 105,790 74,750 74,290 66,500 49,888 72,668 71,700 74,200 54,900 Total Tables Produced 110 90 130 95 76 92 105 110 102 81 142 125 115 106 85 116 120 120 72 5558248 4 5005102 22518851 38 18 15 36 24 30 85 45 115 59 52 44 81 60 82 56 40 103 100 88 57 61 39 90 54 Required a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs. Interpret the meaning of the "fixed" costs and comment on the results. b. Use the chart feature of a spreadsheet to develop a scatter graph of total manufacturing costs and total units produced. Use the graph to identify any unusual observations. c. Excluding any unusual observations, use the high-low method to develop a cost-estimating equation for total manufacturing costs. Comment on the results, comparing them with the results in requirement (a). d. Use simple regression analysis to develop a cost-estimating equation for total manufacturing costs. What advantages does simple regression analysis have in comparison with the high-low method of cost estimation? Why must analysts carefully evaluate the data used in simple regression analysis? e. A customer has offered to purchase 50 dining room tables for $452 per table. Management has asked your advice regarding the desirability of accepting the offer. What advice do you have for management? Additional analysis is required. Westfield owns and provides management services for several shopping centers. After five years with the company, James Heller was recently promoted to the position of manager of one of Westfield's smaller malls on the outskirts of a downtown area. When he accepted the assignment, James was told that he would hold the position for only a couple of years because that mall would likely be torn down to make way for a new sports stadium. James was also told that if he did well in this assignment, he would be in line for heading one of the company's new 200-store operations that were currently in the planning stage. While reviewing the mall's financial records for the past few years, James observed that last year's oil consumption was up by 8%, even though the number of heating degree days was down by 4%. Somewhat curious, James uncovered the following information: The mall is heated by forced-air oil heat. The furnace is five years old and has been well maintained. • Fuel oil is kept in four 5,000-gallon underground oil tanks. The oil tanks were installed 25 years ago. Replacing the tanks would cost $80,000. If pollution was found, cleanup costs could go as high as $2,000,000, depending on how much oil had leaked into the ground and how far it had spread. Replacing the tanks would add more congestion to the mall's parking situation. Required What should James do? Explain Part 2: Market Street Soup Company produces ten varieties of soup in large vats, several thousand gallons at a time. The soup is distributed to several categories of customers. Some soup is packaged in large containers and sold to college and university food services. Some is packaged in half-gallon or small containers and sold through wholesale distributors to grocery stores. Finally, some is packaged in a variety of individual servings and sold directly to the public from trucks owned and operated by Market Street Soup Company. Management has always assumed that costs fluctuated with the volume of soup, and cost-estimating equations have been based on the following cost function: Estimated costs = Fixed costs + Variable costs per gallon Production in gallons Lately, however, this equation has not been a very accurate predictor of total costs. At the same time, management has noticed that the volumes and varieties of soup sold through the three distinct distribution channels have fluctuated from month to month. Required: a. What relevant major assumption is inherent in the cost-estimating equation currently used by Market Street Soup Company? b. Why might Market Street Soup Company wish to develop a cost-estimating equation that recognizes the hierarchy of activity costs? Explain. c. Develop the general form of a more accurate cost-estimating equation for Market Street Soup Company. Clearly label and explain all elements of the equation, and provide specific examples of costs for each element. Part 3: Kendrick Anderson Furniture Maker, LLC creates custom tables in Atlanta. Assume that the following represents monthly information on production volume and manufacturing costs since the company started operations Living Room Tables Produced Dining Room Tables Produced June Year 1 July.. August September October. November. December. ****** ****** January Year 2. February. March April May. June July August September October. November. December. Total Manufacturing Costs $71,000 57,500 79,724 64,250 57,300 60,900 62,700 70,130 68,400 57,400 105,790 74,750 74,290 66,500 49,888 72,668 71,700 74,200 54,900 Total Tables Produced 110 90 130 95 76 92 105 110 102 81 142 125 115 106 85 116 120 120 72 5558248 4 5005102 22518851 38 18 15 36 24 30 85 45 115 59 52 44 81 60 82 56 40 103 100 88 57 61 39 90 54 Required a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs. Interpret the meaning of the "fixed" costs and comment on the results. b. Use the chart feature of a spreadsheet to develop a scatter graph of total manufacturing costs and total units produced. Use the graph to identify any unusual observations. c. Excluding any unusual observations, use the high-low method to develop a cost-estimating equation for total manufacturing costs. Comment on the results, comparing them with the results in requirement (a). d. Use simple regression analysis to develop a cost-estimating equation for total manufacturing costs. What advantages does simple regression analysis have in comparison with the high-low method of cost estimation? Why must analysts carefully evaluate the data used in simple regression analysis? e. A customer has offered to purchase 50 dining room tables for $452 per table. Management has asked your advice regarding the desirability of accepting the offer. What advice do you have for management? Additional analysis is required.
Expert Answer:
Answer rating: 100% (QA)
I would suggest to James to do some analysis and see if the 8 percen... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
One of your colleagues, Katina Vander, was recently promoted to department manager and now serves on the company's strategic planning committee. At its monthly meeting next week, the committee will...
-
Johnny Jones was recently promoted to the position of vice-president of sales and marketing for Jennifers Education Resources Limited, a public company. Johnny is looking for your assistance to...
-
After five years with a national CPA firm with mostly large manufacturing clients, Amy Kimbell joined Hi-Quality Productions Inc. (Hi-Q) as manager of Manufacturing Accounting. Amy has both CPA and...
-
Solve the linear equation with the x-intercept method. Check your answer. Approximate the solution to the nearest thousandth whenever appropriate. 2x = -(3x)
-
The reported net incomes for the first 2 years of Sandra Gustafson Products, Inc., were as follows: 2014, $147,000; 2015, $185,000. Early in 2016, the following errors were discovered. 1....
-
On March 31, 2022, Vine Company issued a $487,000, 2%, 3-year note payable when the market rate was 8%. Interest is due on each March 31, beginning March 31, 2023. The companys fiscal year ends on...
-
Two horizontal parallel conducting rods are connected such that a conducting crossbar free to slide along them has a constant current \(I\) running through it (Figure P27.34). The rods are separated...
-
Presented below is a list of items that may or may not be reported as inventory in a companys December 31 balance sheet. 1. Goods out on consignment at another companys store. 2. Goods sold on an...
-
You can find this question from Excel worksheet "poison pill question". Twilight has 1,000,000 shares outstanding, and the current stock price is $25 per share. Yesterday, Activist Apollo made a...
-
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSRs products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per...
-
Grade S275 steel column having 6.0m effective length for both axes is to carry pure axial loads from the floor above. If a 254 254 UB 89 is available, check the ultimate load that can be imposed on...
-
Looking at the federal funds rate since 2000, identify periods during which, with the benefit of hindsight, the rate might have been kept too low. Identify periods during which it might have been too...
-
Victory Container Corporation was owned by the three Radin brothers. Two of those brothers also owned the Warrensburg Paper and Board Corporation. Victory had no direct ownership of the Warrensburg...
-
Explain the supplyside effects of building ten new hawker centers and a third desalination plant. New schemes announced by the governments budget statement include ten new hawker centers by 2027, a...
-
Which debts have priority payment status under the Bankruptcy Code?
-
What are the possible results of a complaint filed with the NLRB?
-
If you invest $1000 in an account paying an annual percentage rate of 12%, compounded weekly, how much would you have your account at the end of 1 year 10years 20years 100years
-
Could the owner of a business prepare a statement of financial position on 9 December or 23 June or today?
-
Below are listed a number of activities that are part of a companys quality control system: a. Repairs of goods still under warranty. b. Customer returns due to defects. c. Statistical process...
-
It certainly is nice to see that small variance on the income statement after all the trouble weve had lately in controlling manufacturing costs, said Linda White, vice president of Molina Company....
-
The questions in this exercise are based on the Nordstrom, Inc., 2004 annual report at http://phx.corporate-ir.netlphoemx.zhtml?c=93295&p=irol-reportsAnnual. You do not need to print the annual...
-
The textbook states that "data is a resource that must be controlled and managed." Explain this statement, and indicate whether you agree of not, and why.
-
Why do conventional files tend be have duplication of data?
-
One of the dealership's legacy stand-alone systems in the preceding exercise is the salesperson work schedule system. This system was developed in the 1980 s on a single \(P C\), using BASE III, to...
Study smarter with the SolutionInn App