21 May WHAT ARE THE APPARENT LIMITING RESOURCE CONSTRAINTS IN YOUR SOLUTION AND IN WHICH PERIOD DO THEY OCCUR?
check the two files attached as one for data and one for the problem.
Greater Ware Clothing, Inc. manufacturers and sells shirts and other apparel to retailers in the local area.
Orders have been received and Greater Ware is interested in planning shirt production over the next two
months. The following information has been gleaned from conversations with plant management:
At the beginning of month one, there are 75 shirts in inventory. Retailers have placed orders for 1300
shirts in month one and 1250 shirts in month two. Management insists that these orders are filled. Each
shirt delivered to a retailer brings in $12.75 in revenue. Management has requested that at least 50 shirts
be kept in ending inventory due to sudden changes that can occur in ordering.
To make each shirt, 2.1 square yards of cloth are needed. There are currently 100 square yards of cloth in
inventory. Up to 2800 square yards of cloth can be purchased each month for a cost of $2.55 and $2.70
per yard in month 1 and month 2 respectively. Cloth that is not used in one month can be stored and used
in subsequent months.
Each shirt requires 30 minutes of labor time to produce. Current employment is expected to allow for up
to 670 hours of labor in month one and 700 hours in month two. These figures cannot be altered by hiring
more employees. The cost per hour for labor is $9.30.
! All numbers above are available in an Excel data file.
! Your submission must include a properly documented and working copy of your model (your Excel
spreadsheet and Solver model) with annotations as needed to explain unclear calculations.
! This is a linear model. If your model requires a different engine, then you need to rethink your
approach to the model. Remember, there are no IF, Max, or MIN statements (or other disjointed
functions) in linear models.
Make a new copy of your model above E KROGLQJ WKH ³&WUO´ EXWWRQ RQ RXU NHERDUG ZKLOH GUDJJLQJ WKH
worksheet tab to the right with your mouse, creating a new worksheet tab. Delete any range names on
this tab by accessing the Formulas | Name Manager menu option. On this new tab, model and analyze the
following modification to the original situation:
Aggressive sales by company representatives have generated additional demand. Demands figures for
month one and two are now 1600 and 1750 shirts respectively. It is no longer possible to fill all
demand orders each month. Modify your model (this will require additional decision cells to allow
for the company to sell less than demand). Note that demand not filled in one month does not transfer
to subsequent months (this will make things much easier). What are the apparent limiting resource
constraints in your solution and in which period do they occur?
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.