A. An Electrical Company has three workshops in Koforidua, Accra and Kumasi. These workshops produce the following quantities of electric fan. Workshops Koforidua Monthly production (units) 130 Аccra 70 Kumasi 100 The monthly demand for these fans in three towns: Sunyani, Cape Coast and Ho is given below: Destination Sunyani Саре Coast Но The unit transportation costs per unit (in GH¢000) from the sources to the destinations are as shown: Weekly Demand (units) 80 110 60 To From Sunyani Cape Coast Но Koforidua 9 14 12 Accra 11 10 Kumasi 12 8. 15 The model was solved using Solver and part of the Solver output is shown below. Use it to answer the questions that follow. Adjustable Cells Original Cell Name Value Final Value $C$4_Koforidua Sunyani $D$4_Koforidua Cape Coast $E$4 Koforidua Ho $C$5 Accra Sunyani $D$5 Accra Cape Coast $E$5 Accra Ho $C$6 _Kumasi Sunyani $D$6 Kumasi Cape Coast $E$6 Kumasi Ho 80 80 10 10 60 60 100 100 ************** ********************************************************** QUESTION: Give an advise toManagement, providing detailed explanation using the table above. **************************************************************************** 6.
Q: The Summer Outdoor Furniture Company produces wooden lawn chairs. The annual demandfrom its store…
A: Formula:
Q: Suppose the company has received a proposal for setting up another warehouse (Warehouse E) with a…
A: From the given details : Hyderabad Mysore Madras Kochi Pune Vizag Supply Warehouse A 60 70 10…
Q: Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to…
A: Given data,
Q: The Brazilian fast growing economy has been largely dependent on its freight transport capacity. A…
A: Formula:
Q: Jerusalem Medical Ltd., an Israeli producer of portable kidney dialysis units and other medical…
A: Cost of producing each unit on regular time = $985 Overtime = $1310 and Subcontract = $1600
Q: 2. A company has three branches: Manila Branch, Davao Branch, and Tacloban Branch. These branches…
A: Given data is
Q: A company ships LTL to customers in a market in the Midwest at an average costof $40 per cwt. It…
A: Given data: Plant to client shipping cost (Cpc) = $40 per cwt Plant to distribution center (Cpdc) =…
Q: Q: When we solve the given transportation problem according to the lowest cost method, which…
A: Given data is
Q: Acadia Logistics anticipates that it will need more distribution center space to accommodate what it…
A: Given: Requirement(in sq. Ft.) Probability 210,000 0.45 360,000 0.25 510,000 0.15…
Q: 7. Novelis at Oswego NY supplies rolled aluminum sheets to Ford Motor's Kansas City plant to make…
A: The company's nerve center and spiritual center is the Rouge Center. The massive industrial complex,…
Q: Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four…
A: Answer a) We will formulate the given transportation problem as an LP Model as mentioned in the…
Q: Peaches are to be transported from three orchard regions to two canneries. Intermediate stops at a…
A: Find the Given details below: Given details: Riverside Sunnyside Old Farm Waterford Northside…
Q: Reddy & Sons Electronics Company has 3 plants and 4 warehouses in Telangana. The transportation ost…
A: Given: Warehouse1 Warehouse2 Warehouse3 Warehouse4 Supply Plant1 3 1 7 4 300 Plant2 2 6 5 9…
Q: 5. Evaluate the optimal solution of the following transportation problem using Stepping Stone…
A:
Q: Corner points of the feasible region: If there is more than one corner point, type the points…
A:
Q: Johan Company produces computers in plants located at towns A, B, and C. The computers are sent to…
A:
Q: The Metro Times Corporation is a newspaper publishing company with a national circulation reaching…
A: The best route can be determined using the traveling salesman problem. This can be done using Excel.…
Q: The Awesome Skis Company has manufacturing plants in Portland, Oregon and Toronto, Ontario. You have…
A: Find the Given details below: Given details: Outlet Lake Tahoe Whistler Supply Plant…
Q: agen company is producing a single pro cities. All of a sudden, there is a demand for the product in…
A: Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: cross-docking is a logistics practice of unloading goods from impound Transportation vehicles and…
A: Cross-docking is a technique in the logistic process in which the goods are directly distributed…
Q: Prince Electronics, a manufacturer of consumer electronic goods, has five distribution centers in…
A: Formula:
Q: Ram Roy's firm has developed the following supply,demand, cost, and inven tory data. Allocate…
A: A Small introduction about Transportation Method Prologue to Transportation is a starting course…
Q: Problem 11-6 (Algo) Richard's Sporting Goods needs to fill an online order for 150 hockey sticks.…
A: Given data: Number of orders = 150 stickValue of hockey sticks = $50/stickCarrier charge =…
Q: Explain "Columbia Sportswear" clothing brands Promotion plan. (in terms of how they promote? who…
A: Columbia sports wear is an American corporation that engages in production activities for producing…
Q: factor is important for deciding the location for plant. O a. Customer demand O b. Transport cost
A: The location of the plants is based on the consideration such as land, area, social and…
Q: Q2. Pharmaceutical company producing asingle product sold it through five agencies situated in…
A: Given Information:
Q: Jerusalem Medical Ltd., an Israeli producer of portable kidney dialysis units and other medical…
A: Given data,
Q: 2. Sunray Transport company ships truckloads of grain from three warehouses to four distribution…
A: a) Total Demand = 5+15+15+15 = 50. Total Supply = 15+!5+10 = 40 Demand is more than Supply.…
Q: 1. Huawei decided to expand in Africa. Three possible factory sites are available! Nairobi, Cape…
A: Linear programming is a widely used decision making approach in operations management. It helps to…
Q: LM.81 Monkey's Fist is trying to determine where to source their product. In the past, they have…
A: Given data: Criteria Domestic Foreign 1 Foreign 2 Price/Unit $3.94 $3.20 $2.82 Packaging…
Q: East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's…
A: Find the Given details below: Given Details: Branches Coordinates Volume X Y Athens, Texas…
Q: 2. The table below shows the cost matrix From - To- travel that must fulfil by PT. JauhAbadi…
A: Find the Given details below: Given details: Cities A B C D E A M 16 18 13 20 B 21 M 16 27…
Q: East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's…
A: Find the Given details below: Given Details: Branches Coordinates Volume X Y Athens, Texas…
Q: 40. An import/export firm has leased 20,000 cubic feet of storage space to store six items that it…
A: Given data Set up cost or ordering cost = $2000
Q: 4. Three refineries with daily capacities of 6, 5, and 8 million gallons, respectively, supply three…
A: ANSWER IS AS BELOW:
Q: A) Shipper: J&J Company 123 John Street Toronto, ON, Canada, L5R 2N3 Shipment:…
A:
Q: Required Month Space (Sq. Ft.) Leasing Period Cost per Sq. Fa (Months) Leased 1 $ 65 30,000 20,000…
A: given,
Q: 2. By using the data below, use a transportation method to : COST in $ Assembly Plant Supply 210 400…
A: This method is used to find the least cost option to transport the products from one destination to…
Q: 14. Toyco produces a line of Bonnie dolls and accessories at its plants in New York and Baltimore…
A:
Q: Determine how many products to ship from each factory to each warehouse, or from each factory to…
A: This question is related to supply chain management and this topic falls under the operations…
Q: Prescott Industries transports sand and stone extracted fromits open-pit mines located in Odessa and…
A: The Data given in the table implies that: The demand of Abilene =8,000 The demand of Tyler = 10,000…
Q: . A company has a central supply facility and a distribution center located 400miles away. The…
A: Given Central supply product cost P=$75 Transportation rates from central supply TR=$60/unit…
Q: A company has 3 factories manufacturing the same product and 5 sale agencies in different parts of…
A: The transportation problem is a special kind of linear programming problem where the goal is to…
Q: Toyco produces a line of Bonnie dolls and accessories at its plants in New York and Baltimore that…
A: Find the Given details below: From/To Pittsburgh Denver Chicago Los Angeles Supply New York 182…
Q: . The XYZ engineering organization produces the product P in locations T and S to be transported to…
A: Find the Given details below: Given details: Locations L M N Supply T 2 4 2 120 S 3 1 9…
Advise the MD, providing detailed explanation using the table above.
Step by step
Solved in 2 steps with 3 images
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?Located in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 Of the four categories of variables, which one seems to be the most central to Ski Butternuts segmentation strategy, and why?
- Located in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 What role do geographic variables play in Ski Butternuts segmentation and targeting?Located in the picturesque Berkshire Mountains of Western Massachusetts, Ski Butternut has been a family-owned, family-oriented ski destination for more than 50 years. The resort includes 22 trails for downhill skiing and snowboarding, two terrain parks for riding, and a dedicated area for snow tubing. Although Ski Butternut hosts some non-ski events during summer and fall, its business goes into high gear when snowy weather arrives, bringing skiers and riders from across Massachusetts, Connecticut, New York, and New Jersey. Matt Sawyer, Ski Butternuts director of marketing, says the primary target market has always been families with young children who are seeking affordable skiing. Everything from the snack-bar menus to the ski-shop merchandise is presented with families in mind. So that parents can have fun in the snow without worry, the resort has a Childrens Center for children who are too young to ski or have no interest. Fifth-graders are invited to ski for free when accompanied by an adult who buys an adult lift ticket. The resort also created two terrain parks for young snowboarders who were clamoring for a more exciting riding experience. Without the terrain parks, Sawyer says, these boarders would have asked their parents to take them to competing mountains in Vermont. Ski Butternuts research shows that first-timers are a particularly important segment, because they tend to have a strong allegiance to the resort where they learn to ski. First-timers typically visit the resort seven times before seeking out more challenging mountains. As a result, Ski Butternut has made teaching first-timers to ski or snowboard one of its specialties. For this market, the resort bundles ski or board rentals, lift tickets, and also offers a wide range of individual and group lessons for all ages and abilities at a value price. Because Ski Butternut has trails for different skill levels, beginners can challenge themselves by changing trails within the resort once they feel confident. Ski Butternut also targets seniors and college students. Knowing that weekends are the busiest period, the resort offers special midweek prices to attract seniors who have free time to ski on weekdays. College students are particularly value-conscious, and they often travel to ski resorts as a group. As a result, Ski Butternut offers weekend and holiday discounts to bring in large numbers of students who would otherwise ski elsewhere. Thanks to Facebook, Twitter, and other social media, students quickly spread the word about special pricing, which enhances Ski Butternuts ability to reach this key segment. In addition, the resort highlights discount pricing for families when targeting specific segments, such as scout troops, military personnel, emergency services personnel, and members of local ski clubs. Another segment Ski Butternut has selected for marketing attention is ski racers. The resort features professional coaching, lessons, and programs for ski racers in the age group of 8 to 20. Sawyer notes that these ski racers are extremely dedicated to training, which means theyre on the slopes as often as possible, a positive for the resorts attendance and revenue. To stay in touch with racers, Ski Butternut has a special website and a dedicated Facebook page. Sawyer conducts up to 1,200 customer surveys every year to better understand who his customers are and what they need. He also compares the results with skiers who visit mountains of a similar size in other areas. Digging deeper, he analyzes data drawn from the ski shops rental business to build a detailed picture of customers demographics, abilities, and preferences. Based on this research, he knows that the typical family at Ski Butternut consists of two children under age 18 who ski or ride, and at least one parent who skis. Because they can obtain so much information from and about their customers, Sawyer and his team are able to make better decisions about the marketing mix for each segment. By better matching the media with the audience, they get a better response from advertising, e-mail messages, and other marketing communications. As one example, they found that 15 percent of the visitors to Ski Butternuts website were using a smartphone to access the site. Sawyer has now created a special version of the site specifically for mobile use and created a text-message contest to engage skiers who have smartphones.16 How is Ski Butternut applying behavioristic variables in its segmentation strategy? Explain your answer.ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.
- The Winston Company has four distribution centers(A, B, C, and D) that require 40,000, 60,000, 30,000, and 50,000 gallons of de-ionized water, respectively,per month for cleaning their long-haul trucks. Threede-ionized water wholesalers (1, 2, and 3) indicatedtheir willingness to supply as many as 50,000, 70,000,and 60,000 gallons, respectively. The total cost (ship-ping plus price) of delivering 1,000 gallons of de-ionizedwater from each wholesaler to each distribution center isshown in the following table: a. Determine the optimal solution. Show that all capacitieshave been exhausted and that all demands can be metwith this solution.b. What is the total cost of the solution?4. Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. It has decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. It has four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition, and DMOP is not a major player there. When DMOP ships an order to a customer, it uses its own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY x-COORDINATES y-COORDINATES NUMBER OF SHIPMENTS Buffalo 340 865 85 Syracuse 1,435 915 89 Albany 2,315 645 129 New York City 2,290 45 69
- Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northern Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per units (in thousands of dollars) are as follows: To From Hamilton Butler Clermont Southern Gas 10 20 15 Northern Gas 12 15 18 What is the optimal function value of this problem? a. 900 units b. $13,600 c. none of the answers proposed apply d. 1,200 units e. $11,900Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northern Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per units (in thousands of dollars) are as follows: To From Hamilton Butler Clermont Southern Gas 10 20 15 Northern Gas 12 15 18 At optimality, how many units of natural gas are shipped from Southern Gas to Clermont? a. none of the answers proposed apply b. 100 units c. 300 units d. 250 units e. 200 unitsTri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: From TO Hamilton Butler Clermont Southern Gas 10 20 15 Northwest Gas 12 15 18 REQUIREMENTS Develop a network representation of this problem and Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. Describe the distribution plan and show the total distribution cost. (First…