Question: This problem must be typed (in Excel). Ensure to align the decision variables in both the objective function and constraints. You should only type the

This problem must be typed (in Excel). Ensure toThis problem must be typed (in Excel). Ensure toThis problem must be typed (in Excel). Ensure to align the decision variables in both the objective function and constraints. You should only type the LP problem

Two types of catfood are manufactured by a company, Regular and Premium, with the following characteristics. Regular Premium $3.41 $4.23 2,678 1,961 Selling price (kg) Maximum kg demanded Protein quality per kg (minimum) Fat per kg (maximum) 24% 31% 19% 14% These catfoods are made by combining two ingredients, A and B, with the following characteristics. A B $2.12 $2.64 2,725 2,200 Cost (kg) Availability (kg) Protein quality per kg Fat per kg 20% 38% 23% 8% Use the following decision variables to formulate the linear programming model to maximize profit. Ag = kilograms of ingredient A in Regular Ap = kilograms of ingredient A in Premium BR = kilograms of ingredient B in Regular Bp = kilograms of ingredient B in Premium D E F G H J K L M B Protein quality per kg 20% Fat per kg 23% 38% 8% Decision Variables Ar = kilograms of ingredient A in Regular Ap = kilograms of ingredient A in Premium Br = kilograms of ingredient B in Regular Bp = kilograms of ingredient B in Premimum Ar + Ap + Br + A 14 15 16 17 18 19 20 21 22 23 24 25 26 27 1 28 29 2 30 31 3 32 33 4 34 35 5 36 376 38 397 40 41 8 42 439 44

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!