Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

H41 D BIC 1 High-end gaming laptop project (problem 1) 2 Inputs 3 Fixed Costs $45.000.000 4 Sales Revenue / Unit $2,750 5 Variable Costs/Unit

image text in transcribed
image text in transcribed
H41 D BIC 1 High-end gaming laptop project (problem 1) 2 Inputs 3 Fixed Costs $45.000.000 4 Sales Revenue / Unit $2,750 5 Variable Costs/Unit $1,800 7 Calculating accounting profit 8 Unit Sales 9890 9 Sales Revenue $27,197,802 10 Variable Costs $17,802 198 11 Gross Margin $45.000.000 12 Fbed Costs $45.000.000 13 Accounting Profit 15 Data Table: Sensitivity of Costs, Revenues, and Acct. Profit to Unit Sales 16 Input Values for Unit Sales 900.000 1.100.000 1.500.000 18 Fixed Costs 19 Variable Costs 20 Total Costs 21 Sales Revenue 22 Accounting Profit 9,890 $45,000,000 $17,802.198 $62,802.198 $27,197 302 (e) Complete Data Table above (7 points) Problem Problem: Probler 41 Name Problem 1.1 Problem 21 Problem 22 Problem 12 Problem 1 You're planning on manufacturing a new brand of high-end gaming laptops The key question is whether sales will be strong enough to at least break even. Problem 12 sheet lists necessary inputs in yellow cells Answer the following questions (a) What is the accounting profit when unit sales are 900,000 units ? (3 points) Accounting profit (b) At what level of unit sales you will break even? (3pts) $47,368.42 (c) How can you use Goal Seek to calculate break even level of unit sales? (7 points) B13 Set cell To value: O By changing cell: 2 (d) Create a graph that is going to show foxed cost, variable cost, total cost, sales revenue 3 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) 28 e) Complete Data table in Problem 12 sheet 29 and describe how you use Table tool to complete it (7 points) 31 Row input cel 32 Column input cell Problem 41 Problem 42 Name Problem 1.1 Problem 12 Problem 2.1 Problem 2

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

College Accounting Ch 1-12

Authors: Dansby

5th Edition

0763834955, 978-0763834951

More Books

Students also viewed these Accounting questions

Question

Explain the relationship of job design to employee contributions.

Answered: 1 week ago

Question

Discuss the steps in human resource planning.

Answered: 1 week ago