Solve the linear model

Assignment Help Advanced Statistics
Reference no: EM131408

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.

o All numbers above are available in an Excel data file.

o This is a linear model. If your model needs a different engine, then you need to rethink your approach to the model. Remember, there are no IF, Max, or MIN statements in linear models.

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 need 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?

Reference no: EM131408

Percentage change in shareholder wealth

Facebook sold shares to investors at $38 each in its IPO. One year later, its stock price was hovering around $26. What was the percentage drop in Facebook shares in its fir

Assets liabilities and equity

WACC The Patrick Company's year-end balance sheet is shown below. Its cost of common equity is 16%, its before-tax cost of debt is 13%, and its marginal tax rate is 40%.

Organizational performance in fortune company

Please help outline and draft a 2,800- to 3,500-word explanation of the affect of technology on organizational performance in a Fortune 500 company or comparable major publi

What is the probability the client receives an entire stream

what is the expected value and variance of the number of packet retransmissions that will occur before the full stream is received at the client and what is the probability

Statements regarding project crashing

The normal time to complete this activity is 8 days and crash time is 4 days. If this activity is crashed by 2 days it will cost an additional - statements regarding project

Making t-ledger and a journal

I just need help with setting this accounting question up on a t-ledger and a journal it has to be on an excel format as well. I am just confused on how to set it up

Critical analysis of scholarly article

Scholarly writers are aware of their audience and base their writing on solid evidence rather than on assumptions and/or opinions. In addition, scholarly writers must also u

Computing required rate of return

An analyst has modeled the stock of Crisp Trucking using a two-factor APT model. The risk-free rate is 6%, the expected return on the first factor (r1) is 12%

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd