Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A new merchandise item in the store has no historical sales data. Since the demand for this item is price sensitive , the store manager

A new merchandise item in the store has no historical sales data. Since the demand for this item is price sensitive, the store manager has asked you to figure 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 the different price tags the store manager will put on the item.
Prices for this new item vary between $10 and $110. Between 25 and 105 units are expected to sell within the first month. The fixed costs of monthly sales are estimated to be $1,300, and the variable cost per item is $12. Use this data file darr to simulate all possible combinations of price and units sold. Use proper cell referencing to enter one formula (the profit formula) and copy it throughout the entire table. Do not use numbers in formulas. Use only cell references!
Next, after you've completed the table, create a copy of the worksheet in the same workbook. Title the copied sheet "Protected." Finally, protect this sheet using password 123?.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Issues In Database Design And Information Systems Development

Authors: Keng Siau

1st Edition

1599042894, 978-1599042893

More Books

Students also viewed these Databases questions