You're planning to manufacture a new brand of special purpose GPUs for machine learning applications. The key
Question:
You're planning to manufacture a new brand of special purpose GPUs for machine learning applications.
The key question is whether sales will be strong enough to at least break even. Problem 1.2 sheet lists
necessary inputs in yellow cells. Answer the following questions:
a) What is the accounting profit when unit sales are 1,100,000 units
b) At what level of unit sales you will break even?c) How can you use Goal Seek to calculate break even level of unit sales
d) prepare graph showing fixed cost, variable cost, total cost, sales revenue and accounting profit as a function of unit sales. Label X-axis as "Unit Sales", title the graph "Break even analysis", make sure that labels describing each relationship are displayed on the graph. Create graph .
Given Inputs
Fixed Costs $5,20,00,000
Sales Revenue / Unit $2,700
Variable Costs / Unit $2,600
e) Data Table: Sensitivity of Costs, Revenues, and Acct. Profit to Unit Sales
0 2,50,000 5,00,000 7,50,000 10,00,000 12,50,000 15,00,000
Fixed Costs ---
Variable Costs -
Total Costs
Sales Revenue
Accounting Profit
Input Values for Unit Sales
Complete the table above
Engineering Economic Analysis
ISBN: 9780195168075
9th Edition
Authors: Donald Newnan, Ted Eschanbach, Jerome Lavelle