A B C D E All questions on this assignment pertain to SB Manufacturing (SBM). SBM is a manufacturing 2 company that makes two products, P1 and P2 The objective of this assignment is to work 3 through various component of SBM's Sales and Production budgets for 2023 4 5 PART 1 6 DATA 2023 projected sales: 8 Product Sales (units) Price (each) P1 51,000 $70.00 P2 86,000 $75.00 .1 2 2023 projected Finished Goods inventory balance (units) .3 Product 1/1/2023 12/31/2023 14 P1 10,000 12,000 15 P2 18,000 17,000 16 .7 Calculate the following forecasts based upon the above data 8 19 Q1 Forecast Revenues from Product 1 (P1) $3,570,000 Q2 Forecast Revenues from Product 2 (P2) $6,450,000 Q3 Forecast Total Revenues $10,020,000 14 25 Q4 How many units of P1 should SBM manufacture in 2023? 53,000 16 27 Q5 How many units of P2 should SBM manufacture in 2023? 85,000AutoSave . Off ) a311_A3_Emilia_Onrubia . Saved v Search (Alt+Q) Emilia Onrubia O X File Home Insert Page Layout Formulas Data Review View Help Comments Share Insert Palatino-Roman ~ 14 ~ A" A al Wrap Text General Ex AY O 2x Delete Paste Conditional Format as Cell Sort & Find & Analyze BI Uvv MVA v E Merge & Center $ ~ % 9 08 20 Formatting Table ~ Styles v Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A58 X v fx 2023 Budgeted Production Items A B D E F G H K L M N 28 29 PART 2 30 Assume all sales occur evenly during the year, i.e., each month represents 1/12th of 31 annual sales (as estimated for Q3). All sales are made on account and the following additional 32 information pertaining to Accounts Receivable is used for budgeting purposes: 33 34 Sales by month in 2022 35 November Sales 750,000 36 December Sales 700,000 37 Accounts Receivable Collection Schedule as % of Sales 39 In month of Sale 45% 40 In month following the Sale 30% 41 In the 2nd month following the Sale 20% 42 Expected Bad Debts 5% 43 44 Complete the following Cash Collections Schedule on Sales for Q1 2023 in order to answer 45 Questions 6, 7, and 8. 46 Accounts Amount Collected in 47 Month of Sale Receivable January February March 48 November 750,000 49 December 700,000 50 January $835,000 51 February $835,000 52 March $835,000 53 Total Cash Collected