Q6-Q17 please
Formulas Data Review Page Layout Draw Home Insert View Tell me Poste Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? E31 2 company that makes two products, Pi and P2. The objective of this assignment is to work through various aspects of SBM's Master Budget for 2020. S PART 1 7 DATA 8 2020 projected sales 9 Product Sales Price 10 PI 47,800 $65.00 11 12 87,800 $70.00 12 13 2020 projected Finished Goods inventory balances (uit) Product 1/1/20 12/31/20 15 PI 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 22 Forecast Revenues from Product 1 (P1) $3,107,000 23 24 Forecast Revenues from Product 2 (12) $6.146.000 25 25 Forecast Total Revenues for 2020. $9,253,000 27 Instructions Questions Q1 Q2 4: 17 esc 100W Relo AutoSave @E Page Layout 311 A3 Budgets Home Insert Draw Formulas Data Review View Tell me Pasto Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off E31 35 2020 Projected Production standards Beginning 36 Ending Units per PL Units per 12 Unit cost of input Balance 37 Direct laboens T1 Balance 0.2 0 $42.00 30 Direct Labor hrs 12 0.a $35.00 39 Machines 0.25 0.2 40 lbs of 21 3 6 $1.50 45,000 41 Units of 2 50,000 4 3 52.50 65,000 42 Retot 23 60,000 5 8 $0.75 85,000 60,000 43 44 The production of P1 and 12 requires direct labor (2 types), machine hours, and direct materials 45 3 types: 21,72 and 23). Input-output relations are giten 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 50 52 06 4 Based on your answers provided in Part 1 determine the following amounts need to satisfy 49 production goals for 2020, 51 The total number of Ti labor hours required 53 The total number of T2 labor hours required 54 SS The total number of machine hours required 59 The total number of lbs of input 21 required S8 59 The total number of units of input Z2 required 07 Q 56 09 Q10 Instructions Question os 0 $ % & Formid Excel File Edit View Insert AutoSave BE a311 A3 Budgets Data Formulas Review View Tell me Home Insert Draw Page Layout Merge Center Peste Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? E31 D F Q10 SIMINTAART Q11 Q12 013 Q14 015 B 59 The total number of units of input Z2 required GO 61 The total number of feet of input Z3 required 62 63 What is the budget for Tl direct labor (dollars)? 64 65 What is the budget for T2 direct labor (dollars)? 66 67 What is the total labor budget (dollars)? 68 What is the purchases budget for 21 (dollars)? 70 71 What is the purchases budget for 22 (dollars)? 72 73 What is the purchases budget for 23 (dollars)? 74 75 Variable Mig, OH rate per direct labor hour 76 Fixed Mig OH for 2020 is estimated to be 77 fixed overhead is allocated on the basis of machine hours 78 ? What is the budgeted variable Oh for 11 (dollars)? #1 What is the budgeted fixed oH for Pl (dollars)? Q16 Q17 $ 15.00 $3,250,000 Q18 019 What is the budgeted variable OH for 12 (dollars)? 020 Instructions Questions esc DOO FY FS
