can you please provide clean answer

B C E F G 6 ALT-PROD-DL-FO 7 8 Ferndale Company is preparing budgets for 2019. 9 Ferndale estimates that unit sales in January will be 10 22,000 units, February sales will be 24,000 units, and March sales will be 11 28,000 units. 12 13 April sales (in units) will be 30,000, May's sales will be 29,000, and June's sales will be 14 27,000. July's sales are estimated at 26,000. 15 16 Ferndale wishes to end each month with inventory equal to 30.00% of the following month's sales. The December 2018 ending inventory was 3,500 units. 17 18 Prepare a Production budget for the first 6 months of 2019. 19 20 PRODUCTION BUDGET 2019 JANUARY FEBRUARY MARCH 21 UNIT SALES 22 + DESIRED ENDING INVENTORY 23 SUBTOTAL 24 - BEGINNING INVENTORY 25 UNITS TO PRODUCE 26 27 Ferndale prepares its Direct Labor Budget for 2019. 28 Each unit of product requires 0.25 hours to produce. The direct labor rate is $24.00 per hour. 29 Prepare the Direct Labor Budget for 2019. 30 31 32 DIRECT LABOR BUDGET 2019 JANUARY FEBRUARY MARCH 33 UNITS TO PRODUCE 34 HOURS REQUIRED TO PRODUCE ONE UNIT 35 TOTAL TIME REQUIRED IN HOURS 36 DIRECT LABOR RATE PER HOUR 37 BUDGETED DIRECT LABOR COST 38 39 Ferndale prepares its Factory Overhead Budget for 2019. 40 Substantially all overhead corte are fived. Sunonicon costs are as followe ALT-PROD-DL-FO > 4 A APRIL APRIL H MAY MAY JUNE JUNE J K JULY 26,000 See Sales Budget TOTALS 30% of next month sales Sum Last month's Ending Inv. Units to Produce L M N O P Q R JFMAM J J .00 00 00 1 00 0 0 0 0 0 O D 00 00 0 0 00 0 0 JFMAMJ 00 0 0 00 00 0 0 00 0 0 00 00 00 00 0 0 00 00 00 0 SOOO06 S 27 Ferndale prepares its Direct Labor Budget for 2019. 28 Each unit of product requires 0.25 hours to produce. The direct labor rate is $24.00 per hour. Prepare the Direct Labor Budget for 2019. 29 30 31 32 DIRECT LABOR BUDGET 2019 JANUARY FEBRUARY MARCH 33 UNITS TO PRODUCE 34 HOURS REQUIRED TO PRODUCE ONE UNIT 35 TOTAL TIME REQUIRED IN HOURS 36 DIRECT LABOR RATE PER HOUR 37 BUDGETED DIRECT LABOR COST 38 39 Ferndale prepares its Factory Overhead Budget for 2019. 40 Substantially all overhead costs are fixed. Supervisory costs are as follows. 41 Supervisory Salaries $4,500 per month 42 Security Costs' $5,500 per month 43 Factory Heat and Light $3,500 per month 44 Factory Depreciation $5,000 per month 45 Indirect Materials $3,750 per month 46 47 FACTORY OVERHEAD BUDGET JANUARY FEBRUARY 48 Supervisory Salaries 49 Security Costs 50 Factory Heat and Light 51 Factory Depreciation 52 Indirect Materials 53 54 55 56 * Refer to the Direct Labor Budget 57 58 59 ALT-PROD-DL-FO MARCH APRIL MAY APRIL MAY TOTAL BUDGETED OVERHEAD TOTAL DIRECT LABOR HOURS* PREDETERMINED OVERHEAD RATE JUNE JUNE TOTALS TOTALS $0 $0 $0 $0 $0 $0 0 #DIV/0! per DLH SOOOO. 40000 JFMAM J 00 0 00 00 0 0 0 00 0 of o 00 0 0 0 0 0 0 JFMAM J 0 0 0 00 0 00 00 O 400000 2000.. * 00 00 00 00 00 00 B 000.... 0 00 0 0