産業連関表-産業連関表分析ファイル-2015年(平成27年)_202406訂正版.xlsx
|
経済波及効果の計算(40部門表による第2次波及効果まで) |
|
|
|
|
|
|
目次へ戻る |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(移輸出が増減する場合) |
|
|
|
|
|
|
波及効果分析フロー図 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
下記49行以降参照 |
|
消費パターン |
|
|
|
|
|
雇用表 |
|
|
雇用表 |
|
|
|
入力箇所
A(所得増減額)
H(消費転換率) |
移輸出
増減額
(億円) |
生産誘
発係数
(移輸出) |
第1次生産誘発額 |
粗付加価値率 |
雇用者所得率 |
第1次粗付加価値誘発額 |
第1次雇用者所得誘発額 |
消費転換率 |
第2次消費支出増減額 |
生産誘発係数(民間消費支出) |
第2次生産誘発額 |
第2次粗付加価値誘発額 |
第2次雇用者所得誘発額 |
生産誘発額合計 |
|
従業者係数 |
第1次従業者誘発数 |
第2次従業者誘発数 |
雇用者係数 |
第1次雇用者誘発数 |
第2次雇用者誘発数 |
|
|
A |
B |
C=A×B |
D |
E |
F=C×D |
G=C×E |
H |
I=G×H |
J |
K=I×J |
L=K×D |
M=K×E |
C+K |
|
N |
C×N |
K×N |
P |
C×P |
K×P |
1 |
農業 |
0 |
0.08414729570751703 |
0 |
0.5668594230486053 |
0.09421650530123132 |
0 |
0 |
0.7243 |
0 |
0.011060505891934592 |
0 |
0 |
0 |
0 |
|
0.289048 |
0 |
0 |
0.036337 |
0 |
0 |
2 |
畜産 |
|
0.033844849791739996 |
0 |
0.1825799210465206 |
0.0574057589596718 |
0 |
0 |
|
|
0.005421494326339141 |
0 |
0 |
0 |
0 |
|
0.05846 |
0 |
0 |
0.017368 |
0 |
0 |
3 |
林業 |
|
0.004962238936370708 |
0 |
0.6689147125959742 |
0.2661340527080307 |
0 |
0 |
|
|
0.0007962512905756688 |
0 |
0 |
0 |
0 |
|
0.102511 |
0 |
0 |
0.090371 |
0 |
0 |
4 |
漁業 |
|
0.02115778814035914 |
0 |
0.5594508040337967 |
0.17278209321340965 |
0 |
0 |
|
|
0.0017028508571121888 |
0 |
0 |
0 |
0 |
|
0.139207 |
0 |
0 |
0.056623 |
0 |
0 |
5 |
鉱業 |
|
0.006043140805072438 |
0 |
0.4186459848117628 |
0.17504174072278775 |
0 |
0 |
|
|
0.0007745273685292358 |
0 |
0 |
0 |
0 |
|
0.040071 |
0 |
0 |
0.03964 |
0 |
0 |
6 |
飲食料品 |
|
0.1446973070616753 |
0 |
0.23218386401316113 |
0.11289955285409338 |
0 |
0 |
|
|
0.038725681861750405 |
0 |
0 |
0 |
0 |
|
0.040975 |
0 |
0 |
0.038108 |
0 |
0 |
7 |
繊維製品 |
|
0.023163393382511156 |
0 |
0.6107152893723241 |
0.3925082240920437 |
0 |
0 |
|
|
0.00035134503402800543 |
0 |
0 |
0 |
0 |
|
0.100921 |
0 |
0 |
0.09368 |
0 |
0 |
8 |
パルプ・紙・木製品 |
|
0.05082717357833394 |
0 |
0.16092416262356332 |
0.06819655968658382 |
0 |
0 |
|
|
0.0027483723988694607 |
0 |
0 |
0 |
0 |
|
0.02948 |
0 |
0 |
0.022326 |
0 |
0 |
9 |
化学製品 |
|
0.011081587548288195 |
0 |
0.6202552517890709 |
0.11390693532961778 |
0 |
0 |
|
|
0.0002725934539323628 |
0 |
0 |
0 |
0 |
|
0.0155 |
0 |
0 |
0.01517 |
0 |
0 |
10 |
石油・石炭製品 |
|
0.0009639899679832597 |
0 |
0.36547275505007637 |
0.08827024274316754 |
0 |
0 |
|
|
0.0009757165628245954 |
0 |
0 |
0 |
0 |
|
0.018163 |
0 |
0 |
0.018163 |
0 |
0 |
11 |
プラスチック・ゴム製品 |
|
0.0038007200917188257 |
0 |
0.3739072944979064 |
0.2308087857195328 |
0 |
0 |
|
|
0.0007589464873898707 |
0 |
0 |
0 |
0 |
|
0.112099 |
0 |
0 |
0.100933 |
0 |
0 |
12 |
窯業・土石製品 |
|
0.009172978575370104 |
0 |
0.43262924133656977 |
0.1861540050611992 |
0 |
0 |
|
|
0.0005018092652970124 |
0 |
0 |
0 |
0 |
|
0.058152 |
0 |
0 |
0.054227 |
0 |
0 |
13 |
鉄鋼 |
|
0.056957968112544395 |
0 |
0.33146248024218394 |
0.04001125190880596 |
0 |
0 |
|
|
4.130058554171889e-05 |
0 |
0 |
0 |
0 |
|
0.009919 |
0 |
0 |
0.008881 |
0 |
0 |
14 |
非鉄金属 |
|
0.14127295964466421 |
0 |
0.7754821734417792 |
0.11413299795629618 |
0 |
0 |
|
|
2.7706369420763225e-05 |
0 |
0 |
0 |
0 |
|
0.008627 |
0 |
0 |
0.008627 |
0 |
0 |
15 |
金属製品 |
|
0.010400984582692984 |
0 |
0.4317111913357401 |
0.2796823104693141 |
0 |
0 |
|
|
0.00028380707517041185 |
0 |
0 |
0 |
0 |
|
0.094036 |
0 |
0 |
0.080173 |
0 |
0 |
16 |
はん用機械 |
|
0.001653804471983368 |
0 |
0.4493919183993723 |
0.2848175755198117 |
0 |
0 |
|
|
1.2600407789783367e-05 |
0 |
0 |
0 |
0 |
|
0.066889 |
0 |
0 |
0.061004 |
0 |
0 |
17 |
生産用機械 |
|
0.01013005356858442 |
0 |
0.44720659426926596 |
0.25353264424964017 |
0 |
0 |
|
|
5.039750986768231e-05 |
0 |
0 |
0 |
0 |
|
0.066106 |
0 |
0 |
0.06362 |
0 |
0 |
18 |
業務用機械 |
|
0.04362532769891201 |
0 |
0.3082168601306305 |
0.1755135537581644 |
0 |
0 |
|
|
0.00013970973312433027 |
0 |
0 |
0 |
0 |
|
0.041042 |
0 |
0 |
0.040196 |
0 |
0 |
19 |
電子部品 |
|
0.07612571355268953 |
0 |
0.2579116534118459 |
0.17835273652482092 |
0 |
0 |
|
|
0.0006523754404743908 |
0 |
0 |
0 |
0 |
|
0.032256 |
0 |
0 |
0.031177 |
0 |
0 |
20 |
電気機械 |
|
0.018268679305322087 |
0 |
0.4000114087961819 |
0.22901256869046036 |
0 |
0 |
|
|
0.0009071617564886596 |
0 |
0 |
0 |
0 |
|
0.0467 |
0 |
0 |
0.045217 |
0 |
0 |
21 |
情報通信機器 |
|
0.0005874125169402132 |
0 |
0.6635570878118028 |
0.39282092881768405 |
0 |
0 |
|
|
0.00031972595796964836 |
0 |
0 |
0 |
0 |
|
0.085378 |
0 |
0 |
0.083756 |
0 |
0 |
22 |
輸送機械 |
|
0.016285405566945098 |
0 |
0.31307539441132337 |
0.16017763718213895 |
0 |
0 |
|
|
0.00048110159163033777 |
0 |
0 |
0 |
0 |
|
0.029424 |
0 |
0 |
0.027599 |
0 |
0 |
23 |
その他の製造工業製品 |
|
0.005897782404488951 |
0 |
0.4480333514591263 |
0.25484864962842124 |
0 |
0 |
|
|
0.0028259221376093673 |
0 |
0 |
0 |
0 |
|
0.140692 |
0 |
0 |
0.104441 |
0 |
0 |
24 |
建設 |
|
0.005067272163027507 |
0 |
0.477944538438683 |
0.361285286968088 |
0 |
0 |
|
|
0.00407593065614444 |
0 |
0 |
0 |
0 |
|
0.103694 |
0 |
0 |
0.094548 |
0 |
0 |
25 |
電力・ガス・熱供給 |
|
0.031105063340177874 |
0 |
0.4025081598620904 |
0.08918341126416446 |
0 |
0 |
|
|
0.03426122838823721 |
0 |
0 |
0 |
0 |
|
0.010405 |
0 |
0 |
0.010405 |
0 |
0 |
26 |
水道 |
|
0.002834074366006228 |
0 |
0.5118303728147159 |
0.14247934657960637 |
0 |
0 |
|
|
0.011923289883902826 |
0 |
0 |
0 |
0 |
|
0.028669 |
0 |
0 |
0.028669 |
0 |
0 |
27 |
廃棄物処理 |
|
0.001805413744674727 |
0 |
0.6158226461927823 |
0.4459640328036405 |
0 |
0 |
|
|
0.004524623304640535 |
0 |
0 |
0 |
0 |
|
0.095807 |
0 |
0 |
0.093349 |
0 |
0 |
28 |
商業 |
|
0.20544220895726542 |
0 |
0.6671211912604187 |
0.39356446129568634 |
0 |
0 |
|
|
0.06846846707562412 |
0 |
0 |
0 |
0 |
|
0.137826 |
0 |
0 |
0.121719 |
0 |
0 |
29 |
金融・保険 |
|
0.020992890052766815 |
0 |
0.6647275540372861 |
0.31004610977496594 |
0 |
0 |
|
|
0.07207873137722648 |
0 |
0 |
0 |
0 |
|
0.053359 |
0 |
0 |
0.050472 |
0 |
0 |
30 |
不動産 |
|
0.010441738437380575 |
0 |
0.8538593449843039 |
0.03903668650142904 |
0 |
0 |
|
|
0.20211940013809457 |
0 |
0 |
0 |
0 |
|
0.011552 |
0 |
0 |
0.007011 |
0 |
0 |
31 |
運輸・郵便 |
|
0.11139372025602712 |
0 |
0.49554509652462053 |
0.31754412275277494 |
0 |
0 |
|
|
0.047591172809132345 |
0 |
0 |
0 |
0 |
|
0.065849 |
0 |
0 |
0.063751 |
0 |
0 |
32 |
情報通信 |
|
0.029960544937637227 |
0 |
0.506854352492453 |
0.11709269410688172 |
0 |
0 |
|
|
0.03731568488346041 |
0 |
0 |
0 |
0 |
|
0.025964 |
0 |
0 |
0.02442 |
0 |
0 |
33 |
公務 |
|
0.0020719470478053744 |
0 |
0.6817676652679743 |
0.34789626906938165 |
0 |
0 |
|
|
0.002129292524944197 |
0 |
0 |
0 |
0 |
|
0.045815 |
0 |
0 |
0.045815 |
0 |
0 |
34 |
教育・研究 |
|
0.004293205816356341 |
0 |
0.7669070775607618 |
0.553483385742357 |
0 |
0 |
|
|
0.02445534320151232 |
0 |
0 |
0 |
0 |
|
0.074245 |
0 |
0 |
0.073961 |
0 |
0 |
35 |
医療・福祉 |
|
0.00022197008658605697 |
0 |
0.6074015094288261 |
0.49488441096207375 |
0 |
0 |
|
|
0.06358520352054374 |
0 |
0 |
0 |
0 |
|
0.105313 |
0 |
0 |
0.101993 |
0 |
0 |
36 |
他に分類されない会員制団体 |
|
0.002376222884488144 |
0 |
0.5384297389258117 |
0.4708557255064076 |
0 |
0 |
|
|
0.008806639076400164 |
0 |
0 |
0 |
0 |
|
0.189112 |
0 |
0 |
0.176805 |
0 |
0 |
37 |
対事業所サービス |
|
0.06054934876583139 |
0 |
0.5929311785648486 |
0.3420934620934621 |
0 |
0 |
|
|
0.04805943384483033 |
0 |
0 |
0 |
0 |
|
0.105854 |
0 |
0 |
0.090545 |
0 |
0 |
38 |
対個人サービス |
|
0.02722219654258295 |
0 |
0.521754770314741 |
0.25445237111679436 |
0 |
0 |
|
|
0.12187415559024514 |
0 |
0 |
0 |
0 |
|
0.158408 |
0 |
0 |
0.122965 |
0 |
0 |
39 |
事務用品 |
|
0.0014940560092758786 |
0 |
0 |
0 |
0 |
0 |
|
|
0.0011853368935247008 |
0 |
0 |
0 |
0 |
|
0 |
0 |
0 |
0 |
0 |
0 |
40 |
分類不明 |
|
0.008402190175456153 |
0 |
0.4039973578231872 |
0.0123585689629456 |
0 |
0 |
|
|
0.0035003483290920526 |
0 |
0 |
0 |
0 |
|
0.005625 |
0 |
0 |
0.005625 |
0 |
0 |
|
合計 |
|
|
0 |
|
|
0 |
0 |
|
0 |
|
0 |
0 |
0 |
0 |
|
|
0 |
0 |
|
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
生産額 |
|
|
|
(単位:億円) |
|
|
|
(参考)青森市平均消費性向 -家計調査から- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
結 果 |
直接効果及び
第1次波及効果 |
|
第2次
波及効果 |
合計 |
|
|
H27 |
0.7145776757468014 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
H28 |
0.7294036045756311 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
H29 |
0.7426601822299584 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
生産誘発額 |
|
0 |
0 |
0 |
|
|
H30 |
0.7164507015824698 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
粗付加価値誘発額 |
|
0 |
0 |
0 |
|
|
H31/R1 |
0.7184311168068268 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
雇用者所得誘発額 |
|
0 |
0 |
0 |
|
|
R2 |
0.6129042912284024 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
'5年(H27~R1)平均 |
0.7243046561883375 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
(消費支出/可処分所得) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
従業者数・雇用者数 |
|
|
|
(単位:人) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
結 果 |
直接効果及び
第1次波及効果 |
|
第2次
波及効果 |
合計 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
従業者増加人数 |
|
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
雇用者増加人数 |
|
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
これは名目成長率の |
|
0 |
に相当します(初期値は、令和2年度公表の平成30年度県内総生産(名目)4兆3,744億円を基準)。 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|