Spreadsheet: 145705d1331719402-autofill-across-worksheets-indirect
Sheet: Y4Q1

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 4 | Quarter= | 1
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 370 |  | 360 |  | 350
Advertising ($1,000/Qtr.) |  |  | 400 |  | 380 |  | 410
Sales Force Change (No.) |  |  | 1 |  | 4 |  | 3
Product R&D ($1,000/Qtr.) |  | 500
Sales Commision (%) |  | 3.01
Profit Sharing (%) |  | 5.01
Sales Salaries ($/Month) |  | 1650
[NAME] ($1,000/Qtr.) |  | 250
[NAME] ($1,000/Qtr.) |  | 250
Production Wages ($/Hour) |  | 6.3
Production Scheduled (Hours/week) |  | 45
Labor Force Change (No.) |  | 601
Allocation To Markets (%) |  |  | 31 |  | 33 |  | 36
Process R&D ($1,000/Qtr.) |  | 500
Raw Material Ordered (Million lbs.) |  | 10
Bonds Sold or Redeemed ($1,000) |  | -2000
Bank Loan Requested ($1,000) |  | 0
[NAME] ($1,000) |  | 0
Stocks Issued (1,000 Shares) |  | 0
Savings Account ($1,000) |  | 2000
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 5316.157452667463
PRODUCTIVITY (Units/Production-Hr.) |  | 0.0837822175330051
RAW MAT. [NAME] (Lbs./Unit) |  | 178.4844101677728
PRODUCTION OUTPUT  (No. Units) |  |  | 69473.8548220776 |  | 73956.03900414713 |  | 80679.31527725141 |  | 224109.2091034761
FIN. PROD. INVENTORY   (No. Units) |  |  | 27014.51612925251 |  | 23111.06610072989 |  | 29557.81600744343 |  | 79683.39823742583
RAW MAT.INVENTORY (Million Lbs.) |  | 10
[NAME]  (No. Units) |  |  | 42851.57258885018 |  | 50844.97290341723 |  | 51121.49926980799 |  | 144818.0447620754
SALES   (No. Units) |  |  | 42851.57258885018 |  | 50844.97290341723 |  | 51121.49926980799 |  | 144818.0447620754
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 15855.08185787457 |  | 18304.19024523021 |  | 17892.52474443279 |  | 52051.79684753757
SALESPEOPLE ACTIVE  (No.) |  |  | 28 |  | 20 |  | 22 |  | 70
SALES TRAINEES  (No.) |  |  | 1 |  | 4 |  | 3 |  | 8
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 20437.87549618835 |  | ADVERTISING | 1190 |  |  | R & D | 1000
MATERIAL | 16800 |  | SALARIES | 386.1 |  |  | CARRYING - FIN. PROD. | 1.568935584100371
MAINTENANCE | 3065.681324428253 |  | COMMISSIONS | 1566.759085110881 |  |  | CARRYING - RAW. Mat. | 160
TRAINING | 250 |  | TRANSPORTATION | 2036.772104978488 |  |  | BOND INTEREST | 850
PROD. LEVEL CHANGE | 601.8 |  | ADMINISTRATIVE | 3004.090223810377 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1680 |  | SALES FORCE CHANGE | 66 |  |  | ADMINISTRATIVE | 5202.074322514788
ADMINISTRATIVE | 1687.46656446175 |  | TRAINING | 250 |  |  | BOND CALL PREMIUM | 120
[NAME] | 480.5687189929301
TOTAL | 45003.39210407129 |  | TOTAL | 8499.721413899746 |  |  | TOTAL | 7333.643258098889
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 52051.79684753756 |  | ACCOUNTS COLLECTED | 52858.20029962741 |  |  | CASH BALANCE | 31448.30269486112
BEGINNING INVENTORY | 92.3907798618545 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 17350.59894917918
TOTAL PRODUCTION COST | 45003.39210407129 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 16001.23095971479
GOODS AVAILABLE | 45095.78288393314 |  | SAV. ACCOUNT INT. | 300 |  |  | INVENTORY - RAW MAT | 4900
ENDING INVENTORY | 16001.23095971479 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 17000
COST OF GOODS SOLD | 29094.55192421835 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 86700.13260375508
GROSS PROFIT | 22957.24492331921 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 35546.89877826656 |  |  | PLANT & EQUIP. VALUE | 48479.00318030007
TOTAL MARKETING COST | 8499.721413899746 |  | TOTAL SOURCES | 88705.09907789397 |  |  | TOTAL ASSETS | 135179.1357840552
PROFIT ON SALES | 14457.52350941946
 |  |  | TOTAL PRODUCTION COST | 32622.82338507836 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 7333.643258098889 |  | TOTAL MARKETING COST | 8499.721413899746
