1. Using least-squares regression, estimate the fixed cost and variable cost elements of monthly overhead costs. Estimate the fixed cost element to the nearest dollar and the variable cost element to the nearest cent. Fixed cost Variable cost 8.44 per machine hour 2. If the company expects to use 4,900 machine-hours next month, estimate total overhead costs.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Sh3
![Cycle Accessories manufacturers cellphone holders that can be mounted on the handle bars of most motorcycles. The manufacturing
process is highly automated and management feels that machine-hours are likely the main driver of overhead costs. Data from the
most recent year are shown below.
Month
January
February
March
April
May
June
July
August
September
October
November
December
Fixed cost
Variable cost
69
Machine-Hours
3,400
3,460
3,700
4,420
4,600
5,200
5,800
6,400
6,100
4,600
3,760
5,800
Overhead Costs
$61,700
66,620
73,700
81,020
Total overhead costs
Required:
1. Using least-squares regression, estimate the fixed cost and variable cost elements of monthly overhead costs. Estimate the fixed
cost element to the nearest dollar and the variable cost element to the nearest cent.
82,710
81,480
8.44 per machine hour
92,670
91,880
88,420
80,360
75,270
89,130
2. If the company expects to use 4,900 machine-hours next month, estimate total overhead costs.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F323c9976-6b7b-4414-aa82-41105edc66ec%2F84e4ec3d-3957-47d6-af5c-4eab232ead07%2Fj4dk4dg_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Principles of Cost Accounting](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Financial And Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)