Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Be sure to select Keep the Solver Solution and generate an Answer report. Determine: How much of each fertilizer should be purchased to satisfy the
Be sure to select Keep the Solver Solution and generate an Answer report. Determine: How much of each fertilizer should be purchased to satisfy the requirements at minimum cost? What is the minimum cost?
The facilities manager at Ontario Tech is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table: Mineral Minimum Weight (lb) Nitrogen 12 Phosphorus 14 Potash 18 Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. Nitrogen Phosphorus Potash Fertilizer Content {lb} Content lib) Content llbl Price (S) A 20 10 5 10 B 10 5 15 8 C 15 10 5 7 Using Excel Solver, determine how much of each fertilizer should be purchased to satisfy the requirements at minimum cost. Mike Famous Toys Input Area Processing Time (Hours) and Profit per Toy Delivery Truck Dump Truck Garbage Truck Gasoline Truck Matal Casting 2 2.5 2 2 Paint Spray 1 1.5 2 Packaging 0.5 0.5 1 1 Profit per Toy ($) $0.50 $1.00 $1.50 $2.00 UNKNOWN/DECISION VARIABLES Quantity Produced 0 0 200 800 Constraints Total Time Used Limitations Matal Casting 2000 4000 Paint Spray 1800Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started