Question: Data Table - TWO INPUT: orders and Price 1000 1050 Prices 17 18 17000 18000 17850 18900 18700 19800 19550 20700 20400 21600 1100 1150

Data Table - TWO INPUT: orders and Price 1000

Data Table - TWO INPUT: orders and Price 1000 1050 Prices 17 18 17000 18000 17850 18900 18700 19800 19550 20700 20400 21600 1100 1150 1200 1250 1300 1350 1400 1450 15 15000 15750 16500 17250 18000 18750 19500 20250 21000 21750 22500 23250 24000 24750 25500 16 16000 16800 17600 18400 19200 20000 20800 21600 22400 23200 24000 24800 25600 26400 27200 21250 22100 22950 23800 24650 25500 26350 27200 28050 28900 22500 23400 24300 25200 26100 27000 27900 28800 29700 19 19000 19950 20900 21850 22800 23750 24700 25650 26600 27550 28500 29450 30400 20 20000 21000 22000 23000 24000 25000 26000 27000 28000 29000 30000 31000 32000 33000 34000 1500 1550 1600 1650 1700 31350 32300 30600 ii. Use the VLOOKUP function to find profit when 1250 and 1600 t-shirts are ordered and sold for $17 per shirt. Order Profit 1250 21250 1600 27200 Question 3 - Goal Seek i. Using the Goal Seek function, how many t-shorts should be ordered to make profits below? In the Goal Seek Status window, DO NOT click OK. Take note of the recalculated order, click Cancel and record the order in the space below. Profit Order $0 $10,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!