• Title/Summary/Keyword: MS Excel Program

Search Result 32, Processing Time 0.024 seconds

Menu Analysis Using Menu Engineering and Cost/Margin Analysis - French Restaurant of the Tourism Hotel in Seoul - (메뉴엔지니어링기법과 CMA 기법을 이용한 메뉴 분석에 관한 연구 - 서울지역 특1급 호텔의 프렌치레스토랑을 중심으로 -)

  • Lee, Eun-Jung;Lee, Young-Sook
    • Journal of the Korean Society of Food Culture
    • /
    • v.21 no.3
    • /
    • pp.270-279
    • /
    • 2006
  • This study was designed to : (a) analyze the menus of the French restaurant in tourism hotel using the menu analysis techniques of Kasavana & Smith and Pavesic, (b) compare the characteristics of the two analysis techniques. The calculations for the menu analysis were done using the MS 2000 Excel spreadsheet program. The menu mix % and unit contribution margin were used as variables by Kasavana & Smith and weighted contribution margins (WCM) and potential food cost % (PFC%) by Pavesic. In two cases, a four-cell matrix was created and menu items were located in each according they achieved high or low scores with respect to two variables. The items that scored favorably on both variables were rated in the top category (e.g., star, prime) and those that scored below average on both were rated in the lowest category (e.g., dog, problem). While Kasavana & Smith's method focused on customer's viewpoints, Pavesic's method considered the manager's viewpoints. Therefore, it is more likely to be desirable for decision-making on menus if the menu analysis techniques chosen is suited to its purpose.

A Development of Detail Design Software for Conventional Catenary System (기존선 전차선로 상세설계 소프트웨어 개발)

  • Lee, Ki-Won;Kwon, Sam-Young;Cho, YongHyeon;Lee, Tae-Kwon;Lee, Kyung-Hoon
    • Proceedings of the KSR Conference
    • /
    • 2008.06a
    • /
    • pp.481-488
    • /
    • 2008
  • A detail design of overhead catenary system can be divided into a pegging plan and a design of MD(mounting diagram). In the pegging plan, the mast location, staggering and tension length are determined in the longitudinal point of view according to track condition, location of substation and etc. In the MD, a transversal diagram including masts, all of wires, cantilever, foundation and etc. and materials used are shown. This study presents a development of a software to design the MD for a conventional catenary system automatically. In the program, thin walled steel pole, foundation, cantilever, all of wires and etc. are automatically drawn according to the input and catenary conditions. And materials used in the MD and the section can be also managed respectively in the program. This application of the program is developed using C# for input/calculating and using C++(ObjectARX) for drafting the MD, respectively.

  • PDF

ANALYSIS OF THE TRANSPORTATION LOGISTICS FOR SPENT NUCLEAR FUEL IN KOREA

  • Lee, Hyo-Jik;Ko, Won-Il;Seo, Ki-Seok
    • Nuclear Engineering and Technology
    • /
    • v.42 no.5
    • /
    • pp.582-589
    • /
    • 2010
  • As a part of the back-end fuel cycle, transportation of spent nuclear fuel (SNF) from nuclear power plants (NPPs) to a fuel storage facility is very important in establishing a nuclear fuel cycle. In Korea, the accumulated amount of SNF in the NPP pools is troublesome since the temporary storage facilities at these NPP pools are expected to be full of SNF within ten years. Therefore, Korea cannot help but plan for the construction of an interim storage facility to solve this problem in the near future. Especially, a decision on several factors, such as where the interim storage facility should be located, how many casks a transport ship can carry at a time and how many casks are initially required, affect the configuration of the transportation system. In order to analyze the various possible candidate scenarios, we assumed four cases for the interim storage facility location, three cases for the load capacity that a transport ship can carry and two cases for the total amount of casks used for transportation. First, this study considered the currently accumulated amount of SNF in Korea, and the amount of SNF generated from NPPs until all NPPs are shut down. Then, how much SNF per year must be transported from the NPPs to an interim storage facility was calculated during an assumed transportation period. Second, 24 candidate transportation scenarios were constructed by a combination of the decision factors. To construct viable yearly transportation schedules for the selected 24 scenarios, we created a spreadsheet program named TranScenario, which was developed by using MS EXCEL. TranScenario can help schedulers input shipping routes and allocate transportation casks. Also, TranScenario provides information on the cask distribution in the NPPs and in the interim storage facility automatically, by displaying it in real time according to the shipping routes, cask types and cask numbers that the user generates. Once a yearly transportation schedule is established, TranScenario provides some statistical information, such as the voyage time, the availability of the interim storage facility, the number of transported casks sent from the NPPs, and the number of transported casks received at the interim storage facility. By using this information, users can verify and validate a yearly transportation schedule. In this way, the 24 candidate scenarios could be constructed easily. Finally, these 24 scenarios were compared in terms of their operation cost.

