AGEC 325 Name Assignment 18 Fall 2019 Aranch purchases feeder cattle and finishes them out each year. Some years the ranch makes money. other years they lose money. Budgeting before they buy the cattle helps them determine which result is more likely Based on budget projections they buy either 550-pound steer calves or 750-pound yearling steers. PURCHASE AND SELLING PRICE 550 lb. 750 lb. Calves Yearlings per head per head Purchase Price per cwt. $134.70 $124.75 Selling Price per cwt. $108.57 $113.85 Note: prices are quoted in Sper cwt. (100 pounds), convert the cattle weights in the budget to cwt, FEED RATIONS 550 lb 750 lb. Calves Yearlings per head per head Corn 52 Silage ton 2.45 1.50 Supplement lbs. 191 Expected Days on Feed 230 160 Selling Weight lbs. 1,150 1.250 48 120 ton VARIABLE COSTS 550 lb. 750 lb. Calves Yearlings per head per head Corn $4.12 $4.12 Silage $33.00 $33.00 Supplement lbs. $0.10 $0.10 Veterinary and health head $10.00 $8.00 Machinery and equipment operating head $11.00 $7.00 Marketing and miscellaneous head $14.00 $14.00 Labor cost per hour = $15.00 hour Interest rate for variable costs Note on interest rate for variable costs: The lender will finance only 50% of the feed and variable costs Interest on feed and other variable costs feed and other variable costs X 50% X (number of days funds are borrowed : 365) X interest rate for variable costs Interest on the cost of the animal = cost of the animal X (number of days owned + 365) X interest rate for variable costs OWNERSHIP COSTS of facilities and equipment: $10,000 per year spread over 500 head per year AGEC 325 Assignment 14 - ANSWER KEY Summer 2019 3. Using the information on page 1, de formation on page 1. develop an enterprise budeet for 750 lb. yearlings (7 points Name of enterprise: 750 lb. Yearling Steers Gross Revenue os Revenue Quantity Price Total ess 1% for death loss Gross Revenue Variable costs Purchase of feeder animal Interest on cost of feeder animal Feed Corn Corn Silage Supplement Other variable costs Veterinary and health Machinery and equipment operating costs Marketing and miscellaneous Labor Interest on feed, other variable costs Total variable costs Ownership costs for facilities, equipment Total of all costs Gross margin Profit and return to management Breakeven selling price needed to pay variable costs (reduce selling wt. 1% for death loss) 4. Given the selling prices and other budgeted costs, what is the highest purchase price that can be payed and just cover all your variable costs? Subtract all other variable costs from expected gross revenue and divide by the purchase weight. Don't worry about changing the interest cost. (5 points) AGEC 325 Name Assignment 18 Fall 2019 Aranch purchases feeder cattle and finishes them out each year. Some years the ranch makes money. other years they lose money. Budgeting before they buy the cattle helps them determine which result is more likely Based on budget projections they buy either 550-pound steer calves or 750-pound yearling steers. PURCHASE AND SELLING PRICE 550 lb. 750 lb. Calves Yearlings per head per head Purchase Price per cwt. $134.70 $124.75 Selling Price per cwt. $108.57 $113.85 Note: prices are quoted in Sper cwt. (100 pounds), convert the cattle weights in the budget to cwt, FEED RATIONS 550 lb 750 lb. Calves Yearlings per head per head Corn 52 Silage ton 2.45 1.50 Supplement lbs. 191 Expected Days on Feed 230 160 Selling Weight lbs. 1,150 1.250 48 120 ton VARIABLE COSTS 550 lb. 750 lb. Calves Yearlings per head per head Corn $4.12 $4.12 Silage $33.00 $33.00 Supplement lbs. $0.10 $0.10 Veterinary and health head $10.00 $8.00 Machinery and equipment operating head $11.00 $7.00 Marketing and miscellaneous head $14.00 $14.00 Labor cost per hour = $15.00 hour Interest rate for variable costs Note on interest rate for variable costs: The lender will finance only 50% of the feed and variable costs Interest on feed and other variable costs feed and other variable costs X 50% X (number of days funds are borrowed : 365) X interest rate for variable costs Interest on the cost of the animal = cost of the animal X (number of days owned + 365) X interest rate for variable costs OWNERSHIP COSTS of facilities and equipment: $10,000 per year spread over 500 head per year AGEC 325 Assignment 14 - ANSWER KEY Summer 2019 3. Using the information on page 1, de formation on page 1. develop an enterprise budeet for 750 lb. yearlings (7 points Name of enterprise: 750 lb. Yearling Steers Gross Revenue os Revenue Quantity Price Total ess 1% for death loss Gross Revenue Variable costs Purchase of feeder animal Interest on cost of feeder animal Feed Corn Corn Silage Supplement Other variable costs Veterinary and health Machinery and equipment operating costs Marketing and miscellaneous Labor Interest on feed, other variable costs Total variable costs Ownership costs for facilities, equipment Total of all costs Gross margin Profit and return to management Breakeven selling price needed to pay variable costs (reduce selling wt. 1% for death loss) 4. Given the selling prices and other budgeted costs, what is the highest purchase price that can be payed and just cover all your variable costs? Subtract all other variable costs from expected gross revenue and divide by the purchase weight. Don't worry about changing the interest cost. (5 points)
