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