A Planning Study on the Improvement of Public Hospital Patient Room based on the Understanding of User - Focused on the Case Study of District-Based Public Hospital in Korea (사용자 이해에 기반한 공공병원 병실환경 개선에 관한 계획적 연구 - 지역 거점 공공병원의 사례연구를 중심으로)

  • Oh, Kyoung Mi;Park, Jae Seung
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.20 no.4
    • /
    • pp.49-56
    • /
    • 2014
  • Purpose : This purpose of this study is to make a better public hospital patient room to reflect the views of the patient. Methods: Survey to examine patient experience on healing environment in public hospital have been conducted for the data collection. 229 open-ended answers have been analysed statistically by MS Excel program. Results : 1) If there is no toilet space in the six-patient room, installation of toilet in the patient room is necessary. 2) The most Frequently used patient furnitures are necessary to accomodate the patients needs. Depending on the patient condition, installation of a portable or fixed the room furniture for the convenience to the using furniture. 3) According to the flow of modern times, wireless internet access is required to install of expand the space. Also be used to establish a regulations of internet space. 4) To create healing environment infection free environment should be provided. 5) Need for improvements of patient room for relatives of patient. It is necessary to secure a comfortable space to stay. 6) Separation is needed among the patients through therapeutic classification. Implication : In order to provide a better patient room environment, it is necessary to reflect the patient's opinion.

A Study on the Use of General Social Welfare Facilities for the Planning of Integrated Care Center - Focused on four social welfare facilities in Southern Gyeonggi-do (통합돌봄센터 계획을 위한 고령인구의 종합사회복지관 이용실태 연구 - 경기도 남부 4개 사회복지관을 대상으로)

  • Han, Eunbee;Zhang, Jinxiang;Kwon, Soonjung
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.26 no.2
    • /
    • pp.71-79
    • /
    • 2020
  • Purpose: The purpose of this study is to derive basic data for desirable location and functions of the integrated care center. Methods: Survey, Questionaire and statistical analysis are the main research method of this study. In order to collect data related to utilization pattern and favorite functions of the senior people, researchers have visited 4 social welfare facilities located in Southern Gyeonggi Province. 403 questionaires have been gathered from 4 facilities and they have been analyzed by using Excel Program of MS. Results: First, compared to other services, healthcare services have been preferred by many older people in Social welfare Facilities. This means that integrated care centers providing healthcare services for older people rather than services for children or disabilities is desirable. Second, Integrated Care Centers had better be established within the walk distance of elderly people. If it is not easy, the introduction of shuttle bus for older people is desirable. Especially, in case of large Care Center. Implications: This study shows that small facility with community care rather than big facility is desirable for small community in the point of friendliness, convenience, economy, etc.. However it is necessary to combine welfare service and healthcare service even in small centers.

A Study on the Sleep pattern of normal neonates in Seoul and Kyungki area (서울.경기지역 신샌아의 수면/활동 양상에 관한 연구)

  • Kim, Il-Ok;Yang, Eun-Young;Lee, Ja-Hyung
    • Korean Parent-Child Health Journal
    • /
    • v.3 no.2
    • /
    • pp.41-48
    • /
    • 2000
  • The sleep is the most important problem for new parents. However, there were very rare the study about sleep of normal neonates and early infants in Korea. So we attempted pilot survey study of neonates' sleep pattern. The purpose of this study was to investigate the sleep pattern of normal neonates in Seoul and Kyungki area and to provide for basis for nursing intervention for parents of them. The subjects of this study were 37 normal full-term neonates of 2~3weeks of age who were visited by researcher or assistant at postpartum care unit, health care clinic, outpatient clinic located in Seoul and Kyungki area from April 20, 1999 to March 15, 2000. This study was descriptive survey study under the convenient sampling method. The instrument of this study was the NCASA translated by Korean Parent Child Health Academic Association. The collected data were coded as 1/4hour unit, and analyzed by MS Office Excel program. The result of this study were as followed: 1. The mean amount of total sleep was 15.1hours. The mean amount of daytime sleep was 9.5hours. The mean amount of nighttime sleep was 5.7 hours. The mean amount of longest sleep was 2.9hours. The mean amount of shortest sleep was 0.6hour. 2. The mean amount of total activity was 8.9hours. The mean amount of daytime activity was 6.5 hours. The mean amount of nighttime activity was 2.3hours. The frequency of feeding was 10.4 times a day. The frequency of daytime feeding was 7.3 times. The frequency of nighttime feeding was 3.1 times. It is suggested that various subjects and more data according to age, and comparative study among different cultures are needed for further study in the future.

  • PDF

