Eastwood Manufacturing accumulates the following data concerning a mixed cost, using machine hours as the activity level: Month Machine Hours Total Cost ($) January 7,500 12,450 February 6,800 11,520 March 8,200 13,340 April 6,500 11,050 12,080 May 7,200 Using the high-low method, calculate the variable cost per machine hour.

Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?

Grand Canyon Manufacturing Inc. produces and sells a product with a price of 100 per unit. The following cost data have been prepared for its estimated upper and lower limits of activity: Overhead: Selling and administrative expenses: Required: 1. Classify each cost element as either variable, fixed, or semi-variable. (Hint: Recall that variable expenses must go up in direct proportion to changes in the volume of activity.) 2. Calculate the break-even point in units and dollars. (Hint: First use the high-low method illustrated in Chapter 4 to separate costs into their fixed and variable components.) 3. Prepare a break-even chart. 4. Prepare a contribution income statement, similar in format to the statement appearing on page 540, assuming sales of 5,000 units. 5. Recompute the break-even point in units, assuming that variable costs increase by 20% and fixed costs are reduced by 50,000.

Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows: