Formulate an ip model that will assist catatonic

Assignment Help Other Subject
Reference no: EM133063407

Question 1. [Transportation] J'Vita Ultra-Trendy Supply (JUTS) is a wholesale distributor of supplies for beauty and barbershops. JUTS can maintain wholesale centres for Clearall products, its most profitable line, only in two locations: Winnipeg and Montreal. JUTS ships Clearall products to retail outlets in Edmonton, Toronto, and Halifax.

This month, JUTS Montreal centre has 1800 cases of Clearall products available for shipment, while its Winnipeg centre can ship 1300 cases. The Edmonton outlet places a monthly order of 1000 cases, Toronto an order of 1500 cases, while Halifax an order of 600 cases. Carol Smith, the manager of JUTS, has worked out a table of costs per case for shipping as shown in the table below, and she is interested in reducing the shipping cost as much as possible while meeting customer demand.

asd Edmonton Toronto Halifax Available
Winnipeg

$5

$5

$7

1300

Montreal

$3

$2

$4

1800

Need

1000

1500

600

 

Formulate the problem as an LP problem to satisfy demand in Edmonton, Toronto, and Halifax while minimizing transportation costs. Do not solve!

Question 2. [Scheduling, 20 points] Catatonic manufactures and sells accessories for cats. They operate a call center for customer questions and complaints from 10am EST to 8pm EST seven days per week. Customer service staff work 4 days and then get 3 days off in a continuous rotation. That is, they work the same 4 days every week. Call volumes are reasonably stable through the year but do fluctuate by day of the week with most calls coming on weekends. The estimated staffing requirements for each day of the week are as follows:

 

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

Min #

staff

15

12

10

14

18

24

26

The base pay for staff is $14/hour or $140 per 10-hour day. However, there has been excessive turnover among the many staff that work Saturday or Sunday and Catatonic has agreed to pay staff $16/hour on Saturday and Sunday.

Formulate an LP model that will assist Catatonic to staff the call center at minimum weekly cost. Do not solve!

Question 3. [Investment, 24 points] International City Trust (ICT) has $5 million available for investment and wishes to maximize the interest earned on its investment over the next year. The specifics of the investment possibilities are shown in the Table below.

Investment

Interest Earned (Return on Investment)

Trade Credits

7%

Corporate bonds

10%

Gold stocks

19%

Platinum stocks

12%

Mortgage securities

8%

Construction loans

14%

To encourage diversified investment portfolio, the board of directors has placed several limits on the amount that can be committed to any one type of investment:

(1) No more than 25% of the total amount invested may be in any single type of investment,
(2) At least 30% of the funds invested must be in precious metals,
(3) At most 45% must be invested in trade credits and corporate bond.
Formulate the problem as an LP model that maximizes the interest earned on its investments over the next year such that the conditions specified in the table above are met. Do not solve!

Question 4. [Production Inventory, 36 points] Catatonic wishes to develop a model to assist in scheduling production of its soft-sided cat carriers. These items are made of fabric and have zippered openings to put the cat in the carrier and screened sides to allow the cat to see out. The major labor component is stitching the various pieces of fabric together. Demand for the two most popular models are as follows:

 

January

February

March

April

Small

2,000

3,000

4,000

5,000

Medium

1,000

1,000

2,000

2,000

It takes 6 minutes to stitch a small carrier and 7 minutes to stitch a medium carrier. Catatonic has 500 hours of stitching time available each month. The cost to make one small carrier is $6.00, but this will increase to $6.20 in April. The cost to make a medium carrier is $7.50, increasing to $7.80 in April. Carriers made one month but not shipped until later, cost Catatonic $0.30 per unit per month in storage and handling costs. This cost is the same for both small and medium carriers. Catatonic currently has 200 small and 400 medium carriers in inventory and would like to have 500 of each size in inventory at the end of April.

Formulate an LP model that will assist Catatonic in deciding how many of each product to make each month such that total costs are minimized. Do not Solve!

Question 5. [Binary Integer Programming, 20 points] Catatonic is considering investments for the coming year. They are considering opportunities for new products, product redesigns, and process improvements. Proposals have been solicited from various departments within the firm with estimates of additional profit or cost savings, after expenses, that can be expected in the next three years if the project is selected. Managers have been asked what new investment will be required to launch the projects and their assessment of the likelihood that the profit/savings goal will be realized. The projects are summarized below:

Project

Profit/Saving

Cost

Project type

Likelihood of

success

Cat backpack

$150,000

$150,000

New

High

Expandable

airline carrier

$90,000

$165,000

Redesign

High

Catnip clothing

$60,000

$100,000

New

Moderate

Cat tree and

scratching post

$80,000

$60,000

Redesign

Very high

Cat walking

harness

$30,000

$70,000

New

Moderate

Automated

packaging line

$40,000

$240,000

Process

change

High

New supply chain

IT system

$160,000

$400,000

Process

change

Moderate

- They have a budget of $1,000,000 for New projects.
- They try to experiment with at least one new product per year and redesign at least one existing product each year.
- Process change is important with the board of directors and they should make some investment in this area.
- Although the new packaging line is attractive, it will require the new supply chain IT system to be successful (if they select packaging line, they must select IT).
- Management is risk averse and does not like to take on more than one "moderate" risk project (project proponents are notorious with respect to underestimating cost and risk).
- The cat backpack and airline carrier serve the same type of buyer. They will introduce at most one of the two.

Formulate an IP model that will assist Catatonic in selecting which project to pursue such that profits/savings are maximized while addressing all other restrictions. Do not solve!

Reference no: EM133063407

Questions Cloud

How globalization has impacted domestic industries : Some things to consider are how globalization has impacted domestic industries, initiated emigration or caused violent conflicts.
Identify and discuss fully the major issues facing SLC : A ten-million-dollar bond which the company holds matured last year and SLC has not encashed it. Identify and discuss fully the major issues facing SLC
Short-run equilibrium price level and output : 1. What is the short-run equilibrium price level and output?
Explain the types of unemployment : 1. If the real GDP was Y, what types of unemployment would exist?
Formulate an ip model that will assist catatonic : Formulate the problem as an LP problem to satisfy demand in Edmonton, Toronto, and Halifax while minimizing transportation costs. Do not solve
Why does sras eventually become vertical : 1. If an increase in consumer spending of $10 billion would increase real GDP to $300 billion, what is the marginal propensity to consume?
What would be the value of the bonds on July : The bonds were issued on January 1, 2019, with a $1,000 par value. What would be the value of the bonds on July
Determine the demand function : a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function t
Optimal declining price schedule : A Monopolist faces inverse demand curve P = 270 - Q and produces output at constant marginal cost MC = 30.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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