A Study on the Facility and Equipment of Laboratory Medicine in General Hospital - Focused on more than 550 bed sized hospitals (종합병원 진단검사의학과 검사실의 시설 설비 현황 조사 - 550 병상 이상 종합병원을 중심으로)

  • Kim, Youngaee;Song, Sanghoon
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.26 no.1
    • /
    • pp.73-84
    • /
    • 2020
  • Purpose: Though Korean healthcare services have been upgraded, infection and fire had been broken out in general hospitals. And higher concerns about quality assessment made it to clinical laboratory design guideline studies. So, this study investigates the facilities, equipment and personnel of laboratory medicine focusing on more than five hundred fifty bed hospital, and contributes to make guidelines for safety and efficiency in lab. Methods: Questionnaires to supervisor technologist and field surveys to medical laboratories in korean hospitals have been conducted for the data collection. 16 answers have been analysed statistically by MS Excel program. Results: Most of the sample tests such as hematology, clinical chemistry, immunology, transfusion, urinalysis, microbiology and molecular diagnosis are performed by more than 80% in large sized general hospital laboratory. In the test methods, automatic analyzers are used up to 80%, total laboratory automation up to 43% in clinical chemistry and immunology, and manual tests in all sorts of the test. There are placed in single lab or two and three labs above the ground, which are all in semi-open lab. There is some correlation with the number of specimens and the number of lab people depending on the number of hospital beds. Laboratory environment shows that work distance is good, but evacuation path width, visibility, separation of staff area from automatic analyzer, and equipment installations are needed to have more spaces and gears. Most of the infection controls are equipped with mechanical ventilation, air-conditioning, washbasin and wastewater separation, BSC installation and negative pressure lab room. Implications: Although the laboratory space area is calculated considering the number of hospital beds, type of tests and number of staff, hospital's expertise and the samples numbers per year should be taken into account in the planning of the hospital.

Development and Application of Menu Engineering Technique for University Residence Hall Foodservice (대학 기숙사 급식의 메뉴 운영 특성을 고려한 Menu Engineering기법 개발 및 적용)

  • 양일선;이해영;신서영;도현욱
    • Korean Journal of Community Nutrition
    • /
    • v.8 no.1
    • /
    • pp.62-70
    • /
    • 2003
  • This article aims to summarize the development and application of menu engineering technique, 'Menu Engineering Modified by Preference (MEMP)'. The site selected for this project was a foodservice operation in Yonsei University residence hall. Sales and food costs data were collected from the daily sales reports for 1 month, and the survey of food preference was conducted during May, 1999. Statistical data analysis was completed using the SAS/Win 6.12 for descriptive analysis. The calculation for menu analysis were carried out with MS 2000 Excel spreadsheet program. This MEMP technique developed had 6 category criteria and 2 dimensions of the contribution margin (CM) and the menu mix modified% (MMM%) . The MMM% was calculated by the sales volumes and also weighted by food preference. The CM and MMM% for each item were compared with a mean menu CM as well as a 70% rule. Four possible classifications by MEMP were fumed out as 'STAR', 'PLOWHORSE', 'PUZZLE', 'DOG'. 'STAR' items were the most popular and profitable items and required to maintain rigid specifications for quality. The decision actions for 'PLOWHORSE' menu items which were relatively popular, but yield a low menu average CM included combining a plowhorse item with lower cost products and reducing the frequency of serving or serving size. There was a need for 'PUZZLE' items to be changed in the menu combination, improve recipe, and promote menu. The last DOG' items were desired to be deleted. This study demonstrates that menu information can be interpreted more easily with MEMP. The use of MEMP is therefore an effective way to improve management decisions about menu of university residence hall foodservice.

