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

  Stahl consulting started the year with total assets of

stahl consulting started the year with total assets of 20000 and total liabilities of 5000. during the year the

  When comparing various divisions within a company describe

when comparing various divisions within a company describe what problems can arise from evaluating divisions that have

  Mozena corporation has collected the following information

mozena corporation has collected the following information after its first year of sales. sales were 1800000 on 100000

  Lowe manufacturing co warrants its products for one year

lowe manufacturing co. warrants its products for one year. the estimated product warranty is 4 of sales. assume that

  Bloomfield bakers accounts for investment

Bloomfield Bakers accounts for its investment in Clor Confectionary under the equity method. Bloomfield carried the Clor investment at $150,000 and $165,000 at December 31m 2010 and 2011, respectively.

  The following transactions occurred throughout the month of

the following transactions occurred during the month of june 2011 for the stridewell corporation. the company owns and

  Your neighbor is a security analyst he has conducted

your neighbor is a security analyst. he has conducted hisresearch about some stocks in karachi name ofcity stock

  Carla works full-time managing the partnership

Carla works full-time managing the partnership

  Determine the specific accounting principles

Explain the areas in which the Adelphia communications engaged in fraudulent financial reporting and the circumstances that led to this

  What point should the revenue from the gift cards

At what point should the revenue from the gift cards be recognized and should the revenue be recognized at the time the card is sold, or should it be recorded when the card is redeemed?

  The turnaround team included inexperienced personnel a

please help me with these problems merry -go -around mgr a clothing retailer located primarily in shopping malls was

  Comment on any significant problem or areas of cost savings

heritage furniture co. uses a standard cost system. one of thecompanys most popular products is an oak

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