Please prepare budgets for sales, production, direct materials, and direct labor with the information below.
The bodyling processes with proton of Management prives the followerstimmes for 2031 and the fines of 2001 Projecte Salon Unit 560 Single 01 02 Q3 00 3021 7.000 8.000 12.000 7,000 3.000 Prepared for Sale Production Direct Material weet Lab for 2021, using the following information and templates Sales lodge 01 03 03 Pro Sol S000 Production Bapte BY Q 7.000 Defense Produced Sa 02 04 RU Be to RoPro 00 21 02 03 04 Annual 29.440 3 Direct Materials Inputs: 39 Each unit requires 23 pounds costing $1.45 per pound 40 41 DM Budget 42 Units to Produce DM per unit 44 Total pounds DM End Iny 46 -Beg iny 47 DM Required 4 Cost per pound 19 Total Cost of DM 50 51 52 51 Direct Labor Inputs: 54 Each unit requires 45 minutes at a rate of 517 per hour 55 DL Budget 56 52 Units Produced 55 DLH per unit 53 Total DLH required 66 Labor Cost per Hr 61 Total DL Cost 52 362,685 01 22 03 04 Aamual 50100 The budgeting process begins with a projection of sales Management provides the following estimates for 2021 and the first two quarters of 2022: 5 6 Projected Sales in Units at $60 Selling Price: 2021 2022 01 7,000 7,000 9 02 8,000 8,000 10 03 12,000 11 04 16,000 12 13 Prepare Budgets for Sales, Production, Direct Materials and Direct Labor for 2021, using the following information and templates 14 15 16 17 Sales Budget 01 02 03 04 18 Units 19 Price 20 Sales $960,000 21 22 23 24 25 Production Budget Inputs: 26 Beginning inventory Q1: 7,000 Units 27 Desired ending inventory = 20% of the following quarter's sales 28 Production Budget Annual 02 03 0 04 Anal 9 Production de 29 Sales 30 31 Ending Inv 32 Rg Units as Be In 14 Reg Production 15 44.400 QU 02 03 0 Anal 29.440 $4263 37 a Direct Materials Inputs 19 Kach unit requires 2. pounds costing $1.45 per pound 46 41 DM Budget 42 Units to Produce 43 DM per un 44 Total pounds DM 45 End In 46 -Beg Iny 47 DM Required 48 Cox per pound 49 Total Cost of DM 50 51 52 5 Direct Labor Inputs 14 Each unit requires 45 minutes to rate of $17 per hour 55 DL. Radget 56 -57 Units Produced SH DLH per unit 59 Total DL required 50 Labor Cost per HP 61 Total DL Cost 62 02 02 03 04 Am 591,800 The bodyling processes with proton of Management prives the followerstimmes for 2031 and the fines of 2001 Projecte Salon Unit 560 Single 01 02 Q3 00 3021 7.000 8.000 12.000 7,000 3.000 Prepared for Sale Production Direct Material weet Lab for 2021, using the following information and templates Sales lodge 01 03 03 Pro Sol S000 Production Bapte BY Q 7.000 Defense Produced Sa 02 04 RU Be to RoPro 00 21 02 03 04 Annual 29.440 3 Direct Materials Inputs: 39 Each unit requires 23 pounds costing $1.45 per pound 40 41 DM Budget 42 Units to Produce DM per unit 44 Total pounds DM End Iny 46 -Beg iny 47 DM Required 4 Cost per pound 19 Total Cost of DM 50 51 52 51 Direct Labor Inputs: 54 Each unit requires 45 minutes at a rate of 517 per hour 55 DL Budget 56 52 Units Produced 55 DLH per unit 53 Total DLH required 66 Labor Cost per Hr 61 Total DL Cost 52 362,685 01 22 03 04 Aamual 50100 The budgeting process begins with a projection of sales Management provides the following estimates for 2021 and the first two quarters of 2022: 5 6 Projected Sales in Units at $60 Selling Price: 2021 2022 01 7,000 7,000 9 02 8,000 8,000 10 03 12,000 11 04 16,000 12 13 Prepare Budgets for Sales, Production, Direct Materials and Direct Labor for 2021, using the following information and templates 14 15 16 17 Sales Budget 01 02 03 04 18 Units 19 Price 20 Sales $960,000 21 22 23 24 25 Production Budget Inputs: 26 Beginning inventory Q1: 7,000 Units 27 Desired ending inventory = 20% of the following quarter's sales 28 Production Budget Annual 02 03 0 04 Anal 9 Production de 29 Sales 30 31 Ending Inv 32 Rg Units as Be In 14 Reg Production 15 44.400 QU 02 03 0 Anal 29.440 $4263 37 a Direct Materials Inputs 19 Kach unit requires 2. pounds costing $1.45 per pound 46 41 DM Budget 42 Units to Produce 43 DM per un 44 Total pounds DM 45 End In 46 -Beg Iny 47 DM Required 48 Cox per pound 49 Total Cost of DM 50 51 52 5 Direct Labor Inputs 14 Each unit requires 45 minutes to rate of $17 per hour 55 DL. Radget 56 -57 Units Produced SH DLH per unit 59 Total DL required 50 Labor Cost per HP 61 Total DL Cost 62 02 02 03 04 Am 591,800