can someone please let me know what I'm doing wrong and how table is supposed to look like? this is using excel om. weighted average for layout 1 is supposed to be 600 with areas fixed, but I got 504 when I filled out table on my own as shown above. please show how table is supposed to look like and why/how you got that answer.

... 9.6 You have just been hired as the director of opera- tions for Reid Chocolates, a purveyor of exceptionally fine candies. Reid Chocolates has two kitchen layouts under consid- eration for its recipe making and testing department. The strat- egy is to provide the best kitchen layout possible so that food scientists can devote their time and energy to product improve- ment, not wasted effort in the kitchen. You have been asked to evaluate these two kitchen layouts and to prepare a recommen- dation for your boss, Mr. Reid, so that he can proceed to place the contract for building the kitchens. [See Figure 9.20(a), and Figure 9.20(b).] PX a E Number of trips between work centers: To: From: 1 23 314 2 A 5 Refrigerator Counter Sink Storage Stove o Refrig. 1 0 8 13 0 0 Counter 2 5 0 3 3 8 Sink 3 3 3 12 0 4 0 0 Storage 4 3 0 0 0 5 Stove 5 8 4 100 O 0 Figure 9.20(a). Layout Options Kitchen layout #1 Walking distance in feet Refrig. Counter Sink Storage Stove 1 2 2 3 3 4 5 5 4 4 4 4 4 Kitchen layout #2 Walking distance in feet Sink Storage 3 4. 8 12 6 9 6 15 7 7 7 Stove Refrig. 1 Counter 2 2 5 Figure 9.20(b). The computations are complete. ayout Min Load Distance Set D(j,i)=D(i,j) ata Assigned Flow/Load Room Table fridge counter sink storage stove Room 1 fridge 0 8 13 0 0 Room 3 counter 5 0 3 3 8 Room 2 sink 3 12 0 4 0 Room 5 storage 3 0 0 0 5 Room 4 stove 0 8 4 10 0 OTE: The distance from Room ) to Room I should not be a blank but should be the same as the distance from Room I to Room J. Assigned Distance/C Dept ost table Room 1 Room 2 Room 3 Room 4 Room 5 fridge Room 1 4 8 12 16 sink Room 2 4 4 8 12 counter Room 3 8 4 4 8 stove Room 4 12 8 4 4 storage Room 5 16 12 8 4 0 IN tal movement 504 Cost/Movem 1 Total cost 504 ovement computations Second Cost/Distan ce Product rst dept dge dge Second dept Load/Flow First room fridge 0 Room 1 counter 8 Room 1 room Room 1 Room 3 0 0 8 64