Spreadsheet: 145704d1331719288-autofill-across-worksheets-ef57_sample-workbook
Sheet: Y5Q4

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 5 | Quarter= | 4
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 340 |  | 350 |  | 340
Advertising ($1,000/Qtr.) |  |  | 585 |  | 575 |  | 600
Sales Force Change (No.) |  |  | 0 |  | 0 |  | 0
Product R&D ($1,000/Qtr.) |  | 225
Sales Commision (%) |  | 5.4
Profit Sharing (%) |  | 6.15
Sales Salaries ($/Month) |  | 1800
[NAME] ($1,000/Qtr.) |  | 200
[NAME] ($1,000/Qtr.) |  | 200
Production Wages ($/Hour) |  | 6.85
Production Scheduled (Hours/week) |  | 40
Labor Force Change (No.) |  | -500
Allocation To Markets (%) |  |  | 32 |  | 33 |  | 35
Process R&D ($1,000/Qtr.) |  | 225
Raw Material Ordered (Million lbs.) |  | 25
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) |  | 5000
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 4233.010056619356
PRODUCTIVITY (Units/Production-Hr.) |  | 0.19
RAW MAT. [NAME] (Lbs./Unit) |  | 94
PRODUCTION OUTPUT  (No. Units) |  |  | 132576.3894793829 |  | 136719.4016506136 |  | 145005.425993075 |  | 414301.2171230715
FIN. PROD. INVENTORY   (No. Units) |  |  | 74196.13126835291 |  | 4177.898675247096 |  | 173868.1391224067 |  | 252242.1690660067
RAW MAT.INVENTORY (Million Lbs.) |  | 26.02572277721826
[NAME]  (No. Units) |  |  | 187701.9640227325 |  | 214980.1504414815 |  | 162819.8429984603 |  | 565501.9574626744
SALES   (No. Units) |  |  | 187701.9640227325 |  | 214980.1504414815 |  | 162819.8429984603 |  | 565501.9574626744
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 63818.66776772905 |  | 75243.05265451853 |  | 55358.74661947651 |  | 194420.4670417241
SALESPEOPLE ACTIVE  (No.) |  |  | 18 |  | 27 |  | 20 |  | 65
SALES TRAINEES  (No.) |  |  | 0 |  | 0 |  | 0 |  | 0
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 14936.64914364758 |  | ADVERTISING | 1760 |  |  | R & D | 450
MATERIAL | 15492.20123516442 |  | SALARIES | 351 |  |  | CARRYING - FIN. PROD. | 2622.279755028149
MAINTENANCE | 2240.497371547136 |  | COMMISSIONS | 10498.7052202531 |  |  | CARRYING - RAW. Mat. | 137.6624190129891
TRAINING | 200 |  | TRANSPORTATION | 3289.551663957188 |  |  | BOND INTEREST | 1202.5
PROD. LEVEL CHANGE | 200.4 |  | ADMINISTRATIVE | 4977.509787313372 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1549.220123516442 |  | SALES FORCE CHANGE | 0 |  |  | ADMINISTRATIVE | 11998.52299922104
ADMINISTRATIVE | 2471.506085615358 |  | TRAINING | 200 |  |  | BOND CALL PREMIUM | 300
[NAME] | 455.2262515700048
TOTAL | 37545.70021106094 |  | TOTAL | 21076.76667152366 |  |  | TOTAL | 16710.96517326218
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 194420.4670417241 |  | ACCOUNTS COLLECTED | 186649.7542826081 |  |  | CASH BALANCE | 106999.0638455939
BEGINNING INVENTORY | 37291.29664075427 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 64806.82234724137
TOTAL PRODUCTION COST | 37545.70021106094 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 22911.43280107127
GOODS AVAILABLE | 74836.9968518152 |  | SAV. ACCOUNT INT. | 500 |  |  | INVENTORY - RAW MAT | 12725.9137420002
ENDING INVENTORY | 22911.43280107127 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 30000
COST OF GOODS SOLD | 51925.56405074393 |  | PLANT & EQUIP. SALE | 300.6 |  |  | TOTAL CURRENT ASSETS | 237443.2327359068
GROSS PROFIT | 142494.9029909802 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 57182.96366794089 |  |  | PLANT & EQUIP. VALUE | 44766.79890543047
TOTAL MARKETING COST | 21076.76667152366 |  | TOTAL SOURCES | 244633.317950549 |  |  | TOTAL ASSETS | 282210.0316413373
PROFIT ON SALES | 121418.1363194565
 |  |  | TOTAL PRODUCTION COST | 33848.27272432651 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 16710.96517326218 |  | TOTAL MARKETING COST | 21076.76667152366
