Question

In: Accounting

Grosbeck Cattle Company has gathered the following information about operations for the past three years. Mathew...

Grosbeck Cattle Company has gathered the following information about operations for the past three years. Mathew Grosbeck has been expanding herd size and is frustrated that profits have not shown consistent growth. Available 20
Year 1 Year 2 Year 3 Your Score
Cow herd size 120 140 180
Revenues from sale of calves $       102,000 $       119,000 $       153,000
Feed             18,000             21,000             27,000
Labor (1 cowboy per 120 cows)             24,000             48,000             48,000
Cow depreciation             15,000             17,500             22,500
Bull depreciation (1 bull per 30 cows)               1,667               2,083               2,500
Medications/vaccinations               3,000               3,500               4,500
Land lease             10,000             10,000             10,000
Operating income             30,333             16,917             38,500
(a) Determine which costs are variable, fixed, and "step" fixed. Complete the "per unit" cost table on the preprinted worksheet.
(b) How much is the per-cow contribution margin?
(c) How do the "step" costs explain the struggle to achieve consistent growth in profits? What strategy should Mathew undertake to maximize profit potential for his operation?
(d) Assuming Mathew's land will support a herd of 240 cows, project anticipated profits.   Why is the profit more than twice as much as the amount that is earned on a herd size of 120 cows?

Solutions

Expert Solution

Cost per unit
Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 Nature of Exp
Cow herd size 120 140 180 120 140 180
Revenues from sale of calves 102000 119000 153000 850.00 850.00 850.00
Feed 18000 21000 27000 150.00 150.00 150.00 Variable
Cow depreciation 15000 17500 22500 125.00 125.00 125.00 Variable
Medications/vaccinations 3000 3500 4500 25.00 25.00 25.00 Variable
Contribution 66000 77000 99000
Bull depreciation (1 bull per 30 cows) 1667 2083 2500 13.89 14.88 13.89 Step Fixed
Labor (1 cowboy per 120 cows) 24000 48000 48000 200.00 342.86 266.67 Step Fixed
Land lease 10000 10000 10000 83.33 71.43 55.56 Fixed Costs
Profit 30333 16917 38500
Profit % 30% 14% 25%
Description Year 1 Year 2 Year 3
Sales 102000 119000 153000
Less : variable Cost 36000 42000 54000
Contribution 66000 77000 99000
Contribution per unit 550 550 550
Contribution margin 65% 65% 65%
Step Costs
This is a type of fixed cost that is only fixed within certain levels of activity. Once the upper limit of an activity level is reached then anew higher level of fixed cost becomes relevant.
In our case, One cowboy is required per 120 cows. Therefore, upto 120 cows, the cost is fixed, however, every single cow after that will bear this stepped fixed cost of $24000. As we can observe, although we have incurred labor cost for managing 240 cows, our herd size has not reached the level even after two years of operation. This under utilization of the labor resource directly hits our profit.
Similiarly 1 bull is required per 30 cows. Depreciation cost of a bull will increase in proportion to our herd size there by impacting our profit during increased operating levels.
If you want to improve the profit performance of your business, break even point analysissuggests that there are three main ways:
To increase sales volumes
To increase contribution rates
To reduce fixed costs
In order to nullify the impact of fixed costs, we need to increase the size of cow herd by atleast 65 thereby increasing revenue to maintain same level of profit.  
Fixed Costs
labor 24000
land lease 10000
bull 1668
Contribution per unit 550
Breakeven (Cows) 65
Once we make the herd size to 121, our labor costs are commited to $24000 extra and we need o increase the herd atleast by 44 to nullify such extra/step fixed cost
Anticipated
Cow herd size 240
Revenues from sale of calves 204000
Feed 36000
Cow depreciation 30000
Medications/vaccinations 6000
Contribution 132000 65%
Bull depreciation (1 bull per 30 cows) 3336
Labor (1 cowboy per 120 cows) 48000
Land lease 10000
Profit 70664
Profit % 35%
Since our Sales have increased in proportionate to the upper limit of step fixed cost per unit, we are anticipating profits. However, in order to sustain profits at this level, the next level of operation must be at 360 herd size.

Related Solutions

