Compute a cost-volume-profit analysis

Assignment Help Accounting Basics
Reference no: EM131298304

Classifying a company's costs allows for an in-depth analysis of the impact that changes in output have on revenues, costs, and net income or net loss. A cost­volume-profit (CVP) analysis will be completed in order to determine the breakeven point. Relevant costs will be used to prepare a flexible budget. Additionally, an appropriate costing system should be selected and the choice should be substantiated with reasonable rationale. Finally, a memo should be prepared for management that summarizes the results of the quantitative analysis and makes recommendations for an optimal costing system to be ethically used by key decision makers.

The project is divided into three milestones, which will be submitted at various points throughout the course to scaffold learning and ensure quality final submissions. These milestones will be submitted in Modules Two, Four, and Five. The quantitative analysis with a memo to management will be submitted in Module Seven.

In this assignment, you will demonstrate your mastery of the following course outcomes:
- Utilize cost behavior and cost analysis to assist decision makers in planning and adding value to the business
- Prepare a flexible budget for supporting informed managerial decision making
- Interpret variances for determining the optimal costing system to fit an organization's internal accounting needs
- Interpret the role of ethics in cost accounting for determining its impact on decision making

Prompt

In this assignment, multiple analyses will be conducted in order to obtain a company's financial information specific to company costs.
MDE manufactures outdoor garden items such as lawn ornaments and bird feeders. MDE uses a standard costing system to set standards for direct materials, labor, and overhead costs. MDE reviews and revises standards as necessary. Recently, budget variances for bird feeders have caused some concern. You, the company's cost accountant, have been asked to examine the numbers for the product, explain the variances, and suggest ways to improve performance.
Specifically, the following critical elements must be addressed:

You will begin by using the MDE Manufacturing Budget (Table I) to analyze costs, contribution margin, and breakeven point for the bird feeder division. You will then analyze the actual costs and complete a cost-volume-profit (CVP) analysis to determine how many bird feeders must be sold at the current cost and sales price level to earn a $10,000 profit and how much the sales price would have to increase to earn a $10,000 profit at the same cost and sales volume level. Use Tabs 1 and 2 of the Student Workbook.

I. Costs

a) Classify all product and period costs appropriately.

b) Compute a cost-volume-profit analysis. What are the implications of this analysis?

c) Compute contribution margin per unit and contribution margin ratio.

d) Determine the breakeven quantity and the breakeven revenue accurately.

e) Determine if the company is breaking even. What are cost-volume-profit analysis implications on short-term planning?

Your next step is to use the MDE Manufacturing Budget (Tables I, II, III, IV) to compare the budget and actual costs. Determine where variances occurred and explain why. Use Tabs 3 and 4 of the Student Workbook to present your budgets/variances and Tabs 5 and 6 for all budget/variance calculations.

II. Prepare and Perform

a) What are your fixed costs? Segregate them in the budget model.

b) Determine how variable costs change as activity measures change. How can this information be applied?

c) Create the budget model, ensuring fixed costs are hard coded into the model (variable costs are stated as a percentage of the relevant activity measures or as a cost per unit of activity measure).

d) Add actual activity measures to the model. Make sure all information is added accurately.

e) Add the flexible budget calculations to the budget model. Make sure all information is accurate.

f) Compare the flexible budget to the actual expenses. What does this inform? Be sure to discuss the following variances:

i. Static budget variance, including sales volume and flexible budget variances

ii. Price and efficiency variances for direct materials and direct labor

iii. Spending and efficiency variances for variable manufacturing overhead

g) Determine the aspects of the budgeting process that are in need of improvement. Justify your response.

h) Interpret what budget variances represent. Should all variances be investigated?
You have also been asked to give management a recommendation on whether the company should switch from process costing to activity-based costing (ABC). This is an exploratory discussion, but management would like to know more about the difference between the two costing systems and if a different costing system might work better for the company.

III. Main Costing Systems - Activity-Based Costing vs. Process Costing

a) Identify the cost allocation system that would benefit this company most. Justify your response.

