Question

In: Statistics and Probability

1. Linear programming. Clever Sporting Equipment, Inc. makes two types of balls: soccer balls and cork...

1. Linear programming. Clever Sporting Equipment, Inc. makes two types of balls: soccer balls and cork balls. The making of each soccer ball and cork ball requires 2 hours and 4 hours of production time, respectively. For the next month, total production hours of 800 are available. Also, the combined production quantity for these two balls must be at least 300 units in the coming month. Maximum monthly demand for soccer balls is known to be 350 balls. The objective for this linear programming model is to fulfill the given production requirements at a minimum cost for the total production. The production cost for each soccer ball is $9 and each cork ball is $7. Let S = number of soccer balls manufactured and C = number of cork balls manufactured.

(a) Formally state the problem.

(b) Graph the constraints and identify the feasible region. Place the number of soccer balls on the horizontal axis and let each grid line = 25 balls. Be sure to shade in the feasible region and label all intercept values on your constraints.

(c) The optimal production plan for this company is soccer balls and cork balls, and the resulting production cost for the coming month

is $ . Show all work that supports this choice in the space below.

(d) Perform the same linear programming problem in Excel and attach the answer report.

Solutions

Expert Solution

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 400 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 700 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
please show if this is done in excel, Kelson Sporting Equipment, Inc., makes two different types...
please show if this is done in excel, Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: PRODUCTION TIME HOURS Model Cutting and...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (hours)   Model   Cutting and Sewing Finishing   Packaging and Shipping Profit/Glove   Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
use Excel Screen shot Pleaseeeee Kelson Sporting Equipment, Inc., makes two different types of baseball gloves:...
use Excel Screen shot Pleaseeeee Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging...
Kentucky Inc. Manufactures Soccer balls. The estimated number of soccer balls sold for the first three...
Kentucky Inc. Manufactures Soccer balls. The estimated number of soccer balls sold for the first three months of 2018 are as follows: Month: Sales: June 2,000 July 3,000 August 4,000 The Actual finished goods inventory at the end of May 2018 was 2,000 units. Ending Finished Goods inventory is planned to equal 25% of the next month's sales. Kentucky incorporated will sell the soccer balls for $5.00 each. Septemberl 2018 Sales are projected at 8,500 soccer balls. How many Soccer...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT