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

Related questions

Q: Question 3. Change your spreadsheet to 'show formulas' - type "show formulas" and Enter key as shown…

A: A linear objective function can be optimized using the linear programming (LP), also known as linear…

Q: Below is information related to: historical average processing times for Products A and B historical…

Q: .A firm has 77 units of a product on hand. Forecasts of demand are 26 units per week. An MPS…

A: Answer - 85

Q: What is the optimal objective function value for this problem?

A: Here, I have been given the sensitivity report, There are a total of three decision variables, The…

Q: Buzz Appliances manufactures two products: Food Processors and Espresso Machines. The following data…

A: Food Processors Espresso Makers Sales price $125 $225 Variable costs $80 $190

Q: Project A BCDEFG с Note: All projects have equal risk. |*|-| Project A C E Investment Required ($…

A: The gain or loss an investor anticipates on an investment with known historical rates of return…

Q: SELECT THE BEST ALTERNATIVE IN THE GIVEN DECISION TABLE USING: • MAXIMAX STRATEGY • MAXIMIN STRATEGY…

A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

Q: The business school department decided to apply a new method in assigning professors to courses next…

A: Professor/CoursesStatisticsManagementFinanceEconomicsAnderson90659540Sweeney70608075Williams85408060…

Q: Justify the use of the weighting system used for evaluatingmanagers for annual bonuses.

A: Introduction: Weighting system can be defined as the stem which is used for use scales and…

Q: Industrial Designs has been awarded a contract to design a label for a new wine produced by Lake…

A: Linear programming is a mathematical method used to find the best possible outcome or solution from…

Q: TJ, Inc., makes three nut mixes for sale to grocery chains located in the Southeast. The three…

A: There are 3 products:Regular MixDeluxe MixHoliday Mix5 types of nuts are required to make the above…

Q: q3

A: A process that is slowest or the one that causes maximum congestion in the system is known to be a…

Q: General Admission (includes admission to over 35 galleries and non-surcharged exhibitions) FREE…

A: The Museum of Illusions in New Delhi, India, is a one-of-a-kind and interactive museum that tests…

Q: Shelves Unlimited is interested in estimating the additional machine center capacities for a new…

A: Find the given details below:Note that for Part C, the total time details are not available so we…

Q: Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it. Click on the image…

A: A linear objective function can be optimized using the linear programming (LP), also known as linear…

Q: In anticipation of an upcoming engagement, an internal audit team recently toured the company’s…

A: Internal audit is an important component of corporate governance since it assists organisations in…

Q: Problem 7-13 (Algo) Owen Conner works part-time packaging software for a local distribution company…

A: The Breakeven Point is that level of sales at which there is no profit no loss. In other words it is…

Q: Cycle time minutes per cycle

A: Production is the process in which inputs are combined to have the required output. It includes a…

Q: a. Is the change to contract a modification of the contract or a separate contract? b. How should…

A: In the given contract, the changes that occur are the contract modification. Recognized income =…

Concept explainers

Types of Scheduling

Scheduling is the activity of allotting materials to complete the day-to-day tasks efficiently, thus having a competitive advantage when compared to other unplanned work structures. In context to operations management and scheduling, the term "scheduling" determines time managing skills and effective utilization of resources. Any scheduling activity is assigned to a specific person who is known as a scheduler. Loading concerns granting jobs to multiple work centers and their machinery. Vertical loading involves loading according to the selected priority rule.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Fill out the objective function:

VIEW

Step 2:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

9. The Ace Manufacturing Company has orders for three similar products: Orders Product (units) A 2000 500 1200 B C Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect per- centages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows: Сараcity (units) Product Machine Machine A в C 1500 $1.00 $1.30 $1.10 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 1 1500 1000 3 Use the transportation model to develop the minimum cost production schedule for the products and machines. Show the linear programming formulation. 123
II. TALENT MANAGEMENTPlusCoop is a company that manages co-working space rentals, or popular known as co-working spaces. Established since 2014, PlusCoop offers rental services a workspace intended for freelancers, entrepreneurs, and business operators small medium. The space offered consists of 3 types:1. 4 units of communal workspace - large space, maximum capacity of 40 people, rental mechanism per day (24hours) and per person.2. 20 units of exclusive workspace - enclosed space, maximum capacity of 2 people per room, rental mechanismper month and per room.3. 4 units of conference room - large room, maximum capacity of 20 people, rental mechanism per day, withprojector and screen facilities. Armed with wi-fi facilities, whiteboard, free coffee-tea station, and a strategic location in the city center, During 4 years of operation, PlusCoop has succeeded in becoming a very popular co-working space by their target consumers. However, the pandemic that hit Indonesia in 2019 resulted in…
Enter the correct shirt order number from the Payoff Table: 1. Maximin Rule: ____ Shirt order 2. Maximax Rule: ____ Shirt order 3. Expected Payoff Rule: ____ Shirt order Decision $ Payoff Table by Game Outcome Shirt Order Win Lose Tie Options Prob=0.5 0.4 0.1 0 0 0 0 1000 800 -200 200 2000 1600 -1500 100
Case: Radial Bearing Team: A Manufacturing Group's Transformation to Self-Directed Work Discuss Shane’s approach to dealing with George’s demand that he changes the work order quantity back to five. What would be the impact on the team of Shane’s doing so?
Problem 3 Magic Corporation received a contract to develop and produce four electronic boards for a computer company. The following table shows the amount of labour hours and the cost of raw materials for each of the four electronic boards. 1st unit 2nd unit 3rd unit 4th unit Labour 4,000 3,200 2,808 2,560 Raw materials $7,800 $7,020 $6,600 $6,318 Magic Corporation was asked to quote in a new contract for another eight electronic boards. Estimate the time and raw materials costs for the eight units. (Hint: There are two learning curves: one for labour and one for raw materials.)
Pls solve this question correctly in 5 min i will give u like Question # 2 A company produces two products, A and B. The sales volume for product A is at least 40% of the total sales of the two products. Both products use the same raw material, of which the daily availability is limited to 200 kg. Products A and B use this raw material at the rates of 5 kg/unit and 2 kg/unit, respectively. The sales prices for the two products are $50 and $20 per unit. Determine the following: a)Optimum volume of each product to be produced? b)What impact does the production mix have, in case the sales price of Product B decreases by 50%?
00:53:53 C k TB Problem Qu. 5-114 (Algo) Mccabe Corporation uses the weighted-average... for September. Mccabe Corporation uses the weighted-average method in its process costing. The following data pertain to its Assembly Department Mc Graw Hill control Work in process, September 1 Units started into production during September Units completed during September and transferred to the next department Work in process, September 30 Equivalent units of production Q A 2 Required: the weighted-average method. Compute the equivalent units of production for both materials and conversion costs for the Assembly Department for September using Z option W S # 3 X F3 Materials E H command D $ 4 DOD DOO F4 Conversion R C do 5 % F U * 8 N DII F8 Units 800 8,200 7,300 1,700 ( 9 F9 K M 0 Materials 55% F10 Percent Complete 75% L H P F11 > Help command Conversion 10% 25% + 11 Save & Exit 2 F12 option 2 Sub dele
Hand written solutions are strictly prohibited
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)?