(Answered) : Optimization: The Texas Kettle Company –>please show the excel step as much as possable The Texas Kettle Company (TKC) is ex

Optimization: The Texas Kettle Company –>please show the excel step as much as possable

The Texas Kettle Company (TKC) is experiencing tremendous growth in the demand for its barbecue grills. They produce four kinds of grills: discount and premium charcoal grills and discount and premium gas grills. In the coming year, the potential fulfillment requirement from its customers (retailers like Home Depot, Lowe’s, and Wal-mart) sums to a total of 300,000 grills of the type specified in Exhibit 4.1. Exhibit 4.1: TKC’s Fulfillment requirement

Type

Fulfillment Requirement

Discount Charcoal

120,000

Premium Charcoal

80,000

Discount Gas

70,000

Premium Gas

30,000

Total

300,000

TKC’s production is limited by the availability of labor hours in three departments: