please answer all the questions.
AutoSave OFF suu: Insert Draw Page Layout Formulas Lab 6 - Chapter 19 - ACC 214 Home Data View Review = 2 X Arial A lo General 12 A Paste & BI U www ava- v8x v fx Conditional Formatting Format as Table Cell Styles D $ % 898 1 ACC 214 Lab #6: Chapter 19 Name: Information for the Lotus Computer Company for 2019: Expected sales of computer workstation furniture: 300 units @ $ 3.200 per unit 7 Expected manufacturing costs include the following: Direct Materials $ 800 per unit Direct Labor 400 per unit Variable Overhead 100 per unit -1 Fixed Overhead $ 24,000 per year 13 Expected selling expenses include the following: 4 Variable Selling Expenses $ 50 per unit S Fixed Selling Expenses 4,000 per year 7 Lotus' management is considering how many workstations to produce in 2019. The management team is confident that all workstations remaining in the 2019 ending inventory will be sold in 2020. However, the management team does not want to overproduce as the company does not have sufficient storage space for many more workstations. Requirement: Requirements Parts 1 & 2: Assume 300 workstations are sold. Part 1: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income Statement assuming 300 workstations are produced A) Lotus Computer Company Income Statement (Absorption Costing) Forecasted for Year Ended 2019 Sheet1 + Lotus Computer Company Income Statement (Variable Costing) Forecasted for Year Ended 2019 Format Tools Data Window 4.68 GB Help Lab 6 - Chapter 19 - ACC 214 View Excel File Edit View Insert AutoSave OFF s u- Home Insert Draw Page Layout O Aria 12 BIU v8 x V fx Formulas Data Review AA == General Conditional Formatting 5. Format as Table Cell Styles $ % 9 F G H 21 Requirement: 23 Parts 1 & 2: Assume 300 workstations are sold. 25 Part 1: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income Statement assuming 300 workstations are produced 27 A) 28 Lotus Computer Company Income Statement (Absorption Costing) Forecasted for Year Ended 2019 Lotus Computer Company Income Statement (Variable Costing) Forecasted for Year Ended 2019 come Statement (Variable Net Income 45 Part 2: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income 320 workstations are produced Lotus Computer Company Income Statement (Absorption Costing) Esta vastaan Sheet + Lotus Computer Company Income Statement (Variable Costing) Dra. Av Paste & BI U v8 x fx E F G H 21 Requirement: 23 Parts 1 & 2: Assume 300 workstations are sold. 25 Part 1: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income S Lotus Computer Company Income Statement (Absorption Costing) Forecasted for Year Ended 2019 Net Income 45 Part 2: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income: 47 A) Lotus Computer Company Income Statement (Absorption Costing) Enrennetad for Van Ended 2010 Sheet1 + REVIEW view = = = General Conditional Formatting 2 Format as Table Cell Styles Insert 3X Delete 1 Form $ % -28 F G H I J K L M N B) Variable Costing Income Statement assuming 300 workstations are produced. Lotus Computer Company Income Statement (Variable Costing) Forecasted for Year Ended 2019 Net Income 3) Variable Costing Income Statement assuming 320 workstations are produced. Lotus Computer Company Income Statement (Variable Costing) Carannend for Vaar Ended 2010 Format Tools Data Window 4.68 GB 8 Excel File Edit AutoSave Home Insert Draw View Insert @ S U Page Layout Help Lab 6 - Chapter 19 - ACC 214 Data Review View 12 ' Formulas A A A v Paste |v8x General Arial BLUE v fx Conditional Formatting Format as Table Cell Styles P $ % 9 + Form M N O P 45 Part 2: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income Statement assuming 320 workstations are produced 47 A) Lotus Computer Company Income Statement (Absorption Costing) Forecasted for Year Ended 2019 Lotus Computer Company Income Statement (Variable Costing) Forecasted for Year Ended 2019 Net Income Part 3: Comment on which costing method, absorption or variable, yields the highest net income when 320 workstations are produced and 300 are sold. Sheet1 Autosave Home Insert Draw Page Layout View Formulas Data Review AA === 12 Gener Arial B IU 1 Paste A $ V8 fx x B A C D E F G H I 45 Part 2: Create an A) Absorption Costing Income Statement and a B) Variable Costing Income State 47 A) Lotus Computer Company Income Statement (Absorption Costing) Forecasted for Year Ended 2019 Net Income 65 Part 3: Comment on which costing method, absorption or variable, yields the highest net income w Sheet1 + Review View = = 2 General CE 0 $ % Conditional Formatting Format as Table Cell Styles 4 Insert 9X Delete ! Format 82 N O P Q ariable Costing Income Statement assuming 320 workstations are produced. Lotus Computer Company Income Statement (Variable Costing) Forecasted for Year Ended 2019 Net Income ds the highest net income when 320 workstations are produced and 300 are sold.. Tools View Insert s u Format = Excel File Edit .. AutoSave OFF Home Insert Draw hy Arial Data Page Layout Formulas 12 AA Data Window Help 4.70 GB 8 Lab 6 - Chapter 19 - ACC 214 Review View Conditional Formatting General 28 Formatas Table 2 pa $ % 9 8 + Cell Styles E Paste Inse Dele Forn V8 x fx M N O Net Income Net Income 6 Part 3: Comment on which costing method, absorption or variable, yields the highest net income when 320 workstations are produced and 300 are sold. 5 3 Part 4: Comment on potential ethical issues faced by management when inventory is overproduced relative to expected sales Sheet
