Jane macfarlene wants a weekly schedule for two business


Jane MacFarlene wants a weekly schedule for two business services, X and Y. Each 'unit' of X delivered to customers needs one service package, while each unit of Y uses two of the packages, and Jane has a maximum of 110 packages available a week. Each unit of X and Y needs 10 hours of subcontracted work, and Jane has signed agreements with subcontractors for a weekly minimum of 130 hours and a maximum of 650 hours. Jane knows from market surveys that demand for Y is high, and she will have no trouble selling any number of units. However, there is a maximum demand of 50 units of X, despite a long-term contract to supply 10 units to one customer. The net profit on each unit of X and Y is $2000 and $3000 respectively. State the objective function mathematically State the constraints mathematically Do not solve problem graphically Setup the model in excel and use solver to determine the optimized solution (please give step by step excel instructions).

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Jane macfarlene wants a weekly schedule for two business
Reference No:- TGS02432088

Expected delivery within 24 Hours