Question

In: Accounting

Miller Orchard Case - Paul and John Miller have just been presented with an offer from...

Miller Orchard Case -

Paul and John Miller have just been presented with an offer from their uncle.  Uncle Joe can no longer manage his orange orchard, which produces orange juice that is bought by local restaurants and diners to serve their customers; he has offered to turn it over to his nephews to manage as they like if they can provide him a small annual return (10% of sales revenue) to supplement his retirement.  Paul and John have grown up with the orchard and worked there all through their childhood, so they know the business well and love the work.  They are very excited by this prospect.

Miller Orchard typically yields about 1,200,000 pounds of oranges a season. Oranges are cultivated and harvested when ripe; then the juice is extracted.  The remaining pulp and rind are recycled back onto the fields whenever possible or disposed of. Paul and John know that the amount of oranges available for harvest and the amount of juice generated from the oranges is variable, however, dependent each year on a number of climatic and growing factors such as temperature, length of growing season, and fertilizers used. Every year so far, Miller Orchard has sold all the orange juice that it has produced.  The current selling price is $5 per bottle.

Uncle Joe presents the brothers with an Income Statement that he has had prepared for last year (see Exhibit 1).  He provides the following additional information:

Bottling

  • Requires 12 pounds of oranges for each bottle of juice.
  • In the bottling process, the juice is put into bottles, with both bottle caps and labels added during this process. The materials cost associated with the bottles, caps, and labels averages $1.25/bottle.

Direct labor

  • Harvest labor is paid an average of $9.00/hour. An average of 300 pounds of oranges can be harvested each hour.
  • Extraction labor is paid an average of $11.00/hour. The extraction process can be completed for 600 pounds of oranges each hour.

Overhead expenses

  • Supervisor salary -- supervises the production from the cultivation and harvest through the bottling processes. His salary and benefits total $80,000 annually.
  • Sales salary – a sales person receives salary and benefits of $60,000, plus $.50/bottle for each bottle sold.
  • Packing/shipping labor – workers pack 100 bottles per hour for shipment and are paid an average of $10.00/hour.
  • Waste treatment – After crushing, the pulp, seeds, and rind that are left over must be disposed of. One-half of the waste can be recycled back onto the fields as a compost material; the other half must be disposed of at a landfill with a dumping cost of $2,000.

Paul and John figure that if they can each earn salary and benefits of about $90,000 to start, they can support their families and start to develop a promising business. They plan to work the orchard themselves, eliminating the cost of the supervisor and sales manager (although they would probably need to pay distributors the $.50 for each bottle sold).  They anticipate that the remaining costs will be unchanged.

Required:

Based on Uncle Joe’s results from last year, determine which costs are variable and which are fixed, and then develop a contribution margin analysis for the venture.  What is the contribution per bottle of juice?

  1. What is the contribution margin with the changes that Paul and John want to make, assuming that production and sales remain the same?  What is the number of bottles of orange juice that they would need to sell to break even?
  2. If Paul and John find that they need to increase their own salary/benefit packages to $110,000, how many bottles would they need to sell?  Is this feasible?
  3. Should Paul and John investigate further before starting into this venture?  What other factors might impact the success of their business?  Should they accept?

Exhibit 1

Miller Orchard

Income Statement

For the Year Ended 12/31/15

Revenues

$500,000

Product costs

Harvest labor

36,000

Extraction labor

22,000

Bottles, labels, caps

125,000

Utilities

4,500

Waste treatment

2,000

Supervisor

80,000

Total product costs

269,500

Gross margin

230,500

Administrative & sales costs

Sales manager

$60,000

Sales commissions

50,000

Office supplies

10,000

Packing/shipping labor

10,000

Packing/shipping supplies

10,000

Total administrative & sales costs

140,000

Net operating profit

$  90,500

Solutions

Expert Solution

Particular Costs Variable/fix Reason
Product costs
Harvest labor                    36,000.00 Variable Directly attributed to product volume
Extraction labor                    22,000.00 Variable Directly attributed to product volume
Bottles, labels, caps                   125,000.00 Variable Directly attributed to product volume
Utilities                      4,500.00 Variable Directly attributed to product volume
Waste treatment                      2,000.00 Fix Not related directly to volume
Supervisor                    80,000.00 Fix Related to time
Sales manager                    60,000.00 Fix Related to time
Sales commissions                    50,000.00 variable Directly attributed to product volume
Office supplies                    10,000.00 Variable Assumed in absence of any information
Packing/shipping labor                    10,000.00 Variable Directly attributed to product volume
Packing/shipping supplies                    10,000.00 Variable Directly attributed to product volume
Sales                        500,000.00
Less:variable costs
Harvest labor                    36,000.00 Total sales 500000
Extraction labor                    22,000.00 S.P per bottle 5
Bottles, labels, caps                   125,000.00
Utilities                      4,500.00 No of bottles 100000
Sales commissions                    50,000.00
Office supplies                    10,000.00
Packing/shipping labor                    10,000.00
Packing/shipping supplies                    10,000.00
Present Contribution                        232,500.00
no of bottles                        100,000.00
Contibution per bottle                                    2.33
Present Contribution                       232,500.00
Calculation of Fix cost
Savings: Waste treatment                      2,000.00
sales manager salary Nil as it is fixed Supervisor Nil
supervisor manager salary Nil as it is fixed Sales manager Nil
sales commission 50000
Additional variable costs: Total                            2,000.00
10% of sales to uncle -50000 500000*10%
distributors expenses -50000 100000*0.5
Revised contribution                        182,500.00
no of bottles 100000
Revised contribution per bottle                                    1.83
Calculating BEP
Sales units* contribution per unit= Revised fix cost
Units*1.83=2000
Units 1093 2000/1.83
Desired Profit 220000 110000*2
Revised fix cost                            2,000.00
Desired contribution 222000
Contribution per unit                                    1.83
No of bottles to be sold                        121,645.00 222000/1.83
Pounds required                    1,459,740.00 121645*12
Available quantity 1,200,000
Not feasible as available quantity<desired quantity
Factors to be considerd
Certainity of all assumptions
uncertainity of all output to be produced and sold

