A farmer in Wood County has 900 acres of land. She is going to plant each acre with com. soybeans, or wheat. Each acre planted with corn yields a $2,000 profit; each with soybeans yields $2,500 profit; and each with wheat yields $3,000 profit. She has 100 workers and 150 tons of fertilizer. The following table shows the requirement per acre of each of the crops. Assuming a linear relationship, use Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits. Com Soybeans Wheat Labor Fertilızer 01 0.3 0.1 0.2 0.2 04

A farmer in Wood County has 900 acres of land. She is going to plant each acre with com. soybeans, or wheat. Each acre planted with corn yields a $2,000 profit; each with soybeans yields $2,500 profit; and each with wheat yields $3,000 profit. She has 100 workers and 150 tons of fertilizer. The following table shows the requirement per acre of each of the crops. Assuming a linear relationship, use Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits. Com Soybeans Wheat Labor Fertilızer 01 0.3 0.1 0.2 0.2 04

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

please answer do not image.
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
Lamphere Lawn Care provides lawn and gardening services. The price of the service is fixed at a flat rate for each service, and most costs of providing the service are the same, given the similarity in the lawns and lots. The owner budgets income by estimating two factors that fluctuate with the economy: the contribution margin associated with each service call and the number of customers who will request lawn service. Looking at next year, the owner develops the following estimates of contribution margin (price less variable cost of the service, including labor) and the estimated number of service calls. Although the owner understands that it is not strictly true, the owner assumes that the cost of fuel and the number of customers are independent. Contribution Margin per Service Call Scenario Excellent Fair Poor (Price - $ 50 Variable cost) Service Calls 40 12 Number of 10,950 8,500 6,200 In addition to the variable costs of service, the owner estimates that other costs are $63,000…
Rae Dunn makes coffee cups and salad plates out of pottery. It can take her 6 minutes to produce a coffee cup and 3 minutes to produce a salad plate. When making the cups, she will need 34 lb of clay. To make a plate, she will need one lb of clay. She only wants to spend 20 hours a week making the cups and plates. She only found that she had 250 lbs of clay for this project. Rae Dunn does make a profit of $2.00 for each coffee cup and $1.50 for each plate. Let's help Rae Dunn determine what her maximum profit will be.