TOTAL OTHER INCOME | 300 |  | TOTAL OTHER COST | 7333.643258098889 |  |  | BONDS OUTSTANDING | 32000
NET PROFIT BEFORE TAXES | 7423.880251320571 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 3711.940125660286 |  | BONDS REDEEMED | 2000 |  |  | ACCUM. RET. EARNINGS | 39319.73578405516
 |  |  | INCOME TAXES | 3711.940125660286 |  |  | TOTAL STOCK EQUITY | 103179.1357840552
NET PROFIT AFTER TAXES | 3711.940125660286 |  | PROFIT SHARING | 185.9682002955803 |  |  | TOTAL LIABILITIES | 135179.1357840552
PROFIT SHARING COST | 185.9682002955803 |  | PLANT & EQUIP. INVEST. | 902.7
 |  |  | SAVINGS ACCT. DEPOSIT | 2000
NET INCOME | 3525.971925364705 |  | TOTAL DISBURSEMENTS | 57256.79638303286
DIVIDENDS PAID | 0
[NAME] | 3525.971925364705 |  | CASH AVAILABLE | 31448.30269486112
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 31448.30269486112
5.  Economy and Stockmarket Report
Gross Domestic Product | 169 | $ Billions
Personal Consumption Expenditures | 17 | $ Billions
No. of [NAME] | 299 | 1000's
Raw Material Cost | 0.46 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.56923333333334 | 1.861450253196863 | 1 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 2.206961523655307 | 0 | 6000 | 10 | 13
Co.3 Name | 10.63323333333333 | 1.620335903042782 | 0 | 6000 | 10 | 13
Co.4 Name | 10.65833333333334 | -0.1448604744810133 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 0.4837776780789355 | 0 | 6000 | 16 | 19
Co.6 Name | 10.65821569295067 | 1.696629279653956 | 0 | 6020 | 13 | 16
[NAME] | 10.64323333333333 | 0.5876619875607842 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333333 | 1.735637648493432 | 0 | 6000 | 10 | 13
6.  Industry Estimates Report
 | AVG. | AVERAGE | SALES | PROFIT | SALES | PROD. | PROD. | PROD. | SALES | UNIT
COMPANY | PRICE | ADVERTISING | COMMISION | SHARING | SALARIES | WAGES | FORCE | OUTPUT | FORCE | SALES
Co.1 Name | 404.6304801313959 | 493.6006464316835 | 3.114725261352867 | 4.814085050752182 | 1711.191687587552 | 6.270856583285637 | 3939.749895275921 | 235678.6894901129 | 81.0929642006725 | 186721.4563865123
Co.2 Name | 332.2633631882183 | 338.9314019059357 | 3.039183618911088 | 9.792749210963885 | 1657.007115197745 | 6.225381517305097 | 4904.410063954271 | 267063.0479503715 | 72.8140224049252 | 216576.603929534
Co.3 Name | 359.441365846602 | 482.7802904385142 | 2.558089949696551 | 4.588191693411111 | 1776.151544270309 | 5.742199923672507 | 4430.321224432088 | 276473.7689524482 | 68.96752836337298 | 165361.894363828
Co.4 Name | 369.323614179471 | 323.3936402724427 | 2.710794064766595 | 1.209114415965407 | 1551.447655415212 | 5.451022415277844 | 4470.605528883297 | 170674.8408239037 | 69.36823331153325 | 110457.5322099214
Co.5 Name | 361.5386961752174 | 371.6690651717786 | 2.927400723669038 | 3.137348430002955 | 1667.869211260231 | 5.829747337374946 | 3320.267261209057 | 152543.7912154692 | 50.91756829743302 | 140054.0363244505
Co.6 Name | 312.3987600678808 | 360.5104933926459 | 4.93489822555455 | 9.893339254421548 | 1520.760687671768 | 6.589312805871529 | 9521.649228378275 | 481993.8596204951 | 63.13239802268621 | 256865.2266762764
[NAME] | 372.0130826074675 | 406.4085536377241 | 3.029617143990844 | 5.130146279440233 | 1580.909661010031 | 6.423908974763796 | 5256.602224215195 | 224208.0955449203 | 70.77478506777392 | 142430.0401146368
Co.8 Name | 332.5654649487829 | 376.1476727281703 | 2.911760751762634 | 6.083019000743755 | 1644.430009035454 | 5.98107977024222 | 4219.613647552328 | 218946.0722734486 | 77.18382075251047 | 201629.4168352851