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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 5 | Quarter= | 3
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 345 |  | 340 |  | 335
Advertising ($1,000/Qtr.) |  |  | 500 |  | 485 |  | 500
Sales Force Change (No.) |  |  | 0 |  | 0 |  | 0
Product R&D ($1,000/Qtr.) |  | 235
Sales Commision (%) |  | 5.25
Profit Sharing (%) |  | 5.85
Sales Salaries ($/Month) |  | 1775
[NAME] ($1,000/Qtr.) |  | 200
[NAME] ($1,000/Qtr.) |  | 200
Production Wages ($/Hour) |  | 6.85
Production Scheduled (Hours/week) |  | 42
Labor Force Change (No.) |  | 0
Allocation To Markets (%) |  |  | 32 |  | 33 |  | 35
Process R&D ($1,000/Qtr.) |  | 235
Raw Material Ordered (Million lbs.) |  | 10
Bonds Sold or Redeemed ($1,000) |  | 0
Bank Loan Requested ($1,000) |  | 0
[NAME] ($1,000) |  | 0
Stocks Issued (1,000 Shares) |  | 0
Savings Account ($1,000) |  | 4000
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 4805.486035728687
PRODUCTIVITY (Units/Production-Hr.) |  | 0.19
RAW MAT. [NAME] (Lbs./Unit) |  | 94
PRODUCTION OUTPUT  (No. Units) |  |  | 157120.7882475815 |  | 162030.8128803184 |  | 171850.8621457922 |  | 491002.4632736921
FIN. PROD. INVENTORY   (No. Units) |  |  | 129321.713288315 |  | 82438.64675936662 |  | 191832.9474219234 |  | 403593.307469605
RAW MAT.INVENTORY (Million Lbs.) |  | 34.41560566312679
[NAME]  (No. Units) |  |  | 160770.5146278562 |  | 190223.730873681 |  | 151988.2068598304 |  | 502982.4523613676
SALES   (No. Units) |  |  | 160770.5146278562 |  | 190223.730873681 |  | 151988.2068598304 |  | 502982.4523613676
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 55465.82754661038 |  | 64676.06849705154 |  | 50916.04929804317 |  | 171057.9453417051
SALESPEOPLE ACTIVE  (No.) |  |  | 20 |  | 27 |  | 18 |  | 65
SALES TRAINEES  (No.) |  |  | 0 |  | 0 |  | 0 |  | 0
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 18123.40545830401 |  | ADVERTISING | 1485 |  |  | R & D | 470
MATERIAL | 19073.12004419442 |  | SALARIES | 346.125 |  |  | CARRYING - FIN. PROD. | 2453.966399724699
MAINTENANCE | 2718.510818745601 |  | COMMISSIONS | 8980.542130439517 |  |  | CARRYING - RAW. Mat. | 255.9483541934274
TRAINING | 200 |  | TRANSPORTATION | 3898.559558393115 |  |  | BOND INTEREST | 1202.5
PROD. LEVEL CHANGE | 0 |  | ADMINISTRATIVE | 4664.912261806839 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1907.312004419442 |  | SALES FORCE CHANGE | 0 |  |  | ADMINISTRATIVE | 10992.30028407106
ADMINISTRATIVE | 2855.01231636846 |  | TRAINING | 200 |  |  | BOND CALL PREMIUM | 0
[NAME] | 459.8244965353583
TOTAL | 45337.18513856729 |  | TOTAL | 19575.13895063947 |  |  | TOTAL | 15374.71503798919
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 171057.9453417051 |  | ACCOUNTS COLLECTED | 155307.0369340254 |  |  | CASH BALANCE | 57186.0298372883
BEGINNING INVENTORY | 39189.74874606584 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 57019.31511390169
TOTAL PRODUCTION COST | 45337.18513856729 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 37305.47921751373
GOODS AVAILABLE | 84526.93388463312 |  | SAV. ACCOUNT INT. | 420 |  |  | INVENTORY - RAW MAT | 15968.11541571884
ENDING INVENTORY | 37305.47921751373 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 25000
COST OF GOODS SOLD | 47221.45466711939 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 192478.9395844226
GROSS PROFIT | 123836.4906745857 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 17678.62495577187 |  |  | PLANT & EQUIP. VALUE | 45522.62515700048
TOTAL MARKETING COST | 19575.13895063947 |  | TOTAL SOURCES | 173405.6618897972 |  |  | TOTAL ASSETS | 238001.564741423
PROFIT ON SALES | 104261.3517239462
 |  |  | TOTAL PRODUCTION COST | 30004.24059783751 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 15374.71503798919 |  | TOTAL MARKETING COST | 19575.13895063947
