Use the shells as the basis for solving the problems.Submit the workbook via Blackboard by the assigned due date.
1. A farmer in Iowa owns 46 acres of land. She is going to plant each acre with wheat or corn. Each acre planted with wheat yields $200 profit; each with corn yields $300 profit. The labor and fertilizer used for each acre are given in Table 1. One hundred workers and 120 tons of fertilizer are available.
a) Use Solver to help the farmer maximize the profit from her land.
b) Confirm graphically that the solution from part a maximizes the farmerâ€™s profit from her land. (Use the Draw tool bar.)
Data for Farmer Problem
c) Use SolverTable to see what happens to the decision variables and the total profit when the availability of fertilizer varies from 20 tons to 220 tons in 20-ton increments.
When does the farmer discontinue producing wheat? When does she start producing corn?
How does the profit change for each 20-ton increment?
d) Using Solverâ€™s Sensitivity Report, determine how much the profit per acre of wheat can increase and not change the acres planted. How much can it decrease and not change the acres planted?
e) Using Solverâ€™s Sensitivity Report, if the amount of workers available is increased by 15, what is the change in total profit? What is the change in total profit if it is decreased by 43?
2. Bloomington Brewery produces beer and ale. Beer sells for $5 per barrel, and ale sells for $2 per barrel. Producing a barrel of beer requires 5 pounds of corn and 2 pounds of hops. Producing a barrel of ale requires 2 pounds of corn and 1 pound of hops. The brewery has 60 pounds of corn and 25 pounds of hops.
a) Use Solver to maximize Bloomington Breweryâ€™s revenue.
b) Confirm graphically that the solution in part a maximizes Bloomington Breweryâ€™s revenue.(Use the Draw tool bar.)
c) Starting with the optimal solution to the previous problem, use Solverâ€™s Sensitivity Report to either substantiate or refute the following statements: The availability of corn can decrease by any amount (up to 60 pounds), and each unit decrease will cost Bloomington Brewery the same amount in terms of lost revenue. On the other hand, increases in the availability of corn do not have a constant effect on total revenue; the first few extra units have a larger effect than subsequent units.
d) Use SolverTable to see how total revenue changes as the price of a barrel of beer varies from $2 to $10 per barrel in increments of $1 and simultaneously the available corn varies from 50 pounds to 70 pounds in increments of 2 pounds
a) For a telephone survey, a marketing research group needs to contact at least 150 wives, 120 husbands, 100 single adult males, and 110 single adult females. It costs $2 to make a daytime call and (because of higher labor costs) $5 to make an evening call. Table 5 lists the results that can be expected. For example, 30% of all daytime calls are answered by a wife, and 15% of all evening calls are answered by a single male. Because of a limited staff, at most half of all phone calls can be evening calls. Determine how to minimize the cost of completing the survey.
Data for Phone Problem
Percentage of Daytime Calls
Percentage of Evening Calls
b) Using Solverâ€™s Sensitivity Report, determine how much the cost of a daytime call can increase and still have the current solution remain optimal?
c) Using Solverâ€™s Sensitivity Report, determine the change in total cost if five additional husband made calls are required.
Our Service Charter
Excellent Quality / 100% Plagiarism-FreeWe employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
Free RevisionsWe keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
Confidentiality / 100% No DisclosureWe make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
Money Back GuaranteeIf the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
24/7 Customer SupportWe have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.