Related Solutions

Maria and John have been married for 2 years and just learned that they are pregnant....
Maria and John have been married for 2 years and just learned that they are pregnant. They have been renting a small apartment but decide to purchase a house. They find one that is selling for $525,000. They decide to make a 15% down payment. Maria and Jon are considering 2 financing options: Option 1: a 4.0% interest 30-year mortgage Option 2: a 3.25% interest 15-year mortgage Answer the following questions showing all your work to reach each answer. A....
You have just been approached by a magazine with an offer for renewing your subscription. You...
You have just been approached by a magazine with an offer for renewing your subscription. You can renew for one year at $20, two years for $36, or three years at $45. Assuming that you have an opportunity cost of 20% and the cost of a subscription will not change over time, which of these three options should you choose? A) 1 year at $20 B) 2 years at $36 C) 3 years at $45
1.​Maria and John have been married for 2 years and just learned that they are pregnant....
1.​Maria and John have been married for 2 years and just learned that they are pregnant. They have been renting a small apartment but decide to purchase a house. The one they have found has a selling price of $300,000. They will make a 20% down payment. They are considering 2 financing options at their credit union: Option 1: ​ 3.125% interest 30-year mortgage:    Option 2: ​2.5% interest 15-year mortgage: Answer the following questions showing all your work to reach...
John Paul is the bookkeeper for Eaton Company. John has been trying to get the balance sheet of Eaton Company to balance.
E1-10B John Paul is the bookkeeper for Eaton Company. John has been trying to get the balance sheet of Eaton Company to balance. It finally balanced, but now he’s not sure it is correct.EATON COMPANYBalance SheetDecember 31, 2014AssetsLiabilities and Stockholders’ EquityCash$28,500Accounts payable$ 6,000Supplies4,500Accounts receivable(15,000)Equipment30,000Common stock42,000Dividends10,000Retained earnings40,000Total assets$73,000Total liabilities and    stockholders’ equity$73,000InstructionsPrepare a correct balance sheet.
John and Kathy Brown have just been audited and the IRS agent disallowed the business loss...
John and Kathy Brown have just been audited and the IRS agent disallowed the business loss they claimed in 2015. The agent asserted that the activity was a hobby, not a business.                 John and Kathy live in Rochester, New York, near Lake Ontario. Kathy is a CPA, and John was formerly employed by an insurance firm. John’s firm moved in 2006 and John resolved not to move to the firm’s new location. Instead of seeking other employment John felt...
Ava Miller has just completed the second year of operating her veterinary clinic. You have been...
Ava Miller has just completed the second year of operating her veterinary clinic. You have been retained by Ava for tax assistance and advice. At a recent meeting, you gathered information on her practice, which is presented below. For the year ended December 31, 2020, the clinic showed a profit of $123,700, as follows: Professional service $321,000 Gross profit from surgical instrument sales 28,000 $349,000 Administration and other expenses (228,300) 120,700 Interest income 3,000 Net income $123,700 Included in the...
An Ambulatory Surgery Center (ASC) has been presented with a proposal to offer a new diagnostic...
An Ambulatory Surgery Center (ASC) has been presented with a proposal to offer a new diagnostic procedure that would require the purchase of a specialized piece of equipment. This piece of equipment offers physicians the opportunity to diagnose many types of medical conditions. You've been asked by the Center’s administrator to use the techniques of preparing a discounted cash flow analysis to evaluate it from an economic point of view by computing the Net Present Value and Internal Rate of...
Case Study: Real Estate Investment Trust (REIT) You have been presented with the following set of...
Case Study: Real Estate Investment Trust (REIT) You have been presented with the following set of financial statements for the Lynn Associates Trust (LAT), a REIT that is about to make an initial stock offering to the public. This REIT specializes in the acquisition and management of regional shopping centers. Your firm, Blue Street Advisors (BSA), is an investment management company that is considering the purchase of LAT shares. You have been asked to prepare a financial analysis of the...
Mini Case Assume you have just been hired as a business manager of PizzaPalace, a regional...
Mini Case Assume you have just been hired as a business manager of PizzaPalace, a regional pizza restaurant chain. The company’s EBIT was $120 million last year and is not expected to grow. PizzaPalace is in the 25% state-plus-federal tax bracket, the risk-free rate is 6 percent, and the market risk premium is 6 percent. The firm is currently financed with all equity, and it has 10 million shares outstanding. When you took your corporate finance course, your instructor stated...
It is Business Law, question no. 2 Case description You have just been hired by Widget...
It is Business Law, question no. 2 Case description You have just been hired by Widget Corporation and, unfortunately, this company has just had a suit filed against it in Texas. The President of Widget Corporation, your new boss, is going to hire an attorney to litigate the case, but wants to first understand the potential issues of the case. He has asked you to evaluate the situation and write a report identifying and discussing both the procedural law and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT