View the step-by-step solution to:

# MGT150B - Spring 2013 - Homework #6 MGT150B - Spring 2013 Homework #6 A few important notes A. There are practice problems with solutions on...

MGT150B - Spring 2013 - Homework #6 Develop a model in Excel to calculate total monthly profit for the chain. Specifically include the following: Calculate monthly revenue using an IF statement. The threshold for small or large store should be a parameter of your model. Develop a Custom Function to calculate monthly cost as a function of State and size. Calculate monthly profit per store At the bottom of the list calculate: o Total profit for all small stores o Total profit for all large stores o Total monthly profit for all stores. Using a One-way Data Table find the impact of a change in the revenue of small stores from the current value of \$10 per sq. ft. to each value in the range \$8 - \$18. For each revenue alternative identify (1) total profit for all small stores; (2) total profit for all large stores; (3) total monthly profit for the chain. Using a One-way Data Table to find the impact of a change in the revenue of large stores from the current value of \$20 per sq. ft. to each value in the range \$16 - \$26. For each revenue alternative identify (1) total profit for all small stores; (2) total profit for all large stores; (3) total monthly profit for the chain. Using a Two-way Data Table find the impact of a change in both the revenue of small stores from the current value of \$10 per sq. ft. to each value in the range \$7 - \$12 and in the revenue of large stores from the current value of \$20 per sq. ft. to each value in the range \$16 - \$26. For each alternative identify total monthly profit for the chain. Hint : it’s a bit easier if you have the values for the large stores along the left-most column, and small stores across the top row. [2]

Here is the explanation for... View the full answer

State State
Missouri
Oklahoma
Texas
Missouri
Missouri
Illinois
Texas
Arkansas
Illinois
Oklahoma
Illinois
Illinois
Missouri
Oklahoma
Arkansas
Arkansas
Oklahoma
Texas
Arkansas
Texas Store SizeType...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents