What recommendations should Ron Garcia make, with what justification? Provide a detailed analysis with charts, and graphs.

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...
icon
Related questions
Question
100%

Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding, Inc. He had not yet developed any technical knowledge about the manufacturing process, but he had toured the entire facility, located in the suburbs of Mexico City, and had met many people in various areas of the operation.

Mexicana, a subsidiary of Westover Wire Works, a Texas firm, is a medium-sized producer of wire windings used in making electrical transformers. Carlos Alverez, the production control manager, described the windings to Garcia as being of standardized design. Garcia's tour of the plant, laid out by process type (see Figure 7.20), followed the manufacturing sequence for the windings: drawing, extrusion, winding, inspection, and packaging. After inspection, good product is packaged and sent to finished product storage; defective product is stored separately until it can be reworked.

On March 8, Vivian Espania, Mexicana's general manager, stopped by Garcia's office and asked him to attend a staff meeting at 1:00 P.M.

"Let's get started with the business at hand," Vivian said, opening the meeting. "You all have met Ron Garcia, our new management trainee. Ron studied operations management in his MBA program in southern California, so I think he is competent to help us with a problem we have been discussing for a long time without resolution. I'm sure that each of you on my staff will give Ron your full cooperation."

Vivian turned to José Arroyo, production manager. “José, why don’t you describe the problem we are facing?”

“Well,” José said, “business is very good right now. We are booking more orders than we can fill. We will have some new equipment on line within the next several months,which will take care of our capacity problems, but that won’t help us in April. I have located some retired employees who used to work in the drawing department, and I am planning to bring them in as temporary employees in April to increase capacity there.

Because we are planning to refinance some of our long-term debt, Vivian wants our profits to look as good as possible in April. I’m having a hard time figuring out which orders to run and which to backorder so that I can make the bottom line look as good as possible. Can you help me with this?”

Garcia was surprised and apprehensive to receive such an important, high-profile assignment so early in his career. Recovering quickly, he said, “Give me your data and let me work with it for a day or two.”

What recommendations should Ron Garcia make, with
what justification? Provide a detailed analysis with charts, and
graphs.

April Orders
Selected Operating Data
Average output per month = 2,400 units
Average machine utilization = 63%
Product W0075C
1,400 units
Product W0033C
250 units
Average percentage of production sent to rework
department = 5% (mostly from winding department)
Product W0005X
1,510 units
Product W0007X
1,116 units
Average no. of rejected units awaiting rework = 850 (mostly
from winding department)
Note: Vivian Espania has given her word to a key customer that
we will manufacture 600 units of product W0007X and 150
units of product W0075C for him during April.
Plant Capacity (Hours)
Standard Cost
DRAWING
EXTRUSION
WINDING
PACKAGING
SELLING
4,000
4,200
2,000
2,300
PRODUCT MATERIAL LABOR OVERHEAD
PRICE
Note: Inspection capacity is not a problem; we can work overtime,
as necessary, to accommodate any schedule.
WO075C
$33.00
$ 9.90
$23.10
$100.00
WO033C
25.00
7.50
17.50
80.00
WO005X
35.00
10.50
24.50
130.00
Bill of Labor (Hours/Unit)
WO007X
75.00
11.25
63.75
175.00
PRODUCT
DRAWING EXTRUSION WINDING PACKAGING
WO0075C
1.0
1.0
1.0
1.0
W0033C
2.0
1.0
3.0
0.0
WO005X
0.0
4.0
0.0
3.0
WO007X
1.0
1.0
0.0
2.0
Transcribed Image Text:April Orders Selected Operating Data Average output per month = 2,400 units Average machine utilization = 63% Product W0075C 1,400 units Product W0033C 250 units Average percentage of production sent to rework department = 5% (mostly from winding department) Product W0005X 1,510 units Product W0007X 1,116 units Average no. of rejected units awaiting rework = 850 (mostly from winding department) Note: Vivian Espania has given her word to a key customer that we will manufacture 600 units of product W0007X and 150 units of product W0075C for him during April. Plant Capacity (Hours) Standard Cost DRAWING EXTRUSION WINDING PACKAGING SELLING 4,000 4,200 2,000 2,300 PRODUCT MATERIAL LABOR OVERHEAD PRICE Note: Inspection capacity is not a problem; we can work overtime, as necessary, to accommodate any schedule. WO075C $33.00 $ 9.90 $23.10 $100.00 WO033C 25.00 7.50 17.50 80.00 WO005X 35.00 10.50 24.50 130.00 Bill of Labor (Hours/Unit) WO007X 75.00 11.25 63.75 175.00 PRODUCT DRAWING EXTRUSION WINDING PACKAGING WO0075C 1.0 1.0 1.0 1.0 W0033C 2.0 1.0 3.0 0.0 WO005X 0.0 4.0 0.0 3.0 WO007X 1.0 1.0 0.0 2.0
Finished
Office
Wire Drawing
Product
Storage
Rework
Packaging
Department
Winding
Receiving and
Raw Material Storage
Extrusion
Rejected
Product
Storage
Inspection
Transcribed Image Text:Finished Office Wire Drawing Product Storage Rework Packaging Department Winding Receiving and Raw Material Storage Extrusion Rejected Product Storage Inspection
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.