Please I need help

The work is to be done within the excel document.

Needs to be more geared like a real company.

So, write a mission statement that is geared toward a cellphone company.

You should do a little research on corporate mission statements for similar companies and work from that angle.

Financial statement: Use your own knowledge or Do a little research on what each of the categories are on the financial statement. Using your prompt, you can determine gross sales in a given month.

You will use dollar amounts for cost of sales. You will do a lot of estimating and thinking of what you imagine the other categories costing the company.

All figures are dollar amounts. fill them out as if you worked for or owned the company within the prompt.

Sheet Goals Objectives: Use your own knowledge or Research various company mission statements. Using these as guidelines along with the prompt, start writing and developing your own corporate goals and objectives for your cellphone manufacturing company. Fill in the boxes within the Sheet 2: Goals Objectives and relate corporate goals/objectives those to specific manufacturing goals and objectives.

Sheet Income Statement: Use your knowledge or research the associated reference materials for Income Statements. Begin to develop an income statement based on what you know thus far. You may alter the income statement layout in this sheet to meet your need.

You will return to this sheet over the course of the 8-weeks to refine your financial projections on each assignment. Much of this information must be estimated at first. As you gather more information in the design and layout of your facilities, you will begin to better understand your financial analysis.

Sheet Aggregate Plan: Use your knowledge or research any other sources to understand the significance of the Aggregate plan. Study the spreadsheet to understand the various costs associated in the Aggregate plan: Hire cost, Fire cost, holding cost, Backorder cost and how a given aggregate planning strategy will affect these costs. As such, the main idea is for you to utilize your spreadsheet optimization techniques to find the right amount to produce each month such that demand is satisfied, and profitability for those five months is maximized. You're on you own to discover how to optimize this spreadsheet for these five months.

Facilities Design: Goals, Strategies, and Planning Assignment

a. Use the appropriate MS Excel Sheets Associated to the Project:

i. Sheet: Mission statement Needs to be more geared like a real company. So Write a mission statement that is geared toward a cellphone company.

ii. Sheet : Income Statement Do a little research on what each of the categories are on the financial statement. Using your prompt, you can determine gross sales in a given month.

iii. 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

Deliverables

(1) Sheet: Goals Objectives: Completed corporate Mission Statement,

(2) Sheet: Income Statement: Fill in as much as you can estimate - very much a Draft at this point

(3) Sheet: Aggregate Plan: Using the excel spreadsheet optimization function try to optimize the number of products that you produce for the first five months. The objective here is to optimize profitability

Acme Phone Co. Raseer Scheduleing ixey informations Assume all production starts on Monday and ends at the acek's end. (1) Forecasts based en Ameregate Pan (2) Two main types of phones, A and B (SOW type A, SCS type B) (3) Assume each month has 4 weeks (4) Assume Type A model requires 3min of assy time and 10min of setup timefoatch and cests \$2,000 per set-up (5) Assume Type 8 modet requires 3.7 min of assy time and 3 min of setup timefbatch and costs 51.700 per set-up (6) Assume 120 hours (7200 min) of assy and setup time are aralable each week (7) Assume the holding costs are now estimated to be $10.00 yunititime period. 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. Inrome Statement Acme Phone Co. Raseer Scheduleing ixey informations Assume all production starts on Monday and ends at the acek's end. (1) Forecasts based en Ameregate Pan (2) Two main types of phones, A and B (SOW type A, SCS type B) (3) Assume each month has 4 weeks (4) Assume Type A model requires 3min of assy time and 10min of setup timefoatch and cests \$2,000 per set-up (5) Assume Type 8 modet requires 3.7 min of assy time and 3 min of setup timefbatch and costs 51.700 per set-up (6) Assume 120 hours (7200 min) of assy and setup time are aralable each week (7) Assume the holding costs are now estimated to be $10.00 yunititime period. 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. Inrome Statement