Formulate as lp and setup and solve the problem in excel

Assignment Help Operation Management

Reference no: EM131855146

M&M is a company that makes knitted sweaters. Forecasts of sales for the next year are 150 in the autumn, 400 in the winter, and 50 in the spring. Plain sweaters are purchased from a supplier for $20.

The cost of capital is estimated to be 24% per year (or 6% per quarter); thus, the inventory holding cost per item is 0.06 × ( $20 ) = $1.20 per item in the ending inventory per quarter.

The company hires art students part - time to craft designs during the autumn, and they earn $5.50 per hour.

Because of the high demand for part - time help during the winter holiday season, labor rates are higher in the winter, and workers earn $7.00 per hour. In the spring, labor is more difficult to keep, and the owner must pay $6.25 per hour to retain qualified help.

Each sweater takes 2 hours to complete. We can hold about a maximum of 100 sweaters in house every quarter, if we need to hold more inventory then we can rent a warehouse which costs us $1.00 per item in the ending inventory per quarter. However, you cannot rent a warehouse unless the in-house warehouse in filled up.

There is maximum limit to the amount of inventory to be held in the rented warehouse.

Formulate as LP, setup and solve the problem in Excel. Please clearly specify your decision variables and define them properly.

Reference no: EM131855146

Questions Cloud

Caring for clients with fluid : Case Study, Chapter 16, Caring for Clients With Fluid, Electrolyte, and Acid-Base Imbalances

What ethical issues is heather facing in this situation : How effectively do you think Ma Earth is practicing corporate social responsibility in this situation? Explain the reasoning behind your evaluation.

Discuss the issues related to firm integration : Your company is in the process of installing its first "big data" system. Discuss how you would ensure that the traditional challenges of integration- access.

What are the cultural competency mandates : Question: What are the cultural competency mandates of the Joint Commission?

Formulate as lp and setup and solve the problem in excel : Formulate as LP, setup and solve the problem in Excel. Please clearly specify your decision variables and define them properly.

Risks for acquiring future infections : a. What are the factors that increase the client's susceptibility to acquire the pneumoniainfection? b. What are ways to decrease risks for acquiring future

Write a non-recursive program to print out the keys : Write a non-recursive program to print out the keys from a binary search tree in order.

What is the total cost of producing given number of lots : A company can produce a small lot of products the first time at a cost of $2,000. If their 85 percent learning curve allows them to reduce their costs.

What is the probability that a weld which machine indicates : What is the probability that a weld which the machine indicates to be defective is in fact satisfactory?

User Account

All Pages