QUESTION 20 Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table summarizes the required amount of gluing, pressing, and mixture of wood chips required to produce a pallet of 50 units of each type of paneling: Resources Required per Pallet of Paneling Type Paneling Type Tahoe Pacific Savannah Aspen Glue (quarts) 50 50 100 50 Pressing (hours) 50 150 100 50 Pine chips (pounds) 500 400 300 200 Oak chips (pounds) 500 750 250 500 Assume the company has 6,000 quarts of glue; 7,500 hours of pressing capacity; 30,000 pounds of pine chips; and 62,500 pounds of oak chips available in the next production cycle. Further assume that each pallet of Tahoe, Pacific, Savannah, and Aspen panels can be sold for profits of $450, $1,150, $800, and $400, respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. Based on this information, fill out the objective function. MAX X1 + X2 + X3 + X4

QUESTION 20 Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table summarizes the required amount of gluing, pressing, and mixture of wood chips required to produce a pallet of 50 units of each type of paneling: Resources Required per Pallet of Paneling Type Paneling Type Tahoe Pacific Savannah Aspen Glue (quarts) 50 50 100 50 Pressing (hours) 50 150 100 50 Pine chips (pounds) 500 400 300 200 Oak chips (pounds) 500 750 250 500 Assume the company has 6,000 quarts of glue; 7,500 hours of pressing capacity; 30,000 pounds of pine chips; and 62,500 pounds of oak chips available in the next production cycle. Further assume that each pallet of Tahoe, Pacific, Savannah, and Aspen panels can be sold for profits of $450, $1,150, $800, and $400, respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. Based on this information, fill out the objective function. MAX X1 + X2 + X3 + X4

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Question 9
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 48,000 of these trikes. Current schedules yield the following information. Component Front Seat/Frame Rear wheel (each) Available Requirement Plastic 12 16 .20 S Model Regular Deluxe Heavy 100000 Time 40 24 8 2 2 320000 60000 Page 4 of 9 Space Manufacture 8 16 8 4 Cost to 12 2 3 4 5 Cost to Purchase 24 The company obviously does not have the resources available to manufacture everything needed for the completion of 24000 tricycles so has gathered purchase information for each component. Requested: Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 24000 fully completed tricycles at the minimum cost. 18 6 4) A paint supply company makes three styles of Paint Rollers, regular, deluxe and heavy.…
1
Required information [The following information applies to the questions displayed below.] The first production department of Stone Incorporated reports the following for April. Direct Materials Conversion Units Beginning work in process inventory 78,000 Percent Complete 75% Percent Complete 25% Units started this period 412,000 Completed and transferred out 390,000 Ending work in process inventory 100,000 80% 30% The production department had the cost information below. Beginning work in process inventory Direct materials Conversion Costs added this period Direct materials Conversion $ 231,275 36,840 $ 268,115 Total costs to account for 1,296,225 929,160 2,225,385 $ 2,493,500 a. Compute cost per equivalent unit for both direct materials and conversion. Note: Round "Cost per EUP" to 2 decimal places. b. Using the weighted average method, assign April's costs to the department's output-specifically, its units transferred to the next department and its ending work in process inventory.…
A decision situation can be expressed as either a payoff table or a decision tree diagram. Question 30 options: True False
MGT -314 (operation Management) MCQ:
Ann Archibald has ambition to be on the County Governing Board. Her staff has determined the breakdown of tasks needed to secure the election. The following network depicts the breakdown. ( see atttached picture ) Her staff also has estimated the normal and crash times and costs for tasks involved in the breakdown. The information is summarized below. The campaign starts on 4/1/2022. Task Time Estimates (Weeks) Cost Estimates ($) Normal Crash Normal Crash A1 6 4 5,000 10,000 B2 3 3 4,000 4,000 C 10 8 4,000 7,000 D 4 2 1,000 2,000 E 2 1 1,000 2,000 F 3 1 4,000 7,600 G 5 4 7,000 12,000 H 7 5 8,000 14,000 I 2 2 1,200 1,200 J 4 3 5,000 5,800 K 8 6 13,000 15,000 L 5 5 6,000 6,000 M 4 4 2,500 2,500 1 Task A can be crashed by 2 weeks at an additional cost of $5000 ($2,500/week). 2 Task B cannot be crashed. Ann has…
b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.
Hii solve only final answers fast no need long explanation
Explain the following functions of MRP 1.forecasting 2.reducing waste 3.floor-control and scheduling
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?