Individual Project Apple Inc. is launching a new project called the Smartphone 12 The improved features include advance technology that integrates with other smart technology to set temperature controls, automatic startup systems for cars, and ordering groceries when inventory supplies become low 1. Create 4 jobs to collect costs for the new Smartphone using EXCEL 2. Prepare the cost volume profit analysis for the first quarter using output units prepared by the Marketing Department Sales are expected to range between 50,000 to 95,000 per quarter. 3. Historical budgets based on 26,000 units. Department 3 Department 4 Department Assembly Departmen Designing & Assembly Packaging testing software 200,000 420,000 860,000 (Panels) Material 150,000 Labor 250,000 Overhead 552,000 750,000 180,000 500,000 360,000 725,000 780,000 4. Determine target pricing to achieve a profit of S6,500,000 for the first quarter 5. Design a responsibility accounting system to make sure each manager mcets his/her target spending plan budgets (Discuss the type of budgetary system: cost center, revenue center, etc.) 6. Using Microsoft write a one-page (double-spaced) explanation based on your assumptions and your findings Individual Project Apple Inc. is launching a new project called the Smartphone 12 The improved features include advance technology that integrates with other smart technology to set temperature controls, automatic startup systems for cars, and ordering groceries when inventory supplies become low 1. Create 4 jobs to collect costs for the new Smartphone using EXCEL 2. Prepare the cost volume profit analysis for the first quarter using output units prepared by the Marketing Department Sales are expected to range between 50,000 to 95,000 per quarter. 3. Historical budgets based on 26,000 units. Department 3 Department 4 Department Assembly Departmen Designing & Assembly Packaging testing software 200,000 420,000 860,000 (Panels) Material 150,000 Labor 250,000 Overhead 552,000 750,000 180,000 500,000 360,000 725,000 780,000 4. Determine target pricing to achieve a profit of S6,500,000 for the first quarter 5. Design a responsibility accounting system to make sure each manager mcets his/her target spending plan budgets (Discuss the type of budgetary system: cost center, revenue center, etc.) 6. Using Microsoft write a one-page (double-spaced) explanation based on your assumptions and your findings