Please answer the following question

All answers must be entered as a formula. Click OK to begin. OK XD Calculating costs and break-even - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12 AA % Paste BIU- Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D18 X foc AB C D E F G H 3 Night Shades, Inc. (NSI), manufactures biotech sunglasses. The variable materials cost is $9.64 per unit, and the variable labor cost is $8.63 per unit. What is the variable cost per unit? Suppose NSI incurs fixed costs of $915,000 during a year in which total production is 215,000 units. What are the total costs for the year? If the selling price is $39.99 per unit, does NSI break even on a cash basis? If depreciation is $465,000 per year, what is the accounting break-even point? 4 5 6 7 A SA $ $ $ 8 Variable material cost Variable labor cost Fixed costs Production Sales price Depreciation 9.64 8.63 915,000 215,000 39.99 465,000 9 10 S $ $ 11 12 13 14 Complete the following analysis. Do not hard code values in your calculations. 15 16 Variable cost per unit $ 18.27 17 18 Total cost per year 19 20 Cash break-even 21 Sheet1 + $ $ $ Variable material cost Variable labor cost Fixed costs Production Sales price Depreciation 9.64 8.63 915,000 215,000 39.99 465,000 $ $ Complete the following analysis. Do not hard code values in your calculations. Variable cost per unit $ 18.27 Total cost per year Cash break-even Accounting break-even