Ask Question, Ask an Expert


Ask Advanced Statistics Expert

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.

i) All numbers above are available in an Excel data file.

ii) Your submission must include a properly documented and working copy of your model (your Excel spreadsheet and Solver model) with annotations as needed to describe unclear calculations.

iii) 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 by holding the “Ctrl” button on your keyboard while dragging the 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?

Advanced Statistics, Statistics

  • Category:- Advanced Statistics
  • Reference No.:- M9508

Have any Question? 

Related Questions in Advanced Statistics

The final research proposal will consist of the following

The FINAL research proposal will consist of the following NINE (9) items: 1. A business research topic. Strengthen and improve initial proposal. 2. A brief literature review of the research topic Produce 2 to 3 pages on ...

Question1auditors for the military airlift command mac are

Question: 1. Auditors for the Military Airlift Command (MAC) are checking the arrival times of the three charter airlines they used in the Pacific last year. Branflake Airways flew 135 flights and was late 78 times. Flyi ...

Question strength of relationshipawhat is the relationship

Question: Strength of relationship a. What is the relationship between undergraduate GPA and graduate GPA?  Pearson's r= +.375 b. What is the relationship between class size and Graduate GPA Pearson's r= -2.70 c. What is ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate