Please show with work!!!
Myer Wine Racking and Cellar Company is a small but growing carpentry job shop which specializes in natural finish redwood racking systems for storage and display of wine bottles. These racks and cabinets are created by processing redwood lumber through a series of work centers to reduce it to standard components, which are then assembled into seemingly customized goods in an assemble-toorder approach to production. Myer Wine Racking has been so successful in building wine cellars and displays for wine collectors and retail stores, it plans to move to a larger building it has just leased. Myer Wine Racking must organize a layout within the restrictions of that building, which has been divided into twelve equal-sized zones in the illustration below, to which Myer Wine Racking needs to assign twelve functional areas. GROUND PLAN OF NEW BUILDING FOR MYER WINE RACKING The owner of the building is willing to install interior walls according to Myer Wine Racking's specifications, with some limitations. First, the owner is not willing to change the locations of doors along the exterior of the building. This is important because, of the twelve functional areas within Myer's layout, only the Front Office or the Demo Cellar are appropriate locations for the front entrance, meaning that one of these two areas must be assigned to Zone \#4. Likewise, the Shipping Department and Lumber Storage must each be assigned an exterior loading bay door, confining their locations to Zones \#11 and #12. Second, the building owner wishes to minimize the expense of running water lines and sewer drains. Plumbing enters through the west wall of the building, so the owner is only willing to install rest rooms within the first four zones of the building. Because Myer will request rest rooms in both its Front Office and Production Office areas, these two areas must be located somewhere within Zones \#1 - \#4. To aid the layout design process further, Myer Wine Racking has determined a closeness rating for each possible pair of neighboring areas within its facility, as organized in this REL diagram. REL DIAGRAM OF CLOSENESS RATINGS BETWEEN FUNCTIONAL AREAS IN MYER WINE RACKING LAYOUT 1. Recommend a good layout for Myer Wine Racking by assigning each of the twelve functional areas to one of the twelve zones in the ground plan, working within the restrictions of the building's owner. 2. Calculate and report the score earned by your recommended layout, based on the following scale: Each pair of areas which share a straight border within the layout earn - 100 points if the pair's corresponding closeness rating is " A " - 50 points if the pair's corresponding closeness rating is " E " - 25 points if the pair's corresponding closeness rating is " I " - 5 points if the pair's corresponding closeness rating is " O " - 0 points if the pair's corresponding closeness rating is " U " - -100 points if the pair's corresponding closeness rating is " X " 3. Can you improve the recommended layout if the building's owner could be convinced to run additional water lines and drains, such that the restrooms could be located anywhere in the building? If so, by how much? Home Insert Draw Page Layout Formulas Data Review View Automate Tell me You can revise the scoring weights, too
