Roedel Electronics produces a variety of electrical components, including a remo
ID: 3269153 • Letter: R
Question
Roedel Electronics produces a variety of electrical components, including a remote controller for televisions and a remote controller for VCRs. Each controller consists of three subassemblies that are manufactured by Roedel: a base, a cartridge, and a keypad. Both controllers use the same base subassembly, but different cartridge and keypad subassemblies. Roedel's sales forecast indicates that 7000 TV controllers and 5000 VCR controllers will be needed to satisfy demand during the upcoming Christmas season. Because only 500 hours of in-house manufacturing time are available, Roedel is considering purchasing some, or all, of the subassemblies from outside suppliers. If Roedel manufactures a subassembly in-house, it incurs a fixed setup cost as well as a variable manufacturing cost. The following table shows the setup cost, the manufacturing time per subassembly, the manufacturing cost per subassembly, and the cost to purchase each of the subassemblies from an outside supplier: a. Determine how many units of each subassembly Roedel should manufacture and how many units Roedel should purchase. What is the total manufacturing and purchase cost associated with your recommendation? b. Suppose Roedel is considering purchasing new machinery to produce VCR cartridges. For the new machinery, the setup cost is $3000: the manufacturing time is 2.5 minutes per cartridge, and the manufacturing cost is $2.60 per cartridge. Assuming that the new machinery is purchased, determine how many units of each subassembly Roedel should manufacture and how many units of each subassembly Roedel should purchase. What is the total manufacturing and purchase cost associated with your recommendation? Do you think the new machinery should be purchased? ExplainExplanation / Answer
a)
b)
i did this in excel but cant upload file .so im entering in data here.pls execuse me .if you have any doubts comment me .pls rate it if it is clear x1 = number of key boards to produce x2 = number of small top flaps to produce x3 = number of large top flaps to produce x4 = number of small vertical stands to produce x5 = number of large vertical stands to produce y1 = 1, if keyboards are produced, 0 if not y2 = 1, small top flap are produced, 0 if not y3 = 1, large top flap are produced, 0 if not y4 = 1, small vertical stand are produced, 0 if not y5 = 1, large vertical stand are produced, 0 if not p1 = number of key boards to purchase p2 = number of small top flaps to purchase p3 = number of large top flaps to purchase p4 = number of small vertical stands to purchase p5 = number of large vertical stands to purchase Objective function Z Min = 04x1 + 2.9x2+3.15x3+0.3x4+0.55x5+ 0.65p1 + 3.45p2+3.75p3+0.5p4+0.7p5 + 1000y1 + 1200y2 + 1900y3 + 1500y4+1500y5 Constraints x1+p1 = 12000 x2+p2 = 7000 x3+p3 = 5000 x4+p4 = 7000 x5+p5 = 5000 0.9x1 + 2.2x2 + 3x3 + 0.8x4 + 1x5 <= 30000 x1 <= 12000y1 x2 <= 7000y2 x3 <= 5000y3 x4 <= 7000y4 x5 <= 5000y5a)
0.4 2.9 3.15 0.3 0.55 0.65 3.45 3.7 0.5 0.7 1000 1200 1900 1500 1500 x1 x2 x3 x4 x5 y1 y2 y3 y4 y5 p1 p2 p3 p4 p5 LHS RHS Solution 12000 1 2866 6999 5000 1 1 1 1 1 0 6999 2134 1 0 1 1 12000 = 12000 1 1 7000 = 7000 1 1 5000 = 5000 1 1 7000 = 7000 1 1 5000 = 5000 0.9 2.2 3 0.8 1 29999.4 <= 30000 1 -12000 0 <= 0 1 -7000 -6999 <= 0 1 -5000 -2134 <= 0 1 -7000 -1 <= 0 1 -5000 0 <= 0 Objective function Z Min 12473590 x1 = 12000 x2 = 1 x3 = 2866 x4 = 6999 x5 = 5000 p1 = 0 p2 = 6999 p3 = 2134 p4 = 1 p5 = 0Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.