TOTAL OTHER INCOME | 420 |  | TOTAL OTHER COST | 15374.71503798919 |  |  | BONDS OUTSTANDING | 37000
NET PROFIT BEFORE TAXES | 89306.63668595704 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63738.8
INCOME TAXES | 44653.31834297851 |  | BONDS REDEEMED | 0 |  |  | ACCUM. RET. EARNINGS | 137262.764741423
 |  |  | INCOME TAXES | 44653.31834297851 |  |  | TOTAL STOCK EQUITY | 201001.564741423
NET PROFIT AFTER TAXES | 44653.31834297853 |  | PROFIT SHARING | 2612.219123064244 |  |  | TOTAL LIABILITIES | 238001.564741423
PROFIT SHARING COST | 2612.219123064244 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 4000
NET INCOME | 42041.09921991429 |  | TOTAL DISBURSEMENTS | 116219.6320525089
DIVIDENDS PAID | 0
[NAME] | 42041.09921991429 |  | CASH AVAILABLE | 57186.0298372883
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 57186.0298372883
5.  Economy and Stockmarket Report
Gross Domestic Product | 179 | $ Billions
Personal Consumption Expenditures | 19 | $ Billions
No. of [NAME] | 345 | 1000's
Raw Material Cost | 0.49 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.36913333333334 | 7.575480844848456 | 3 | 6000 | 10 | 13
Co.2 Name | 10.55813333333336 | 10.43197039641701 | 1.666666666666667 | 6000 | 10 | 13
Co.3 Name | 10.57303333333333 | 5.922506495859443 | 0 | 6000 | 10 | 13
Co.4 Name | 10.61813333333335 | 3.689585324932797 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 11.63016804544496 | 0 | 6000 | 16 | 19
Co.6 Name | 10.34495987899721 | 13.17621545611865 | 0 | 6020 | 16 | 19
[NAME] | 10.62313333333334 | 7.006849869985714 | 0 | 6000 | 13 | 16
Co.8 Name | 10.65833333333336 | 6.462376880702027 | 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 | 331.701555429879 | 1556.152406422592 | 5.917579476777751 | 5.937812168968251 | 2013.095604523618 | 6.148884106657881 | 6612.622042071964 | 645431.3808350146 | 77.5946198981602 | 692365.2220914032
Co.2 Name | 319.3615613300827 | 594.3640280837291 | 4.983069782171208 | 9.26776383177686 | 1654.645535164968 | 6.567710176861813 | 6572.535996189464 | 625517.6484941414 | 71.12965875191584 | 731099.5700099738
Co.3 Name | 345.6043162916283 | 538.7898096492353 | 3.370857400593777 | 6.154879636578325 | 1803.692913185593 | 6.31649214405022 | 3215.509823815548 | 351219.2002568314 | 86.14043518955891 | 403872.9613867388
Co.4 Name | 342.3055240314113 | 1002.662349816725 | 5.971761442129492 | 3.510089018841227 | 1589.214374634521 | 5.86930872281058 | 2667.250453062957 | 235512.1659332814 | 77.40245557393587 | 303465.9960335874
Co.5 Name | 329.2409124773216 | 517.9432321105575 | 6.693794659763229 | 5.917820567678414 | 1705.147663517664 | 6.0016700643995 | 7583.514323654898 | 763396.2113322669 | 85.57755406022297 | 902548.4074848307
Co.6 Name | 316.7543943393271 | 596.0273807739198 | 4.750847245381627 | 8.246771499800039 | 1521.435644821568 | 6.753904488209551 | 8855.417182938054 | 902902.3840627006 | 85.43211590225005 | 917373.4129464282
[NAME] | 326.2287543571823 | 463.820562430551 | 5.173982098611698 | 5.776466674563055 | 1736.444897890741 | 6.820798361773662 | 4823.526287811691 | 496185.6420526857 | 64.23200331493379 | 487162.6698460891
Co.8 Name | 377.6817193763279 | 503.7359653727771 | 4.877775858781585 | 8.149611002817968 | 2029.782870695616 | 7.232833202432242 | 4722.587239622863 | 435136.6740324161 | 96.26468271602705 | 434457.9099436155