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: Sales South $ Central Variable expenses as a percentage of sales Direct Fixed expenses 400,000 $ 50% 190,000 All other fixed costs are assumed unallocated common fixed costs North 450,000 605,000 $500,000 30% 40% 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. Solution: Prepare the solution below in the order listed for required. 20% Monthly Advertising for the central market would be increased by $40,000 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: Sales South $ Central Variable expenses as a percentage of sales Direct Fixed expenses 400,000 $ 50% 190,000 All other fixed costs are assumed unallocated common fixed costs North 450,000 605,000 $500,000 30% 40% 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. Solution: Prepare the solution below in the order listed for required. 20% Monthly Advertising for the central market would be increased by $40,000
Expert 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...
-
The T-accounts for Equipment and the related Accumulated Depreciation-Equipment for Oriole Company at the end of 2022 are shown here. Beg bal. Acquisitions End, bal. Disposals Equipment 124,000...
-
A group of 70 students were asked to record the last digit of their social security number. a. Draw a relative frequency histogram using the values 0 through 9 as the class midpoints. What is the...
-
Sam Chase of Flowers.co.uk receives a brochure from the Hackett Group, a consulting firm specialising in benchmarking. He asks the Hackett Group to provide benchmark data from its recent study of the...
-
A company is negotiating with a potential supplier for the purchase of 100,000 widgets. The company estimates that the suppliers variable costs are $5 per unit and that the fixed costs, depreciation,...
-
Identify the four components of an ecosystem. After you do this try to visualize the interactions of these four components of an ecosystem as illustrated by Figure 2. 2 in the textbook. Does this...
-
Two years ago, your best friend Scott Adams started a home business selling custom-made chairs and tables. His original designs quickly became popular, and he began selling in large quantities. To...
-
It is now June 30, 2023. The journal entry for the investment in the put option had already been recorded on January 1, 2023. SmartiePants Corp prepared its financial statements on March 31, 2023 as...
-
Have students imagine that they are a member of a therapy group formed to help individuals work out emotional and behavioral difficulties. What role would you see yourself taking on in the group?...
-
a) Using integration by parts, show that 1(x)= Hint: 1xt and te has an easy antiderivative. b) Repeat this logic again to show that 1 21-dr. 1(x)=-2 + c) Repeat twice more to start to notice a...
-
E-commerce store dealing in traditional clothing in Canada, suggest some plans and techniques for Future Growth & Expansion: 1. Plan how to grow the company and the product line (give real examples...
-
A proposed new venture will cost $85,000 and should produce annual cash flows of $30,000, $55,000, $40,000, and $40,000 for Years 1 to 4, respectively. The discount rate is 10 percent. What is the...
-
What are ways in which a monopolist can engage in price discrimination? Provide one or two examples of price discrimination you observe in your daily life? What type of price discrimination is it?
-
Suggest how you might respond to the Ma's concern that Zian is rejecting his Chinese culture. This morning you notice that Zian starts a conversation with one of his peers, how could you share this...
-
Alaya infrastructure is a small sized organisation having 150 employees. The organisation never had a formal induction training. You are their first ever HR Manager and you strongly feel the need to...
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
Harmon Household Products, Inc., manufactures a number of consumer items for general household use. One of these products, a chopping board, requires an expensive hardwood. During a recent month, the...
-
Rowe Company manufactures a variety of products in several departments. Budgeted costs for the company's Finishing Department for the year have been set as follows: Variable costs: Direct materials ....
-
Who is generally responsible for the materials price variance? The materials quantity variance? The labor efficiency variance?
-
Gross profit is (A) Excess of sales over cost of goods sold (B) Sales less purchases (C) Cost of goods sold + opening inventory (D) Net profit less expenses of the period
-
To find the value of closing inventory at the end of a period we (A) Do this by physically counting the inventory (i.e. stocktaking) (B) Look in the inventory account (C) Deduct opening inventory...
-
Net profit is calculated in the (A) Trading account (B) Profit and loss account (C) Trial balance (D) Statement of financial position
Study smarter with the SolutionInn App