Q: Based on Heady and Egbert (1964). Walnut Orchard has two
Based on Heady and Egbert (1964). Walnut Orchard has two farms that grow wheat and corn. Because of differing soil conditions, there are differences in the yields and costs of growing crops on the two...
See AnswerQ: Continuing the previous problem, use Goal Seek for each value of
Continuing the previous problem, use Goal Seek for each value of number mailed (once for 80,000, once for 90,000, and so on). For each, find the response rate that allows the company to break even. Th...
See AnswerQ: Julie James is opening a lemonade stand. She believes the fixed
Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand is $50.00. Her best guess is that she can sell 300 cups per week at $0.50 per cup. The variable cost...
See AnswerQ: Candy Kane Cosmetics (CKC) produces Leslie Perfume, which requires
Candy Kane Cosmetics (CKC) produces Leslie Perfume, which requires chemicals and labor. Two production processes are available. Process 1 transforms 0.3 unit of labor and 0.4 unit of chemicals into an...
See AnswerQ: Federated Oil has refineries in Los Angeles and Chicago. The Los
Federated Oil has refineries in Los Angeles and Chicago. The Los Angeles refinery can refine up to two million barrels of oil per year, and the Chicago refinery up to three million. After the oil is r...
See AnswerQ: Modify the employee scheduling model so that employees are paid $10
Modify the employee scheduling model so that employees are paid $10 per hour on weekdays and $15 per hour on weekends. Change the objective so that you now minimize the weekly payroll. (You can assume...
See AnswerQ: A feed company produces two types of cattle feed, both consisting
A feed company produces two types of cattle feed, both consisting totally of wheat and alfalfa. Feed 1 must contain at least 75% wheat, and feed 2 must contain at least 65% alfalfa. Feed 1 sells for $...
See AnswerQ: Carrington Oil produces gas 1 and gas 2 from two types of
Carrington Oil produces gas 1 and gas 2 from two types of crude oil: crude 1 and crude 2. Gas 1 is allowed to contain up to 4% impurities, and gas 2 is allowed to contain up to 3% impurities. Gas 1 se...
See AnswerQ: Based on Thomas (1971). A toy company produces toys at
Based on Thomas (1971). A toy company produces toys at two plants and sells them in three regions. The current demands at these regions are given in the file. Each plant can produce up to 4500 units....
See AnswerQ: A company produces two products: A and B. Product A
A company produces two products: A and B. Product A sells for $11 per unit and product B sells for $23 per unit. Producing a unit of product A requires two hours on assembly line 1 and one unit of raw...
See Answer
