Part 4 Tennis company, a distributor of Tennis Rackets, has been experiencing losses for some time,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 4 Tennis company, a distributor of Tennis Rackets, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement below: Sales Variable expenses Contribution margin Fixed expenses Net operating loss $ 1,505,000 $ 581,500 $ 923,500 930,000 $ (6,500) In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Below is data by geographic market: South Central Sales $ 400,000 $ Variable expenses as a percentage of sales Direct Fixed expenses 50% 190,000 All other fixed costs are assumed unallocated common fixed costs 605,000 North $500,000 30% 40% 450,000 260,000 Required: 1. Prepare a segmented income statement segmented by geographical market and total for the company in good form. Use cell referencing of the information above to develop an answer to the following questions. 2. Do you recommend that the company drop one of the geographical markets based only on your calculations in #1? Why? What will be the impact on income of the company as a whole if it drops this geographical market? Be specific about the dollar amount change. 3. The company's sales manager believes that sales in the South geographical market could be increased by Would you recommend the increased advertising? Why? Develop a revised South market segmented income statement down to the computation of geographic margin. 20% Monthly Advertising for the central market would be increased by $40,000 Solution: Prepare the solution below in the order listed for required. Part 4 Tennis company, a distributor of Tennis Rackets, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement below: Sales Variable expenses Contribution margin Fixed expenses Net operating loss $ 1,505,000 $ 581,500 $ 923,500 930,000 $ (6,500) In an effort to isolate the problem, the president has asked for an income statement segmented by geographic market. Below is data by geographic market: South Central Sales $ 400,000 $ Variable expenses as a percentage of sales Direct Fixed expenses 50% 190,000 All other fixed costs are assumed unallocated common fixed costs 605,000 North $500,000 30% 40% 450,000 260,000 Required: 1. Prepare a segmented income statement segmented by geographical market and total for the company in good form. Use cell referencing of the information above to develop an answer to the following questions. 2. Do you recommend that the company drop one of the geographical markets based only on your calculations in #1? Why? What will be the impact on income of the company as a whole if it drops this geographical market? Be specific about the dollar amount change. 3. The company's sales manager believes that sales in the South geographical market could be increased by Would you recommend the increased advertising? Why? Develop a revised South market segmented income statement down to the computation of geographic margin. 20% Monthly Advertising for the central market would be increased by $40,000 Solution: Prepare the solution below in the order listed for required.
Expert Answer:
Answer rating: 100% (QA)
1 Tennis Company Segmented Income Statement South Sales 400000 Variable Expenses 30 120000 Contribut... 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
-
Assume for this question that Louie and Kathleen decide to gift the XYZ company stock to the neighbor today. Which best describes how the gift to the neighbor will be treated in Louie's estate tax...
-
Types of audit procedures Audit procedures are used to gatherevidence to support the auditors conclusions on the fairpresentation of a companys financial statements. Procedures can beperformed...
-
Fresh water is to be obtained from brackish water at 65oF with a salinity of 0.12 percent on mass basis (or TDS = 1200 ppm). Determine (a) The mole fractions of the water and the salts in the...
-
In Shady Company, materials are entered at the beginning of each process, and conversion costs are incurred uniformly throughout the process. Work in process inventories, with the percentage of work...
-
Suppose an investor uses the quadratic utility function $U(x)=$ $x-\frac{1}{2} c x^{2}$. Suppose there are $n$ risky assets and one risk-free asset with total return $R$. Let $R_{M}$ be the total...
-
Exhibit 4.21 presents selected operating data for three retailers for a recent year. Macys operates several department store chains selling consumer products such as brand-name clothing, china,...
-
Hampton Company reports the following information for its recent calendar year. Income Statement Data Sales Expenses: Cost of goods sold Salaries expense Depreciation expense Net income Required:...
-
Baitem Inc. had budgeted for $4,760,000 of manufacturing overhead. During the year, the company had worked 125,000 labours, but had budgeted for 140,000 hours. Manufacturing overhead is charged on...
-
During the pandemic, the use of telemedicine for primary care visits has significantly increased. From a patient's standpoint, how does telemedicine affect the demand for primary care visits? Think...
-
When chest compressions are in progress, how often should the heart rate be assessed?
-
What neurobiological mechanisms underlie the modulation of motivation, and how can an understanding of these processes inform interventions to enhance intrinsic drive ?
-
your proposal will require a rationale or a justification for the change you are proposing. You will develop a plan to make the change outlined in the rationale. I will need to approve the topic you...
-
AFTER COMPLETING MODULE 11 YOU SHOULD BE ABLE TO: 1.Explain the features of electronic media of communication and electronic culture 2.Differentiate the impacts of oral, literate, and electronic...
-
Read and reflect on the following article. The article may be located by clicking on the The CIP Report: September 2014 link on the Past Issues Catalog page: Mueller, J., & Stewart M. G. (2014,...
-
Ex. (17): the vector field F = x i-zj + yz k is defined over the volume of the cuboid given by 0x a,0 y b, 0zc, enclosing the surface S. Evaluate the surface integral ff, F. ds?
-
LDDS continued to publicly report increasing profits and sales in the financial statements, which allowed it to acquire more companies with no limit to the growth of its stock price. True/False
-
LDDS suffered from high fixed costs coupled with a lack of technical knowledge and expertise in optimizing the configuration of circuits, which resulted in high line costs. True/False
-
WorldCom overstated its sales by holding its books open at the close of a reporting period. True/False
Study smarter with the SolutionInn App