File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Xat Copy Format Painter Clipboard Palatino-Roman 14 AA === 29 Wrap Text BTU A E Medewer General $ % 8-98 Conditional Formatas Cell Formatting Table Styles Styles Tont Algement Number G 29 A B c D 1 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 through 3 various aspects of SBM's Master Budget for 2020, 4 5 PART 1 6 7 DATA 8 2020 projected sales: 9 Product Sales Price 10 PI 54.500 $65.00 11 P2 94,500 $70.00 12 13 2020 projected Finished Goods inventory balances (units) 14 Product 01/01/20 12/31/20 15 P1 10.000 12.000 16 P2 24.000 20.000 17 18 You may assume there are no beginning or ending balances in Work in Process inventories. 19 Instructions Questions File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Palatino-Roman 14 " ' General X Cut In Coy * Format Painter Clipboard HIU BTU Wrap Text E Maiden Center A 5 % -18 Conditional Format Cell Formatting Table Styles In For 14 Nigert 15 Number E29 B E A D 18 You may assume there are no beginning or ending balances in Work in Process inventories. 19 20 Calculate the following forecasts based upon the given data. 21 22 Forecast Revenues from Product 1 (P1) $ 3,542,500 Q1 23 $6,615,000 Q2 24 Forecast Revenues from Product 2 (P2) 25 26 Forecast Total Revenues for 2020 27 28 How many units of P1 should SBM manufacture in 2020? $ 10,157,500 Q3 56,500 Q4 29 90,500 Q5 30 How many units of P2 should SBM manufacture in 2020? 31 32 PART 2 33 34 DATA 35 2020 Projected Production standards: 36 Units per P1 - Direct lahar hre T4 Instructions Questions Raw Materials Beginning Ending Balance Balance Units per P2 Unit cost of input Con Home Insert Draw Page Layout Formulas Data Review View Help Acrobat General X Cut Is copy Format Painter Clipboard Palatino Roman 14 BIU AYA 2 Wrap Text A EEEEH $ % 988 Conditional format as Cell Formatting Table Styles sert De Tent 15 Alignment Number 5 E29 G B D 36 E F 34 DATA Raw Materials 35 2020 Projected Production standards: Beginning Ending Units per P1 Units per P2 Unit cost of input Balance Balance 37 Direct labor hrs T1 0.2 0 $42.00 38 Direct labor hrs T2 0 0.3 $35.00 39 Machine hrs 0.25 0.2 40 Lbs of Z1 3 6 $1.50 45,000 50,000 41 Units of Z2 4 3 $2.50 65,000 60,000 42 Feet of Z3 5 8 $0.75 85,000 60,000 43 44 The production of P1 and P2 requires direct labor (2 types), machine hours, and direct materials 45 (3 types. Z1, Z2, and Z3) Input-output relations are given in the table above per unit of output 46 Input prices are per unit of input such as a pound, hour, foot or unit 47 48 Based on your answers provided in Part 1 determine the following amounts need to satisfy 49 production goals for 2020. 50 51 The total number of T1 labor hours required 11,300 52 Q6 371 en The total number of Talahar bare mind Instructions Questions AutoSave Data Review View Acrobat Help Formulas Insert Draw Page Layout File Home General Xcut Palatino-Roman 14 - AA 2 Wrap Text BTUA E E Merve Ex Center $ % -% Conditional Format Formatting Table s copy Format Painter Number Styles Font 19 Aligament Clipboard 29 D E B C A 27,150 32,225 52 53 The total number of T2 labor hours required 54 55 The total number of machine hours required 56 57 The total number of lbs. of input Z1 required 58 59 The total number of units of input Z2 required 712,500 497,500 60 1,006,500 61 The total number of feet of input Z3 required 62 $474,600 63 What is the budget for T1 direct labor (dollars)? 64 $950,250 65 What is the budget for T2 direct labor (dollars)? 66 67 What is the total labor budget (dollars)? 68 69 What is the purchases budget for Z1 (dollars)? $1,424,850 70 What in the hannhunden for 70 dollarni Instructions Questions File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat In A copy Palatino-Roman 14 AA == 2 Wrap Text BIU A ES Erge General $ % 38% Format Pointer In Conditional Format a Cell Formatting Table Styles Styrs Clpboard rt Alignment Number 529 A B D E F Q15 Q16 Q17 69 What is the purchases budget for Z1 (dollars)? 70 71 What is the purchases budget for Z2 (dollars)? 72 73 What is the purchases budget for Z3 (dollars)? 74 75 Variable Mfg. OH rate per direct labor hour 76 Fixed Mfg. OH for 2020 is estimated to be. 77 fixed overhead is allocated on the basis of machine hours 78 79 What is the budgeted variable OH for P1 (dollars)? 80 81 What is the budgeted fixed OH for P1 (dollars)? 82 83 What is the budgeted variable OH for P2 (dollars)? 15.00 $ 3,250,000 Q18 Q19 Q20 84 85 What is the budgeted fixed oH for P2 (dollars)? 86 Q21 87 What is the budgeted cost of goods manufactured for P1 (total dollars)? Q22 RA Instructions Questions
