Question

Using Regression Results to Construct and Apply a Cost Formula Dohini Manufacturing Company had the following...

  1. Using Regression Results to Construct and Apply a Cost Formula

    Dohini Manufacturing Company had the following 12 months of data on purchasing cost and number of purchase orders.

    Month Purchasing Cost Number of Purchase
    Orders
    January $18,860        370                 
    February 18,065        330                 
    March 19,250        370                 
    April 18,050        410                 
    May 19,345        400                 
    June 19,500        450                 
    July 19,670        460                 
    August 20,940        560                 
    September 19,430        440                 
    October 20,020        500                 
    November 18,800        470                 
    December 19,340        480                 

    The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are:

    Intercept 15,021 (rounded to the nearest dollar)
    X variable 1 9.74 (rounded to the nearest cent)

    Required:

    1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate.

    Total purchasing cost = $ + ($ × Purchase orders)

    2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.)
    $

    3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.)
    $

    What is the total fixed purchasing cost?
    $

Homework Answers

Know the answer?
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
Similar Questions
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine...
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Speedy Pete’s is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows: Month Delivery Cost Number of Deliveries May $63,450 1,800 June 67,120 2,010 July 66,990 2,175 August 68,020 2,200 September 73,400 2,550 October...
Creating and Using a Cost Formula Big Thumbs Company manufactures portable flash drives for computers. Big...
Creating and Using a Cost Formula Big Thumbs Company manufactures portable flash drives for computers. Big Thumbs incurs monthly depreciation costs of $16,000 on its plant equipment. Also, each drive requires materials and manufacturing overhead resources. On average, the company uses 10,400 ounces of materials to manufacture 5,200 flash drives per month. Each ounce of material costs $3.00. In addition, manufacturing overhead resources are driven by machine hours. On average, the company incurs $20,800 of variable manufacturing overhead resources to...
Method of Least Squares, Developing and Using the Cost Formula The method of least squares was...
Method of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 147,400 Slope 210 The cost driver used was number of parts inspected. Required: 1. What is the cost formula? Total cost of receiving = $ + (...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and construct a cost function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and construct a cost function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January 9,590 490 February 7,100 570 March 7,631 610 April 8,240 460 May 9,887 530 June 8,590 420 July 12,460 680 August 7,600 380 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost($) Employee Hours January 9,290 350 February 6,800 410 March 7,331 430 April 7,940 320 May 9,587 380 June 8,290 300 July 10,732 490 August 7,300 270 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and Construct a Cost Function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost($) Employee Hours January 9,790 290 February 7,300 330 March 7,831 350 April 8,440 260 May 10,087 310 June 8,790 240 July 11,040 400 August 7,800 220 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Creating and Using a Cost Formula Kleenaire Motors manufactures hybrid sports utility vehicles (SUVs). Kleenaire incurs...
Creating and Using a Cost Formula Kleenaire Motors manufactures hybrid sports utility vehicles (SUVs). Kleenaire incurs monthly depreciation costs of $10,000,000 on its highly automated plant machinery and warehousing facility. Also, each SUV requires materials and manufacturing overhead resources. On average, the company uses 75,000,000 pounds of steel to manufacture 50,000 SUVs per month. Each pound of steel costs $0.20. In addition, manufacturing overhead resources are driven by machine hours. On average, the company incurs $200,000,000 of variable manufacturing overhead...
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that...
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that Differs from the Data Period Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $7,100 340 February 9,999 530 March 8,240 610 April 9,887 590 May 8,590 460 June 7,631 330 July 9,590 550 August 7,550 290 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor...
An important application of regression analysis in accounting is in the estimation of cost. By collecting...
An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,000 450 5,000 550 5,400 600 5,900 700 6,400...
An important application of regression analysis in accounting is in the estimation of cost. By collecting...
An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,400 450 5,400 550 5,800 600 6,300 700 6,800...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT