Spreadsheet: 145687d1331710707-autofill-across-worksheets-sample-workbook
Sheet: Y5Q1

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 5 | Quarter= | 1
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 355 |  | 350 |  | 345
Advertising ($1,000/Qtr.) |  |  | 440 |  | 430 |  | 420
Sales Force Change (No.) |  |  | 0 |  | 0 |  | 0
Product R&D ($1,000/Qtr.) |  | 600
Sales Commision (%) |  | 3.9
Profit Sharing (%) |  | 5.21
Sales Salaries ($/Month) |  | 1750
[NAME] ($1,000/Qtr.) |  | 200
[NAME] ($1,000/Qtr.) |  | 500
Production Wages ($/Hour) |  | 6.3
Production Scheduled (Hours/week) |  | 40
Labor Force Change (No.) |  | 0
Allocation To Markets (%) |  |  | 32 |  | 33 |  | 35
Process R&D ($1,000/Qtr.) |  | 600
Raw Material Ordered (Million lbs.) |  | 40
Bonds Sold or Redeemed ($1,000) |  | 5000
Bank Loan Requested ($1,000) |  | 0
[NAME] ($1,000) |  | 0
Stocks Issued (1,000 Shares) |  | 0
Savings Account ($1,000) |  | 0
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 5187.699498589186
PRODUCTIVITY (Units/Production-Hr.) |  | 0.1504581176977014
RAW MAT. [NAME] (Lbs./Unit) |  | 96.44778036903762
PRODUCTION OUTPUT  (No. Units) |  |  | 128100.723470682 |  | 132103.8710791408 |  | 140110.1662960584 |  | 400314.7608458811
FIN. PROD. INVENTORY   (No. Units) |  |  | 109256.1159510605 |  | 100927.5247845975 |  | 134246.5439656894 |  | 344430.1847013474
RAW MAT.INVENTORY (Million Lbs.) |  | 59.9775388991366
[NAME]  (No. Units) |  |  | 76680.98447163818 |  | 87078.66373558696 |  | 80081.84505840747 |  | 243841.4932656326
SALES   (No. Units) |  |  | 76680.98447163818 |  | 87078.66373558696 |  | 80081.84505840747 |  | 243841.4932656326
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 27221.74948743155 |  | 30477.53230745544 |  | 27628.23654515058 |  | 85327.51834003757
SALESPEOPLE ACTIVE  (No.) |  |  | 24 |  | 27 |  | 22 |  | 73
SALES TRAINEES  (No.) |  |  | 0 |  | 0 |  | 0 |  | 0
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 16762.02674817578 |  | ADVERTISING | 1290 |  |  | R & D | 1200
MATERIAL | 16442.3347141928 |  | SALARIES | 383.25 |  |  | CARRYING - FIN. PROD. | 751.8276684843959
MAINTENANCE | 2514.304012226367 |  | COMMISSIONS | 3327.773215261465 |  |  | CARRYING - RAW. Mat. | 234.3480361267358
TRAINING | 500 |  | TRANSPORTATION | 3178.499201116295 |  |  | BOND INTEREST | 975
PROD. LEVEL CHANGE | 0 |  | ADMINISTRATIVE | 3449.207466328163 |  |  | LOAN INTEREST | 31.51971185782575
EQUIPMENT | 1644.23347141928 |  | SALES FORCE CHANGE | 0 |  |  | ADMINISTRATIVE | 6823.260051450211
ADMINISTRATIVE | 2401.573804229405 |  | TRAINING | 200 |  |  | BOND CALL PREMIUM | 0
[NAME] | 470.3912830684199
TOTAL | 40734.86403331205 |  | TOTAL | 11828.72988270592 |  |  | TOTAL | 10015.95546791917
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 85327.51834003757 |  | ACCOUNTS COLLECTED | 86007.86448690461 |  |  | CASH BALANCE | 6882.98032584638
BEGINNING INVENTORY | 23067.30195848739 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 28442.50611334585
TOTAL PRODUCTION COST | 40734.86403331205 |  | BOND SALE RETURN | 5000 |  |  | INVENTORY - FIN. PROD. | 35048.21234453439
GOODS AVAILABLE | 63802.16599179944 |  | SAV. ACCOUNT INT. | 420 |  |  | INVENTORY - RAW MAT | 28107.68944038183
ENDING INVENTORY | 35048.21234453439 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 21000
COST OF GOODS SOLD | 28753.95364726505 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 119481.3882241085
GROSS PROFIT | 56573.56469277252 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 0 |  |  | PLANT & EQUIP. VALUE | 46568.73702377357
TOTAL MARKETING COST | 11828.72988270592 |  | TOTAL SOURCES | 91427.86448690461 |  |  | TOTAL ASSETS | 166050.125247882
PROFIT ON SALES | 44744.83481006659
 |  |  | TOTAL PRODUCTION COST | 43422.13803605083 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 10015.95546791917 |  | TOTAL MARKETING COST | 11828.72988270592
