Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Question: A new merchandise item in the store has no historical sales data.Since the demand for this item is price sensitive, store manager is interested i...A new merchandise item in the store has no historical sales data. Since the demand for this item is price sensitive, 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 $20 and $30. Between 50 and 200 units are expected to sell within the first month. Fixed costs of monthly sales estimated to be $1.000 and cost per item is $15. 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 (50,60,70,200). Properly label all data entries. Do not use a number in formulas.Use cell reference!

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

Fundamentals Of Quality Control And Improvement

Authors: Amitava Mitra

4th Edition

1118705149, 978-1118705148

More Books

Students also viewed these General Management questions