Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide full ANSWERS AND HOW YOU GOT TO THE ANSWER, Problem 1 You're planning to manufacture a new brand of special purpose GPUs for
please provide full ANSWERS AND HOW YOU GOT TO THE ANSWER,
Problem 1 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? (3 points) (b) At what level of unit sales you will break even? (3pts) (c,) How can you use Goal Seek to calculate break even level of unit sales? (7 points) \begin{tabular}{|l|l|} \hline Set cell & \\ \hline To value: & \\ \hline By changing cell: & \\ \hline \end{tabular} (d) Create a graph that is going to show 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 on a separate sheet (7 points) (e) Complete Data table in Problem 1.2 sheet and describe how you use Table tool to complete it (7 points) \begin{tabular}{|l|l|} \hline Row input cell & \\ \hline Column input cell & \\ \hline \end{tabular} Special purpose GPUs project (problem 1) Inputs Fixed Costs Sales Revenue / Unit Variable Costs / Unit \begin{tabular}{|r|} \hline$52,000,000 \\ \hline$2,700 \\ \hline$2,600 \\ \hline \end{tabular} Calculating accounting profit Unit Sales Sales Revenue Variable Costs Gross Margin Fixed Costs Accounting Profit Data Table: Sensitivity of Costs, Revenues, and Acct. Profit to Unit Sales Fixed Costs Variable Costs Total Costs Sales Revenue Accounting Profit \begin{tabular}{|c|l|l|l|l|l|l|l|l|} \hline \multicolumn{8}{|c|}{ Input Values for Unit Sales } \\ \hline & 0 & 250,000 & 500,000 & 750,000 & 1,000,000 & 1,250,000 & 1,500,000 \\ \hline & & & & & & & & \\ \hline & & & & & & & & \\ \hline & & & & & & & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started