Systems Analysis & Ops research questions Question 1 Giapettoâ€™s Woodcarving, Inc. manufactures two types of toys: soldiers and trains. Each soldier sold generate $3 in profit while each train generates $2 in profit. The manufacture of wooden soldiers and trains requires two types of skilled labor: carpentry and finishing. A soldier requires 2 hours of finishing labor and 1 hour of carpentry labor. A train requires 1 hour of finishing labor and 1 hour of carpentry. Each week, Giapetto can obtain all the needed raw materials but only 100 finishing hours and 80 carpentry hours. Demand for trains is unlimited, but at most 40 soldiers are bought each week. Help Giapetto to maximize his profit. a) Formulate the linear programming model for the problem. b) Use the Graphical method to find the optimal solution. Show all steps. c) Use Excel Solver or Lindo to solve the model you formulated. Copy and paste your spreadsheet and the Answer report in its entirety from Excel OR your Lindo input and output. d) Generate the range sensitivity analysis as part of the output (will use next week). Questions 2 My diet requires that all the food I eat come from one of the four â€œbasic food groupsâ€ (chocolate cake, ice cream, soda, and cheesecake). At present, the following four foods are available for consumption: brownies, chocolate ice cream, cola, and pineapple cheesecake. Each brownie cost $0.50, each scoop of ice cream costs $0.20, each bottle of cola cost $0.30, and each piece of pineapple cheesecake costs $0.80. Each day, I must ingest at least 500 calories, 6 oz. of chocolate, 10 oz of sugar, and 8 oz of fat. The nutritional content per unit of each food is shown in the table. Formulate a linear programming model that can be used to satisfy my daily nutritional requirements at minimum cost. CALORIES CHOCOLATE (ounces) SUGAR (ounces) FAT (ounces) Brownie 400 3 2 2 Chocolate Ice Cream (1 scoop) 200 2 2 4 Cola (1 bottle) 150 0 4 1 Pineapple Cheesecake (1 piece) 500 0 4 5 a) Formulate the linear programming model for the problem. b) Use Excel Solver or Lindo to solve the model you formulated. Copy and paste your spreadsheet and the Answer report in its entirety from Excel OR your Lindo input and output. Question 3 Semicond is a small electronics company that manufactures tape recorders and radios. The per-unit labor costs, raw materials, and selling price of each product are given in Table 1. On December 1, 1997, Semicond has available raw material that is sufficient to manufacture 100 tape recorders and 100 radios. On the same date, the companyâ€™s balance sheet is as shown in Table , and Semicondâ€™s current ratio is 20,000/10,000 = 2. Tape Recorder Radio Selling Price $100 $90 Labor Cost $50 $35 Raw Material Cost $30 $40 Assets Liabilities Cash $10,000 Accounts Receivable $3,000 Inventory outstanding* $7,000 Bank Loan $10,000 Semicond must determine how many tape recorders and radios should be produced during December. Demand is large enough to ensure that all goods produced will be sold. All sales on credit, however, and payment for goods produced in December will not be received until February 1, 1998. During December, Semicond will collect $2000 in accounts receivable, and Semicond must payoff $1000 of the outstanding loan and a monthly rent of $1000. On January 1, 1998, Semicond will receive a shipment of raw material worth $2000, which will be paid for on February 1, 1998. Semicondâ€™s management has decided that the cash balance on January 1, 1998 must be at least $4000. Also, Semicondâ€™s bank requires that the current ratio (assets/liabilities) at the beginning of January be at least 2. In order to maximize the contribution to profit from December production, (revenues to be received) â€“ (variable production costs), what should Semicond produce during December? a) Formulate the linear
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique.
FALL 2018 HOMEWORK HELP| ASSIGNMENT HELP,…