B G Goal Seek Status 1 PROBLEM 3: CALCULATE THE 'REQUIRED MORE SALES' OF A STORE KEEPING GOAL OF 'AVG SALES = $55000'. ( 2 3 Goal Seeking with Cell B18 4 MONTHLY TOTAL SALES OF A STORE 5 PRODUCTS SALES 6 APPLE $72,450 7 SAMSUNG $47,350 8 NOKIA $18,932 9 NIKON $37,540 10 CANON $53,123 11 SONY 12 PHILIPS 13 HITACHI 14 LENOVO 15 BENQ 16 IBM 17 REQUIRED MORE SALES 18 AVG SALE $77,899 $25,000 $64,350 $81,990 $15,430 $78,950 -335544.32| $52,092 20 21 2222 OK may not have found a solution. Target value: 55000 Cancel Current value: $52,092 Step Pause M

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question

How would this get solved? How would I goal seek? What formula would need to be used? I'm practicing formulas because  i'd like to get into finance at some point and I'm stuck on this practice question, 

B
G
Goal Seek Status
1
PROBLEM 3: CALCULATE THE 'REQUIRED MORE SALES' OF A STORE KEEPING GOAL OF 'AVG SALES = $55000'. (
2
3
Goal Seeking with Cell B18
4 MONTHLY TOTAL SALES OF A STORE
5
PRODUCTS
SALES
6 APPLE
$72,450
7
SAMSUNG
$47,350
8 NOKIA
$18,932
9 NIKON
$37,540
10 CANON
$53,123
11 SONY
12 PHILIPS
13 HITACHI
14 LENOVO
15 BENQ
16 IBM
17 REQUIRED MORE SALES
18 AVG SALE
$77,899
$25,000
$64,350
$81,990
$15,430
$78,950
-335544.32|
$52,092
20
21
2222
OK
may not have found a solution.
Target value: 55000
Cancel
Current value: $52,092
Step
Pause
M
Transcribed Image Text:B G Goal Seek Status 1 PROBLEM 3: CALCULATE THE 'REQUIRED MORE SALES' OF A STORE KEEPING GOAL OF 'AVG SALES = $55000'. ( 2 3 Goal Seeking with Cell B18 4 MONTHLY TOTAL SALES OF A STORE 5 PRODUCTS SALES 6 APPLE $72,450 7 SAMSUNG $47,350 8 NOKIA $18,932 9 NIKON $37,540 10 CANON $53,123 11 SONY 12 PHILIPS 13 HITACHI 14 LENOVO 15 BENQ 16 IBM 17 REQUIRED MORE SALES 18 AVG SALE $77,899 $25,000 $64,350 $81,990 $15,430 $78,950 -335544.32| $52,092 20 21 2222 OK may not have found a solution. Target value: 55000 Cancel Current value: $52,092 Step Pause M
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON