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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 3 | Quarter= | 3
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 360 |  | 330 |  | 320
Advertising ($1,000/Qtr.) |  |  | 380 |  | 380 |  | 410
Sales Force Change (No.) |  |  | 1 |  | 2 |  | 5
Product R&D ($1,000/Qtr.) |  | 250
Sales Commision (%) |  | 1.1
Profit Sharing (%) |  | 1
Sales Salaries ($/Month) |  | 1550
[NAME] ($1,000/Qtr.) |  | 50
[NAME] ($1,000/Qtr.) |  | 50
Production Wages ($/Hour) |  | 6.15
Production Scheduled (Hours/week) |  | 42
Labor Force Change (No.) |  | 400
Allocation To Markets (%) |  |  | 31 |  | 34 |  | 35
Process R&D ($1,000/Qtr.) |  | 250
Raw Material Ordered (Million lbs.) |  | 25
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.) |  | 3874.625
PRODUCTIVITY (Units/Production-Hr.) |  | 0.06471256617513273
RAW MAT. [NAME] (Lbs./Unit) |  | 234.0185703984621
PRODUCTION OUTPUT  (No. Units) |  |  | 40317.74560520469 |  | 44219.46292183741 |  | 45520.03536071498 |  | 130057.2438877571
FIN. PROD. INVENTORY   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
RAW MAT.INVENTORY (Million Lbs.) |  | 32.20920404674403
[NAME]  (No. Units) |  |  | 55210.49058161776 |  | 64040.38696978716 |  | 68756.85943189662 |  | 188007.7369833015
SALES   (No. Units) |  |  | 43201.9252405439 |  | 44219.46292183741 |  | 45520.03536071498 |  | 132941.4235230963
BACKORDERS   (No. Units) |  |  | 6004.28267053693 |  | 9910.462023974873 |  | 11618.41203559082 |  | 27533.15673010262
SALES  ($1000) |  |  | 15552.69308659581 |  | 14592.42276420635 |  | 14566.41131542879 |  | 44711.52716623095
SALESPEOPLE ACTIVE  (No.) |  |  | 27 |  | 17 |  | 12 |  | 56
SALES TRAINEES  (No.) |  |  | 1 |  | 2 |  | 5 |  | 8
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 12654.3605784375 |  | ADVERTISING | 1170 |  |  | R & D | 500
MATERIAL | 13678.14550779535 |  | SALARIES | 297.6 |  |  | CARRYING - FIN. PROD. | 11.53671854135685
MAINTENANCE | 1898.154086765625 |  | COMMISSIONS | 491.8267988285404 |  |  | CARRYING - RAW. Mat. | 150.5800573252843
TRAINING | 50 |  | TRANSPORTATION | 1036.556233785424 |  |  | BOND INTEREST | 950
PROD. LEVEL CHANGE | 400.8 |  | ADMINISTRATIVE | 2804.707117615481 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1367.814550779535 |  | SALES FORCE CHANGE | 66 |  |  | ADMINISTRATIVE | 4359.044483311547
ADMINISTRATIVE | 1050.286219438785 |  | TRAINING | 50 |  |  | BOND CALL PREMIUM | 120
[NAME] | 465.8757667512807
TOTAL | 31565.43670996807 |  | TOTAL | 5916.690150229446 |  |  | TOTAL | 6091.161259178189
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 44711.52716623095 |  | ACCOUNTS COLLECTED | 46897.17553931869 |  |  | CASH BALANCE | 46056.12491239142
BEGINNING INVENTORY | 708.7276709988926 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 14903.84238874365
TOTAL PRODUCTION COST | 31565.43670996807 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 0
GOODS AVAILABLE | 32274.16438096696 |  | SAV. ACCOUNT INT. | 220 |  |  | INVENTORY - RAW MAT | 12989.88555010545
ENDING INVENTORY | 0 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 13000
COST OF GOODS SOLD | 32274.16438096696 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 86949.85285124052
GROSS PROFIT | 12437.36278526398 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 43047.41946270927 |  |  | PLANT & EQUIP. VALUE | 46722.90090837678
TOTAL MARKETING COST | 5916.690150229446 |  | TOTAL SOURCES | 90164.59500202796 |  |  | TOTAL ASSETS | 133672.7537596173
PROFIT ON SALES | 6520.672635034538
 |  |  | TOTAL PRODUCTION COST | 27171.41543542144 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 6091.161259178189 |  | TOTAL MARKETING COST | 5916.690150229446