A Study on the Facility and Equipment of Laboratory Medicine in General Hospital - Focused on less than three hundred bed hospitals (종합병원 진단검사의학과 검사실의 시설 현황 조사 - 300 병상 미만 병원을 중심으로)

  • Kim, Youngaee
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.25 no.3
    • /
    • pp.15-23
    • /
    • 2019
  • Purpose: As the medical laboratories in general hospitals have made an efforts on quality management and employee health, they recognized the need of design guideline for clinical laboratory. As laboratories are prohibited to patients, their environments are becoming more congested and deteriorated as time goes by. So, this study investigates the current status of facility and equipment of laboratory medicine focusing on less than three hundred patient bed hospitals, and searches the improving matters. Methods: Questionnaires to technologist captains and field surveys to medical laboratories in korean hospitals have been conducted for the data collection. 18 answers have been analysed statistically by MS Excel program. Results: The result of this study can be summarized into followings. Clinical laboratory functions are all hematology, clinical chemistry, immunology, transfusion and urine microscopy, and except for three including microbiology for infection and bio safety level. Average man power of lab are 12.3 man including lab director and captain. Patient bed number, space area and total specimen numbers are not correlated with each other, but specimen numbers and employee number are correlated with. Work space distances are usually good, but exit distances are not adequate for escape owing to obstacles. Specimen delivery system by courier, test method by automatic analyzer, access floor for exposed plumbing and electricities are more practical. Open lab layed out in the center and lab support layed peripheral in space diagram. Lab space configuration by SD method showed that lab support area and employee support area are dissatisfied. Implications: Specialized hospital and yearly total specimen numbers are related to the space area and organization for laboratory planning and design.

A Study on the Establishment & Functional Characteristics of Health Facilities for the Aged in Japan

  • Kim, Tae Il;Yoshida, Tomo Hiko
    • Architectural research
    • /
    • v.8 no.1
    • /
    • pp.1-7
    • /
    • 2006
  • Various housing measures are needed for the rapidly aging society of Korea. In particular, the welfare policy for the elderly has changed towards the community care. Taking this fact into consideration, it is necessary to have the establishment of a system that offers the elderly appropriate welfare services at their appropriate residence (ageing in place) for the effectiveness of the community care. In this aspect, there are a number of implications to Korea to study merits and demerits of the Health Facilities for the Aged (HFA) in Japan. The society of Japan has been rapidly aging since 1970, and Korea is to face the same situation. As for the data of this study, a total of 2,393 facilities (as of November 1999) mentioned in the annual report of the Japanese Ministry of Health, Labor and Welfare were classified based on types of their establishment: (1) free-standing structures (603 facilities); (2) annexes to hospitals (981 facilities); (3) annexes to welfare facilities (511 facilities); and (4) annexes to clinics (298 facilities). Next, 239 facilities were selected through taking a sample of 10 percent from each type of the HFA mentioned above. This was done through the random sampling method with the computer program of MS EXCEL. The Implications of the results of analyses are as follows. First, most of the health facilities were planned with the scale that was larger than the scale of standard special nursing homes in terms of the total floor area. Precise equations that were to obtain precise results of the scale of the HFA and the appropriate number of residents were obtained through the method of the regression analysis. Korea and Japan have similarities in terms of culture, society and family relations; however, the two countries also have differences in terms of the application of laws on the establishment of houses, hospitals, and welfare facilities. As for planning the scale of the HFA, the realities of Korea should be considered. Second, as for the functional aspect of the HFA with a condition of returning home, the place before and after the HFA showed the pattern of 'from a residential place to a residential place' and 'from a hospital to a hospital.' This reveals a close correlation with the types of the HFAs and operational ways of the facilities. Its cause is considered to be the aspect of the operation and management of the HFA rather than the aspect of its function of providing services in association with medical and health facilities. Therefore, when intermediate welfare facilities are considered in Korea, it is strongly advised to consider the problem of annexes to other facilities and efficiency of sharing of the facilities in terms of its operation and management.