Reference no: EM13962962
Optimization
The Sentry Lock Corporation manufactures a popular commercial security lock at plans in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.5, $37.5, $39, and $36.25, respectively, while the annual production capacity at each plant is 18,000, 15,000, 25,000, and 20,000, respectively. Sentry's locks are sold to retailers through wholesale distributors in 7 cities across a nation. The unit cost of shipping from each plant to each distributor is summarized in the following table along with the forecasted demand from each distributor for the coming year.
Unit Shipping Cost to Distributor in
|
Plants
|
Tacoma
|
San Diego
|
Dallas
|
Denver
|
St. Louis
|
Tampa
|
Baltimore
|
|
Macon
|
$2.5
|
$2.75
|
$1.75
|
$2.00
|
$2.1
|
$1.8
|
$1.65
|
|
Louisville
|
$1.85
|
$1.9
|
$1.5
|
$1.6
|
$1.00
|
$1.9
|
$1.85
|
|
Detroit
|
$2.3
|
$2.25
|
$1.85
|
$1.25
|
$1.5
|
$2.25
|
$2.00
|
|
Phoenix
|
$1.9
|
$0.9
|
$1.6
|
$1.75
|
$2.00
|
$2.5
|
$2.65
|
|
Demand
|
8,500
|
14,500
|
13,500
|
12,600
|
18,000
|
15,000
|
9,000
|
Sentry wants to determine the least expensive way of manufacturing and shipping locks from their plants to the distributors. Because the total demand from distributors exceeds the total production capacity for all the plants, Sentry realizes they will not be able to satisfy all the demand for their product, but wants to make sure each distributor will have the opportunity to fill at least 80% of the orders they receive.
1. Build an appropriate Linear Programming Model for the Sentry Lock problem.
2. Solve your Linear Programming model by EXCEL. Attach a copy of your EXCEL model.
3. Give a brief description of the meaning of your Linear Programming solution.
|
Prepare the companys sales budget and schedule
: Prepare the company's sales budget and schedule of expected cash collections. Prepare the company's production budget for the upcoming fiscal year.
|
|
Nutritional elements per pound of feed
: A farmer can purchase 3 kinds of feed for his stock, with various percentages of each of 4 nutrients, called A, B, C, and D. A mixture of feeds gives proportional amounts of nutrients. The following table gives the minimum da..
|
|
The triangle has the angles 45,45,90 with a base of length
: The triangle has the angles 45,45,90 with a base of length a. The dipole is located at the right base corner pointing in the -x direction.
|
|
How many trades must he made to break even
: Use the contribution margin ratio CVP formula to compute Big Time's break even revenue in dollars. If the average trade leads to $800 in revenue for Big Time, how many trades must he made to break even?
|
|
Annual production capacity
: The Sentry Lock Corporation manufactures a popular commercial security lock at plans in Macon, Louisville, Detroit, and Phoenix. The per unit cost of production at each plant is $35.5, $37.5, $39, and $36.25, respectively, while the annual product..
|
|
Draw an aoa network diagram representing the project
: Draw an AOA network diagram representing the project. Put the node numbers in circles and draw arrows from node to node, labeling each arrow with the activity letter and estimated time.
|
|
Small businesses are undercapitalized
: Suppose that 30% of all small businesses are undercapitalized. Forty percent of all undercapitalized small businesses fail and 20% of all small businesses that are not undercapitalized fail. A small business is chosen at random. The probability th..
|
|
Describe your company operations and the market
: For the company you selected, describe your company's operations and the market in which it operates. Search for the EVA, and free cash flow using the firm's annual report
|
|
Discuss the signal a large stock repurchase might foretell
: Discuss the signal a large stock repurchase might foretell about management's outlook relative to the future of a company. Explain whether a repurchase of stock is typically a good or bad sign. Provide a rationale for your response
|