I NEED HELP. PLEASE. I NEED THIS IN EXCEL FORMAT LISTED BELOW.

I'LL RATE THE WORK. THANK YOU SO MUCH.

Bill Graham and Larry Miller incorporated B&L Landscapes, Inc. on July 1, 2017. The business consists of lawn care and sprinkler system installations. In addition, they also sell two types of fertilizer During 2018, B&L Landscapes, Inc. acquired a 30% interest in Crestline Pipe. The president of Crestline wants to develop a management report to evaluate Manufacturing Overhead costs. Bill and Lary want to help and have volunteered your services to provide some managerial reporting for Crestne Crestline Pipe distributes high-quality PVC pipe and has the following information for the month of March, 2018 Crestline Pipe Manufacturing Overhead Budget (Static) For the Month of March, 2018 Budgeted production in LF Budgeted costs 119.250 Indirect materials (50.30/DLH) 7,155 11,925 9,540 Maintenance ($0.25/DLH) 5963 40,500 15,950 2,800 1.150 1250 $96233 Indirect labor ($0.50/DLH) 1 Utilities (50.40/DLH) Salories Depreciation Property taxes Insurance Total budgeted costs Crestline Pipe Manufacturing Overhead Costs (Actual) For the Month of March, 2018 Actual production in LF Actual costs Indirect materials Indirect labor 12.068 11,850 10,530 5,595 40,500 15.950 2.800 1,150 .250 Maintenance Depreciation Property taxes Insurance Total budgeted costs $101693 Crestline Pipe had the following static budget and overhead costs for March. Manufacturing overhead is budgeted based on direct labor hours (DLH). Direct labor is budgeted at 12 minutes per linear foot (LF) Instructions 1. Prepare a flexible manufacturing overhead budget based on the following amounts produced a) 117,550 LF b) 118,950 LF C) 119.250 LF d) 201,500 LF e) 202.425 LF 2. Prepare a flexible budget report showing the differences (favorable and unfavorable) in manufacturing overhead costs for the month of March. Include your analysis of what variances should be investigated further Prepare a responsibility report for the manufacturing overhead for March, assuming only variable costs are controllable. Provide a brief evaluation of how this information could be used to measure the manufacturing manager's performance 3. B8 1 ACC122 Accounting Principles ll B&L LANDSCAPES, INC. Manufacturing Overhead Flexible Budget For the Month of March, 2018 2 4 6 Production in LF 7 Variable Costs 8Indirect Materials 9 Indirect Labor 10 Utilities Maintenance 12 Total Variable Costs 13 Fixed Costs 14 Salaries 15 Depreciation 16 Property Taxes 17 Insurance 18 Janitorial 19 Total Fixed Costs 20 Total Budgeted Costs 21 23 24 25 26 27 28 29 30 32 34 Flexible Budgets Flexible Budget Report Responsibility Report Ready B4 X V 'For the Month of March, 2018 1 ACC122 Accounting Principles ll 2 3 4 B&L LANDSCAPES, INC Manufacturing Overhead Flexible Budget Report For the Month of Mrch, 2018 Favorable/ Difference Unfavorable Budget Actual 7 Production in LF 8 Variable Costs 9Indirect Materials 10 Indirect Labor 11 Utilities 12 Maintenance 13 Total Variable Costs 14 Fixed Costs 15 Salaries 16 Depreciation 17 Property Taxes 18 Insurance 19 Janitorial 20 Total Fixed Costs 21 Total Budgeted Costs 23 24 25 26 27 28 29 30 31 32 Flexible Budgets Flexible Budget Report Responsibility Report Ready B4 >