To
create a chart
What is a Chart?
A chart is
a diagram or an effective tool you use in Excel in exchange
graphically with data you
have in a given table.
Tuesday, September 17, 2019
Solve a problem with Excel Solver
Solve
a problem using Solver
|
||||||||||
Month
|
Q1
|
Q2
|
Q3
|
Q4
|
Total
|
|||||
Seasonality
|
0.9
|
1.1
|
0.8
|
1.2
|
||||||
Units
Sold
|
3,592
|
4,390
|
3,192
|
4,789
|
15,962
|
|||||
Sales
|
$143,662
|
$175,587
|
$127,700
|
$191,549
|
$638,498
|
Color
Code
|
||||
Cost
|
89,789
|
109,742
|
79,812
|
119,718
|
399,061
|
|||||
Gross
|
53,873
|
65,845
|
47,887
|
71,831
|
239,437
|
Target
|
||||
Salesforce
|
8,000
|
8,000
|
9,000
|
9,000
|
34,000
|
Changing
|
||||
Advertising
|
10,000
|
10,000
|
10,000
|
10,000
|
40,000
|
|||||
Overhead
|
21,549
|
26,338
|
19,155
|
28,732
|
95,775
|
Constraints
|
||||
Total
Costs
|
39,549
|
44,338
|
38,155
|
47,732
|
169,775
|
|||||
Prod.
Profit
|
$14,324
|
$21,507
|
$9,732
|
$24,099
|
$69,662
|
|||||
Profit
Margin
|
10%
|
12%
|
8%
|
13%
|
11%
|
|||||
Product
Price
|
$40.00
|
|||||||||
Product
Cost
|
$25.00
|
|||||||||
Solve a problem using Solver
values to maximize or minimize another price, enter and change constraints, and save a difficulty model.
Subscribe to:
Posts (Atom)