Purchase Solution

Flexible Budgets

Not what you're looking for?

Ask Custom Question

Please see attached problem.

Item Cost Formula
Utilities... $6,000 per year, plus $0.30 per machine hour (MH)
Supplies... $10,000 per year, plus $0.80 per machine hour
Depreciation... $25,000 per year
Indirect labor... $21,000 per year, plus $0.40 per machine hour

Using these cost formulas, complete the following flexible budget:

Machine Hours Cost Formula
Overhead Costs (per MH) 8,000 10,000 12,000
Variable overhead costs:
Utilities 0.30 2,400 3,000 3,600
Supplies 0.80 6,400 8,000 9,600
Indirect labor 0.40 3,200 4,000 4,800
Total variable costs.... $1.50 $12,000 $15,000 $18,000

Fixed overhead costs:
Utilities 6,000 6,000 6,000
Supplies 10,000 10,000 10,000
Depreciation 25,000 25,000 25,000
Indirect labor 21,000 21,000 21,000
Total fixed overhead costs.... 62,000 62,000 62,000
Total overhead costs... $74,000 $77,000 $80,000

Refer to the flexible budget data above. The standard time to complete one unit of product is 1.6 machine hours. Last year the company planned to operate at the 10,000 machine hour level of activity. During the year the following actual activity took place:

Number of units produced.... 5,000 units
Actual machine hours worked... 8,500 hours

Actual overhead costs:
Variable Fixed
Utilities... $2,600 $5,900
Supplies... $6,700 $10,300
Indirect labor... $3,300 $21,700
Depreciation... $25,000

Prepare a performance report for the year using the format that appears below. Do not compute efficiency variances for variable overhead items.

Performance Report Hardball Corp.
Budgeted machine hours.... ________________
Actual machine hours... ________________
Standard machine hours... ________________

Cost Formula Actual Cost Flex budget Spending or (per MH) 8,500 MHS based on Budgeted
8,500 MHs Variance
Variable overhead costs:
____________________ $________ $________ $________ $________
____________________ _________ _________ _________ _________
____________________ _________ _________ _________ _________
Total variable costs.... $________ _________ _________ _________

Fixed overhead costs:
____________________ _________ _________ _________
____________________ _________ _________ _________
____________________ _________ _________ _________
____________________ _________ _________ _________
Total fixed costs.... _________ _________ _________
Total overhead costs... $________ $________ $________

Attachments
Purchase this Solution

Solution Summary

Word document contains Flexible Budgets of Hardball Corp.

Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media