Question

Question 3. Tom Johnson Manufacturing intends to increase the capacity through the addition of new equipment. Two vendors have presented proposals. The fixed cost for proposal A is $47000 and for proposal, B is $54000. The variable cost for A is $21 and for B, $23. The revenue generated by each unit of A is 35 and B is $38 a. What is the breakeven point in units and in dollars for proposal A? b. What is the breakeven point in units and in dollars for proposal B7 c. If the expected volume is 7500 units, which proposal should be chosen? Justify with rationale d. Approximately, which sales volume, the profit of B is more than profit of A by 13000? Hints: Goal seek would help) Question 4 The UAE celebrates national day with children wearing new dresses embroidered with national flags. A tailor has three weeks before the national day and plans to work for up to 40 hours per week for the next three weeks. He earns a revenue of AED100 from stitching a pant and AED 80 from a shirt. He has a stock of 90 meters of cloth and 80 units of packaging material. A pant requires 0.S meters of cloth and a shirt 0.9 meters of cloth It takes a tailor approximately 1.2 hours to cut and stitch a pant and 0.9 hours to stitch a shirt After stitching, the pants and shirts are packaged separately using special packaging material. A pant needs 1.2 units of packaging material whereas a shirt needs 0.5 units of packaging material He has enough demand for both dresses. The tailor wants to determine the mumber of pants (1) and shirts (x2) to produce in order to maaximize his revenue. Assume that fractional values of shirts and pants are acceptable. The ratio between pants and sewing the number of shirts is 1 to 2. The demand for the shirt is no less than 15 and at most 80. Formulate a linear programming model for this problem

please help if you can explain the goal seek part thanks in advance

Answer 1