TOTAL OTHER INCOME | 420 |  | TOTAL OTHER COST | 10015.95546791917 |  |  | BONDS OUTSTANDING | 35000
NET PROFIT BEFORE TAXES | 35148.87934214743 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 787.9927964456438 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 17574.43967107371 |  | BONDS REDEEMED | 0 |  |  | ACCUM. RET. EARNINGS | 67190.725247882
 |  |  | INCOME TAXES | 17574.43967107371 |  |  | TOTAL STOCK EQUITY | 131050.125247882
NET PROFIT AFTER TAXES | 17574.43967107371 |  | PROFIT SHARING | 915.6283068629403 |  |  | TOTAL LIABILITIES | 166050.125247882
PROFIT SHARING COST | 915.6283068629403 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 0
NET INCOME | 16658.81136421077 |  | TOTAL DISBURSEMENTS | 84544.88416105823
DIVIDENDS PAID | 0
[NAME] | 16658.81136421077 |  | CASH AVAILABLE | 6882.98032584638
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 6882.98032584638
5.  Economy and Stockmarket Report
Gross Domestic Product | 179 | $ Billions
Personal Consumption Expenditures | 16 | $ Billions
No. of [NAME] | 331 | 1000's
Raw Material Cost | 0.49 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.36913333333335 | 2.14219304242011 | 0 | 6000 | 10 | 13
Co.2 Name | 10.60823333333335 | 6.320561491432237 | 0 | 6000 | 10 | 13
Co.3 Name | 10.57303333333334 | 4.555348405466881 | 0 | 6000 | 10 | 13
Co.4 Name | 10.64823333333335 | 1.047382431555156 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 4.256650713426255 | 0 | 6000 | 16 | 19
Co.6 Name | 10.3449598789972 | 8.88311987174279 | 0 | 6020 | 16 | 19
[NAME] | 10.64323333333333 | 2.776468560701795 | 0 | 6000 | 13 | 16
Co.8 Name | 10.65833333333335 | 5.638363511490743 | 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 | 308.9650376636416 | 968.0910173589679 | 5.139990560341474 | 6.082570423104793 | 2032.307202923169 | 6.317765350798879 | 3965.092161438124 | 418627.4648151921 | 81.22826355683259 | 376819.2251336875
Co.2 Name | 339.8136410712182 | 392.18062269906 | 4.282005591178726 | 9.945138771558959 | 1660.563306370527 | 6.437265048696052 | 6560.852505394289 | 677641.8816202335 | 72.60518104242362 | 465747.1847284512
Co.3 Name | 359.2073673420001 | 472.084215144215 | 3.503016193880017 | 5.036764788629986 | 1784.328520921167 | 5.990318456635869 | 3196.617341032621 | 317063.8068762139 | 64.22785114787307 | 312311.704723556
Co.4 Name | 350.4513648110021 | 684.4916304864405 | 4.615212524666219 | 3.486676094508791 | 1544.116577623256 | 5.752060246577583 | 3245.775563713405 | 222881.8142218414 | 77.81162273427267 | 163640.6229124096
Co.5 Name | 329.2085616830774 | 401.8698007446134 | 3.934075067490892 | 4.630264434877233 | 1627.480708563211 | 5.791060822633531 | 4756.689825405939 | 409443.9211183335 | 74.44116993417532 | 374650.3119231381
Co.6 Name | 336.7073108712602 | 582.654830479231 | 5.4916501091021 | 5.064092784505946 | 1508.906591889242 | 6.395477660042807 | 7120.107100755627 | 675029.521182991 | 58.56232894545535 | 655644.511758727
[NAME] | 351.4986866652869 | 441.8453440539849 | 3.99230640848223 | 5.198639577752533 | 1819.52528983104 | 6.205396136511333 | 5065.084782954589 | 407613.2078986537 | 69.81541927898039 | 253537.9739918075
Co.8 Name | 342.6178936107024 | 481.7538079310905 | 4.673001684263168 | 7.570615374368996 | 1947.033678133182 | 7.529335353545619 | 4897.596065629284 | 469376.5751819365 | 82.72175824162154 | 387690.1707371558