Reference no: EM131671127
Assignment: Cost Behavior and Cost-Volume-Profit Analysis
Show computations in good format and explain answers as required. Write comments below the computations in Excel. MUST BE COMPLETED IN EXCEL.
Scenario A
Compute the break-even point in sales dollars if fixed costs are $200,000 and the total contribution margin is 20% of revenue.
Show the analysis in an excel table format, and write a one-paragraph interpretation of the information presented in the table.
Scenario B
Danny Company makes and sells stuffed animals. One product, Panda Bear, sells for $28 per bear. Panda Bears incur fixed costs of $100,000 per month and a variable cost of $12 per bear. How many Panda Bears must be produced and sold each month to break even?
Show the analysis in an excel table format, and write a one-paragraph interpretation of the information presented in the table..
Scenario C
Jerry is considering buying a company if it will break even or earn net income on revenues of $80,000 per month. The company that Peter is considering sells each unit it produces for $5. Use the following cost data to compute the variable cost per unit and the fixed cost for the period. Calculate the break-even point in sales dollars. Should Jerry purchase this company?
Volume (units) Cost
8,000 $70,000
68,000 $190,000
Show the analysis in an excel table format, and write a one-paragraph interpretation of the information presented in the table.
Scenario D
Reliable Delivery currently delivers packages for $9 each. The variable cost is $3 per package, and fixed costs are $60,000 per month. Compute the break-even point in both sales dollars and units under each of the following independent assumptions. Comment on why the break-even points are different.
1. The costs and selling price are as just given.
2. Fixed costs are increased to $75,000.
3. Selling price is increased by 10%. (Fixed costs are $60,000.)
4. Variable cost is increased to $4.50 per unit. (Fixed costs are $60,000 and selling price is $9.)
5. Show the analysis in an excel table format, and write a one-paragraph interpretation of the information presented in the table.
Describe factors in detail related to creating a culture
: Describe some factors in detail related to creating a culture of honesty within the golf course operation, starting at the beginning.
|
Probability-randomly select monthly cell phone bill is more
: According to a report by Scarborough Research, the average monthly household cellular phone bill is $60. Suppose local monthly household cell phone bills.
|
Compare and contrast the issue of minority and majority
: Create a short bio, a page to a page and a half, on the author of your course project novel. What are the main themes in their work
|
Compute probability for the internal revenue service
: According to the Internal Revenue Service, income tax returns one year averaged $1,332 in refunds for taxpayers. One explanation of this figure is that taxpayer
|
Compute the break-even point in sales dollars
: Compute the break-even point in sales dollars if fixed costs are $200,000 and the total contribution margin is 20% of revenue.
|
Find the proportion of the cost
: Toolworkers are subject to work-related injuries. One disorder, caused by strains to the hands and wrists, is called carpal tunnel syndrome.
|
Prepare a pro forma income statement
: Discuss how Quaker Crackers results compare to its industry - prepare a pro forma income statement (using the table in excel) before proceeding
|
Determine the value of variable from the given information
: Suppose you are working with a data set that is normally distributed, with a mean of 200 and a standard deviation of 47.
|
Primary language-primary language
: Indicate a connection between this event/group of people and the impact of gender and culture, family therapy theories, etc.
|