TOTAL OTHER INCOME | 800.6 |  | TOTAL OTHER COST | 16710.96517326218 |  |  | BONDS OUTSTANDING | 32000
NET PROFIT BEFORE TAXES | 105507.7711461943 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63438.2
INCOME TAXES | 52753.88557309717 |  | BONDS REDEEMED | 5000 |  |  | ACCUM. RET. EARNINGS | 186771.8316413373
 |  |  | INCOME TAXES | 52753.88557309717 |  |  | TOTAL STOCK EQUITY | 250210.0316413373
NET PROFIT AFTER TAXES | 52753.88557309717 |  | PROFIT SHARING | 3244.363962745476 |  |  | TOTAL LIABILITIES | 282210.0316413373
PROFIT SHARING COST | 3244.363962745476 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 5000
NET INCOME | 49509.52161035169 |  | TOTAL DISBURSEMENTS | 137634.254104955
DIVIDENDS PAID | 0
[NAME] | 49509.52161035169 |  | CASH AVAILABLE | 106999.0638455939
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 106999.0638455939
5.  Economy and Stockmarket Report
Gross Domestic Product | 219 | $ Billions
Personal Consumption Expenditures | 17 | $ Billions
No. of [NAME] | 363 | 1000's
Raw Material Cost | 0.56 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.36913333333334 | 12.62976819726514 | 6.666666666666667 | 6000 | 10 | 13
Co.2 Name | 10.55813333333335 | 11.01770426680385 | 3.333333333333333 | 6000 | 10 | 13
Co.3 Name | 10.57303333333333 | 3.176809972842369 | 0 | 6000 | 11 | 14.5
Co.4 Name | 10.61813333333336 | 4.215109235280824 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 13.97367974857517 | 0 | 6000 | 16 | 19
Co.6 Name | 10.34495987899722 | 19.02507241690065 | 0 | 6020 | 16 | 19
[NAME] | 10.57303333333333 | 8.251586935058615 | 0 | 6000 | 13 | 16
Co.8 Name | 10.65833333333336 | 8.067689070187926 | 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 | 350.5935813263985 | 839.0873819262598 | 6.00341305695943 | 6.104662429293819 | 1941.688518673831 | 6.501198662157357 | 9223.419876771097 | 925928.4020382492 | 78.17135219596294 | 842616.5012194633
Co.2 Name | 336.549243445334 | 793.8882620242056 | 5.625002462125107 | 9.702770287581055 | 1641.941790453952 | 6.583823084049881 | 7729.360979119787 | 738518.6757353911 | 75.3187522853062 | 701641.7006416052
Co.3 Name | 422.7653256345245 | #[NAME]! | 3.897561982785797 | 6.27515135634008 | 1933.215458480863 | 6.380819815314031 | 3333.2012312136 | 178551.0920170646 | 80.04380258290239 | 184317.6050208264
Co.4 Name | 340.3987480984097 | 1025.618388636068 | 6.463018844853833 | 4.110212658451332 | 1513.11750246684 | 5.677658190482417 | 2684.425351848721 | 264966.9605219552 | 79.92884459969734 | 318269.0775484828
Co.5 Name | 308.9285123485991 | 503.0815604111065 | 6.806577004805274 | 7.141292351209374 | 1663.606475894886 | 6.051907283740467 | 12650.15354223725 | 1275490.780605885 | 88.2160334499847 | 1076806.028593795
Co.6 Name | 354.9606327380192 | 976.4249049103926 | 4.968781982944558 | 4.721727788301024 | 1445.091754258532 | 6.523720710665755 | 13411.60886855878 | 1271985.032380283 | 96.83972207462402 | 1282253.317183817
[NAME] | 366.0624161636776 | 586.1186612474272 | 5.238825752697185 | 6.224693825519119 | 1798.557460055242 | 6.747319896463922 | 4147.332992701894 | 399175.2662307027 | 62.98926668264534 | 574022.0040886606
Co.8 Name | 356.6430705241052 | 560.9232507474538 | 5.541173447649289 | 8.614854511217752 | 1951.070418307931 | 7.320888428717362 | 5683.993802729456 | 543197.4492329644 | 92.5256214074895 | 537368.8877527454