SuperTutor

(15)

$15/per page/Negotiable

About SuperTutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,Engineering,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 328 Weeks Ago, 2 Days Ago
Questions Answered: 12843
Tutorials Posted: 12834

Education

  • MBA, Ph.D in Management
    Harvard university
    Feb-1997 - Aug-2003

Experience

  • Professor
    Strayer University
    Jan-2007 - Present

Category > Business & Finance Posted 23 Jun 2017 My Price 7.00

Jane M wants a weekly schedule

Jane M 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 and show formulas/cells so I can get a better understanding of the process) Thanks!

Answers

SuperTutor
(15)
Status NEW Posted 23 Jun 2017 06:06 AM My Price 7.00

-----------

Attachments

file 1498198121-Solutions file.docx preview (56 words )
S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e. ----------- H-----------YPE-----------RLI-----------NK -----------&qu-----------ot;-----------htt-----------p:/-----------/wo-----------rkb-----------ank-----------247-----------.co-----------m/&-----------quo-----------t; -----------\t -----------&qu-----------ot;-----------_bl-----------ank-----------&qu-----------ot;----------- -----------Tha-----------nk -----------you----------- -----------
Not Rated(0)