Question

Questions 1-30 refer to the following problem: A farmer can grow wheat or corn. The unit profits for a bushel of each are the same. To grow wheat (W) and corn (C), the farmer requires four input factors: Capital (K), land (L), A-Fertilizer (A), and B-fertilizer (B). The production of one bushel of corn requires two units of capital and the production of one unit of wheat four units of capital. The farmer has 32 units of capital available. The production of one bushel of corn requires two units of land and the production of one unit of wheat one unit of land. The farmer has 20 units of land available. The production of one bushel of corn requires two units of A- Fertilizer, and no B-fertilizer. The farmer has 18 units A-Fertilizer available. The production of one bushel of wheat requires one unit of B fertilizer, and no A-fertilizer. The farmer has 6 units of B-Fertilizer available. The farmer wants to maximize profits. In programming the above model into Excel, you have to fill out a spreadsheet like the one below. A B C D F 2 Corn Wheat 3 Unit Profits 1 Opt. Solution 4 Opt. Quant a. EITTET 6 Constraints Corn Wheat Actual Usage Maximum Allowable Usage 7 Capital b. C. n. Land d. e. O. 9 A-Fertilizer f. p. 10 B-Fertilizer h. i. m. q. 15. What value do you enter into cell c 2 C C A B C 1 2 Corn Wheat 3 Unit Profits 1 1 Opt. Solution 4 Opt. Quant a. 6 Constraints Corn Wheat Actual Usage Maximum Allowable Usage 7 Capital b. C. n. Land d. e. O. A-Fertilizer f. p. 10 B-Fertilizer h. i. m. 16. What value do you enter into cell d. 4 2 0 CO et A B C E F 1 2 Corn Wheat 3 Unit Profits 1 1 Opt. Solution Opt. Quant a. Constraints Corn Wheat Actual Usage 6 Maximum Allowable Usage 7 Capital b. j. n. Land d. k. O. 9 A-Fertilizer f, g. 10 B-Fertilizer h. i. m. q. 17. What value do you enter into cell e. 2 ai po C

Answer 1

As mentioned in the problem,

Production of one unit wheat require 4 units of capital so in cell c - 4

Production of one bushel of  corn require 2 units of land so in cell d- 2

Production of one unit wheat require 1 units of land so in cell e - 1