Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please post answers with explanation. thanks alot! this is the continuation .. my apologies! 2 3 You're planning on manufacturing a new brand of high-end

please post answers with explanation. thanks alot! image text in transcribed
this is the continuation .. my apologies! image text in transcribed
2 3 You're planning on manufacturing a new brand of high-end gaming laptops 4 The key question is whether sales will be strong enough to at least break even. 5 Problem 1.2 sheet lists necessary inputs in yellow cells 6 Answer the following questions 8 (a) What is the accounting profit when unit sales are 900,000 units? (3 points) 12 (b) At what level of unit sales you will break even? 13 (3pts) 14 16 (c) How can you use Goal Seek to calculate break even level of unit sales? (7 points) 17 18 Set cell 19 To value: 20 By changing cell: 21 22 (d) Create a graph that is going to show fixed cost, variable cost, total cost, sales revenue 23 and accounting profit as a function of unit sales. Label X-axis as "Unit Sales", title the 24 graph "Break even analysis", make sure that labels describing each relationship are displayed on 25 the graph. Create graph on a separate sheet (7 points) 26 27 28 (e) Complete Data table in Problem 1.2 sheet 29 and describe how you use Table tool to complete it (7 points) 30 31 Row input cell 32 Column input cell Inputs 3 Ford Costs 4 Sales Revenue / Unit 5 Variable Costs / Unit $45,000,000 $2,750 $1,800 7 Calculating accounting profit 8 Unit Sales 9 Sales Revenue 10 Variable Costs 11 Gross Margin 12 Fixed Costs 13 Accounting Profit 15 Data Table: Sensitivity of Costs, Revenues, and Acct. Profit to Unit Sales 300.000 Input Values for Unit Sales 500.000 700.000 900,000 1.100.000 1,500,000 18 Fixed Costs 19 Variable Costs 20 Total Costs 21 Sales Revenue 22 Accounting Profit (e) Complete Data Table above (7 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Payroll Accounting 20

Authors: Bernard J. Bieg, Judith A. Toland

26th Edition

1337268798, 9781337268790

More Books

Students also viewed these Accounting questions

Question

=+b) Why does the interns suggestion make sense?

Answered: 1 week ago