Write a paragraph to explain to your CEO that based on using regression analysis, through using the solver tool of excel, recalculate the optimum units to produced this month is 800 pro 200 mini to have the maximize revenue of $174,400.00. Explain what/why would it be if you make any changes in the units to stay within the constraints that you have it would produce less money. Screenshot attached
Write a paragraph to explain to your CEO that based on using regression analysis, through using the solver tool of excel, recalculate the optimum units to produced this month is 800 pro 200 mini to have the maximize revenue of $174,400.00. Explain what/why would it be if you make any changes in the units to stay within the constraints that you have it would produce less money. Screenshot attached
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Write a paragraph to explain to your CEO that based on using regression analysis, through using the solver tool of excel, recalculate the optimum units to produced this month is 800 pro 200 mini to have the maximize revenue of $174,400.00. Explain what/why would it be if you make any changes in the units to stay within the constraints that you have it would produce less money.
Screenshot attached
![File
LA From Access
From Web
From Text
F10
2
Home Insert Page Layout
3
From Other
Sources
Get External Data
5
A
4 Number to Make
⠀
6 Required Inputs
7 Labor Hours
8 Ship sets
X
10
11 Unit Profit
12
13
14
Formulas Data
Show Queries
From Table
##
New
Existing
Connections Query Recent Sources
Get & Transform
9 Electronic Components
fxx =B11*B4+C11*C4
Pro
B
с
D
Mini
800
200
Used
6
9
2000
1
1
15
10
$182.00 $139.00
Review
Connections
Properties
Refresh
All-Edit Links
Connections
E
View
6600 <=
1000 <=
14000 <=
F
Tell me what you want to do...
x Clear
Available
222
Sort
7000
1000
14000
TOTAL PROFIT $173,400.00
G
Filter
Sort & Filter
Reapply
Advanced
H
CE
A
E88
Flash
Text to
Remove Data Consolidate Relationships Manage
Columns Fill Duplicates Validation
Data Model
I
J
Data Tools
K
L
M
tott
BY
18:34
18+
What-If Forecast Group Ungroup Subtotal
Analysis Sheet
Forecast
ΣΓΕ
N
O
Outline
P
Sign in Share
?, Solver
Analyze
Q](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2e458219-0b63-4373-b31d-e4792f050f3b%2F48a929b6-7871-4ca2-9b83-579247b99bf7%2F6dea4vf_processed.png&w=3840&q=75)
Transcribed Image Text:File
LA From Access
From Web
From Text
F10
2
Home Insert Page Layout
3
From Other
Sources
Get External Data
5
A
4 Number to Make
⠀
6 Required Inputs
7 Labor Hours
8 Ship sets
X
10
11 Unit Profit
12
13
14
Formulas Data
Show Queries
From Table
##
New
Existing
Connections Query Recent Sources
Get & Transform
9 Electronic Components
fxx =B11*B4+C11*C4
Pro
B
с
D
Mini
800
200
Used
6
9
2000
1
1
15
10
$182.00 $139.00
Review
Connections
Properties
Refresh
All-Edit Links
Connections
E
View
6600 <=
1000 <=
14000 <=
F
Tell me what you want to do...
x Clear
Available
222
Sort
7000
1000
14000
TOTAL PROFIT $173,400.00
G
Filter
Sort & Filter
Reapply
Advanced
H
CE
A
E88
Flash
Text to
Remove Data Consolidate Relationships Manage
Columns Fill Duplicates Validation
Data Model
I
J
Data Tools
K
L
M
tott
BY
18:34
18+
What-If Forecast Group Ungroup Subtotal
Analysis Sheet
Forecast
ΣΓΕ
N
O
Outline
P
Sign in Share
?, Solver
Analyze
Q
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.