please answer question 6 based on this information.

ACCOUNTING 306 COMPUTER PROJECT # 1 SIMPLE REGRESSION ANALYSIS USING THE DATA BASE ATTACHED: eleva 1) CREATE A SCATTERPLOT OF THE OBSERVED NUMBER OF UNITS PRODUCED AND THE RELATED MANUFACTURING OVERHEAD. 2) FIT THE REGRESSION LINE TO THE SCATTERPLOT.DISPLAY THE EQUATION OF THAT LINE AND ALSO THE R-SQUARED ON THE SCATTERPLOT Ps 3) USING SIMPLE REGRESSION, USE THE REGRESSION TOOL UNDER ADD-IN " DATA ANALYSIS" OF EXCEL TO GENERATE A SPREADSHEET OF OUTPUT DATA WITH " UNITS PRODUCED " AS THE INDEPENDENT VARIABLE AND MANUFACTURING OVERHEAD AS THE DEPENDENT VARIABLE 4) USING THE RESULT OF QUESTION # 3, WHAT IS YOUR ESTIMATE OF MANUFACTURING OVERHEAD IF 150 UNITS WERE TO BE PRODUCED? 5) HOw wOULD YOU ASSESS THE QUALITY OF THE RELATIONSHIP IN QUESTION # 3 BASED ON THE VALUE OF R-SQUARED? 75 " 6) USE OF BREAKEVEN ANALYSIS TECHNIQUES DETERMINE THE FOLLOWING DATE: A) AVERAGE VALUE FOR DM COST/UNIT AND DL COST/UNIT. B) VARIABLE MANUFACTURING OVERHEAD COST/UNIT C) TOTAL FIXED MANUFACTURING OVERHEAD COST FROM THE SIMPLE REGRESSION ANALYSIS. D) ONCE YOU HAVE THE DATA, CALCULATE THE BREAKEVEN POINT IN UNITS BY INSERTING A FORMULA INTO A CELL ON YOUR EXCEL SPREADSHEET. queens Lamps Inc specializes In manufacturing custom designed lamps. It is a low volume ma Its cost data for four years Is as follows. Sales Price Per Unjt: 400.00 Varinbre selling and General Expenses per unt Monthly Fixed Selling and General Expenss2,000 Number of Units Production Machine Material Direct Labor Manufacturing Observation" Number Month Year Produced Batches Hours 10,777