Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jerry Thomas is the manger for the storeroom for Classic Manufacturing. He was asked to estimate the future monthly purchase costs for part number 782.

Jerry Thomas is the manger for the storeroom for Classic Manufacturing. He was asked to estimate the future monthly purchase costs for part number 782. Jerry collected the cost and quantity data for the past nine months as provided below.

Month

Purchase cost

Quantity Purchased

January

$ 12,925

2,762

February

$ 13,250

2,862

March

$ 17,903

4,212

April

$ 16,075

3,818

May

$ 13,375

2,966

June

$ 14,064

3,447

July

$ 15,550

3,685

August

$ 10,483

2,356

September

$ 15,200

3,636

Estimated monthly purchases of part 782 for the following three months are:

October 3,590

November 3,960

December 3,290

Required:

  1. Use the high-low method to develop a linear formula to estimate the purchase costs for the parts to be purchased for the rest of the year

  1. Use the formula in (a) to estimate the purchase costs for each of the months October to December.

  1. Use the regression method to develop a formula to estimate the purchase costs for the parts to be purchased for the rest of the year.

  1. Use the formula in (c) to estimate the purchase costs for each of the months October to December.

  1. What are your comments on the results in (b) and (d) above?

Show all your calculations for (a) to (d).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Finance For Non-Specialists

Authors: Eddie McLaney, Peter Atrill

11th Edition

1292244011, 9781292244013

More Books

Students also viewed these Accounting questions

Question

How are most students funded?

Answered: 1 week ago