Scatter Diagrams and High-Low Cost Estimation Assume the local Pearle Vision has the...

60.1K

Verified Solution

Question

Accounting

image

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 1 3,000 $ 49,620 2 1,500 30,225 3 4,400 72,420 4 2,800 49,140 5 2,300 41,865 6 1,200 25,860 7 2,000 37,500 Required (a.) Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order- processing costs. $ 8,400 + $ 14.55 (b.) Plot the data on a scatter diagram. Using the information from representative high-and low-volume months, develop a cost estimating equation for monthly production costs. If needed, an Excel worksheet is provided in the following link in order to create the scatter diagram: Scatter_Diagram $ 18,400 X + $ 24.25 XX

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students