Overton Company has gathered the following information.
Overton Company has gathered the following information.Units in beginning work in process21,100Units started into production184,900Units in ending work in process24,700Percent complete in ending work in process:    Conversion costs60%    Materials100%Costs incurred:    Direct materials$103,000    Direct labor$263,576    Overhead$187,500Compute equivalent units of production for materials and for conversion costs.MaterialsConversion CostsThe equivalent units of production  Determine the unit costs of production. (Round unit costs to 2 decimal places, e.g. 2.25.)MaterialsConversion CostsUnit costs$$  Show the assignment of costs to units transferred out and in process.Transferred out$Ending work in process$
An analyst has gathered the following information about a company Income Statement for the Year 2004...
An analyst has gathered the following information about a company Income Statement for the Year 2004 Sales                                                      $1,500 Expenses COGS                        $1,300 Depreciation                     30 lnt Expenses                     40 Total expenses                                           1,370 Income from cont op                                     130 Gain on sale                                                   30 Income before tax                                         160 Income tax                                                     64 Net Income                                                   $96 Additional Information:                                               Dividends paid                                                                                                 $30 Common stock sold                                                                                            20 Equipment purchased                                                                                         50 Bonds issued                                                                                                      80 Fixed asset sold for (original cost of $100 with accumulated depreciation of $70)     60 Accounts receivable decreased by                                                                        30 Inventory decreased by                                                                                       20 Accounts payable increased by                                                                             20 Wages payable decreased by                                                                               10 What is...
The balance sheet includes the following information: A. Information about the firm's past operations B. Information...
The balance sheet includes the following information: A. Information about the firm's past operations B. Information to calculate financial ratios C. Information about the firm's current market value D. A, B, and C E. A and B When a firm declares dividends: A. Net income decreases and cash decreases B. Retained earnings decreases and cash increases C. Net income decreases and dividend payable increases D. Retained earnings decreases and dividend payable increases E. None of the above For a firm...
The following information is available for the first three years of operations for Jefferson Company: 1.  ...
The following information is available for the first three years of operations for Jefferson Company: 1.   Year                    Taxable Income       2017                         $500,000       2018                           375,000       2019                           400,000 2.   On January 2, 2017, heavy equipment costing $800,000 was purchased. The equipment had a life of 5 years and no salvage value. The straight-line method of depreciation is used for book purposes and the tax depreciation taken each year is listed below:                                                     Tax Depreciation                                                       2017              2018   ...
The following information is available for the first three years of operations for Jefferson Company: 1.  ...
The following information is available for the first three years of operations for Jefferson Company: 1.   Year                    Taxable Income       2017                         $500,000       2018                           375,000       2019                           400,000 2.   On January 2, 2017, heavy equipment costing $800,000 was purchased. The equipment had a life of 5 years and no salvage value. The straight-line method of depreciation is used for book purposes and the tax depreciation taken each year is listed below:                                                     Tax Depreciation                                                       2017              2018   ...
The following information is available for the first three years of operations for Wildhorse Company: 1....
The following information is available for the first three years of operations for Wildhorse Company: 1. Year Taxable Income 2020 $610,000 2021 460,000 2022 510,000 2. On January 2, 2020, heavy equipment costing $710,000 was purchased. The equipment had a life of 5 years and no salvage value. The straight-line method of depreciation is used for book purposes and the tax depreciation taken each year is listed below: Tax Depreciation 2020 2021 2022 2023 Total $234,300 $319,500 $106,500 $49,700 $710,000...
Basics of Productivity Measurement Holbrook Company gathered the following data for the past two years: Base...
Basics of Productivity Measurement Holbrook Company gathered the following data for the past two years: Base Year Current Year Output 910,000 1,080,000 Output prices $14 $14 Input quantities:    Materials (lbs.) 182,000 1,080,000    Labor (hrs.) 91,000 540,000 Input prices:    Materials $4 $5    Labor $8 $8 Required: 1. Prepare a productivity profile for each year. If required, round your answers to two decimal places. Holbrook Company Productivity Profile Base Year Current Year Materials productivity ratio Labor productivity ratio 2. Prepare partial income...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 3.20 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.10 pounds. Materials cost $1 per pound, but Stefani always takes the 1.00% cash discount all of its suppliers offer. Freight costs average $0.40 per pound. Direct labor. Each unit requires 2.90 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit. The average hourly...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 3.90 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.20 pounds. Materials cost $ 2 per pound, but Stefani always takes the 1.00 % cash discount all of its suppliers offer. Freight costs average $ 0.45 per pound. Direct labor. Each unit requires 2.60 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit....
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 4.20 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.70 pounds. Materials cost $1 per pound, but Stefani always takes the 2.00% cash discount all of its suppliers offer. Freight costs average $0.45 per pound. Direct labor. Each unit requires 1.60 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit. The average hourly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT