Determine the level of total revenues

Assignment Help Accounting Basics
Reference no: EM131496825

Problem 1 -

Cavalier Chairs, Inc., a producer and retailer of custom design office chairs, is considering opening a new retail store.

In negotiating the cost of the space, they were given two rental options:

  • Option 1 - A fixed rental price of $1,200 per week; OR
  • Option 2 - A rental charge based on total sales. The charge would be 15% of monthly sales revenue plus a fixed monthly payment of $1,000.

For the new retail store, Cavalier Elements estimates that their other costs would be:

  • Average cost of store items = $175 per unit
  • Store manager's salary = $850 per month
  • Sales commissions = 10% of sales revenue
  • Other selling, general and administrative expenses = 8% of sales plus a monthly cost of $1,000 per month, (i.e. this amount does not include store rental costs or store manager's salary).

The average selling price of a Cavalier's office chair is $375 each.

Required -

a. Assuming the initial month's expected unit sales are 50 chairs, prepare a Contribution Margin Income Statement for Option 1 and a Contribution Margin Income Statement for Option 2,

b. Compute the breakeven in sales units for (a) Option 1 and (b) Option 2.

c. Determine the level of total revenues at which the company will be indifferent between Option 1 and Option 2.

d. Compute the degree of operating leverage at sales of 50 units for (a) Option 1 and (b) Option 2.

e. Given your computation in d., which Option will have the greater increase in income with increases in sales activity? Please explain your answer.

f. Given your computation in d., which Option is the least risky Option if the demand for Cavalier's chairs declines in subsequent period? Please explain your answer.

Problem 2 -

In preparation for arranging a $300,000 bank line of credit, Terra, Inc. needs to prepare a detailed budget.

Their budget director has completed parts of the budget.  For example, he has provided the following budgeted sales for the selected four-month period:

Month

Unit Sales

April

100,000

May

155,000

June

115,000

July

130,000

At the beginning of April, the company had 40,000 units of finished goods in inventory.

Their budget guidance indicates that they should retain their levels of finished goods inventory equal to 20 percent of the unit sales for the next month.

In addition, in their production process:

  • They use 5 pounds of a single raw material for each unit produced. Each pound of material costs $8.
  • Plans are to have inventory levels for materials equal to 25% percent of the amount of materials needed to satisfy next month's production and 175,000 units of raw material on hand at the end of June.
  • Materials inventory on April 1 was 118,000 pounds.

Required: Using the given information, prepare the following:

a. A Production budget in units for April, May, and June.

b. A Materials Purchases budget in pounds and in dollars for April, May, and June.

Additionally, answer the following questions:

c. Explain the term/concept of budgetary slack.  Why does it occur?  What is the primary indication that budgetary slack is occurring?

d. Management experts argue that motivational considerations should be a part of budget planning and utilization.  What do you believe is their reason for such an observation?  Do you agree? Please explain your answer.

e. Lastly, please list 4 steps a manager might take to motivate employees to participate effectively in the budgeting process.

Problem 3 -

Comfort & Ease, Inc. produces and sells mattresses.  The mattresses are available in the traditional sizes - Double, Queen, and King.

Frank Burns, the company Controller, prepared a Brand Profit Report detailing the profitability of the 3 brands:


Double

Queen

King

Total

# units sold

20,000

30,000

50,000

100,000






Sales

$200,000

$450,000

$1,000,000

$1,650,000

Less: Variable costs

(100,000)

(270,000)

(600,000)

(970,000)

Less: Fixed costs

(110,000)

(165,000)

(275,000)

(550,000)

Income/ (Loss)

$ (10,000)

$ 15,000

$ 125,000

$ 130,000

In the Brand Profit Report, variable costs represent the direct costs associated with producing the mattresses (e.g. materials and labor, etc.) and fixed costs represent common costs shared by all the products (e.g. depreciation, insurance, supervisor salaries, etc.).  Common costs are allocated based on #units produced and sold (assume the company sells all that it produces).

When Caroline Ease, the company's President, reviewed the analysis, she asked Mr. Burns what the effect on Operating Income would be, if the company discontinued producing and selling the "Double" mattress size.

Required -

a. Revise the Brand Profit Report assuming the "Double" mattress brand is discontinued.

b. After revising the Brand Profit Report in part a. above, if either the Queen or King brand shows an Operating Loss, further revise the Brand Profit Report to show the implications of discontinuing that item.

c. Write a brief note explaining your observations regarding discontinuing unprofitable brands when common costs are part of the profit analysis, including a recommendation of whether to proceed with that option.

d. Ignoring the results from parts a., b., & c. above, revise the original Brand Profit Report, assuming the company discontinues the "Double" brand and they use the "Double" brand sales team to increase the sales of "Queen" mattresses by 20% and to increase the sales of "King" mattresses by 30%.

e. Write a brief note explaining your observations in part d., including a recommendation of whether to proceed with the proposal in part d.

Reference no: EM131496825

Questions Cloud

Define relationship in personal ethics and business ethics : How can firms best ensure that their code of business ethics is read, understood, believed, remembered, and acted upon?
Contrast the project management life cycle : Compare and contrast the project management life cycle with the system development life cycle (SDLC)?
Discuss the concept of whistle blowing : Why is it important not to view the concept of "whistle blowing" as "tattle-telling" or "ratting" on another employee?
Identify common health traditions based on cultural heritage : Identify common health traditions based on cultural heritage. Evaluate and discuss how the families subscribe to these traditions and practices.
Determine the level of total revenues : Determine the level of total revenues at which the company will be indifferent between Option 1 and Option 2. Compute the breakeven in sales units for Option 1
Is eva really an improvement over roi roe or eps : What are some examples of behavior, out put,and in put controls?
What are common-size finance al statements : Why should you begin a case analysis with a financial analysis? When are other approaches appropriate?
Imagine that an associate of yours : Imagine that an associate of yours just designed a table with captions outside the table's borders.
What is the importance of cultural competency in nursing : What is the importance of cultural competency in nursing practice? Support your response.

Reviews

Write a Review

Accounting Basics Questions & Answers

  The following standards for variable overhead have been

the following standards for variable overhead have been established for a company that makes only one productstandard

  Sweet dreams inc manufactures bedding sets the budgeted

1. crow manufacturers inc. projected sales of 64363 bicycles for 2012. the estimated january 1 2012 inventory is 5278

  Explain calculation of goodwill impairment under us gaap

Explain in your own words the testing and calculation of Goodwill Impairment under US GAAP. Provide citation from ASC 350.

  In this case the customer is using six sigma to reduce

in this case the customer is using six sigma to reduce defects in a service.ltbr gtthe general situationltbr gta number

  Estimate the production level

1. Estimate the production level required for the coming year to meet these objectives.

  Calculate the break even volume for both technologies

A firm in its plans for a new facility is considering two production technologies, A and B. Technology A involves higher variable costs techniques; technology B relies on higher fixed cost production techniques.

  Data indicates that there is a 69 chance that a business

consider newly incorporated small businesses in a certain area. data indicates that there is a 69 chance that a

  What is the appropriate accounting treatment

What is the specific citation that describes the guidelines for reporting legal costs? What is the appropriate accounting treatment?

  Assuming that the perpetual inventory system is used

Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale.

  At year-end december 31 chan company estimates its bad

at year-end december 31 chan company estimates its bad debts as 0.30 of its annual credit sales of 753000. chan records

  Wages from a part-time job

O.2 Compute the 2015 standard deduction for the following taxpayers. Margie is 15 and claimed as a dependent by her parents. She has $800 in divi- dends income and $1,400 in wages from a part-time job.

  Norton company reports the following operating results for

norton company reports the following operating results for the month of august sales 305000 units 5000 variable costs

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