Using excel prepare a new segmented income statement

Assignment Help Accounting Basics
Reference no: EM13573914

A contribution format income statement for the most recent year for Big Bear Consumer Electronics Inc. is shown below.



Total Department


AM/FM radios

HD radios

Sales


$320,000

100%


$270,000

100%

$50,000

100%

Less variable expenses


236,000

74%


216,000

80%

20,000

40%

Contribution Margin


84,000

26%


54,000

20%

30,000

60%

Less Traceable Fixed Expenses


15,000

5%


10,000

4%

5,000

10%

Segment Margin


69,000

22%


$44,000

16%

$25,000

50%

Less Common Fixed Expenses


40,000

13%






Net Operating Income


$29,000

9%
























PROBLEM BACKGROUND:

Shortly after graduating with a business degree from Bridgewater State University, you are hired as an assistant to the District Manager of a national consumer electronics chain.  

During your first day on the job, you attend a meeting regarding product lines carried by the chain. You learn about a fairly new innovation called HD (high definition) radio. This product allows consumers to listen to not only traditional AM and FM bands, but also to the newly created HD frequencies that most local radio stations are broadcasting free of charge to listeners on adjacent frequencies that previously were unused. Unlike satellite radio, this service requires no subscription charges. Consumers who have heard HD radio tell you that AM-HD broadcasts sound like FM and FM-HD broadcasts sound like CD quality!

Due to improved manufacturing technologies, the cost to manufacture HD radios has dropped dramatically.

PROBLEM:

Your boss (the District Manager) has authorized you to spend $10,000 for advertising for one of your chain's local stores, promoting one of their product lines.   A Marketing Research class at Bridgewater State University conducted a study indicating that the additional advertising would increase sales of the AM/FM radios by $50,000 and increase sales of the HD radios by only $45,000.

The local store manager (who never took a course in Managerial Accounting) argues that the advertising budget should be spent on the AM/FM radios because it will result in more sales dollars. The store manager also argues that the AM/FM radio line's total sales are substantially higher than the HD line, therefore as the biggest selling item, it should receive all advertising allotments.

REQUIRED:   YOU ARE TO WORK INDEPENDENTLY

a) Determine which product line (AM/FM radios or HD radios) you will spend the $10,000 of advertising on. Show your work, justifying this decision, based upon a cost/benefit analysis.   What would you tell the store manager? Include a short memo to your boss (the District Manager) explaining your decision.

b) Using Excel, prepare a new segmented income statement (including the new sales and cost data) based upon your recommendation. (hint: on what line would the $10,000 of dedicated advertising appear?)

c) What form of media would you recommend using to advertise your chosen product line?   (explain why)

d) Are there any "implicit" considerations that should enter the decision on which product line to promote?

Reference no: EM13573914

Questions Cloud

Would theactivities at a manufacturer of canned soup be : would theactivities at a manufacturer of canned soup be best classified as unit-level batch-level product-level or
Due to merger negotiations company r offers 50 a share the : acquisition by exchanging stock. company r wishes to acquire company s. company rs stock sells for 100 per share.
Cole laboratories makes and sells a lawn fertilizer called : cole laboratories makes and sells a lawn fertilizer called fastgro. the company developed standard costs for one bag of
It is anticipated that the after-tax cash inflows from the : acquisition of assets for cash. master corporation wants to buy certain fixed assets of smith corporation. however
Using excel prepare a new segmented income statement : a contribution format income statement for the most recent year for big bear consumer electronics inc. is shown
Please submit a 1000 word essay on the following title the : please submit a 1000 word essay on the following titlethe role of youth in promoting the asean-korea
Sibble corporation uses activity-based costing to assign : sibble corporation uses activity-based costing to assign overhead costs to products. overhead costs have already been
Acquisition of assets for cash knab corporation is : acquisition of assets for cash. knab corporation is considering acquiring deerson corporation for 40000. deerson has
Suppose the standard for a given cost during a period was : suppose the standard for a given cost during a period was 80000. the actual cost for the period was 72000. under what

Reviews

Write a Review

Accounting Basics Questions & Answers

  Prepare an amortization schedule that describes the pattern

Federated fabrications leased a tooling machine on January 1, 2011, for a three-year period ending December 31, 2013. The lease agreement specified annual payment of $36,000 beginning with the first payment at the inception of the lease, and each ..

  What is the actual wage rate per hour compute the labor

a popular product of loring glassworks is a hand-decorated vase. the companys standard cost system calls for .75 hours

  Write down a 700- to 1050-word paper analyzing the

select a publicly held company to use as the basis for this assignment. research your selected company and acquire the

  Find journal entry for sold merchandise

"Thirty-five years ago, young employees we hired wereambitious, conscientious, hardworking, and honest. What is the journal entry for: Sold merchandise for $10,000 and accepted a 10% 7-month note?

  Asume the following the real risk-free rate r is expected

1. assume the following the real risk-free rate r is expected to remain constant at 3. inflation is expected to

  What is the net amount of property-plant and equipment

What is the net amount of property, plant, and equipment that will appear on the balance sheet?

  Draw an entity-relationships diagram

Draw an Entity-Relationships Diagram. A commercial bakery makes many different products. these products include breads, dessert, specialty cakes, and many other baked goods.

  Gross profit method to determine inventory lost

Lisa's School Supplies suffered a fire loss. The company needs to estimate the cost of the goods destroyed. Beginning inventory was $500,000, purchases totaled $700,000, and sales came equaled $1,000,000.

  Determine the total and per share dividends for each class

A company had stock outstanding as follows during each of its first three years of operations: 2,500 shares of $10, $100 par, cumulative preferred stock and 50,000 shares of $10 par common stock. The amounts distributed as dividends are present..

  Sin tax on cigarettes and alcohol

Please help with writing a research paper that examines an issue of current relevance to public policymaking.

  Antonella in today tax dollars

how much would this action save Antonella in today's tax dollars? If Antonella's tax rate increased to 32% next year, would receiving the bonus in January still be advantageous?

  Shares of common stock outstanding throughout the year

If Roland declared $150,000 of cash dividends on preferred stock and has 100,000 shares of common stock outstanding throughout the year, earnings per share is:

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