Docstoc

Manufacturing Dashboard

Document Sample
Manufacturing Dashboard Powered By Docstoc
					Jul

Utah
Annual Average Production: 175,000

Quantity Produced by Month

Quantity Produced by Plant Location
250,000

Philedelphia Florida Vermont Utah Chicago Washington Texas
0.00 50,000.00 100,000.00 150,000.00 200,000.00 250,000.00

200,000

150,000
100,000 50,000

0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Quantity Produced/Month and Sold by Plant Location

Production Returns/Month by Plant Location

3,000,000
2,500,000 2,000,000 Philedelphia Florida

1,500,000
1,000,000 500,000

Vermont
Utah Chicago Washington Texas

0

0

500

1000

1500

2000

Quantity of Chips Sold Quantity of Chips Produced

Utah

Annual Average Production:

9,950,000

No. of Employees by Plant Location
140,000

No. of Employees by Average Salary

120,000 Philedelphia Florida Vermont Utah Chicago Washington Texas
0 50 100 150 200 250 300

100,000
90,000

80,000 70,000
65,000

60,000

Total Employee Salaries/Year by Plant Location

55,000
50,000

45,000 Philedelphia Florida
Vermont

40,000
35,000

Utah Chicago
Washington Texas 0 5,000,000 10,000,000 15,000,000 20,000,000

30,000 25,000 0 5 10 15 20 25 30

Total Yearly Sales

Philedelphia Florida Vermont Utah Chicago Washington Texas 0% 20% 40% 60% 80% 100%

Philedelphia Vermont Chicago Texas 0 10 20 30 40 50 60 70 80

Millions

Profit Expense

Profit/Year by Plant Location
18,000,000 16,000,000

Expenses per Year

14,000,000
12,000,000 Philedelphia 10,000,000

Florida
Vermont Utah

8,000,000
6,000,000 4,000,000

Chicago
Washington Texas

2,000,000
0

0

20,000,000

40,000,000

60,000,000

80,000,000

Salaries Material Other

1 TABLE A 25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 80,000 90,000 100,000 120,000 140,000 Number Total Salary TABLE B Production Return by Plant/Month TABLE C January February March April May June July August September October November December Total Texas 11 15 18 20 30 45 36 30 22 19 11 8 6 4 2 277 15,255,000 Texas 1850 Texas 150,000 160,000 170,000 180,000 190,000 200,000 210,000 220,000 220,000 220,000 220,000 260,000 2,400,000

2 Washington 8 9 10 15 13 10 13 11 8 6 5 4 2 3 1 118 6,280,000 Washington 645 Washington 120,000 110,000 108,000 105,000 99,000 98,000 90,000 90,000 90,000 90,000 90,000 90,000 1,180,000

3 Chicago 9 12 17 22 13 15 10 13 15 12 8 5 3 2 1 157 8,310,000 Chicago 700 Chicago 65,000 60,000 65,000 70,000 75,000 80,000 75,000 80,000 85,000 80,000 85,000 80,000 900,000

4 Utah 8 9 22 21 25 12 15 25 18 9 7 6 4 2 2 185 9,950,000 Utah 1040 Utah 200,000 175,000 150,000 160,000 165,000 165,000 170,000 175,000 180,000 185,000 195,000 180,000 2,100,000

4 Utah 8 9 22 21 25 12 15 25 18 9 7 6 4 2 2 185 9,950,000 Utah 1040 Utah 200,000 175,000 150,000 160,000 165,000 165,000 170,000 175,000 180,000 185,000 195,000 180,000 2,100,000

5 Vermont 9 4 14 15 25 29 32 25 23 11 6 4 3 2 1 203 11,055,000 Vermont 820 Vermont 100,000 110,000 120,000 130,000 140,000 150,000 160,000 150,000 150,000 150,000 140,000 130,000 1,630,000

6 Florida 7 14 16 27 31 29 18 14 8 3 4 2 2 1 1 177 8,600,000 Florida 500 Florida 140,000 130,000 120,000 110,000 100,000 90,000 80,000 70,000 65,000 65,000 65,000 65,000 1,100,000

7 Philedelphia 2 3 4 6 9 12 15 13 12 10 5 3 2 1 1 98 5,740,000 Philedelphia 940 Philedelphia 65,000 64,000 65,000 66,000 65,000 68,000 65,000 65,000 66,000 65,000 66,000 65,000 785,000

8

9

10

