Managerial accounting: master budgeting
Not what you're looking for?
Mainline moving company specializes in hauling heave foods over long distances. The company's revenues and expenses depend on revenue miles, a measure that combines both weights and mileage. The summarized budget data for next year are based on predicted total revenue miles of 800,000. At that level of volume, and at any level of volume between 700,000 and 900,0000 revenue miles, the company's fixed costs are $110,000. The selling price and variable costs are:
Per Revenue Mile
Average selling price (revenue) $1.50
Average variable expenses 1.30
1. Compute the budgeted net income. Ignor income taxed
2. Management is trying to decide hor various possible conditions or decisions might affect net income. Compute the new net income for each of the following changes. Consider each case independantly.
a. A 10% increase in sales price
b. a 10% increase in revenue miles
c. a 10% increase in variable expenses
d. a 10 percent increase in fixed expenses
e An average decrease in selling price of $.03 per revenue mile and a 5% increase in revenue miles. Refer to the original data.
f. An Average increase in selling price of $.05 and 100% decrease in revenue miles.
g. A 10% increase in fixed expenses in the form of more advertising and a 5 % increase in revenue miles.
Purchase this Solution
Solution Summary
This solution provides a detailed sample computation of the given accounting problem in Excel format.
Solution Preview
** Please see the attached file for the complete solution response **
Dear student,
Solution is provided in the attached excel file in the given sequence (Budgeted net income under original output level and under all Possible conditions from a through g) as mentioned in the posted problem.
Preliminary data
Original output
Selling price per revenue mile 1.50
Variable cost per revenue mile 1.30
Contribution Margin 0.20
1 Budgeted Net Income for original level of 800000 revenue miles
Sales revenue $1,200,000
Variable cost $1,040,000
Contribution Margin $160,000
Fixed cost $110,000
Budgeted Operating income $50,000
2 Computation of new net income under each of the following conditions
(a) 10% increase ...
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Operations Management
This quiz tests a student's knowledge about Operations Management
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.