TOTAL OTHER INCOME | 220 |  | TOTAL OTHER COST | 6091.161259178189 |  |  | BONDS OUTSTANDING | 36000
NET PROFIT BEFORE TAXES | 649.5113758563493 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 324.7556879281747 |  | BONDS REDEEMED | 2000 |  |  | ACCUM. RET. EARNINGS | 33813.35375961729
 |  |  | INCOME TAXES | 324.7556879281747 |  |  | TOTAL STOCK EQUITY | 97672.7537596173
NET PROFIT AFTER TAXES | 324.7556879281747 |  | PROFIT SHARING | 3.247556879281747 |  |  | TOTAL LIABILITIES | 133672.7537596173
PROFIT SHARING COST | 3.247556879281747 |  | PLANT & EQUIP. INVEST. | 601.2
 |  |  | SAVINGS ACCT. DEPOSIT | 2000
NET INCOME | 321.5081310488929 |  | TOTAL DISBURSEMENTS | 44108.47008963653
DIVIDENDS PAID | 0
[NAME] | 321.5081310488929 |  | CASH AVAILABLE | 46056.12491239142
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 46056.12491239142
5.  Economy and Stockmarket Report
Gross Domestic Product | 154 | $ Billions
Personal Consumption Expenditures | 18 | $ Billions
No. of [NAME] | 361 | 1000's
Raw Material Cost | 0.42 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.65833333333333 | 1.070613775368967 | 0 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 1.586024251813827 | 0 | 6000 | 10 | 13
Co.3 Name | 10.63323333333333 | 1.61534619009755 | 0 | 6000 | 10 | 13
Co.4 Name | 10.65833333333333 | 0.1141465869602396 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 0.6697873891313478 | 0 | 6000 | 16 | 19
Co.6 Name | 10.65821569295067 | 1.068506993182615 | 0 | 6020 | 10 | 13
[NAME] | 10.64323333333334 | 0.05358468850814881 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333333 | 0.9562831747935104 | 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 | 353.3552375371772 | 421.9489798232692 | 1.749968562106463 | 2.940979489114411 | 1619.71670406638 | 6.33796291009598 | 4711.850393033143 | 224361.2013810724 | 72.65792407439933 | 224174.285258722
Co.2 Name | 356.886668959125 | 325.3422274729825 | 2.275428387711315 | 9.744481744852461 | 1521.14654972484 | 6.039474725196235 | 4131.756982930015 | 198329.5742294082 | 57.59383144626092 | 205395.3000534817
Co.3 Name | 362.1326779121874 | 249.5203688728243 | 1.045879784392947 | 4.009392023724901 | 1583.171684795258 | 5.746350926297894 | 4199.421016602113 | 194154.7522470561 | 52.54299427602183 | 188360.3575846511
Co.4 Name | 386.1993167178814 | 302.2968095999921 | 2.518269553702499 | 0.9871583865547245 | 1531.647888831583 | 5.901531072564439 | 4285.774129478757 | 146271.6215301522 | 50.29882779027588 | 153731.3120497677
Co.5 Name | 355.0620475241058 | 367.6988789673894 | 1.031710048538254 | 1.018284060468146 | 1663.422417460042 | 5.717336673932532 | 3542.166168761591 | 147007.0160422332 | 55.79916878718837 | 185658.4973961143
Co.6 Name | 327.0739595308122 | 414.18605722569 | 2.766985733340127 | 8.944856717727323 | 1508.549484232153 | 6.710179386044461 | 6312.527165369404 | 208180.7777896165 | 61.05877022981982 | 278370.2573028267
[NAME] | 340.4378800344969 | 396.9177940090644 | 1.055509441283824 | 1.013116099877557 | 1490.468484992884 | 6.405472943994384 | 3792.015228022846 | 134548.7015031606 | 57.39372061296454 | 128280.1643790178
Co.8 Name | 348.1023501228142 | 362.5876679035829 | 2.026704108553065 | 5.022998758095572 | 1676.637411275889 | 6.099771650601924 | 4230.936055659537 | 172127.2922162563 | 73.92501525084386 | 190131.9646527219