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

  Discuss the audit opinion

Discuss the audit opinion you consider most appropriate for each of these situations.

  Government financial statements

Answer the following questions based on Scottsdale, AZ CAFR year ending June 30, 2012.

  Journal entries by twin digital

Prepare the journal entries by Twin Digital to record the semiannual interest on July 1, 2011, as well as to record the redemption of the bonds on July 1, 2011.

  What are some of advantages and disadvantages of tracking

the "Dual Track" approach is a method of accounting used in government for the purposes of simplified reporting. What does it mean to run your accounts on the ‘Dual Track' approach?

  Compare company ratio results to industry averages

The chosen company is Apple Inc. The purpose of the comprehensive project is to use resources available to obtain industry averages for commonly used ratios. Additionally you will compare company ratio results to industry averages

  Which of the following is a reason that employees must

if you know these and get them right i will have a few more coming. if you dont know the answers dont respond. a

  Application of linear eqautions

An art dealer sold two artworks at $1520 thereby making a profit of 25% on the first work and 10% on the second, where as if he had approached any exhibition he would have sold them together for $1535 with a profit of 10% on the first and 25% on t..

  Problem related to income statement data

Mars Corporation has three departments. Condensed income statement data are as follows:

  Calculate the amount of debt and equity that would be

charter enterprises currently has 1 million in total assets and is totally equity financed. it is contemplating a

  What is the purpose of cafr what are the components of

what is the purpose of cafr? what are the components of cafr? why is the federal government not subject to gasb 34? how

  Determine the maturity value of a loan of 240000 after

determine the maturity value of a loan of 2400.00 after three years. the loan carries a simple interest rate of 7.7 per

  In may we produced 48 tables the 48 tables used 950 linear

1. we produce wood tables. the standard costs are as follows per tablewood - 20.5 linear feet at a cost of 13.15

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