Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
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

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

Finance The Basics

Authors: Erik Banks

3rd Edition

1138919780, 9781138919785

More Books

Students also viewed these Accounting questions

Question

Experimental mortality: Did participants drop out during the study?

Answered: 1 week ago

Question

Please help me evaluate this integral. 8 2 2 v - v

Answered: 1 week ago

Question

=+d. Purchaser: buys the item.

Answered: 1 week ago