Agricultural supply is mixing a fertilizer to sell to farmer

Assignment Help Operation Management

Reference no: EM131152736

Jericho Agricultural Supply is mixing a fertilizer to sell to farmers. The agricultural supplier creates two fertilizer blends out of pure ingredients. Blend A uses 10 lbs of nitrogen and 10 lbs of phosphate in each 20 lb bag. Blend B uses 16 lbs of phosphate and 4 lbs of nitrogen in each 20 lb bag. A bag of Blend A sells for $16, while a bag of Blend B sells for $18. The supplier has 200 lbs of phosphate and 240 lbs of nitrogen to work with. How many bags of each kind of fertilizer should the agricultural supplier mix to generate the maximum gross income? Formulate a linear programming model and solve it graphically. Display your graph and calculate the maximum gross income. Create your graph using Microsoft Word or Excel and submit it to your instructor.

I need help with setting up the solution within excel.

Reference no: EM131152736

Questions Cloud

Provide a history of its use as a weapon of terrorist hazard : Provide a history of its use as a weapon of mass destruction (WMD); describe how it is made and dispersed, signs and symptoms of its use; circumstance where it would be the weapon of choice.

Support the strategy focused on customer service : Operating a bank, for example layout of facility, staff, drive-through service. Then identify ways that they can be improved at Prime Bank in order to support the strategy focused on customer service.

Why is the hospital considering this additional service : Is it financially viable for a hospital to offer this service? What costs and revenues would you predict to know the viability? Would any revenues cover the costs of offering this service?

Determine the greatest load p the beam : Determine the greatest load P the beam will support without causing the A992 steel member BC to buckle. Due to the forked ends on the member, consider the supports at B and C to act as pins for x-x axis buckling and as fixed supports for y-y axis ..

Agricultural supply is mixing a fertilizer to sell to farmer : Jericho Agricultural Supply is mixing a fertilizer to sell to farmers. The agricultural supplier creates two fertilizer blends out of pure ingredients. Blend A uses 10 lbs of nitrogen and 10 lbs of phosphate in each 20 lb bag. Blend B uses 16 lbs of ..

How do you create a list using a listview control : Discussion questions for Android Develpers. How do you create a list using a ListView control? Discuss adding the Images to the Resources Folder.

Produces memory units for specialized applications : FireBurst Electronics produces memory units for specialized applications. Unit A provides 2 GB of high-bandwidth memory and 18 GB of low-bandwidth memory. Unit B provides 0.5 GB of high-bandwidth memory and 60 GB of low-bandwidth memory. Display you..

Determine the factor of safety with respect to buckling : Due to the forked ends on the member, consider the supports at B and C to act as pins for x-x axis buckling and as fixed supports for y-y axis buckling. Determine the factor of safety with respect to buckling about each of these axes.

Calculate the average miles per gallon obtained on a trip : Write a program that will calculate the average miles per gallon obtained on a trip. Input the amount of gas used and the number of miles driven.

User Account

All Pages