Answered step by step
Verified Expert Solution
Question
1 Approved Answer
confused on how to use goal seek for this problem F G H B c D E 1 Mickey Drexler's Worksheet 2 Numbers totally made
confused on how to use goal seek for this problem
F G H B c D E 1 Mickey Drexler's Worksheet 2 Numbers totally made up by Prof. G 3 4 Product Cost Manufactured Expenses Price 5 Purple Leather Pants $ 23.00 40,000 $ 920,000 $ 60.00 6 Jeans $ 14.00 40,000 $ 560,000 $ 29.95 7 T-Shirts $ 5.00 50,000 $ 250,000 $ 12.95 8 Sweatshirts $ 9.00 30,000 $ 270,000 $ 19.95 9 TOTAL $ 2,000,000 10 11 to break even, Gap would need to sell this number of Purple Leather Pants: Sold $ 32,000 $ 48,000 $ 20,000 $ $ Revenue $ 958,400 $ 621,600 $ 399,000 $ 1,979,000 $ Proft/Loss (920,000) 398,400 371,600 129,000 (21,000) Now, use Goal Seek to figure out exactly how many units of Purple Leather Pants Mickey Drexler needs to sell in order to break even (break even means the firm hasn't lost any money - $0 profits, but also $0 losses). If you set up Goal Seek properly, the result should show in cell F5 when you're done. Also enter this value, arrived at from Goal Seek, into cell F11 Save your work, and submit your final, complete workbook, containing the "Fortune 11" and "Pants Goal worksheets, via Canvas. F G H B c D E 1 Mickey Drexler's Worksheet 2 Numbers totally made up by Prof. G 3 4 Product Cost Manufactured Expenses Price 5 Purple Leather Pants $ 23.00 40,000 $ 920,000 $ 60.00 6 Jeans $ 14.00 40,000 $ 560,000 $ 29.95 7 T-Shirts $ 5.00 50,000 $ 250,000 $ 12.95 8 Sweatshirts $ 9.00 30,000 $ 270,000 $ 19.95 9 TOTAL $ 2,000,000 10 11 to break even, Gap would need to sell this number of Purple Leather Pants: Sold $ 32,000 $ 48,000 $ 20,000 $ $ Revenue $ 958,400 $ 621,600 $ 399,000 $ 1,979,000 $ Proft/Loss (920,000) 398,400 371,600 129,000 (21,000) Now, use Goal Seek to figure out exactly how many units of Purple Leather Pants Mickey Drexler needs to sell in order to break even (break even means the firm hasn't lost any money - $0 profits, but also $0 losses). If you set up Goal Seek properly, the result should show in cell F5 when you're done. Also enter this value, arrived at from Goal Seek, into cell F11 Save your work, and submit your final, complete workbook, containing the "Fortune 11" and "Pants Goal worksheets, via Canvas Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started