General AES 3 5 Clipboard E78 Merge & Center - $ Font % 8-98 Conditional Format as Cell Formatting Table Styles Insert Delete Format Alignment x Number Styles Cells 8 DATA 9 2020 projected sales: Product 11 P1 12 P2 Sales 47,800 87,800 Price $65.00 $70.00 14 2020 projected Finished Goods inventory balance (units) Product 1/1/2020 12/31/2020 16 P1 10,000 12,000 17 P2 24,000 20,000 19 Calculate the following forecasts based upon the 20 above data Q1 $3,107,000 22 Forecast Revenues from Product 1 (P1) 23 an instructions Questions DO Type here to search HD-1080 8 Search Home Insert Draw Page Layout Formulas Data Review View Add-ins Help Mohamm = Palatino-Roman BIU-B = = P este este -14 A AA A 2 33 Wrap Text Merge & Center - AutoSum Clipboard General $ % Number & Conditionat Font Formatting Table So Alignment Styles Clear 78 Styles Cells Editing 39 Beginning Balance Ending Balance 0.3 36 37 DATA 38 2020 Projected Production standards: Units per P1 Units per P2 Unit cost of input 40 Direct labor hrs T1 0.2 $40.00 41 Direct labor hrs T2 $36.00 42 Machine hrs 0.01 0.025 43 Lbs of Z1 $1.50 44 Units of Z2 $2.50 45 Feet of Z3 $0.75 46 47 The production of P1 and P2 requires direct labor (2 types), machine hours, 48 and direct materials (3 types: Z1, Z2, and Z3). Input-output relations 49 are given in the table above per unit of output. Input prices are per unit 50 of input such as a pound, hour, foot, or unit. 51 52 Based on your answers provided in Part 1 determine the following amounts Instructions Questions - ---- - oo wo 42,000 60,000 85,000 42,000 70,000 60,000 Type here to search Fb - 1080 - JU ) .00 - Alignment X V Alignment Conditional Format as Cell Formatting Table Styles Insert Delete Format Number Styles Cells B. What is the purchases budget for Z3 (dollars)? Q17 $689,550 Variable manufacturing overhead is budgeted at $15 per direct labor hour. While fixed factory overhead is estimated to be $2.5 million. It is allocated based on machine hours What is the budgeted variable OH for P1 (dollars)? Q18 What is the budgeted fixed OH for P1 (dollars)? Q19 What is the budgeted cost of goods manufactured for P1 (dollars)? Q20 2 Instructions Questions Type here to search B.1080 u Draw Page Layout Search Formulas Data Review View Add-ins Help Palatino-Roman 14 AA SE= BIU - OAE Wrap Text Merge & Center - Currency Clipboard Font $ % 8-9 EH Conditional Format as Cell Formatting Table Styles E87 Alignment Insert Delete Format - fx Number Clear Styles Cells B 20 above data 21 Q1 $3,107,000 Q2 $6,146,000 $9,253,000 22 Forecast Revenues from Product 1 (P1) 23 24 Forecast Revenues from Product 2 (P2) 25 26 Forecast Total Revenues 27 28 How many units of P1 should SBM 29 manufacture in 2020? 30 31 How many units of P2 should SBM 32 manufacture in 2020? 33 34 35 PART 2 Q3 Q4 49,800 05 83,800 36 DATA Instructions Questions o Type here to search LU Panatine - Roman 8 I J 14 Paste AA 6 - A H EE == X ta s = 25 Wrap Text Merge & Center - Currency $ % WE Clipboard & - Font Insert Delete Format Alignment Conditional Format as Cell Formatting Table Styles Styles E87 Number - X for B 55 The total number of T1 labor hours required C D 56 Q6 9,960 57 The total number of T2 labor hours required 58 Q7 25,140 Q8 2,593 59 The total number of machine hours required 60 61 The total number of lbs. of input Z1 required Q9 652,200 62 63 The total number of units of input Z2 required Q10 450,600 65 The total number of feet of input Z3 required Q11 919,400 67 What is the budget for T1 direct labor (dollars)? Q12 $398,400 Q13 $905,040 69 What is the budget for T2 direct labor (dollars)? 70 71 What is the total labor budget (dollars)? Instructions Questions Q14 $1,303,440 Type here to search Oema Na La NW FB: 1030. - - - Clipboard Merge & Center Font $ % & - Conditional Format as Cell Formatting Table Styles Insert Dele Alignment E87 Number Styles Cells C D 72 73 What is the purchases budget for Z1 (dollars)? 74 Q15 $978,300 75 What is the purchases budget for Z2 (dollars)? 76 Q16 $1,126,500 77 What is the purchases budget for Z3 (dollars)? Q17 78 $689,550 79 Variable manufacturing overhead is budgeted at 80 $15 per direct labor hour. While fixed factory overhead is 81 estimated to be $2.5 million. It is allocated based on machine hours 82 83 What is the budgeted variable OH for P1 (dollars)? 84 85 What is the budgeted fixed OH for P1 (dollars)? Q18 $149,400 Q19 $0 86 Q20 87 What is the budgeted cost of goods manufactured 88 for P1 (dollars)? Instructions Questions Type here to search General AES 3 5 Clipboard E78 Merge & Center - $ Font % 8-98 Conditional Format as Cell Formatting Table Styles Insert Delete Format Alignment x Number Styles Cells 8 DATA 9 2020 projected sales: Product 11 P1 12 P2 Sales 47,800 87,800 Price $65.00 $70.00 14 2020 projected Finished Goods inventory balance (units) Product 1/1/2020 12/31/2020 16 P1 10,000 12,000 17 P2 24,000 20,000 19 Calculate the following forecasts based upon the 20 above data Q1 $3,107,000 22 Forecast Revenues from Product 1 (P1) 23 an instructions Questions DO Type here to search HD-1080 8 Search Home Insert Draw Page Layout Formulas Data Review View Add-ins Help Mohamm = Palatino-Roman BIU-B = = P este este -14 A AA A 2 33 Wrap Text Merge & Center - AutoSum Clipboard General $ % Number & Conditionat Font Formatting Table So Alignment Styles Clear 78 Styles Cells Editing 39 Beginning Balance Ending Balance 0.3 36 37 DATA 38 2020 Projected Production standards: Units per P1 Units per P2 Unit cost of input 40 Direct labor hrs T1 0.2 $40.00 41 Direct labor hrs T2 $36.00 42 Machine hrs 0.01 0.025 43 Lbs of Z1 $1.50 44 Units of Z2 $2.50 45 Feet of Z3 $0.75 46 47 The production of P1 and P2 requires direct labor (2 types), machine hours, 48 and direct materials (3 types: Z1, Z2, and Z3). Input-output relations 49 are given in the table above per unit of output. Input prices are per unit 50 of input such as a pound, hour, foot, or unit. 51 52 Based on your answers provided in Part 1 determine the following amounts Instructions Questions - ---- - oo wo 42,000 60,000 85,000 42,000 70,000 60,000 Type here to search Fb - 1080 - JU ) .00 - Alignment X V Alignment Conditional Format as Cell Formatting Table Styles Insert Delete Format Number Styles Cells B. What is the purchases budget for Z3 (dollars)? Q17 $689,550 Variable manufacturing overhead is budgeted at $15 per direct labor hour. While fixed factory overhead is estimated to be $2.5 million. It is allocated based on machine hours What is the budgeted variable OH for P1 (dollars)? Q18 What is the budgeted fixed OH for P1 (dollars)? Q19 What is the budgeted cost of goods manufactured for P1 (dollars)? Q20 2 Instructions Questions Type here to search B.1080 u Draw Page Layout Search Formulas Data Review View Add-ins Help Palatino-Roman 14 AA SE= BIU - OAE Wrap Text Merge & Center - Currency Clipboard Font $ % 8-9 EH Conditional Format as Cell Formatting Table Styles E87 Alignment Insert Delete Format - fx Number Clear Styles Cells B 20 above data 21 Q1 $3,107,000 Q2 $6,146,000 $9,253,000 22 Forecast Revenues from Product 1 (P1) 23 24 Forecast Revenues from Product 2 (P2) 25 26 Forecast Total Revenues 27 28 How many units of P1 should SBM 29 manufacture in 2020? 30 31 How many units of P2 should SBM 32 manufacture in 2020? 33 34 35 PART 2 Q3 Q4 49,800 05 83,800 36 DATA Instructions Questions o Type here to search LU Panatine - Roman 8 I J 14 Paste AA 6 - A H EE == X ta s = 25 Wrap Text Merge & Center - Currency $ % WE Clipboard & - Font Insert Delete Format Alignment Conditional Format as Cell Formatting Table Styles Styles E87 Number - X for B 55 The total number of T1 labor hours required C D 56 Q6 9,960 57 The total number of T2 labor hours required 58 Q7 25,140 Q8 2,593 59 The total number of machine hours required 60 61 The total number of lbs. of input Z1 required Q9 652,200 62 63 The total number of units of input Z2 required Q10 450,600 65 The total number of feet of input Z3 required Q11 919,400 67 What is the budget for T1 direct labor (dollars)? Q12 $398,400 Q13 $905,040 69 What is the budget for T2 direct labor (dollars)? 70 71 What is the total labor budget (dollars)? Instructions Questions Q14 $1,303,440 Type here to search Oema Na La NW FB: 1030. - - - Clipboard Merge & Center Font $ % & - Conditional Format as Cell Formatting Table Styles Insert Dele Alignment E87 Number Styles Cells C D 72 73 What is the purchases budget for Z1 (dollars)? 74 Q15 $978,300 75 What is the purchases budget for Z2 (dollars)? 76 Q16 $1,126,500 77 What is the purchases budget for Z3 (dollars)? Q17 78 $689,550 79 Variable manufacturing overhead is budgeted at 80 $15 per direct labor hour. While fixed factory overhead is 81 estimated to be $2.5 million. It is allocated based on machine hours 82 83 What is the budgeted variable OH for P1 (dollars)? 84 85 What is the budgeted fixed OH for P1 (dollars)? Q18 $149,400 Q19 $0 86 Q20 87 What is the budgeted cost of goods manufactured 88 for P1 (dollars)? Instructions Questions Type here to search