Suppose Leon takes an average of 20 min to finish Packaging.

1.      What is the fastest way to manufacture Old Oregon tables using the original crew? How many could be made per day?

2.      Would production rates and quantities change significantly if George would allow Randy to perform one of the four functions and make one of the original crew the backup person?

3.      What is the fastest time to manufacture a table with the original crew if Cathy is moved to either preparation or finishing?

Also solution should in excel file using solver should be include with answer.

Case Study Old Oregon Wood Store In 1992, George Brown started the Old Oregon Wood Store tomanufacture Old Oregon tables. Each table is carefully con—structed by hand using the highest-quality oak. Old Oregontables can support more than 500 pounds, and since the start ofthe Old Oregon Wood Store, not one table has been returnedbecause of faulty workmanship or structural problems. In addi-tion to being rugged, each table is beautifully finished using aurethane varnish that George developed over 20 years of work—ing with Wood-finishing materials. The manufacturing process consists of four steps: prepara-tion. assembly. finishing, and packaging. Each step is per-formed by one person. In addition to overseeing the entireoperation. George does all of the finishing. Tom Surowslo’ per-forms the preparation step, which involves cutting and formingthe basic components of the tables. Leon Davis is in charge ofthe assembly, and Cathy Stark performs the packaging. Although each person is responsible for only one step inthe manufacturing process, everyone can perform any one of thesteps. It is George’s policy that occasionally everyone shouldcomplete several tables on his or her own without any help orassistance. A small competition is used to see who can completean entire table in the least amount of time. George maintainsaverage total and intermediate completion times. The data areshown in Figure 9.5+ It takes Cathy longer than the other employees to constructan Old Oregon table. in addition to being slower than the otheremployees, Cathy is also unhappy about her current responsi-bility of packaging, which leaves her idle most of the day. Herfirst preference is finishing, and her second preference ispreparation. In addition to quality, George is concerned with costs andefficiency. When one of the employees misses a day, it causesmajor scheduling problems. In some cases, George assigns an-other employee overtime to complete the necessary work. Atother times, George simply waits until the employee returns towork to complete his or her step in the manufacturing process.Both solutions cause problems. Overtime is expensive, andwaiting causes delays and sometimes stops the entire manufac-turing prooess. To overcome some of these problems, Randy Lane washired. Randy’s major duties are to perform miscellaneous jobsand to help out if one of the employees is absent. George hasgiven Randy training in all phases of the manufacturing process,and he is pleased with the speed at which Randy has been ableto learn how to completely assemble Old Oregon tables. Totaland intermediate completion times are given in Figure 9.6. FIGURE 9.5Manufacturing Time 10° 190 250 275in Minutes I Preparation | assembly I finishing I Packaging I{Turn}so 150 220 canI Frailnitration I Asssnfly I Finishihg‘ I Packaging I(George)110 200 290| Preparatlon I Assenfly I Finishlng I Packaging |(Leon)120 ‘90 290 315Preparation Assorrmly finishing Packaging{CWJFIGURE 9.6Randy’s Completion 110 190 290 300Times in Minutes I Preparation I Amnbly I Finishing I Pma’gmg. |