My tutor that I Have been using for the past 5 weeks bailed on me with an assignment due tomorrow by 9PM Central USA time. There is 3 weeks left in this course. I am looking for someone that is proficient in Excel and Quantitative Methods. I have 4 assignments, 1 quiz, and 1 final that is due over the next weeks. Right now my focus is on this as it is last minute. If you are interested in further assignments I would consider sticking with 1 tutor as that is what I like to do. Pay will be discussed after this assignment is completed to see if we can work out an arrangement. The teacher posts podcasts and notes that I can provide if needed. Typical assignments will require excel, however, this particular one is word only. Let me know if you have any questions or would like to see the help that is available in blackboard.

Thanks!

BADM 3963 Linear Programming Formulation homework #1 Summer 2017 Write the LP formulations for the following problems in a Word document. Submit Word document in BB Assignments Due 7/6, 9pm 1.Teethree, Inc. is a small manufacturer of sports equipment whose management has decided to begin producing golf bags. Two models will be produced - a standard bag and a deluxe bag. The bags require work in four departments as indicated in the table below. Each standard bag contributes $15 profit and each deluxe bag contributes $12 profit. The amount of time available in each department for production of golf bags is as follows: Cutting, 630 hours; Sewing, 600 hours; Finishing, 708 hours; and Packaging, 135 hours. Department Cutting Sewing Finishing Packaging Standard Bag requirement per bag 0.7 hour 0.5 hour 1 hour 0.10 hour Deluxe bag requirement per bag 1 hour 0.8 hour 0.67 hour 0.25 hour Write the linear programming formulation to help Teethree determine the best mix of the two bags to produce. 2. Epsum Chemical Co. produces two products that are sold as raw materials to companies that manufacture cosmetics. Based on an analysis of current inventory levels and potential demand for the coming month, Epsum's management specified that the combined production for products A and B must total at least 325 gallons. Separately, a major customer's order for 105 gallons of product A must be met. Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 500 hours of processing time are available. Production costs are $2 per gallon for product A and $3 per gallon for product B. Write the linear programming formulation to help Epsum determine how many gallons of each product should be produced for a minimum cost. 3. The Checotah Chamber of Commerce sponsors public service programs and is planning next year's advertising mix to promote the programs. Television, radio, and online ads are being proposed. The following table shows estimates of audience reach, costs, and individual upper limits on each type of ad. Type of ad Cost per ad Audience reached Upper limit on per ad ads of this type Television $2,000 100,000 10 Radio $300 18,000 20 Online $600 40,000 10 The budget for ads is limited to $18,500. To ensure a balanced used of the three media, radio ads must not exceed 50% of the total number of ads and television ads must account for at least 10% of the total number of ads. Write the linear programming formulation to help the Chamber determine the best mix of ads that will maximize the total audience reached. 4. Mad Manufacturing makes three components that are sold to makers of air conditioners. The components are processed on two machines: a shaper and a grinder. Times required for each component on each machine are as follows: Component Shaper (minutes) Grinder (minutes) A 6 4 B 4 5 C 4 2 The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component C can be sold, but up to 1,000 units of each of the other components can be sold. The company has orders for 600 units of component A that must be met. The profit contributions for components A, B, and C are $8, $6, and $9, respectively. Write the linear programming formulation for Mad Manufacturing to determine the best production mix of the three components. _ LP formulatmn homework I Read textbook Ch T, section 7".4 - focus on LP formulation homework 2 IsoPrqt Line mired omit Corner Point Solution method),section 15 (omit QM just look at Excellsections 1:5, I? Read Supplemental notes on LP Empirical sat-Inow, Sofvfngsimnhoneons linear equations Watch podcasts on gaphical method and Read Ch 9 Sections 9.1,9_2,9_3 Read Transportation and Assignment Notes Watch podcasln on tansportation heuristics Read textbook Ch 1 l, se-ctionsll. 1, 11.2 {to pgi'l], 11.4 (pg414),11.5 Read Supplemental Project :11\"ng notes, Watch odcast on Critical Path hiethod BADM 3963 Linear Programming Formulation homework #1 Summer 2017 Write the LP formulations for the following problems in a Word document. Submit Word document in BB Assignments Due 7/6, 9pm 1.Teethree, Inc. is a small manufacturer of sports equipment whose management has decided to begin producing golf bags. Two models will be produced - a standard bag and a deluxe bag. The bags require work in four departments as indicated in the table below. Each standard bag contributes $15 profit and each deluxe bag contributes $12 profit. The amount of time available in each department for production of golf bags is as follows: Cutting, 630 hours; Sewing, 600 hours; Finishing, 708 hours; and Packaging, 135 hours. Department Cutting Sewing Finishing Packaging Standard Bag requirement per bag 0.7 hour 0.5 hour 1 hour 0.10 hour Deluxe bag requirement per bag 1 hour 0.8 hour 0.67 hour 0.25 hour Write the linear programming formulation to help Teethree determine the best mix of the two bags to produce. 2. Epsum Chemical Co. produces two products that are sold as raw materials to companies that manufacture cosmetics. Based on an analysis of current inventory levels and potential demand for the coming month, Epsum's management specified that the combined production for products A and B must total at least 325 gallons. Separately, a major customer's order for 105 gallons of product A must be met. Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 500 hours of processing time are available. Production costs are $2 per gallon for product A and $3 per gallon for product B. Write the linear programming formulation to help Epsum determine how many gallons of each product should be produced for a minimum cost. 3. The Checotah Chamber of Commerce sponsors public service programs and is planning next year's advertising mix to promote the programs. Television, radio, and online ads are being proposed. The following table shows estimates of audience reach, costs, and individual upper limits on each type of ad. Type of ad Cost per ad Audience reached Upper limit on per ad ads of this type Television $2,000 100,000 10 Radio $300 18,000 20 Online $600 40,000 10 The budget for ads is limited to $18,500. To ensure a balanced used of the three media, radio ads must not exceed 50% of the total number of ads and television ads must account for at least 10% of the total number of ads. Write the linear programming formulation to help the Chamber determine the best mix of ads that will maximize the total audience reached. 4. Mad Manufacturing makes three components that are sold to makers of air conditioners. The components are processed on two machines: a shaper and a grinder. Times required for each component on each machine are as follows: Component Shaper (minutes) Grinder (minutes) A 6 4 B 4 5 C 4 2 The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component C can be sold, but up to 1,000 units of each of the other components can be sold. The company has orders for 600 units of component A that must be met. The profit contributions for components A, B, and C are $8, $6, and $9, respectively. Write the linear programming formulation for Mad Manufacturing to determine the best production mix of the three components. BADM 3963 Linear Programming Formulation homework #1 Summer 2017 Write the LP formulations for the following problems in a Word document. Submit Word document in BB Assignments Due 7/6, 9pm 1.Teethree, Inc. is a small manufacturer of sports equipment whose management has decided to begin producing golf bags. Two models will be produced - a standard bag and a deluxe bag. The bags require work in four departments as indicated in the table below. Each standard bag contributes $15 profit and each deluxe bag contributes $12 profit. The amount of time available in each department for production of golf bags is as follows: Cutting, 630 hours; Sewing, 600 hours; Finishing, 708 hours; and Packaging, 135 hours. Department Cutting Sewing Finishing Packaging Standard Bag requirement per bag 0.7 hour 0.5 hour 1 hour 0.10 hour Deluxe bag requirement per bag 1 hour 0.8 hour 0.67 hour 0.25 hour Write the linear programming formulation to help Teethree determine the best mix of the two bags to produce. 2. Epsum Chemical Co. produces two products that are sold as raw materials to companies that manufacture cosmetics. Based on an analysis of current inventory levels and potential demand for the coming month, Epsum's management specified that the combined production for products A and B must total at least 325 gallons. Separately, a major customer's order for 105 gallons of product A must be met. Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 500 hours of processing time are available. Production costs are $2 per gallon for product A and $3 per gallon for product B. Write the linear programming formulation to help Epsum determine how many gallons of each product should be produced for a minimum cost. 3. The Checotah Chamber of Commerce sponsors public service programs and is planning next year's advertising mix to promote the programs. Television, radio, and online ads are being proposed. The following table shows estimates of audience reach, costs, and individual upper limits on each type of ad. Type of ad Cost per ad Audience reached Upper limit on per ad ads of this type Television $2,000 100,000 10 Radio $300 18,000 20 Online $600 40,000 10 The budget for ads is limited to $18,500. To ensure a balanced used of the three media, radio ads must not exceed 50% of the total number of ads and television ads must account for at least 10% of the total number of ads. Write the linear programming formulation to help the Chamber determine the best mix of ads that will maximize the total audience reached. 4. Mad Manufacturing makes three components that are sold to makers of air conditioners. The components are processed on two machines: a shaper and a grinder. Times required for each component on each machine are as follows: Component Shaper (minutes) Grinder (minutes) A 6 4 B 4 5 C 4 2 The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component C can be sold, but up to 1,000 units of each of the other components can be sold. The company has orders for 600 units of component A that must be met. The profit contributions for components A, B, and C are $8, $6, and $9, respectively. Write the linear programming formulation for Mad Manufacturing to determine the best production mix of the three components. General Homework Instructions BADM 3963 Read and follow the instructions on each homework assignment. They may vary from assignment to assignment. Your name must be the first thing typed in every Word document and every Excel worksheet. Work submitted without your name will not be graded. Consider your work to be professional presentations. They should be well-organized and a positive reflection of your ability to communicate. Make sure that your work is easy to read and follow o In Excel use a separate worksheet for each problem - with labeled tabs. o In Word use white space, headings, indentations to make the report more readable When reporting answers: write complete sentences, use correct grammar and spell check your work. If you are asked to report answers: \"Reported\" means answers should tell a complete story. Here is an example: o Inadequate, unacceptable answer: 5 o Acceptable answer: The NPV for project D is $5 million. When a Word document is used to report results from Excel, any significant tables or graphs should be copied into the Word document from Excel. o The entire spreadsheet should NOT be copied into Word. o The Excel file will also be submitted. Learn to re-size Excel tables and graphs so the work fits on a single page in Word. o At this stage in your career, you are responsible for learning how to use the software appropriately. When submitting two files (one Word and one Excel) you must attach both before you hit the Submit button in Blackboard. o Never submit more than two files - one Word and one Excel would be the max. BADM 3963 Linear Programming Formulation homework #2 Summer 2017 Write the LP formulations for the following problems in a Word document. Submit Word document in BB Assignments - review comments & notes from LP hmwk #1 before submitting this assignment. Due 7/10, 9pm 1. Management at the Riverside Diner is trying to decide how to allocate a monthly advertising budget of $1800. They are considering newspaper advertising and radio advertising. Aside from the total budget, the following requirements must be met: at least 25% of the budget must be spent on each type of advertising the amount of money spend on newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. The index for newspaper advertising is estimated at 50 and the index for radio advertising is 80. Write the linear programming formulation for Riverside to use to determine how much of its budget that should be allocated to each type of advertising in order to maximize total audience exposure. 2. Madisen Furniture of Overland Park, Kansas produces two types of desks: executive desks and secretary desks at two plants. Plant 1 operates on a double shift of 80 hours per week. Plant currently operates 50 hours per week. The table below shows production time and standard costs at each plant for each type of desk. Executive desks are sold for a price of $350 and secretary desks for $275. The company has been experiencing cost overruns lately and has set a weekly budget constraint on production costs. The weekly budget for total production of executive desks is $2000, while the budget for secretary desks is $2200. Management would like to determine the number of each type of desk that should be produced at each plant in order to maximize PROFIT. Item Plant Executive desk Secretary desk Executive desk Secretary desk 1 1 2 2 Production time (hours/desk) 7 4 6 5 Standard cost ($/desk) 250 200 260 180 Write the linear programming formulation for this problem. 3. Mr. Barry Fisher, head dietician for Seattle Grace Hospital, is responsible for planning and managing patient diets. Mr. Fisher is currently planning a diet for patients who are restricted to a diet consisting of two food sources. The nutritional requirements that must be met daily are at least: 1,000 units of nutrient A, 2,000 units of nutrient B, and 1,500 units of nutrient C. Each ounce of food source #1 contains 100 units of A, 400 units of B, and 200 units of C. Each ounce of food source #2 contains 200 units of A, 240 units of B, and 200 units of C. Food source #1 costs $6.05 per ounce and food source #2 costs $8.32 per ounce. Write the linear programming formulation that can be used to determine the minimal cost combination of the food sources that will meet all nutrition requirements. 4. The Landsmere Shipping Company runs a cargo jet between London, England and New rk, New Jersey. To keep operational expenses in line, the jet will not depart until all decks are loaded with cargo. The aircraft has three decks: lower, middle, and upper. The jet cannot carry more than 120 total tons of cargo for each leg of the trip. No more than 50 tons of cargo should be carried on the lower deck. For balance purposes, the middle deck must carry one-third of the load of the lower deck and the upper deck must carry two-fifths of the load of the lower deck. However, no more than 75 tons of cargo should be loaded on the middle and upper decks combined. The profit from the shipping is $18 per ton for cargo on the lower deck $21 for cargo on the middle deck, and $32 for cargo on the upper desk. Write the linear programming formulation to determine the best allocation of cargo on the three decks. 5. The KK Cosmetics Company is introducing three new products for the fall season, which the marketing department currently is calling Mad, Mud, and Mod. These three products are made from three ingredients, code-named A, B, and C. The milligrams of each ingredient required to make one ounce of each final product are shown in the following table. Product Mad Mud Mod Ingredient (milligrams per ounce of product) Ing A Ing B Ing C 4 7 8 3 9 7 6 3 12 Each milligram of Ingredient A costs $0.15, each milligram of ingredient B costs $0.23, and each milligram of ingredient C costs $0.55. Each ounce Mad will be sold for $18, each ounce of Mud will be sold for $25, each ounce of Mod will be sold for $39 The firm currently has 400, 800, and 1,000 milligrams respectively, on hand of the ingredients A, B, and C. Write the linear programming formulation to determine the optimal mix of Mad, Mud, and Mod that KK should produce to maximize profit. 6. Standard Motors, Inc., sells standard automobiles and station wagons. The company makes $3000 profit on each standard auto that it sells and $4000 on each station wagon. The manufacturer cannot supply more than 300 standard autos and 200 station wagons per month. Dealer preparation time requires 2 hours for each standard auto and 3 hours for each station wagon. The company has 900 hours of shop time available each month for new car preparation. Write the linear programming formulation to determine how many standard autos and station wagons should be ordered to maximize profit. Amber Henson BADM 3963 Linear Programming Formulation homework #1 Summer 2017 Write the LP formulations for the following problems in a Word document. Submit Word document in BB Assignments Due 7/6, 9pm 1.Teethree, Inc. is a small manufacturer of sports equipment whose management has decided to begin producing golf bags. Two models will be produced - a standard bag and a deluxe bag. The bags require work in four departments as indicated in the table below. Each standard bag contributes $15 profit and each deluxe bag contributes $12 profit. The amount of time available in each department for production of golf bags is as follows: Cutting, 630 hours; Sewing, 600 hours; Finishing, 708 hours; and Packaging, 135 hours. Department Cutting Sewing Finishing Packaging Standard Bag requirement per bag 0.7 hour 0.5 hour 1 hour 0.10 hour Deluxe bag requirement per bag 1 hour 0.8 hour 0.67 hour 0.25 hour Write the linear programming formulation to help Teethree determine the best mix of the two bags to produce. Variables Let; X1 = Number of standard bags produced X2 = Number of deluxe bags produced Maximize Z = 15X1 + 12X2 Subject to; 0.70X1 + X2 = 0 (non-negativity constraint) 2. Epsum Chemical Co. produces two products that are sold as raw materials to companies that manufacture cosmetics. Based on an analysis of current inventory levels and potential demand for the coming month, Epsum's management specified that the combined production for products A and B must total at least 325 gallons. Separately, a major customer's order for 105 gallons of product A must be met. Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 500 hours of processing time are available. Production costs are $2 per gallon for product A and $3 per gallon for product B. Write the linear programming formulation to help Epsum determine how many gallons of each product should be produced for a minimum cost. Variables Let; X1 = Number of gallons of product A produced X2 = Number of gallons of product B produced Minimize Z = 2X1 + 3X2 Subject to; X1 + X2 >= 325 (Combined number of gallons to produce) X1 >= 105 (number of gallons of product A to produce) 2X1 + X2 = 0 (non-negativity constraint) 3. The Checotah Chamber of Commerce sponsors public service programs and is planning next year's advertising mix to promote the programs. Television, radio, and online ads are being proposed. The following table shows estimates of audience reach, costs, and individual upper limits on each type of ad. Type of ad Cost per ad Audience reached Upper limit on per ad ads of this type Television $2,000 100,000 10 Radio $300 18,000 20 Online $600 40,000 10 The budget for ads is limited to $18,500. To ensure a balanced used of the three media, radio ads must not exceed 50% of the total number of ads and television ads must account for at least 10% of the total number of ads. Write the linear programming formulation to help the Chamber determine the best mix of ads that will maximize the total audience reached. Variables Let; X1 = number of television ads X2 = number of radio ads X3 = number of online ads Maximize Z = 100,000X1 + 18,000X2 + 40,000X3 Subject to; X1 = 0.1*(X1 + X2 + X3) (minimum number of radio ads allowed) 4. Mad Manufacturing makes three components that are sold to makers of air conditioners. The components are processed on two machines: a shaper and a grinder. Times required for each component on each machine are as follows: Component Shaper (minutes) Grinder (minutes) A 6 4 B 4 5 C 4 2 The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component C can be sold, but up to 1,000 units of each of the other components can be sold. The company has orders for 600 units of component A that must be met. The profit contributions for components A, B, and C are $8, $6, and $9, respectively. Write the linear programming formulation for Mad Manufacturing to determine the best production mix of the three components. Variables Let; X1 = number of units of component A produced X2 = number of units of component B produced X3 = number of units of component C produced Maximize Z = 8X1 + 6X2 + 9X3 Subject to; 6X1 + 4X2 + 4X3 = 600 (component A units demanded) Amber Henson BADM 3963 Linear Programming Formulation homework #1 Summer 2017 Write the LP formulations for the following problems in a Word document. Submit Word document in BB Assignments Due 7/6, 9pm 1.Teethree, Inc. is a small manufacturer of sports equipment whose management has decided to begin producing golf bags. Two models will be produced - a standard bag and a deluxe bag. The bags require work in four departments as indicated in the table below. Each standard bag contributes $15 profit and each deluxe bag contributes $12 profit. The amount of time available in each department for production of golf bags is as follows: Cutting, 630 hours; Sewing, 600 hours; Finishing, 708 hours; and Packaging, 135 hours. Department Cutting Sewing Finishing Packaging Standard Bag requirement per bag 0.7 hour 0.5 hour 1 hour 0.10 hour Deluxe bag requirement per bag 1 hour 0.8 hour 0.67 hour 0.25 hour Write the linear programming formulation to help Teethree determine the best mix of the two bags to produce. Variables Let; X1 = Number of standard bags to be produced X2 = Number of deluxe bags to be produced Maximize profit = 15X1 + 12X2 Subject to; 0.70X1 + X2 = 0 (non-negativity constraint) 2. Epsum Chemical Co. produces two products that are sold as raw materials to companies that manufacture cosmetics. Based on an analysis of current inventory levels and potential demand for the coming month, Epsum's management specified that the combined production for products A and B must total at least 325 gallons. Separately, a major customer's order for 105 gallons of product A must be met. Product A requires 2 hours of processing time per gallon, and product B requires 1 hour of processing time per gallon. For the coming month, 500 hours of processing time are available. Production costs are $2 per gallon for product A and $3 per gallon for product B. Write the linear programming formulation to help Epsum determine how many gallons of each product should be produced for a minimum cost. Variables Let; X1 = Number of gallons of product A to be produced X2 = Number of gallons of product B to be produced Minimize cost = 2X1 + 3X2 Subject to; X1 + X2 >= 325 (Combined number of gallons to produce) X1 >= 105 (number of gallons of product A to produce) 2X1 + X2 = 0 (non-negativity constraint) 3. The Checotah Chamber of Commerce sponsors public service programs and is planning next year's advertising mix to promote the programs. Television, radio, and online ads are being proposed. The following table shows estimates of audience reach, costs, and individual upper limits on each type of ad. Type of ad Cost per ad Audience reached Upper limit on per ad ads of this type Television $2,000 100,000 10 Radio $300 18,000 20 Online $600 40,000 10 The budget for ads is limited to $18,500. To ensure a balanced used of the three media, radio ads must not exceed 50% of the total number of ads and television ads must account for at least 10% of the total number of ads. Write the linear programming formulation to help the Chamber determine the best mix of ads that will maximize the total audience reached. Variables Let; X1 = number of television ads to be used for the best mix X2 = number of radio ads to be used for the best mix X3 = number of online ads to be used for the best mix Maximize total audience = 100,000X1 + 18,000X2 + 40,000X3 Subject to; X1 = 0.1*(X1 + X2 + X3) (minimum number of radio ads allowed) 4. Mad Manufacturing makes three components that are sold to makers of air conditioners. The components are processed on two machines: a shaper and a grinder. Times required for each component on each machine are as follows: Component Shaper (minutes) Grinder (minutes) A 6 4 B 4 5 C 4 2 The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component C can be sold, but up to 1,000 units of each of the other components can be sold. The company has orders for 600 units of component A that must be met. The profit contributions for components A, B, and C are $8, $6, and $9, respectively. Write the linear programming formulation for Mad Manufacturing to determine the best production mix of the three components. Variables Let; X1 = number of units of component A to be processed X2 = number of units of component B to be processed X3 = number of units of component C to be processed Maximize profit = 8X1 + 6X2 + 9X3 Subject to; 6X1 + 4X2 + 4X3 = 600 (component A units demanded)