Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Worlds First Stock Exchange

Authors: Lodewijk Petram

1st Edition

0231163789,0231537328

Students also viewed these Finance questions

Question

List and describe four determinants of a countrys productivity.

Answered: 1 week ago