15 Feb A new merchandise item in the store has no historical sales data. Since the demand for this item is price sensitive, the store manager is interested in figuring out what price will

5
A new merchandise item in the store has no historical sales data. Since the demand for this item is price sensitive, the store manager is interested in figuring out what price will break even or make a profit. Simulating sales can help you realize the minimum number of items you need to sell in order to cover costs, given different price tags the store manager will put on the item. Price can vary between $10 and $20. Between 20 and 100 units are expected to sell within the first month. The fixed costs of monthly sales estimated to be $1,000 and variable cost per item is $5. Use this data file Download this data fileto simulate all possible combinations of price and units sold. Use proper cell referencing to enter one formula and copy it into the entire table. Do not use numbers in formulas. Use only cell references! Create a copy your worksheet in the same workbook. Name this worksheet “Protected”. Protect this sheet using password 123. Allow users to select and change prices and the number of units sold, but not any formulas. Save and submit this file for grading. Assignment 1 Rubric: Item Points Absolute reference to fixed cost and cost/item 4 Mixed references are correct 4 Worksheet copied and only formula cells protected 2 Total 10