Sold daily in order to break even

Assignment Help Financial Management

Reference no: EM132068607

A cell phone accessory store sells its inventory for an average price of $28.00. The store incurs a daily fixed cost of $1400 which includes salaries and rental. The average variable cost per item is $12.50. Set up this problem in Excel as shown below. Use Goal Seek to compute the number of item (X) that must be sold daily in order to break even. STORE PARAMETERS: Selling price per unit: $28 Fixed Cost: $1400 Variable cost per unit: $12.50 INPUT DATA: Number of units: RESULTS: Total revenue: Fixed Cost: Total Variable Cost: Total Cost: Profit:

Reference no: EM132068607

Questions Cloud

Calculate the expected return and variance for all assets : Calculate the expected return and the variance for all assets and determine the expected return of any portfolio obtained by mixing any of the three assets.

What is the net income for this firm : What is the net income for this firm?

Determine the net present value of the project : An existing online book retailer is considering whether to open a brick and mortar bookshop. Determine the net present value of the project.

Company produce each week to maximize its weekly profits : How many units of each model should the company produce each week to maximize its weekly profits?

Sold daily in order to break even : Use Goal Seek to compute the number of item (X) that must be sold daily in order to break even

The total nominal return on her investment : Emma purchased a designer purse five years ago for $60. The total nominal return on her investment is _____ but the real return is only ______.

How much will the annuity cost her : If the first $80,000 payment is received today, and if the annual discount rate is 8%, how much will the annuity cost her?

Annually with monthly compounding : If he earns 10% interest annually with monthly compounding, how much money will he have at the end of 20 years if he starts saving today?

What is the stock price if the annual discount rate : What is the stock’s price if the annual discount rate (required return) is 15% with quarterly compounding?

User Account

All Pages