Engineers design products or processes to meet desired needs. Usually those products and processes are technical in nature, for example designing an automobile (product) or distillation sequence (process) or an entire production facility to meet business requirements. The engineering design process herein is applied to solve manufacturing-systems related problems. Through this project, you will design a facility that will be able to manufacture a given forecasted number of parts (that marketing has pre-determined) over the course of two years. As such, you will be required to apply the business goals and forecasts to aggregate planning and production requirements. The major topic that you must become familiar with and synthesize into your facilities design are given in the table, Topics Covered in Project shown below.

for Financial Analysis of Manufacturing Facilities (income statement and balance sheet) use External References

1. Facilities Design: Goals, Strategies, and Planning Assignment a. Use the appropriate MS Excel Sheets Associated to the Project: i. Sheet : Income Statement ii. Sheet : Aggregate Planning

b. Goals and Objectives Sheets: Synthesize and decide on the appropriate corporate goals, objectives and competitive strategy for your company (list in sheet 1) c. Income Statement Sheet: Formulate an expected income statement for first month and first year of operations. d. Aggregate Planning Sheet: Formulate and optimize the aggregate forecast

The forccast is provided below. In additson, the con'rpany would like to casure that 600 units are in inventory at the end of May. Inrome Statement Excel Phone assembles cellular phones with integrated cameras for distribution to 20 days/month and 12 months/year. Verizon and US Cellular. In the past year, Excel Phone assembled 88,560 phones using 41 employees. For this problem, determine the workforce in terms of the number of workers Excel Phone has hired you as an external consultant for your expertise in aggregate (rather than the number of hours). planning. Your bonus at the end of the year is based on production costs savings you recommend. You have gathered extensive data from the company, which you summarize as follows: The forecast is provided below. In addition, the company would like to ensure that 600 units are in inventory at the end of May. The forccast is provided below. In additson, the con'rpany would like to casure that 600 units are in inventory at the end of May. Inrome Statement Excel Phone assembles cellular phones with integrated cameras for distribution to 20 days/month and 12 months/year. Verizon and US Cellular. In the past year, Excel Phone assembled 88,560 phones using 41 employees. For this problem, determine the workforce in terms of the number of workers Excel Phone has hired you as an external consultant for your expertise in aggregate (rather than the number of hours). planning. Your bonus at the end of the year is based on production costs savings you recommend. You have gathered extensive data from the company, which you summarize as follows: The forecast is provided below. In addition, the company would like to ensure that 600 units are in inventory at the end of May