Utilize data driven analysis in making business decisions

Assignment Help Accounting Basics
Reference no: EM13854128

Part I
Herrestad Company does produce and sell two products and the details below will be used to prepare a segmented income statement (showing the income for each product and the total) for the company. Use ABC to allocate all fixed costs to the two products.

Background information

 

 

 

 

Total

Prod A

Prod B

Beginning inventory

0

 

 

Units produced

10,000

2,500

7,500

Units sold

8,000

2,000

6,000

 

 

 

 

Selling price per unit

$255

480

180

Variable costs per unit

 

 

 

Direct material

100

280

40

Direct labor

60

60

60

Variable overhead

25

40

20

Variable selling and admin. exp.

10

13

9

 

 

 

 

Fixed costs

 

 

 

Fixed manufacturing overhead

200,000

 

 

Fixed selling and administrative

100,000

 

 

 

 

 

 

Production runs (not $)

100

65

35

Number of sales reps (not $)

25

15

10

Here are the first few lines of the segmented income statement to help you get started. Complete the statement in good format and make sure you allocate the fixed costs to the two products. When done, comment on the information and the relative profitability of the two products.

Herrestad Company

Segmented Income Statement for the period ending Dec. 31, 2015

 

A

B

Total

Sales

$960,000

$1,080,000

$2,040,000

Variable costs:

 

 

 

Direct material

560,000

240,000

800,000

Part II

Differential analysis involves knowing which costs are relevant, i.e. future costs that vary among alternatives. It is important to know what information to use and not just how to execute the analysis.

Herrestad Company receives an offer to make a new product, called C, for a new customer. The customer wants to buy 1,000 units. Product C has the same cost structure as product B with three exceptions. The new customer is only willing to pay $150 per unit, direct materials costs will decrease by $12 per unit and Herrestad does not have to incur any variable selling and administrative expenses.

Make a list of the expenses and amounts that are relevant for this decision. How much with the sale of this product contribute to the profitability of Herrestad?
What if the company only pays $140 per unit? How does this change the contribution towards profitability?
If you were the manager, would you accept this order? What considerations, other than financial would enter into your decision?

This Is a Signature Assignment Expectation for ACC202 Module 4 SLP

There are 2 specific learning outcomes:

apply business theories, models, and concepts to guide analysis of problems and situations
utilize data driven analysis in making business decisions.

In this SLP assignment for Module 4 our emphasis will be on understanding the concept of relevant costs. You will be summarizing all of what you learned the in the Cases, SLPs and TDs.

The grading rubric below has been developed to measure student success in meeting the ACC202 Module 4 SLP expectations related to applying your knowledge of relevant costs in the budget process.

Reference no: EM13854128

Questions Cloud

Analyze what you have learned from theory : analyze what you have learned from "theory" against concepts/ideas that you intuit and implement in your daily interactions
Is the companys projected sales mix most profitable : After allocating the company's fixed overheads to products the Fertilizers, division incurs a loss of Rs 2.4 crore. Should the company drop this division?
What the common core standards would do to our school : Many people would disagree that women deserve the same recognition as their male counterpart. For example: When it comes to the mental and physical aspect of it, men don't think women are equal. The military for instance still has some ways to go ..
What are the ethical issues of the given case : What are the ethical issues in this case? What keeps other companies from having the commitment to environmental sustainability that NBB has evidenced?
Utilize data driven analysis in making business decisions : utilize data driven analysis in making business decisions
Water potential of an open beaker : 1. What is the water potential of an open beaker containing pure water? 2. Why don't red blood cells swell or shrink in blood?
Rephrase the paragraphs : Throughout your academic career, you will be required to write papers for which you will need to do research in books, journals, electronic media, and other sources. One of the challenges of good scholarship is to take what has already been done, ..
What is the approximate total annual inventory holding cost : The product is ordered 12 times per year, and the ordering cost is $120 per order. What is the approximate total annual inventory holding cost of Product XYZ?
Explain the meaning of entrepreneurship and its features : Explain the meaning of entrepreneurship and its features?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Economic order quantity

Ben would like to use an inventory system that minimizes inventory cost and will satisfy 95 percent of his customers who order this wine. a. What is the economic order quantity for Ben to order?

  Monterey corporation is considering the purchase of a

monterey corporation is considering the purchase of a machine costing 36000 with a 6-year useful life and no salvage

  Real rate of return on the investment

Suppose you bought an 8 percent coupond bond one year ago for 1090. the bond sells for 1056 today. If the inflation rate last year was 3 percent, what was your total real rate of return on the investment?

  A companys current net operating income is 18000 and its

a companys current net operating income is 18000 and its average operating assets are 133000. the companys required

  The following information applies to the questions

the following information applies to the questions displayed below. park company reported the following march

  Who makes up the majority of the members of the american

1. what is the mission of the american institute of certified public accountants and does the organization have

  Kelly company sells its only product for 9 per unit

kelly company sells its only product for 9 per unit variable production costs are 3 per unit and selling and

  Prepare a monthly cash budget for march and april include

the treasure of unisyms company has accumulated the following budget information for the first two months of the coming

  Orbit airways purchased a baggage-handling truck for 41000

orbit airways purchased a baggage-handling truck for 41000. suppose orbit sold truck on december 31 2008 for 28000 cash

  Component of the entity according to gaap

During the year, Schembri completed the sale of one of its operating divisions that qualifies as a component of the entity according to GAAP.

  Burns company-journal entries

Prepare all appropriate journal entries relative to uncollectible accounts and bad debt expense. Show the year-end balance sheet presentation for accounts receivable.

  Legal effect of the presence of a superceding

The legal effect of the presence of a superceding event is that:

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