Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. 1. southwest clothing company, produces denim jean

1. Southwest Clothing Company, produces denim jeans, is planning to introduce a new line of lime...

60.1K

Verified Solution

Question

Advance Math

1. Southwest Clothing Company, produces denim jeans, is planningto introduce a new line of lime green jeans. Each pair of jeanscosts $5.50 for fabric and $3.00 for labor. Each pair will be soldfor $24.99 each. Fixed costs are estimated as $10,000 per month.Southwest intends to build an EXCEL model to explore the optionsfor production.

a. Set up a spreadsheet model to calculate total profit withproduction quantity as the decision variable - assumingthat Southwest will sell all of the jeans that areproduced.

b. Use the Excel tool Data/What-If Analysis/Goal Seekto determine the break-even quantity for the jeans.

c. Use the Excel tool Data/What-If Analysis/Data Tableto create a one-way table to demonstrate the sensitivity of profitto changes in selling price per pair of jeans

           Use prices of 21.99 23.99 25.99, 27.99 and 31.99 in yourtable.

d. Create a graph of the one-way table results.

Answer & Explanation Solved by verified expert
3.8 Ratings (700 Votes)
DollarsDollarsDollarsDollarsDollarsDollarsPrice Per Unit249921992399259927993199Units    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Algebra
1.2K views

Which answer represents the series in sigma notation 1 1 1024 4096 0 0 1...

Basic Math
1.2K views

Question 10 of 14 Step 1 of 1 College dining is considering opening a national...

Operations Management
1.2K views

Referring to Appendix B in the Kerin, et al. text, what potential marketing career appeals to...

General Management
1.2K views

The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of...

Biology
1.2K views

Question 71 Listen Creators of the Shake Weight a moving dumbbell claim that their product...

Algebra
1.2K views

56 40 56 40 Type an integer or a simplified fraction

Accounting
1.2K views

B2B Company is considering the purchase of equipment that would allow...

Accounting
1.2K views

1) If Nike, an American corporation, produces sneakers in Thailand this would count as part...

Accounting
1.2K views

Terrence Corporation plans to sell 33,000 units of its single product in March. The company...

Accounting
1.2K views

Help please increase the selling or administrative expenses. What is the unit cost...

Accounting
1.2K views

You would like to contribute to a savings account over the next three years in...

Finance
1.2K views

You have backtested the following strategies. Based on the performance evaluation, which of these strategies...