Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Speedy Petes is a small start-up company

  1. Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost

    Speedy Petes 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 72,850 2,630
    November 75,450 2,800
    December 73,300 2,725

    Coefficients shown by a regression program for Speedy Petes data are:

    Intercept 43,293
    X Variable 11.34

    In your calculations, round the variable rate per delivery to the nearest cent.

    Required:

    Use the results of regression to make the following calculations:

    1. Calculate the fixed cost of deliveries. $

    Calculate the variable rate per delivery. $per delivery

    2. Construct the cost formula for total delivery cost.

    Total Delivery Cost = $ + ($ Number of Deliveries)

    3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. $

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

More Books

Students also viewed these Accounting questions