Use goal seek to compute the number of item x that must be


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:

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Use goal seek to compute the number of item x that must be
Reference No:- TGS02862067

Expected delivery within 24 Hours