If the profit of Product C increased by 1.50, does the production plan change? Does the profit
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cinto Furniture Company has 4 main types of products. Each type product requires a different amount of Assembly, Cutting and Packing hour. Each products requires a different unit of wood. We are now using 4 variables to representing these 4 products: B = # of Product B made and Sold D = # of Product D made and Sold A = # of Product A made and Sold C = # of Product C made and Sold Objective: Maximize Profit = S2.50A + $4.00B + $5.00C + $5.50D Constraints: Assembly: Cutting: Packing: Wood: 2A +3B +5C +4D <1,000 hours < 2,600 hours <1,500 hours 13A +1B +14C +3D 2A +7B +9C +6D 1A +13B +12C +15D <3,000 units Minimum # of C: 10 2 10 Non-negativity: A, B, C, D > 0 The sensitivity report is given below Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SBS2 # of Product A 105 0.00 2.5 0.25 1.56 SCS2 # of Product B -0.19 4 0.19 1E+30 SD$2 # of Product C 10 0.00 1.62 1E+30 SES2 # of Product D 185 0.00 5.5 32 0.22 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Assembly Time SF$6 Cutting Time Packing Time Wood Used SF$5 1000.00 1.23 1000 73.13 182.00 2060.00 0.00 2600 1E+30 540.00 SF$7 1410.00 0.00 1500 1E+30 90.00 SF$8 3000.00 0.04 3000 585.00 305.22 SF$9 Minimum # of C 10.00 -1.62 10 35.45 1E+30 Cinto Furniture Company has 4 main types of products. Each type product requires a different amount of Assembly, Cutting and Packing hour. Each products requires a different unit of wood. We are now using 4 variables to representing these 4 products: B = # of Product B made and Sold D = # of Product D made and Sold A = # of Product A made and Sold C = # of Product C made and Sold Objective: Maximize Profit = S2.50A + $4.00B + $5.00C + $5.50D Constraints: Assembly: Cutting: Packing: Wood: 2A +3B +5C +4D <1,000 hours < 2,600 hours <1,500 hours 13A +1B +14C +3D 2A +7B +9C +6D 1A +13B +12C +15D <3,000 units Minimum # of C: 10 2 10 Non-negativity: A, B, C, D > 0 The sensitivity report is given below Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SBS2 # of Product A 105 0.00 2.5 0.25 1.56 SCS2 # of Product B -0.19 4 0.19 1E+30 SD$2 # of Product C 10 0.00 1.62 1E+30 SES2 # of Product D 185 0.00 5.5 32 0.22 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Assembly Time SF$6 Cutting Time Packing Time Wood Used SF$5 1000.00 1.23 1000 73.13 182.00 2060.00 0.00 2600 1E+30 540.00 SF$7 1410.00 0.00 1500 1E+30 90.00 SF$8 3000.00 0.04 3000 585.00 305.22 SF$9 Minimum # of C 10.00 -1.62 10 35.45 1E+30
Expert Answer:
Related Book For
Posted Date:
Students also viewed these organizational behavior questions
-
A western wood product has two production departments: cutting and assembly. The company has been using a single predetermined cost driver rate based on plant wide direct labor hours. That, is the...
-
A company specializing in parachute assembly states that its main parachute failure rate is not more than 1%. You perform a hypothesis test to determine whether the companys claim is false. When will...
-
Furniture Products is a multi division manufacturer. The divisions are autonomous segments; each division is responsible for its own sales, costs of operations, working capital management, and...
-
Do you have convincing evidence of sufficient computer skills to engage in online discussion forums, access online library resources, engage in online videoconferencing, and utilize word processing,...
-
List three reasons why a business should wish to repurchase some of its shares.
-
Rianna.com uses the allowance method of accounting for bad debts. The company produced the following aging of the accounts receivable at year-end. Instructions (a) Calculate the total estimated bad...
-
Discuss how the Privacy Act of 1974 and the Health Insurance Portability and Accountability Act of 1996 safeguard a patients privacy.
-
A negotiable promissory note executed and delivered by B to C passed in due course and was indorsed in blank by C, D, E, and F. G, the present holder, strikes out Ds indorsement. What is the...
-
Frankie has a very busy lunch counter. On Tuesday, they sold 190 meals and brought in revenue of $2,644. The vegetarian curry rice costs $7.00 and the Chicken Marsala costs $12.00. If the augmented...
-
The Ploughman family owns and operates a 640-acre farm that has been in the family for several generations. The Ploughmans always have had to work hard to make a decent living from the farm and have...
-
A simple trust has one beneficiary and in the current year has interest income of 8,000.00, tax exempt interest of$6,000.00, c/g income of$4,000 and fiduciary fees expense of $2,000.00 (allocable to...
-
In 1968 Howard Cunningham was charged in Daytona Beach, Florida, with having sex with a minor. Howard was a senior at the University of Tennessee enjoying a spring break when he had a brief fling...
-
Sixty years later, is Tybee bomb still lurking? BY J.R. ROSEBERRY TYBEE BOMB TIMELINE " Feb. 5, 1958: An F-86 fighter jet collided with a B-47 bomber carrying a 7,600-pound Mark 15 nuclear bomb...
-
FACT SCENARIO You are involved in a legal dispute over the home renovations done on the homeowners' property, which is a heritage home in which one of the parties grew up and holds great sentimental...
-
HYPOTHETICAL You work at a law firm, and you have been instructed by your supervising attorney to determine if the firm's client, Peterson, would be able to file and win a lawsuit against Electric...
-
Crown Metal was in business of manufacturing metal packaging. Mr. Di Tomaso was employed by Crown Metal for over 22 years as a two-piece mechanic and press maintainer, which involved setting up the...
-
Carlos Cavalas, the manager of Echo Products' Brazilian Division, is trying to set the production schedule for the last quarter of the year. The Brazilian Division had planned to sell 69,960 units...
-
Tiger, Inc. signed a lease for equipment on July 1, 2007.The lease is for 10 years (the useful life of the asset).The first of 10 equal annual payments of $500,000 was made on July 1, 2007.The...
-
The capital budgeting process provides both an opportunity and a temptation for unethical behavior. Give three examples.
-
Peregrine Enterprises is a large, diversified corporation with eight operating divisions. Each division is organized as a profit center. Each division manager's remuneration is augmented by a bonus...
-
The Evander Company has operated a comprehensive budgeting system for many years. This system is a major component of the company's program to control operations and costs at its widely scattered...
-
In the winter sport of curling, two teams alternate sliding 20 kg stones on an icy surface in an attempt to end up with the stone closest to the center of a target painted on the ice. During one...
-
The acceleration of the spacecraft in which the Apollo astronauts took off from the moon was 3.4 m/s 2 . On the moon, g = 1.6 m/s 2 .What was the apparent weight of a 75 kg astronaut during takeoff?
-
A vendor at the local art fair ties her tent to the concrete-filled coffee can shown in Figure P5.34. A stiff breeze comes up and the string becomes taut. What is the maximum value that the string...
Study smarter with the SolutionInn App