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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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