Chart Data 12 1 1 1 1 1 1 1 1 1 1 1 1 4 Quantity of Chips Chips Produced Quantity of Sold Facility Texas #### Texas #### #### Jan #### #### Texas 1850 Texas WashingtonWashington#### Feb #### #### WashingtonWashington #### #### 645 Chicago #### Chicago #### #### Mar #### #### Chicago 700 Chicago Utah #### Utah #### #### Apr #### #### Utah 1040 Utah Vermont Vermont #### May #### #### Vermont Vermont #### #### 820 Florida #### Florida #### #### Jun #### #### Florida 500 Florida PhiledelphiaPhiledelphia#### Jul #### #### PhiledelphiaPhiledelphia #### #### 940 0 0 Aug #### #### 0 0 0 Sep #### #### 0 0 0 Oct #### #### 0 Nov #### #### Dec #### #### Total
7 7

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

4 Nb of Emp #### Profit Expense Salaries Material Other 277 #### 8 Texas #### Texas #### #### Texas #### Texas 29.3 Texas #### #### #### 118 #### 9 WashingtonWashington#### WashingtonWashingtonWashington#### #### #### #### #### 15.3 #### 157 #### 22 Chicago #### Chicago #### #### Chicago #### Chicago8.9 Chicago 1 #### #### #### 185 #### 21 Utah #### Utah #### #### Utah #### Utah 27.3 Utah #### #### #### 203 #### 25 Vermont Vermont #### Vermont Vermont Vermont #### #### #### #### #### 22.8 #### 177 #### 12 Florida #### Florida #### #### Florida #### Florida13.2 Florida #### #### #### 98 #### 15 PhiledelphiaPhiledelphia#### PhiledelphiaPhiledelphiaPhiledelphia#### #### #### #### #### 72.2 #### #### 25 #### #### 18 #### #### 9 #### #### 7 #### 6 #### 4 #### 2 #### 2

Other

Follow the steps to enable your Manufacturing Dashboard.
>> >> TRUE 1) This template is prepared for analyzing the manufacturing performances of facilities. If you need to use the dashboard, check the box:
Online Use

Enter the name of the product that is sold:

Chips
2) Enter the names of your facilities (you may add up to 10): 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 3)

Texas Washington Chicago Utah Vermont Florida Philedelphia

Enter the values to classify your employees with respect to their salaries. You may use a range method or average method. Check the one

####
0. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15.

2

Salary Ranges

0 25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 80,000 90,000 100,000 120,000 140,000

to to to to to to to to to to to to to to to to

25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 80,000 90,000 100,000 120,000 140,000 ∞

4)

Use Table A in the 'Data' sheet to enter the number of employees included in each salary average.

5) 6) 7)

Use Table B to in the 'Data' sheet to enter the production return quantity by plant/month. Use Table C to in the 'Data' sheet to enter the monthly production quantities for each facility. Enter the Revenue factor (unit price) and Monthly Other Expense factor for each facility. (Revenue will be calculated as factor times number of units produced/sold) (Other Expense will be calculated as factor times 12 times monthly production quantity)

Facility
1. 2. 3. 4. 5. 6. 7. 8. 9. 10.

Unit Price 12.20 13.00 21.00 13.00 14.00 12.00 92.00

Other Exp.Factor 1.00 1.00 1.10 1.70 2.30 0.90 1.30

Texas Washington Chicago Utah Vermont Florida Philedelphia

8)

Enter fixed yearly Material Expenses for each facility:

Facility
1. 2. 3. 4. 5. 6. 7. 8. 9. 10.

Mat.Exp. 4,400,000 6,000,000 8,300,000 4,200,000 3,210,000 2,100,000 3,800,000

Texas Washington Chicago Utah Vermont Florida Philedelphia

>> 9)

Your Manufacturing Dashboard is ready to use. Following steps are for online use. Visit the site below:

http://www.spreadsheetweb.com/getting_started.htm
You will only need the username and password to create your Manufacturing Dashboard. 10) Visit the site below:

http://trial.spreadsheetweb.com/spreadsheetweb/
Login to page with your new account information. 11) >> >> Click "Add Web Application" to upload this file. Your Manufacturing Dashboard will be created automatically. You can simply use the Manufacturing Dashboard from that link or place it on your website. Your Manufacturing Dashboard will look like: In order to see more online applications created with SpreadsheetWEB you can check the link below:

http://www1.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=ca15da36-0d37-47f0-b88e-f1

http://www.spreadsheetweb.com/demos.htm

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

board.

e a range method or average method. Check the one you prefer and enter the values:
Salary Averages

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15.

25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 70,000 80,000 90,000 100,000 120,000 140,000

Other Exp.Factor 1.00 1.00 1.10 1.70 2.30 0.90 1.30

e created automatically.

pplicationId=ca15da36-0d37-47f0-b88e-f1a4b9efdb67

Texas Washington Chicago Utah Vermont Florida Philedelphia