1. FERTILIZER NUTRIENTS (Please Use Excel and show screenshots:) )
A produce farmer is purchasing fertilizer containing threenutrients: nitrogen, phosphorus, and potassium. The farmer’sminimum weekly requirements are 240 units of nitrogen, 120 units ofphosphorus, and 80 units of potassium. There are two popular blendsof fertilizer on the market. Blend A costs $8.00 a bag, andcontains 4 units of nitrogen, 6 units of phosphorus, and 4 units ofpotassium. Blend B costs $10.00 a bag, and contains 12 units ofnitrogen, 2 units of phosphorus, and 2 units of potassium.
(a) How many bags of each blend should the farmer purchase eachweek to minimize the cost of meeting the nutrient requirements?
(b) What is the minimum weekly cost?
