Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Business Finance homework help

i NEED THIS ASAP……

I need it in excel i have the answers

ACT 500 – Module 06: Cost-Volume-Profit (CVP) Analysis

Module 06: Discussion

Submit as an excel document and show your work with formulas

Fill-in-the-Blank Equations

1. __________ = Difference in Total Cost ÷ Difference in Units Produced

Variable Cost per Unit

2. Contribution Margin = Sales – __________

Variable Costs

3. Contribution Margin Ratio = __________ ÷ Sales

Contribution Margin

4. __________ = Fixed Costs ÷ Unit Contribution Margin

Break-Even Sales (units)

5. Sales (units) = (__________ + Target Profit) ÷ Unit Contribution Margin

Fixed Costs

6. Operating Leverage = Contribution Margin ÷ __________

Operating Income

7. Margin of Safety (percent of current sales) = (Sales – Sales at Break-Even Point) ÷__________

Sales

8. Margin of Safety (SAR) = Sales (SAR) – __________

Break-Even Sales (SAR)

9. The total cost of production for the last four quarters for Moore’s Mowers is as follows. Use the high-low method to determine the variable cost per unit and the fixed cost.

Total Cost
Units Produced

Quarter 1 51,000 SAR 2,000

Quarter 2 56,400 SAR 2,300

Quarter 3 49,200 SAR 1,900

Quarter 4 53,700 SAR 2,150

Variable Cost = _____________18 SAR per unit

Fixed Cost = ____________ 15,000 SAR

10. During 2023, Caps by Huely sold 50,000 finished products with a contribution margin of 55%. The variable costs totaled 40,500 SAR for the year. Determine the sales, contribution margin, and unit contribution margin.

Sales = ____________ 90,000 SAR

Sales price per unit = ____________ 1.80 SAR

Variable cost per unit = ____________
(0.81)

Contribution margin per unit= ____________
0.99 SAR

Contribution margin= ____________ 49,500 SAR

11. If a manufacturing company had a contribution margin of $65,700 for 20Y5 from selling 25,000 products at 6 SAR each, determine the variable cost per unit, contribution margin ratio, and unit contribution margin. Round unit answers to two decimal places and percentages to the nearest whole percent.

Sales (SAR) = ____________ $150,000

Contribution margin = ____________
(65,700)

Total variable cost= ____________
$ 84,300

Variable cost per unit= ____________ $3.37

Unit contribution margin= ____________ $2.63

Contribution margin ratio = ____________ 44%

12. Determine the change in operating income for each situation for a company that has an increase in total sales of $52,000.

a. Unit contribution margin of $4.50 and each product selling for $8.

= ____________$29,250

b. Contribution margin ratio of 24% and each product selling for $10.

= ____________$12,480

c. Unit contribution margin of $6, with total variable costs of $25,000 at $5 per unit.

= ____________$30,000

13. After incurring an operating loss of $(6,000) in 20Y5, the production manager would like to know the break-even point in sales and units for the company. During 2023, the company sold 6,000 at $3 each. Variable costs for the year totaled $10,800. Determine the sales and units sold that were needed to break even.

Sales = ____________200,000 SAR

Variable costs = ____________
(80,000)

Contribution margin = ____________120,000 SAR

Fixed costs= ____________
(50,400)

Operating income = ____________
69,600 SAR

14. A tire manufacturer sells its finished goods for 80 SAR each. The variable cost to manufacture each product is 20 SAR, while fixed costs equal 20,700 SAR. In 2022, the company earned operating income of 32,100SAR. In 2023, the CEO would like to increase operating income by 5%. Determine the sales in dollars and units needed to achieve the CEO’s goal. Round answers to the nearest whole number.

Target Profit = ____________ 33,705SAR = 32,100SAR × 1.05

Sales (units) = ____________ 907 units = (20,700SAR + 33,705SAR) ÷ $60

Sales (dollars) = ____________ $72,540 = (20,700SAR + 33,705SAR) ÷ 75%, or 907 units × 80SAR per unit

Submit as an excel document for faculty grading.

*Due to rounding, the two methods will differ by $20 in sales.

