Question

Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of s
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

a)

From the month, observe that the highest order processing cost s 144840
The lowest order processing cost is 51720
Therefore the cost estimating equation for monthly order processing costs is
VC = Difference between highest and lowest order processing costs / Difference between highest and lowest sales orders
=(144840-51720)/ (4400-1200)
=93120/3200
=29.1

FC = Highest order sales - Order processing costs x Lowest order processing cost
=51720- (29.1) (1200)
=51720-34920
=16800

Hence the equation is Monthly order processing costs = 16800+29.10X

b)

From the month observe that the second highest order processing cost is 99240
The lowest order processing cost is 51720
The second highest and lowest sales order are 3000 and 1200
Therefore, the cost estimating equation for monthly order processing costs is
VC = Difference between highest and lowest order processing costs / Difference between highest and lowest sales orders
VC = (99240-51720)/(3000-1200)
=47520/1800
=26.4

FC =Highest order sales - Order processing costs x Lowest order processing cost
=51720-(26.4)(1200)
=51720-31680
=20040

Hence, the equation is monthly order processing costs = $20040 + 26.4X

Add a comment
Know the answer?
Add Answer to:
Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on...

    Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 82,700 1,500 50,375 4,400 120,700 2,800 2,300 1,200 2,000 81,900 69,775 43,100 62,500 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. = $ 14,000 ~ +$ 24.25 ♥ (b.) Plot the data on a scatter diagram. Using...

  • Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on...

    Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 82,700 1,500 50,375 4,400 120,700 2,800 81,900 2,300 69,775 1,200 43,100 2,000 62,500 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. x + $ (b.) Plot the data on a scatter diagram. Using the information from representative...

  • Assume the local Pearle Vision has the following information on the number of sales orders received...

    Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 3,000 $ 82,700 1,500 50,375 4,400 120,700 2,800 81,900 2,300 69,775 1,200 43,100 2,000 62,500 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. = $ + $ (b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a...

  • Assume the local Pearle Vision has the following information on the number of sales orders received...

    Assume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. Month Sales Orders Order-Processing Costs 1 3,000 $ 99,240 2 1,500 60,450 3 4,400 144,840 4 2,800 98,280 5 2,300 83,730 6 1,200 51,720 7 2,000 75,000 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs. Answer Answer (b.) Plot the data on a scatter diagram. Using the information from representative...

  • Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Coles County Highway Department...

    Scatter Diagrams and High-Low Cost Estimation From April 1 through October 31, Coles County Highway Department hires temporary employees to mow and clean the right-of-way along county roads. The County Road Commissioner has asked you to help her in determining the variable labor cost of mowing and cleaning a mile of road. The following information is available regarding current-year operations: Month April May June Miles Mowed Labor and Cleaned Costs 350 $9,600 300 8,800 400 10,400 250 8,000 375 10,000...

  • High-Low Cost Estimation Assume the local YRC Worldwilde delivery service hub has the following information available...

    High-Low Cost Estimation Assume the local YRC Worldwilde delivery service hub has the following information available about fleet miles and operating costs: Year Miles Operating Costs 2017 556,000 $175,600 2018 684,000 214,000 Use the high-low method to develop a cost-estimating equation for total annual operating costs. (Let X = annual fleet miles.) Total annual costs = Answer + Answer * X

  • 5. Scatter Diagram (10 Points). Used the scatter diagram below and develop a cost-estimating equation for...

    5. Scatter Diagram (10 Points). Used the scatter diagram below and develop a cost-estimating equation for month production costs. 25000 20000 15000 Order-Processing Costs 10000 5000 o 0 200 400 600 800 1000 1200 14 Sales Orders

  • Exercise 18-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following...

    Exercise 18-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following Information about its units produced and total costs. points Units Produced Period Period Total Costs $2,700 3,300 3,980 4.500 608 1.ece 1.489 1.800 Units Produced 2,200 2.680 3.898 3,480 3,888 Total Costs $5.799 6,300 6,988 7.500 9. 160 eBook 5.100 le Hint Estimate total costs of 3.200 units are produced. Complete the below table to calculate the fixed cost and variable cost of sales...

  • Exercise 21-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following...

    Exercise 21-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following information about its units produced and total costs. Units Produced Period 1 2 3 4 5 410 810 1,210 1,610 Total Costs $2,510 3,110 3,710 4,310 4,910 Period 6 7 8 9 Units Produced 2,010 2,410 2,810 3,210 3,610 Total Costs $5,510 6,110 6,710 7,310 8,286 LO Estimate total costs if 3,010 units are produced. Complete the below table to calculate the fixed cost...

  • Exercise 18-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following...

    Exercise 18-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following information about its units produced and total costs. Units Units Period Period Produced Produced Total Costs Total Costs $2,630 3,230 3,830 4,430 5,030 2,130 2,530 2,930 3,330 3,730 $5,630 6,230 6,830 7,430 8,598 1 0 6 2 530 7 3 930 8 1,330 1,730 4 5 10 Estimate total costs if 3,130 units are produced. Complete the below table to calculate the fixed cost...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT