Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 600 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:ModelMaxProduction Time (Hours)Cutting andSewing Finishing1/211/2s.t.Regular modelCatcher's modelAssuming that the company is interested in maximizing the total profit contribution, answer the following:(a) What is the linear programming model for this problem? If required, round your answers to 3 decimal places or enter your answers as a fraction. If the constant is "1" it must be entered in the box. Do not round intermediate calculation. If an amount iszero, enter "0".3/2Let R = number of units of regular model.C = number of units of catcher's model..51.0RRRPackaging andShipping1/61/2+R, C1.5.5XCCс3cSSC ≤Profit/Glove$42$8Cutting and SewingFinishingPacking and Shipping

Objective Functions and Constraints: Based on the given details, the objective…

Answered: Kelson Sporting Equipment, Inc., makes…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Vv
Use the following information for the next 3 problems: ABC Company plans to construct a 60,000 sq. ft private warehouse and rent public warehouse as needed. Warehouse inventory turns at the rate of 2 times per month. One pound of merchandise occupies 0.2 cubic feet of warehouse space and can be stacked 10 feet high. Given aisles, and normal operating efficiency, only 50 percent of the total warehouse space is actually used for storage. Assume the facility is being built to size so no additional space is allowed for future product growth. A private warehouse can be constructed for $36 per sq. ft. and can be amortized over 20 years. Annual fixed costs amount to $20 per sq. ft. of total space. The cost of operation is $0.03 per pound of throughput. Space may also be rented for a storage charge on inventory of $0.06 per pound per month and a handling charge of $0.05 per pound of throughput. Monthly demands for a typical year are as follows: Month Demand (lb) Jan 2,000,000…
Company DEF has a choice of two machines to purchase. They both make the same product which sells for P10. Machine A has FC of P5,000 and a per unit cost of P5. Machine B has FC of P15,000 and a per unit cost of P1. Under what conditions would you select Machine A?
Cox Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $23,750 Material cost per unit = $0.17 • Labor cost per unit = $0.12 • Revenue per unit = $0.67 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Which one of the following is a variable to be considered when calculatingproduction lot size? a forecasted demandb customer orderc the lower of customer orders and forecasted demandd the higher of customer orders and forecasted demand
James Calender is the buyer for "Joe's Radio Hut", a local electronics chain that has developed a loyal customer base with its quality service and competitive pricing. Due to the short selling lives of electronics products, James has only a single opportunity to order the new GO multifunction photo printer and hair dryer. The item sells for $139.24 and the per unit cost is $128.93. Any units remaining at the end of the season must be disposed of at a cost of $18.04. Demand for the item is believed to be normally distributed with a mean 605 and standard deviation 145.2. What is the cost of shortage? (specify answer to 2 decimal places)What is the critical fractile? (specify answer to 3 decimal places)What is the cost minimizing order quantity? (specify answer as a whole number)
What relationship between x and y is suggested by the scattergram? OA a quadratic relationship with downward concavity OB. a linear relationship with positive slope OC. a linear relationship with negative slope D. a quadratic relationship with upward concavity
Sturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the workweek, for a total of 120 hours of capacity per week. The shop efficiency (the percent of total time available for production), which accounts for setups, changeovers, and maintenance, averages 70% with a standard deviation of 5%, which reduces the weekly capacity. Six key parts are produced, and the plant has three different types of machines to produce each part. The machines are not interchangeable as they each have a specific function. The time to produce each part on each machine varies. The mean time and standard deviation (in hours) to produce each part on each machine are shown below: Mean Time Part Type Machine A Machine B Machine C 1 3.5 2.6 8.9 2 3.4 2.5 8 3 1.8 3.5 12.6 4 2.4 5.8 12.5 5 4.2 4.3 28 6…
Please include an excel sheet showing calculations
A Company currently has 230 units of a product on-hand that it orders every three weeks when the salesperson visits the premises. Average demand for the product is 20 units per day with a standard deviation of 5 units. Lead time for the product to arrive is seven days. Management has a goal of 95 percent probability of not stocking out for this product. The salesperson is due to come in late this afternoon when 210 units are left in stock. How many units should be ordered?
Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and personal shopping service targeted at busy families with children aged newborn to five years old. Currently, Taylor has one level of subscription service, the standard service. For $100 a month, the standard service provides its customers a monthly delivery of 10 clothing items carefully chosen to match the child's size, gender, and emerging style. The online clothing subscription market is fairly new but is growing rapidly and thus Taylor is considering extending the product line to increase its market share and profits. Taylor is debating whether to add a premium subscription service featuring profitable high-markup items for $125 per month, a basic subscription service that contains lower-markup popular items priced at $75 per month, or possibly both. Taylor knows that the new product lines provide an opportunity to attract more customers and possibly increase revenues and profit,…
Carizick Co manufactures gaming products. It has created a new games console called the QpBox which is about to be launched. Demand for the QpBox is anticipated to be high. The product life cycle of the QpBox is expected to be three years with 300,000 units forecast to be sold during its first year. Sales volumes are expected to decrease by 75,000 units in each subsequent year. Production volumes will be based on expected demand levels. The following costs for the QpBox have been determined: Design and development Pre-launch advertising Advertising in Year 2 Packaging Manufacturing cost $120m $0.5m $0.4m $3 per unit $80 per unit At a recent board meeting, the finance director said that Carizick Co should look to maximise the profitability of the QpBox over its life cycle. The marketing director made the comment that Carizick Co should focus on extending the maturity phase of the life cycle only as this stage is where the QpBox is most profitable. Contract with Zone Co Carizick Co has…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS