Exam 2.- online version (1) - Excel Home Insert Draw Page Layout Formulas Data Review View Tell me what you want to do Cut Calibri General Copy Format Panter Blu Paste . IEE . _ _ _Merge & Center . $ . % , Conditional Format as C Formatting Table Sty Clipboard Font Alignment Number Styles 119 2 Wong Inc, Budgeted Sales Revenue and Budgeted Production for 2019 are as following: 4 1) Budgeted sales revenue Q1 5 Budgeted units sales 6 Budgeted sales price 7 Budgeted sales revenue1 as Q4 Year 13,000 000 20000 24,000 72000 $125 $100 $100 $100 $100 1,625,000 1,500,000 2,000,000 2,400,000 7,200,000 9 2) Budgeted Production 10 Budgeted units sales 01 02 03 4 Year 13,00015,000 20,000 24,00072,000 Budgeted ending inventory (15% of budgeted units 11 sales) 1,950 2,250 3,000 3,600 3,600 Budgeted beginning 12 inventony 13 Budgeted Production12,95015,30020,750 24,600 73.60o 14 2,000 1,950 2,250 3,000 2,000 sUsing Budgeted Sales Revenue and Budgeted Production provided above to complete the Raw Material Budget of Wong Inc. for 2019.(35 Planned beginning raw material inventory for Q1 is 2500. 17 Instruction Q1 2 Q3 Q4 Ready