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 1 year 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...

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...

The Ace, Ltd. sporting goods factory is just launching a line of soccer balls to be...

The Ace, Ltd. sporting goods factory is just launching a line of soccer balls to be used in FIFA events. The circumference of the soccer ball must be between 68 and 70 cm when the balls are inflated to 12.05 psi. The company determined that it should set the LSL as 68 cm and the USL as 70 cm. Their quality strategy was to become a six-sigma company, and they instituted training and new tools to achieve that goal, and...

Kelson Sporting Equipment, Inc., makes two different models of baseball gloves: a regular glove and a...

Kelson Sporting Equipment, Inc., makes two different models of baseball gloves: a regular glove and a catcher’s mitt. The firm has 1000 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 for each product are: Production Time (hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular glove 1 1/2 1/8 $6...

Field Sports Equipment Inc. (FSE) produces basketballs at its factory in Hamilton and soccer balls at...

Field Sports Equipment Inc. (FSE) produces basketballs at its factory in Hamilton and soccer balls at its factory in Windsor. At its current annual rate of production, the cost of producing basketballs is $70,000 and the cost of producing soccer balls is $45,000. You are the manager of FSE and your team has developed a new study concerning FSE production costs. If FSE consolidates production at a single location, the annual cost of production will be $100,000. 2.1) You have...

Subjects