can you help me answer please
Qs are in one picture
the rest of the pics are the options for the Qs
Required information Excel Analytics 5-55: Interpretation of Cost Estimation Results: Visualization [The following information applies to the questions displayed below.] Point Products produces field hockey balls, which are packaged in cases. The balls are produced in a single plant. Because of the nature of the production process at Point Products, overhead includes all labor costs. Data on production output (in cases) and total overhead costs (in thousands of dollars) from the past 15 months follow: Using the data above, the cost anolyst at Point Products ran a regression analysis of overhead costs on number of cases; with the following results: Dependent variable: Monthly overhead costs Independent variable: Production output (cases) At the same time, the cost analyst, working with the plant manager, started an account analysts of the individual overhead accounts. They estimated a fixed cost per month of $22,600 and a variable cost per case of $80. \begin{tabular}{l} Questions \\ 1. Based on the regression results, what are the estimated variable costs \\ per case? \\ 2. Based on the regression analysis results, which of the following \\ statements regarding the estimated fixed costs is accurate? \\ 3. Which of the following conclusions can be drawn from the analyses? \\ 4. Using the account analysis, what are the estimated costs for Month 10? \\ \hline 5.Forwhichofthefollowingmonthsaretheestimatedcosts(basedontheaccountanalysis)greaterthantheactualcosts? \end{tabular} jestions Answers i, what are the estimated variable costs is results, which of the following di fixed costs is accurate? ons can They are higher than the estimated fixed costs from the account analysis. They include a negative sign preceding the amount, which should be ignored. The estimated amount is negative and should therefore not be relied upon. They are negative, indicating that zero output is within the relevant range. are the estimated variable costs Its, which of the following costs is accurate? be drawn from the analyses? Neither analysis provides a useful estimate of overhead costs across volumes within the relevant range. he estimated costs for Month 10? the o imator macte / hacad an $340,360$358,520$394,840$403,960 14. Save your progress by choosing Save As from the File menu, You may now answer all questions for Assignment 555