Question: Required purchasing department costs fixed, variable or mixed? b. Estimate the average purchasing cost per purchase order at the low and high point of purchase

 Required purchasing department costs fixed, variable or mixed? b. Estimate theaverage purchasing cost per purchase order at the low and high point

Required purchasing department costs fixed, variable or mixed? b. Estimate the average purchasing cost per purchase order at the low and high point of purchase order. Assume no outliers in your analysis. Note: Round answers to two decimal places. Estimated high point: \$ Estimated low point: \$ c. Use the high-low method to develop a cost-estimating equation for total annual operating costs. Note: Round answers to the nearest whole dollar. Cost estimating equation: Y=$ x+$ x d. If purchases for next quarter are expected to be 9,600 units, what are expected purchasing department costs? $ DA2-5 Analyzing Data Visualizations: Purchasing Department Costs Assume you are the purchasing manager at Block for materials used in the chip reader. You have observed that as the company has increased its sales volume, the total cost to process purchase orders has increased as well, but not at a constant rate. You would like to estimate the cost to process purchase orders next month. You gather the following data for the last eight quarters. (See data to the right) Required a. Prepare a scatter diagram that shows the relationship between the number of purchase orders and purchase department costs for the last eight quarters. Based upon the scatter diagram, are purchasing department costs fixed, variable or mixed? b. Estimate the average purchasing cost per purchase order at the low and high point of purchase orders using data from the chart. Assume no outliers in your analysis. c. Use the high-low method to develop a cost-estimating equation for total annual operating costs. d. If purchases for next quarter are expected to be 9,600 units, what are expected purchasing department costs? e. What are some reasons why the total cost to process purchase orders is not increasing at a constant rate? What trends do you expect in the average cost per unit in the purchasing department

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!