Question & Answer: 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…..

Please answer (b)
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 $165,400 100,750 241,400 163,800 139,550 86,200 125,000 3,000 1,500 4,400 2,800 2,300 1,200 2,000 4 Required (a.) Use information from the high- and low-volume months to develop a cost- estimating equation for monthly order-processing costs. -$ 28,000+ 48.5 X (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

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 $165,400 100,750 241,400 163,800 139,550 86,200 125,000 3,000 1,500 4,400 2,800 2,300 1,200 2,000 4 Required (a.) Use information from the high- and low-volume months to develop a cost- estimating equation for monthly order-processing costs. -$ 28,000+ 48.5 X (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

Expert Answer

 

  1. High low volume cost estimating equation

High volume in month 3=no. of sales orders=4400

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: 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…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

Cost=$241,400

Low volume month6=no. of sales orders=1200

Cost=$86,200

Equation:

Y=a+bX

Y=cost

X=Volume=No. of sales order

Y1=$86,200 , X1=1200

Y2=$241,400 X2=4400

b=(Y2-Y1)/(X2-X1)=(241400-86200)/(4400-1200)=$48.5

Estimated Variable cost per sales order=$48.5

a=Y1-bX1=86200-48.5*1200=$28,000

Estimated fixed cost=$28,000

Cost Estimating Equation:

Order processing cost(Y)=$28,000+48.5X

Y= $28,000 + $48.50 X
X Yac Ye=28000+48.5*X
Month Number of orders Actual order processing cost Estimated order processing cost
1 3000 165400 173500
2 1500 100750 100750
3 4400 241400 241400
4 2800 163800 163800
5 2300 139550 139550
6 1200 86200 86200
7 2000 125000 125000

Grand Paper Writers
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All papers are written by the best professional writers to ensure 100% originality. We always provide plagiarism reports whenever we deliver completed papers.

Free Revisions

All papers by Grand Paper Writers are completed and submitted on time. This timely delivery of papers gives you time to go through the paper before the official deadline.

Title-page

As an additional service, we will provide a title page that precedes the contents of your paper. Here, you will provide your personal details.

Bibliography

We also ensure that we provide an extra page for the references or bibliographies following referencing rules.

Originality & Security

At Grandpaperwriters.com, we guarantee students for the provision of security and original work. All your personal information is handled with confidentiality and is not shared with third parties. Additionally, we ensure that we provide original content with accompanying plagiarism reports to show originality.

24/7 Customer Support

Our customer support team is always available 24/7 to provide instant responses to any queries raised by students.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Grandpaperwriters.com has the best professional essay writers for quality services.

Pricing

Flexible Pricing

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Communication

Admission Help & Client-Writer Contact

Grandpaperwriters.com provides an interactive portal where students can communicate directly to their writers.

Deadlines

Paper Submission

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Reviews

Customer Feedback

Grandpaperwriters.com appreciates feedback from our clients to help us improve the delivery of essay writing services. As such, we are constantly changing our policies to ensure maximum customer and writer satisfaction.