Hanna Joy LTD. produces four products: W, X, Y and Z, using three resources, namely wood,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Hanna Joy LTD. produces four products: W, X, Y and Z, using three resources, namely wood, metal and labour. The first three constraints in the algebraic formulation and SOLVER output below are resource availability constraints. Hanna Joy LTD. must produce a total of at least 205 units of the first two products and proper use of his machinery requires that the amount of Y produced be at exactly 1/3 of the amount of Z produced. The tables below give the revenue per unit for the products, and the cost per unit for the resources. Product W X Y Z Revenue per unit $82 $65 $131 $63 Here is a correct algebraic formulation of the problem. Let W, X, Y and Z denote the number units of products W, X, Y and Z to produce. Maximize 45W + 26X+53Y+34Z subject to: 3W + 10X + 2Y + SZ ≤ 2900 4W+ X + 12Y+ 2Z ≤ 400 2W + X+ 3Y+ Z≤ 300 W+ X 2 205 First two products Y and Z requirement 0 1 The SOLVER solution is shown below. W X Y 0.00 286.05 2.33 45 26 53 Wood (meters) 3 10 2 Metal (meters) 4 1 12 Labour (hours) 2 1 3 Resources Wood (meters) Metal (meters) Labour (hours) W, X, Y and Z 1 Y-0.33Z- 0 0 1 Z 6.98 34 5 2 1 0 0 0 -0.33 Cost per unit $3 $5 $4 7797.67 2900.00 327.91 300.00 286.05 0.00 x= 2900 400 300 205 0 (a) The price per meter of metal has risen to $6. (Hint: rewrite the objective function equation). (3 points) (b) A total of at most $10,000 is available for acquisition of the wood material. (Hint: add an additional constraint). (3 points) (c) Hanna Joy LTD. decided that the amount produced of product Y must constitute at least 30% of the total number of units produced. (Hint: add an additional constraint). (2 points) The following correct output for this problem in its original form is provided below as an Excel Solver output. You will need this output to answer questions (d) through (g) each part of which is to be considered independently of all others. Variable Cells Cell SCS8 W SDSS X SESS Y SFS8 Z Constraints Name Name Cell $G$10 Wood $G$11 Metal $G$12 Labour SGS13 Demand $G$14 Balance Final Value 0.00 286.05 2.33 6.98 Final Value 2900.00 327.91 300.00 286.05 0.00 Reduced Cost -6.60 0.00 0.00 0.00 Shadow Price 0.02 0.00 25.77 0.00 -24.35 Objective Coefficient 45 26 53 34 Constraint R.H. Side 2900 400 300 205 0 Allowable Increase 6.60 17.75 1.00 0.33 Allowable Increase 100.00 A 19.02 81.05 3.57 Allowable Decrease IE+30 0.17 16.71 5.57 Allowable Decrease 258.33 B 10.00 IE+30 6.67 (d) Two numbers have been removed from the resource sensitivity table by your professor (the letters A and B appear instead of the numbers). What are the correct values of A and B? Justify. (4 points) (e) In order to start producing product W (e.g. W>0), what would need to happen to the revenue per unit of W? Justify. (2 points) (1) Up to 15 additional hours (beyond the original 300 hours) of labour are available, at the same cost of $4/hour. What is the new optimal value of the objective function? Justify. (4 points) (g) If the revenue for product Y has changed from $131 to $121, do the optimal values of the decision variables change? Justify. What about the objective function? If you can determine what the new optimal value of the objective function is, then do so. (4 points) Hanna Joy LTD. produces four products: W, X, Y and Z, using three resources, namely wood, metal and labour. The first three constraints in the algebraic formulation and SOLVER output below are resource availability constraints. Hanna Joy LTD. must produce a total of at least 205 units of the first two products and proper use of his machinery requires that the amount of Y produced be at exactly 1/3 of the amount of Z produced. The tables below give the revenue per unit for the products, and the cost per unit for the resources. Product W X Y Z Revenue per unit $82 $65 $131 $63 Here is a correct algebraic formulation of the problem. Let W, X, Y and Z denote the number units of products W, X, Y and Z to produce. Maximize 45W + 26X+53Y+34Z subject to: 3W + 10X + 2Y + SZ ≤ 2900 4W+ X + 12Y+ 2Z ≤ 400 2W + X+ 3Y+ Z≤ 300 W+ X 2 205 First two products Y and Z requirement 0 1 The SOLVER solution is shown below. W X Y 0.00 286.05 2.33 45 26 53 Wood (meters) 3 10 2 Metal (meters) 4 1 12 Labour (hours) 2 1 3 Resources Wood (meters) Metal (meters) Labour (hours) W, X, Y and Z 1 Y-0.33Z- 0 0 1 Z 6.98 34 5 2 1 0 0 0 -0.33 Cost per unit $3 $5 $4 7797.67 2900.00 327.91 300.00 286.05 0.00 x= 2900 400 300 205 0 (a) The price per meter of metal has risen to $6. (Hint: rewrite the objective function equation). (3 points) (b) A total of at most $10,000 is available for acquisition of the wood material. (Hint: add an additional constraint). (3 points) (c) Hanna Joy LTD. decided that the amount produced of product Y must constitute at least 30% of the total number of units produced. (Hint: add an additional constraint). (2 points) The following correct output for this problem in its original form is provided below as an Excel Solver output. You will need this output to answer questions (d) through (g) each part of which is to be considered independently of all others. Variable Cells Cell SCS8 W SDSS X SESS Y SFS8 Z Constraints Name Name Cell $G$10 Wood $G$11 Metal $G$12 Labour SGS13 Demand $G$14 Balance Final Value 0.00 286.05 2.33 6.98 Final Value 2900.00 327.91 300.00 286.05 0.00 Reduced Cost -6.60 0.00 0.00 0.00 Shadow Price 0.02 0.00 25.77 0.00 -24.35 Objective Coefficient 45 26 53 34 Constraint R.H. Side 2900 400 300 205 0 Allowable Increase 6.60 17.75 1.00 0.33 Allowable Increase 100.00 A 19.02 81.05 3.57 Allowable Decrease IE+30 0.17 16.71 5.57 Allowable Decrease 258.33 B 10.00 IE+30 6.67 (d) Two numbers have been removed from the resource sensitivity table by your professor (the letters A and B appear instead of the numbers). What are the correct values of A and B? Justify. (4 points) (e) In order to start producing product W (e.g. W>0), what would need to happen to the revenue per unit of W? Justify. (2 points) (1) Up to 15 additional hours (beyond the original 300 hours) of labour are available, at the same cost of $4/hour. What is the new optimal value of the objective function? Justify. (4 points) (g) If the revenue for product Y has changed from $131 to $121, do the optimal values of the decision variables change? Justify. What about the objective function? If you can determine what the new optimal value of the objective function is, then do so. (4 points)
Expert Answer:
Related Book For
Accounting and Finance An Introduction
ISBN: 978-1292088297
8th edition
Authors: Peter Atrill, Eddie McLaney
Posted Date:
Students also viewed these accounting questions
-
Three friends, X Y and Z decide to form a partnership to carry on a business trading in used cars. X has experience working as a manager and salesman. Y is a skilled motor mechanic. Z is wealthy. The...
-
A company manufactures three products X, Y and Z using the same manufacturing facilities arranged in five departments; A, B, C, D and E. The material handling is done by a fork lift. The container...
-
Maximize 10x + 12y + 10z subject to the constraints Solve the linear programming problem by the simplex method. 2 y + 3z s 12 2 0, 20, :20.
-
Exporting files into binary files is done in O Logical files O Physical backup O Physical full backup O Physical partial backup L
-
Using the data from SE5-4A, calculate the cost of goods sold and the cost of the ending inventory using the FIFO periodic cost flow assumption. In SE5-4A, Calculate the cost of goods sold and the...
-
Robert Gates rounds the corner of the street and smiles when he sees his wife pruning rose bushes in their front yard. He slowly pulls his car into the driveway, turns off the engine, and falls into...
-
Its Intoxicating Inc., is a Pennsylvania corporation that manufactures and distributes cosmetic products to various retailers. Maritim is a German company that owns and operates hotels throughout...
-
Glaus Leasing Company agrees to lease machinery to Jensen Corporation on January 1, 2010. The following information relates to the lease agreement. 1. The term of the lease is 7 years with no renewal...
-
The figure depicts Jack - in - the - box: "Jack" is attached inside a box by a spring, as shown. You estimate Jack's mass to be 0 . 4 k g . As so often happens, a sign tells you the spring constant:...
-
In a random sample of 1800 observed values from the interval (0, 1), it was found that 391 values were between 0 and 0.2, 490 values were between 0.2 and 0.5, 580 values were between 0.5 and 0.8, and...
-
For the function (x) = 6(2) - 8, state its domain, range, and asymptote and then graph the function. Enter the domain and range in interval notation. To enter o when in text mode, type infinity. To...
-
1. Suppose the historical annual volatility and mean of returns on the Japanese TOPIX index are 20% and 2%, respectively, while the annual historical Japanese inflation is 0.1%. Further, suppose that...
-
You own a construction company. You have been offered two different jobs, but they both must be done in the next month and they would both take all of your workers to complete within that time. The...
-
What are some advantages of incorporating your business? What are some reasons why you wouldn't want to incorporate?
-
What would a training guide matrix for a global team in an organization related to marketing science look like?
-
Credit Suisse has a bond which matures in three years with a coupon of 4.0%. The required rate of return on UBS's three- debt is 4.55%. What is the theoretical price of the bond? (5) Establish the...
-
10-3 10-4 0-14 Sonya Inc. is expected to pay a $0.80 per share dividend at the end of the year (that is, D = $0.80). The dividend is expected to grow at a constant rate of 5% a year. The required...
-
Complete the equations for the following equilibria and calculate Keq where the Keq expression includes [HO]. Be sure to enter Keq in proper scientific notation. (a) ammonia (acting as a base) reacts...
-
Pisces plc produced the following statement of financial position and income statement at the end of the third year of trading: An analysis of the underlying records reveals the following: 1 The...
-
Lewisham Ltd manufactures one product line the Zenith. Plans over the next few months are as follows: 1 Sales demand ...................................Units July .........................180,000...
-
SJ Services Ltd has been asked to quote a price for a special contract to render a service that will take the business one week to complete. Information relating to labour for the contract is as...
-
Verify the color SU(3) representations for combinations of three or fewer quarks and antiquarks given in Eq. (19.28). Data from Eq. 19.28 qq=303=108 qq 3 3 603, 999 3 3 3 = 36315, qqq 3 3 3 1088 10,
-
Prove that Eq. (19.34) gives the simplest multi-gluon and gluon-quark states that contain an \(\mathrm{SU}(3)\) color singlet in the decomposition. Data from Eq. 19.34 (GG)1: (88)1 (Gqq) : [8 (383)8]...
-
A textile manufacturer is concerned about the strength of cotton yarn. In order to nd out whether fiber length is an important factor in determining the strength of yarn, the quality control manager...
Study smarter with the SolutionInn App