You will create your own worksheet in Excel for this assignment.

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

cover costs, given different price tags the store manager will put on the item.

Price can vary between $$10$ and $$50.$ Between $20$ and $180$ units are expected to sell within the first month. Flxed casts of monthly sales estimated

be $$1,250$ and cost per item is $$11.$ Build a table for this problem and simulate all possible combinations of price and units sold. Use proper cell

referencing to enter one formula and copy it to the entire table. For the number of units sold use $10$ unit increments $(20,30,40,50$dots, Properly label

all data entries. Do not use a number informulas. Use cell reference!