b) Does this cost allocation system meet management planning and control goals? Explain.

c) What are the ethical implications that should be considered with this cost allocation system?

d) Describe the ethical implications of direct costs versus indirect costs. What considerations should be made when selecting one of these two?

After all of your calculations and research, you are now ready to prepare your report.

IV. Prepare a Memo to Management

a) Summarize your quantitative analysis based on your findings (include answers to all questions in Sections I, II, and III).

b) Report the parts of the budgeting process that are in need of improvement. Provide suggestions to improve those parts.

c) Report overall improvement recommendations to management. Consider the ethical implications when communicating sensitive information.

Reference no: EM131298304

Questions Cloud

Healthcare organizations perform marketing related data : Identify two ways that healthcare organizations perform marketing related data capture that do not violate any regulatory stipulations. Analyze and discuss how these might change in the future and why.
How the deadweight loss created by plastic bags will change : Plans to curtail use of plastic bags, but not much action Last summer, Seattle approved a 20-cents charge on plastic shopping bags, which was intended to reduce pollution by encouraging reusable bags.
How you might negotiate a loan with the bank : Both of these assets are free and clear from any indebtedness. Offer opinions on how you might negotiate a loan with the bank.
The expected investment trading and advisory services : Which of the following firms is the correct term for the definition: "These companies provide a variety of services to include the expected investment trading and advisory services, as well as money accounts similar to those at mutual funds"? Illustr..
Compute a cost-volume-profit analysis : Compute a cost-volume-profit analysis. What are the implications of this analysis - compute contribution margin per unit and contribution margin ratio and determine the breakeven quantity and the breakeven revenue accurately.
How can a firm use the internet and technology : Why do you think stockholders of a firm that is performing very well would prefer that the firm pay only a low percentage of its earnings as dividends?
Understand relationship between federal and state minimums : Help them understand the relationship between the Federal minimum, and State minimums and offer your suggestions about where changes should take place and why.
Definitions of new roles for leaders and systems citizens : Considering Senge's definitions of new roles for leaders and systems citizens, describe how leaders and systems citizens in your organization (WELLSTAR Health System) would operate in a "learning organization culture" such that this becomes compet..
Why might a creditor prefer informal remedies : Why might the owners of a firm prefer debt financing to equity financing?- What alternatives for raising the funds are available to you?

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Cane company manufactures two products called alpha and

cane company manufactures two products called alpha and beta that sell for 120 and 80 respectively. each product uses

  Suppose instead that the firms in problem 9 compete by

suppose instead that the firms in problem 9 compete by setting quantities rather than prices. all other facts are the

  Us gaap and uk national rules

Identify and discuss factors that may account for the existing differences in practices between US GAAP and UK national rules.

  The equipment that was bought had a fair market value of

the equipment that was bought had a fair market value of 450000 but the actual purchase price was 400000. they signed a

  Accounts receivable relate to sales of merchandise

During 2010, $25,000 of bonds payable were issued in exchange for property, plant, and equipment. There was no amortization of bond discount or premium.

  The new computer-controlled conveyor belt

The new computer-controlled conveyor belt is an exciting project that moves and positions items on a conveyor belt with a high degree of accuracy (

  The european union scientific committee on food conducted a

the european union scientific committee on food conducted a study last year and found that while caffeine levels in

  Process of posting journal entries to general ledger account

The entry will be recorded on page 7 of the general journal. Use whatever account numbers you like in the general ledger. Assume that none of the accounts to be debited or credited currently contain a balance.

  At a sales level of 80000 blue companys contribution

at a sales level of 80000 blue companys contribution margin is 34000. if the degree of operating leverage is 5 at a

  The physical units are the car seats

The physical units are the car seats

  If running corp can only sell a maximum of 6000 units of

running corp. manufactures two models of a fishing reel deluxe and supreme selling for 90 and 150 respectively. there

  Phil emley owns a garage and is contemplating purchasing a

phil emley owns a garage and is contemplating purchasing a tire retreading machine for 18000. after estimating costs

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd