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.

Principles of Economics 2e
2nd Edition
ISBN:9781947172364
Author:Steven A. Greenlaw; David Shapiro
Publisher:Steven A. Greenlaw; David Shapiro
ChapterA: The Use Of Mathematics In Principles Of Economics
Section: Chapter Questions
Problem 3RQ: Exercise A3 What dome slices of a pie chart represent?
icon
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.

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
E88
Flash
Text to
Remove Data Consolidate Relationships Manage
Columns Fill Duplicates Validation
Data Model
CE
A
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
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 E88 Flash Text to Remove Data Consolidate Relationships Manage Columns Fill Duplicates Validation Data Model CE A 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
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Economics 2e
Principles of Economics 2e
Economics
ISBN:
9781947172364
Author:
Steven A. Greenlaw; David Shapiro
Publisher:
OpenStax