Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Estimating Cost Behavior Using Least-Squares Regression Method Sigrid's Custom Graphics specializes in creating and painting store window advertisement displays. The majority of its business comes

image text in transcribed

Estimating Cost Behavior Using Least-Squares Regression Method Sigrid's Custom Graphics specializes in creating and painting store window advertisement displays. The majority of its business comes from local retailers and fast-food restaurants A portion of Sigrid's aperating information for the past year follows: Number of Window Displ eys Operating Cost $1,540 1,720 2,100 2.675 3,250 3,760 3,270 3.220 2,980 2.090 1,950 2,925 42 75 81 September 80 58 December Required: I. Perform a least-squares regression analysis on Sigrid's data. 2. Using the regression output, create a linear equation - a hax) for estimating Sigrid's operating costs. 3. Using the least-squares regression results, calculate the store's expected operating cost if it paints 96 windows. 4. Consider the pattern of the company's activity and costs throughout the year. Would you consider this to be a seasonal business? Explain your answer and how this information could impact the relative proportion of fixed and variable costs for the business. s. Using your cost estimates obtained with the high-low and regression methods, predict the store's operating costs for the upcoming months based on the following expected sales levels: Month Expacted Number of Wndew January February 48 70 76 87 85 June Explain why there are differences between cost predictions based on the high-low method and on least- squares regression. Which do you think is more accurate? Why? Using the regression results, prepare contribution margin income statements for January through June. Assume that the business charges $80 per window on average. 6. 7

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

Financial accounting

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel

IFRS Edition

9781119153726, 978-1118285909

More Books

Students also viewed these Accounting questions

Question

4. Describe the factors that influence self-disclosure

Answered: 1 week ago

Question

1. Explain key aspects of interpersonal relationships

Answered: 1 week ago