## the following problems and submit the results in either a Microsoft Word

## the following problems and submit the results in either a Microsoft Word

Activity 5.5 â Module ProblemsComplete the following problems and submit the results in either a Microsoft Worddocument or a Microsoft Excel spreadsheet. If you choose to use an Excelspreadsheet, place each problem on a separate sheet and label the tab with problemnumber. Save your document with a descriptive file name, including the assignmentand your name.5-1The Outdoor Furniture Corporation manufactures two products, benches and picnictables, for use in yards and parks. The firm has two main resources: its carpenters (labor force)and a supply of redwood for use in the furniture. During the next production cycle, 1,200 hoursof labor are available under a union agreement. The firm also has a stock of 3,500 board feet ofgood-quality redwood. Each bench that Outdoor Furniture produces requires 4 labor hours and10 board feet of redwood; each picnic table takes 6 labor hours and 35 board feet of redwood.Completed benches will yield a profit of $9 each, and tables will result in a profit of $20 each.a. How many benches and tables should Outdoor Furniture produce to obtain the largestpossible profit? Use the graphical LP approach. (Submit both the QM and the graphicalsolution.)5-2MSA Computer Corporation manufactures two models of minicomputers, the Alpha 4and the Beta 5. The firm employs six technicians, working 160 hours each per month, on itsassembly line. Management insists that full employment (i.e., all 160 hours of time) bemaintained for each worker during next monthâs operations. It requires 20 labor hours toassemble each Alpha 4 computer and 25 labor hours to assemble each Beta 5 model. MSA wantsto see at least 10 Alpha 4s and at least 15 Beta 5s produced during the production period. Alpha4s generate $1,200 profit per unit, and Beta 5s yield $1,800 each.a. Determine the most profitable number of each model of minicomputer to produce duringthe coming month.b. What would the profit be if they decided to make at least 15 of each model?5-3Woofer Pet Foods produces a low-calorie dog food for overweight dogs. This product ismade from beef products and grain. Each pound of beef costs $1.50, and each pound of graincosts $0.70. A pound of the dog food must contain at least 9 units of Vitamin 1, 10 units ofVitamin 2, and 6 units of Vitamin 3. A pound of beef contains 6 units of Vitamin 1, 12 units ofVitamin 2, and 4 units of Vitamin 3. A pound of grain contains 12 units of Vitamin 1, 9 units ofVitamin 2, and 10 units of Vitamin 3. Formulate this as a LP problem to minimize the cost of thedog food.a. How many pounds of beef and grain should be included in each pound of dog food?b. What is the cost and vitamin content of the final product?c. What would the distribution of beef and grain be if the cost of beef increased to $3.50 perpound?Page 1 of 2WorkfileContents.docx5-4The Feed âN Ship Ranch fattens cattle for local farmers and ships them to meat marketsin Kansas City and Omaha. The owners of the ranch seek to determine the amounts of cattlefeed to buy so that minimum nutritional standards are satisfied, and at the same time total feedcosts are minimized. The feed mix can be made up of the three grains that contain the followingingredients per pound of feed:INGREDIENTABCDSTOCK X3216FEED (OZ)STOCK Y2308STOCK Z4124The cost per pound of stocks X, Y, and Z are $3.50, $4.75, and $4.50, respectively. Theminimum requirement per cow per month is 4 pounds of ingredient A, 5 pounds of ingredient B,1 pound of ingredient C, and 8 pounds of ingredient D. The ranch faces one additionalrestriction: it can only obtain 500 pounds of stock Z per month from the feed supplier regardlessof its need. Because there are usually 100 cows at the Feed âN Ship Ranch at any given time,this means that no more than 5 pounds of stock Z can be counted on for use in the feed of eachcow per month.a. Formulate this as an LP problem.b. Solve using LP software.You may submit just the answers or you may submit the answers and the QM worksheets youused to arrive at the answer. Choosing the latter will afford instructors the opportunity to reviewyour work and determine if you understand the concept but have made some minorcomputational error, therefore allowing them to assign some credit based on your understanding.Submitting just the answers does not provide for any partial credit.Page 2 of 2WorkfileContents.docx

We are the best paper help / essaytyper in the world