Breakeven Analysis

User Generated

wfsvyre08

Business Finance

Description

Module 03_Breakeven Analysis Problem. Excel template and complete the included problem.

You may want to reference the following tutorial and video on Excel prior to completing this assignment:

Getting Started with Excel Tutorial

Working with Formulas: Concepts Video

 

Module 03_Breakeven Analysis Problem.xlsx


 

Unformatted Attachment Preview

Breakeven Analysis Management believes it can sell a new product for $250. First Scale of Operations: fixed costs of production are estimated to be $50,000 and the variable costs are $21 Second Scale of Operations: fixed costs of production are estimated to be at $150,000 and variable costs are $ a. Complete the tables below for each scale of operations with the given levels of output and the relationships between quantity and fixed cost, quantity and variable costs, and quantity and total costs. First Scale of Operations Quantity Total Revenue Variable Costs Fixed Costs Total Costs Profit / (Loss) Total Costs Profit / (Loss) 0 500 1,000 1,500 2,000 2,500 3,000 Second Scale of Operations Quantity Total Revenue Variable Costs Fixed Costs 0 500 1,000 1,500 2,000 2,500 3,000 b. What is the breakeven number of units sold for each scale of operations? Note that partial units cannot be c. Assume that ½ of the fixed costs in each scale of operations is non-cash depreciation. What is the cash flow generated by each scale of operations if 1,000 of units are sold? d. Based on the results calculated in the tables for each scale of operations and the breakeven units calculation variable costs have on a firm's operating earnings? Breakeven Analysis Management believes it can sell a new product for $250. First Scale of Operations: fixed costs of production are estimated to be $50,000 and the variable costs are $21 Second Scale of Operations: fixed costs of production are estimated to be at $150,000 and variable costs are $ a. Complete the tables below for each scale of operations with the given levels of output and the relationships between quantity and fixed cost, quantity and variable costs, and quantity and total costs. First Scale of Operations Quantity Total Revenue Variable Costs Fixed Costs Total Costs Profit / (Loss) Total Costs Profit / (Loss) 0 500 1,000 1,500 2,000 2,500 3,000 Second Scale of Operations Quantity Total Revenue Variable Costs Fixed Costs 0 500 1,000 1,500 2,000 2,500 3,000 b. What is the breakeven number of units sold for each scale of operations? Note that partial units cannot be c. Assume that ½ of the fixed costs in each scale of operations is non-cash depreciation. What is the cash flow generated by each scale of operations if 1,000 of units are sold? d. Based on the results calculated in the tables for each scale of operations and the breakeven units calculation variable costs have on a firm's operating earnings?
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags