Determine two-month production schedule at minimize cost

Assignment Help Operation Management

Reference no: EM131229230

A sporting goods manufacturer is developing a production schedule for two types of racquetball racquets. An order has been received for 180 of the standard model and 90 of the professional model. These are to be delivered at the end of this month. Another order has been received for 200 of the standard model and 120 of the professional model, but these are not to be delivered until the end of next month. Production in each of the two months may be in normal time or overtime. In the current month, a standard racquet may be produced at a cost of $40 on normal time, and a professional model may be produced at a cost of $60 on regular time. Overtime raises the cost of these to $50 and $70. Due to a new labor contract for next month, all costs will increase by 10% at the end of this month. The total number of racquets that may be produced in a month on regular time is 230, and an additional 80 racquets may be produced using overtime each month. Given the large order for delivery at the end of next month, the company is considering producing some extra racquets this month and keeping them in storage until the end of next month. The cost for keeping these in inventory for one month is estimated to be $2 per racquet.

Formulate and solve a linear program to determine a two-month production schedule at minimize cost.

Please solve using excel solver and show steps in excel

Reference no: EM131229230

Questions Cloud

Determining the elements of a valid contract : Is this a valid contract? Review the elements of a valid contract, which have been discussed thus far in this course, as you respond to this question. Define consideration and explain why you are of the opinion that there is or is not consideratio..

Identifying and assessing the project risks : How can a risk assessment matrix help in the process of identifying and assessing the project risks?

Are laws related to oil and gas development sufficient : Are laws related to oil and gas development sufficient? Do they protect the environment? Do they encourage industry? Include any personal or work experience that you have related to oil and gas laws. 100 Words and APA format.

Using moral language with respect to-making moral : What is the point, if any, of using moral language with respect to and making moral judgments about corporations? Give an example of the use of such language.

Determine two-month production schedule at minimize cost : A sporting goods manufacturer is developing a production schedule for two types of racquetball racquets. An order has been received for 180 of the standard model and 90 of the professional model. These are to be delivered at the end of this month. Fo..

Effect of high flow oxygen on mortality : What was the population being studied - Did the subjects represent this population? Include considerations such as sample size and age, gender, ethnicity etc. where appropriate.

Nonprofit institution is not merely delivering a service : "The nonprofit institution is not merely delivering a service. It wants the end user to be not a user but a doer. It uses a service to bring about a change in a human being" Please describe in details what this quote means.

Which jury is the appropriate jury to hear the related cases : If a plane leaves from San Francisco traveling to Scotland, but crashes over Pennsylvania where is jurisdiction proper to hear cases relating to the plane crash? Which jury is the appropriate jury to hear the related cases? Not, this is not an o..

What are virtual organizations : What are virtual organizations? Please provide an example. How can a virtual organization reduce costs?

User Account

All Pages