Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

can you help me answer please
Qs are in one picture
the rest of the pics are the options for the Qs image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding And Auditing Corporate Culture A Maturity Model Approach

Authors: Angelina K. Y. Chin, CIA, CRMA, CPA

1st Edition

1634540719, 978-1634540711

More Books

Students also viewed these Accounting questions

Question

Differentiate 3sin(9x+2x)

Answered: 1 week ago

Question

Compute the derivative f(x)=(x-a)(x-b)

Answered: 1 week ago

Question

d. What language(s) did they speak?

Answered: 1 week ago