15.Prepare a cost-volume-profit chart for a company that has an 80% contribution margin for goods that it sells for $150 each. The company’s fixed costs total $54,000. Also, determine the break-even point in units and sales.

Break-Even Point (units) = ____________ 450 units = $54,000 ÷ $120 per unit

Break-Even Point (sales) = ____________ $67,500 = $54,000 ÷ 80%, or 450 units × $150 per unit

Submit as an excel document with cost-volume-profit chart for faculty grading.

>Business & Finance homework help

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Reading 8

Instructions and readings attached For section #2 Comparative Insight (7 points) I also attached week 7 reading (Reading_Interviewing Candidates-1.pdf)

HR 2

Instructions and readings are attached. Note: You don’t have to create the video. Just write a script (1-3 mins)

ethics

BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in our Learn readings and presentations.

Unit VI

see attached You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of employees needed. Complete the Unit VI Assignment Template for this assignment and submit it for grading in Blackboard.

Odoo

What is Odoo implementation? Odoo implementation Odoo implementation is the process of setting up and configuring the Odoo ERP system to match a company’s specific business needs. It involves analyzing workflows, customizing modules, migrating data, and integrating various departments like sales, inventory, HR, and accounting into a single unified

Heed wk 3

Global Regulatory and Legal Requirements of Quality.v1 17a Study Guide- Pathway to Medical Device Approval Part 1 1. Which branch of FDA Approves Medical Device products? 2. The Approval Pathway is Based on Device Risk. Fill in the following table: Medical Device Risk Classification Classification Define Examples Class I Class

Sam Strother and Shawna Tibbs

Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Insurance Company and co-directors of the company’s pension fund management division. An important new client, the North-Western Municipal Alliance, has requested that Mutual of Seattle present an investment seminar to the mayors of the represented cities, and

P1

Procurement Management Plan Instructions This week, you will produce your Procurement Management Plan for your project. Your plan will provide direction to manage procurement throughout the life of your project. The plan recognizes and describes the products and/or services to be acquired, the types of contracts to be used to

Mathematical accounting

A company produces and sells a single product. The fixed costs amount to $50,000 per month, and the variable cost per unit is $25. The product is sold for **$40 per unit**. **Required:** 1. Calculate the **break-even point** in units and in dollars. 2. Determine the **profit or loss** if

Accounting

Discuss advantages of monetary policies in business laws.

9-2 Final Project Milestone Four: Synthesis of Course Content

Submit a draft showing the link between your topic and the information, theories, and material covered in the class.

Business Finance – Accounting HOMEWORK

see attached Use this reference for first 2 questions. Williams, J., Bettner, M., & Smith, K. (2023). Financial & Managerial Accounting (eBook with Connect access). New York, NY: McGraw-Hill Education. Homework 1, 1 page with 2 references: Select a publicly traded company and access the company’s most recent annual report

Monetary Accounting

Discus the valuations skills studied.in Monetary Accounting

financial accounting

Question (Financial Accounting): XYZ Limited began operations on January 1, 2024. The following transactions occurred during its first month of business: The owner invested $120,000 cash into the business. Purchased equipment worth $60,000, paying $20,000 in cash and the balance on credit. Purchased inventory costing $25,000 on

Mathematics economics

Question (Mathematical Economics): A firm’s production function is given by: [ Q = 50L^{0.5}K^{0.5} ] where ( Q ) is output, ( L ) is labor, and ( K ) is capital. The price of output is ( P = 10 ), the wage rate is ( w =

Federal Reserve Bank (Fed)

Explain how the decision of the Federal Reserve Bank (Fed) to raise interest rates would be expected to affect each component of the weighted average cost of capital (WACC). What mistakes are commonly made when estimating the WACC, and how do these mistakes arise?

Economics

Inflation and Its Impact on Consumer Purchasing Power and Economic Growth Inflation, defined as the sustained increase in the general price level of goods and services in an economy, has significant implications for consumer purchasing power and overall economic growth. Its effects can be both beneficial and detrimental, depending on

Accounting

Question: A company purchases office equipment for $12,000 on January 1, 2024. The equipment has an estimated salvage value of $2,000 and a useful life of 5 years. Using the straight-line method, calculate: (a) The annual depreciation expense. (b) The book value of the equipment at the end of the