Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Formulate this problem as a linear program to maximize the total profit and determine the optimum number of parts to be produced each month. Make
Formulate this problem as a linear program to maximize the total profit and determine the optimum number of parts to be produced each month. Make sure to define and explain the decision variables, objective function, and constraints.
Relaxation Inc. is a furniture company that manufactures desks and chairs for offices. They have forecasted the demand of desks and chairs for the second half of this year, and currently they are at the planning phase for production. They figured out the manufacturing plan for their chairs, however they are still struggling to determine the optimal production schedule for their desks. Each desk is made up of three main assembly parts: A, B, and C. Part C is assembled from two other parts: D and E. Figure 1 shows the hierarchy of parts and the number of each used in assembling a single desk. DESKS Qty: 1 A Part B Part Qty: 2 Part C Qty: 3 Qty: 1 Part E Part D Qty: 1 Qty: 2 Figure 1: Product Structure Tree Table 1 shows the monthly inventory cost per unit, the lead time, which is the time between when the part is ordered until it is received, the current inventory, and finally the ordering policy for each part. Notice that desks do not have inventory cost. Table 1: Parts' Requirements Part A Part E Part B 8 Part C 4 Part D 7 5 2 Inventory Cost: Lead Time: Current Inventory: 1 month 100 Minimum 500 parts 2 months 30 2 months 0 1 month 40 2 months 0 Ordering Policy: none none none none The forecasted monthly demand for desks and the monthly production cost per unit of each part is given in table 2. Each desk is sold for 3000 Saudi Riyals. Table 2: Monthly Demand and Production Cost Month, Year Forecasted Production Cost / Unit 2022 Demand Desk Part A Part B Part C Part D Part E July 120 400 170 220 70 110 50 August 160 400 140 215 80 130 September 210 450 150 205 90 170 October 230 500 140 195 20 210 November 310 600 130 200 80 180 December 360 600 160 200 80 190 585 588 40 55 45 60 35 Relaxation Inc. is a furniture company that manufactures desks and chairs for offices. They have forecasted the demand of desks and chairs for the second half of this year, and currently they are at the planning phase for production. They figured out the manufacturing plan for their chairs, however they are still struggling to determine the optimal production schedule for their desks. Each desk is made up of three main assembly parts: A, B, and C. Part C is assembled from two other parts: D and E. Figure 1 shows the hierarchy of parts and the number of each used in assembling a single desk. DESKS Qty: 1 A Part B Part Qty: 2 Part C Qty: 3 Qty: 1 Part E Part D Qty: 1 Qty: 2 Figure 1: Product Structure Tree Table 1 shows the monthly inventory cost per unit, the lead time, which is the time between when the part is ordered until it is received, the current inventory, and finally the ordering policy for each part. Notice that desks do not have inventory cost. Table 1: Parts' Requirements Part A Part E Part B 8 Part C 4 Part D 7 5 2 Inventory Cost: Lead Time: Current Inventory: 1 month 100 Minimum 500 parts 2 months 30 2 months 0 1 month 40 2 months 0 Ordering Policy: none none none none The forecasted monthly demand for desks and the monthly production cost per unit of each part is given in table 2. Each desk is sold for 3000 Saudi Riyals. Table 2: Monthly Demand and Production Cost Month, Year Forecasted Production Cost / Unit 2022 Demand Desk Part A Part B Part C Part D Part E July 120 400 170 220 70 110 50 August 160 400 140 215 80 130 September 210 450 150 205 90 170 October 230 500 140 195 20 210 November 310 600 130 200 80 180 December 360 600 160 200 80 190 585 588 40 55 45 60 35 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started