A TV manufacturer packs the finished TVs together according to their model types, and the dimension...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A TV manufacturer packs the finished TVs together according to their model types, and the dimension of the box for each model are as follows: Box Length 120 Dimension Width 100 Height 110 2 W|N 3 4 5 69 8 9 10 11 12 13 14 15 150 65 90 150 40 230 220 60 40 75 135 150 120 90 100 100 100 100 100 100 100 100 100 100 100 100 100 100 110 110 110 110 110 110 110 110 110 110 110 110 110 110 These boxes are going to be loaded into containers with dimensions 400 x 100 x 110 (Length X Width X Height). Since the products are fragile, rotating boxes is not allowed. Hence, you only need to consider the length dimension when loading. (a) (15 points) Develop a mathematical model to determine a loading plan such that the maximum unused (empty) space in a loaded/used container is minimized. Define your decision variables clearly. (b) (10 points) Solve the model (with a time limit of 60 seconds) you developed in part (a) using OpenSolver and report the best solution. Upload the excel file as well when uploading your solutions. (Hint: The best solution found within a time limit of 60 seconds has an objective function value of 55) A TV manufacturer packs the finished TVs together according to their model types, and the dimension of the box for each model are as follows: Box Length 120 Dimension Width 100 Height 110 2 W|N 3 4 5 69 8 9 10 11 12 13 14 15 150 65 90 150 40 230 220 60 40 75 135 150 120 90 100 100 100 100 100 100 100 100 100 100 100 100 100 100 110 110 110 110 110 110 110 110 110 110 110 110 110 110 These boxes are going to be loaded into containers with dimensions 400 x 100 x 110 (Length X Width X Height). Since the products are fragile, rotating boxes is not allowed. Hence, you only need to consider the length dimension when loading. (a) (15 points) Develop a mathematical model to determine a loading plan such that the maximum unused (empty) space in a loaded/used container is minimized. Define your decision variables clearly. (b) (10 points) Solve the model (with a time limit of 60 seconds) you developed in part (a) using OpenSolver and report the best solution. Upload the excel file as well when uploading your solutions. (Hint: The best solution found within a time limit of 60 seconds has an objective function value of 55)
Expert Answer:
Answer rating: 100% (QA)
To develop a mathematical model for determining a loading plan that minimizes the maximum unused spa... View the full answer
Related Book For
College Algebra With Modeling And Visualization
ISBN: 9780134418049
6th Edition
Authors: Gary Rockswold
Posted Date:
Students also viewed these finance questions
-
Given a distribution that has a mean of 44 and a standard deviation of 17, calculate the probability that a sample of 81 has sample means in the following ranges. a. greater than 42 b. at most 46 c....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Determine which of the fundamental laws of algebra is demonstrated. 8(3 2) = 8(3) 8(2)
-
Consider the problem of the particle moving on the surface of a cone, as discussed in Examples 7.4 and 8.7. Show that the effective potential is V(r) mgr cot a + 2mr?
-
Access the 2007 10-K for Abercrombie & Fitch (www.abercrombie.com). Required: Prepare a trend analysis for 2006 and 2007, using 2006 as the base year.
-
At 3:00 a.m. on November 22, 2010, 16-year-old Sydney McLemore was driving a Mazda3 with her friend, Natalie Hurst, in the front passenger seat. The vehicle was traveling south on Ross Bridge Highway...
-
Relevant costs, opportunity costs. Larry Miller, the general manager of Basil Software, must decide when to release the new version of Basils spreadsheet package, Easyspread 2.0. Development of...
-
Problem 3 For a multiple linear regression model with 4 variables, where ~ Y = Bo+B1X1 + B2X2 + 3X3 + B4X4 + , N(0,2), what is the test statistic for each of the following tests? and what is the...
-
1. What are the pick-up, sort, linehaul, and delivery costs to Hardee for this move? 2. What is the total cost of this move? Cost per cwt.? Cost per revenue mile? 3. If Hardee would put two drivers...
-
A 800g ball is pulled up a slope as shown in the diagram. Calculate the potential energy it gains. 20cm 50cm
-
The Abraham Company receives $ 2 7 , 0 0 0 to do a job. However, the work is not yet completed. How is the receipt of this money recognized for financial reporting purposes?
-
Zoey has found her grandmother's diary from when she attended college in the 1920s. In multiple entries, Zoey's grandmother describes female classmates for whom she has same-sex crushes. These diary...
-
Remainder person R owned a contingent remained in a trust, which R transferred to R's child. Under the trust terms, R's sibling S was to receive the remainder if S survived the income beneficiary,...
-
Fantasia is a popular photographer in her area and she typically charges $ 1 2 5 for a photo session. Mario is an accountant who charges $ 1 0 0 per hour to complete a tax return. Fantasia would like...
-
Discuss fixed assets and cost determination in financial statements. Provide examples of fixed assets. What costs are included in determining the total cost of an asset?
-
The lifetime of a light bulb in a certain application is normally distributed with a mean = 1400 hours and standard deviation = 200 hours. a. What is the probability that a randomly selected light...
-
General Electric Capital, a division of General Electric, uses long-term debt extensively. In a recent year, GE Capital issued $11 billion in long-term debt to investors, then within days filed legal...
-
Solve the inequality symbolically. Express the solution set in set-builder or interval notation. -3 (2-4) 2(1-22)
-
Use properties for summation notation to find the sum. 31 (3k = 3)
-
Find the probability of drawing 2 diamonds from a standard deck of 52 cards without replacing the first card.
-
Explain why the Carnot cycle overestimates the thermal efficiency achievable from an engine producing power output. Discuss why external irreversibility reduces the effective temperature ratio of an...
-
Closed cycle gas turbines operate on the internally reversible Joule cycle with an efficiency of \[\eta_{\text {Joule }}=1-\frac{1}{r_{p}^{(\kappa-1) / \kappa}}\] where \(r_{p}=\) pressure ratio of...
-
The operating processes of a spark-ignition engine can be represented by the Otto cycle, which is internally reversible and gives a thermal efficiency of \[\eta_{\text {Otto...
Study smarter with the SolutionInn App