Please answer question 1-25 using cell referencing and explanation
A B C D E F G H K 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 various aspects of SBM's Master Budget for 2020 5 PART 1 DATA 2020 projected sales: LD Product Sales Price 10 P1 47,000 $65.00 11 P2 87,000 $70.00 12 13 2020 projected Finished Goods inventory balances (units) 14 Product 1/1/2020 12/31/2020 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 20 Calculate the following forecasts based upon the given data. 21 Put additional calculations here 22 Forecast Revenues from Product 1 (P1) Q1 23 24 Forecast Revenues from Product 2 (P2) Q2 25 26 Forecast Total Revenues for 2020. Q3 27 28 How many units of P1 should SBM manufacture in 2020? Q4 29 30 How many units of P2 should SBM manufacture in 2020? Q5 3132 PART 2 35 34 DATA Raw Materials 35 2020 Projected Production standards: Beginning Ending 36 Units per P1 Units per P2 Unit cost of inpull Balance balance 37 Direct labor his 17 0.2 $42.00 38 Direct labor hrs T2 0.3 $35.00 39 Machine his 1.25 0.2 40 Lbs of 21 $1.50 45,000 50.000 41 Units of ZZ 3 $2.50 65,000 60,000 42 Feet of 23 $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: 21. 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 Q6 52 53 The total number of T2 labor hours required 07 54 55 The total number of machine hours required QB 56 57 The total number of lbs. of input 21required Q9 58 59 The total number of units of input 22 required Q10 60 61 The total number of feet of input 23 required @11 62 63 What is the budget for T1 direct labor (dollars)? 012 64 65 What is the budget for T2 direct labor (dollars)? 013 66 What is the total labor budget (dollars)? 014 68 69 What is the purchases budget for 21 (dollars)? 015 70 71 What is the purchases budget for Z2 (dollars)? 016 12 73 What is the purchases budget for 23 (dollars)? 017 14 75 Variable Mig. OH rate per direct labor hour 15.00 Fixed Mig. OH for 2020 is estimated to be: $ 3,250,000 77 liked overhead is allocated on the basis of machine hours 78 9 What is the budgeted variable OH for P1 (dollars)? Q18 80 1 What is the budgeted fixed OH for P1 (dollars)? Q13 82 83 What is the budgeted variable OH for P2 (dollars)? Q20 84 85 What is the budgeted fixed OH for P2 (dollars)? 021 86 87 What is the budgeted cost of goods manufactured for P1 (total dollars)? 022 88 89 What is the budgeted cost of goods manufactured for P2 (total dollars)? 023 1 What is the budgeted cost per unit of P1 manufactured in 2020? 024 92 93 What is the budgeted cost per unit of P2 manufactured in 2020? 025 94
