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 operating information for the past year follows:

Required:

1. Prepare a scatter graph of Sigrid’s operating cost and draw the line you believe best fits the data.

2. Based on this graph, estimate Sigrid’s total fixed costs per month.

3. Using the high-low method, calculate Sigrid’s total fixed operating costs and variable operating cost per window.

4. Using the high-low method results, calculate the expected operating cost for the business if it paints 96 windows.

5. Perform a least-squares regression analysis on Sigrid’s data.

6. Using the regression output, create a linear equation (y = a + bx ) for estimating Sigrid’s operating costs.

7. Using the least-squares regression results, calculate the store’s expected operating cost if it paints 96 windows.

Month Number of Window Displays Operating Cost January February March $1,540 1,720 2,100 2,675 3,250 3,760 3,270 3,220 2,980 2,090 1,950 2,925 40 42 66 April May 75 80 June 83 July August September October 81 88 80 58 November 67 December 77