Question: CAN SOMEONE PLEASE SHOW ME HOW TO DO THIS USING EXCEL 1. Calculating Costs and Break-Even [LO3] Night Shades, Inc. (NSI), manufactures biotech sunglasses. The

CAN SOMEONE PLEASE SHOW ME HOW TO DO THIS USING EXCEL 1. Calculating Costs and Break-Even [LO3] 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.

a. What is the variable cost per unit?

b. 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?

c. 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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I need help with some questions and have included please help??? Week 3 7) Calculating IRR [LO5] A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent,...

Can I get your help again? I have attached the problem. Chapter 9 7) Calculating IRR [LO5] A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent, should...

1. Calculating Costs and Break-Even [LO3] 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. a....

1 Calculating Costs and Break-Even [LO3] Night Shades, Inc. (NSI), manufactures biotech sunglasses. The variable materials cost is S11.13 per unit, and the variable labor cost is $7.29 per unit. a....

1. Calculating Costs and Break-Even [LO3] Night Shades, Inc. (NSI), manufactures biotech sunglasses. The variable materials cost is $11.13 per unit, and the variable labor cost is $7.29 per unit....

Hello, Please can someone tell me how to calculate the break even point on Chapter 11 Question 7. Please see the attached. Thank you, Cindy Chapter 9 Question 7 Calculating IRR [LO5] A firm evaluates...

Calculating Costs and Break-Even [LO3] 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. a. What...

The costs of an employment relationship for the firm are not limited to wages. when the firm hires a worker it must spend resources on the recruitment process (for instance on newspaper...

Co. reported pretax book income of $2,500,000. During the current year, the accrued vacation account increased by $76,000. In addition, book depreciation was $50,000 and tax depreciation was $85,000....

As easy as it is to use credit, it is even easier to get into trouble with it . If you do you should: Question 1 9 options: devise a realistic budget that includes a plan to pay of the balance....

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Write formal and informal proposals.

Describe the components of a formal report.

Write formal and informal reports.