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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 3 | Quarter= | 4
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 370 |  | 350 |  | 340
Advertising ($1,000/Qtr.) |  |  | 380 |  | 380 |  | 410
Sales Force Change (No.) |  |  | 0 |  | 1 |  | 4
Product R&D ($1,000/Qtr.) |  | 350
Sales Commision (%) |  | 1.95
Profit Sharing (%) |  | 3.75
Sales Salaries ($/Month) |  | 1650
[NAME] ($1,000/Qtr.) |  | 100
[NAME] ($1,000/Qtr.) |  | 100
Production Wages ($/Hour) |  | 6.3
Production Scheduled (Hours/week) |  | 42
Labor Force Change (No.) |  | 1200
Allocation To Markets (%) |  |  | 31 |  | 33 |  | 36
Process R&D ($1,000/Qtr.) |  | 350
Raw Material Ordered (Million lbs.) |  | 40
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.) |  | 4880.893749999999
PRODUCTIVITY (Units/Production-Hr.) |  | 0.07244794537655046
RAW MAT. [NAME] (Lbs./Unit) |  | 207.941583116415
PRODUCTION OUTPUT  (No. Units) |  |  | 48017.58697728768 |  | 51115.49581453204 |  | 55762.35907039859 |  | 154895.4418622183
FIN. PROD. INVENTORY   (No. Units) |  |  | 392.2332514501977 |  | 0 |  | 0 |  | 392.2332514501977
RAW MAT.INVENTORY (Million Lbs.) |  | 40
[NAME]  (No. Units) |  |  | 47625.35372583749 |  | 56445.42205896074 |  | 58780.89343022183 |  | 162851.6692150201
SALES   (No. Units) |  |  | 47625.35372583749 |  | 51115.49581453204 |  | 55762.35907039859 |  | 154503.2086107681
BACKORDERS   (No. Units) |  |  | 0 |  | 2664.963122214351 |  | 1509.267179911618 |  | 4174.230302125969
SALES  ($1000) |  |  | 17621.38087855987 |  | 17890.42353508621 |  | 18959.20208393552 |  | 54471.00649758161
SALESPEOPLE ACTIVE  (No.) |  |  | 28 |  | 19 |  | 20 |  | 67
SALES TRAINEES  (No.) |  |  | 0 |  | 1 |  | 4 |  | 5
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 16605.370001059 |  | ADVERTISING | 1170 |  |  | R & D | 700
MATERIAL | 12989.88525870927 |  | SALARIES | 356.4 |  |  | CARRYING - FIN. PROD. | 0
MAINTENANCE | 2490.80550015885 |  | COMMISSIONS | 1062.184626702841 |  |  | CARRYING - RAW. Mat. | 128.8368135933852
TRAINING | 100 |  | TRANSPORTATION | 1475.337560598696 |  |  | BOND INTEREST | 900
PROD. LEVEL CHANGE | 1200.8 |  | ADMINISTRATIVE | 2992.51604305384 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1298.988525870927 |  | SALES FORCE CHANGE | 42 |  |  | ADMINISTRATIVE | 5159.697560679319
ADMINISTRATIVE | 1332.577471933436 |  | TRAINING | 100 |  |  | BOND CALL PREMIUM | 120
[NAME] | 467.2290090837678
TOTAL | 36485.65576681526 |  | TOTAL | 7198.438230355378 |  |  | TOTAL | 7008.534374272705
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 54471.00649758161 |  | ACCOUNTS COLLECTED | 51217.84676613322 |  |  | CASH BALANCE | 35532.22067995963
BEGINNING INVENTORY | 0 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 18157.00216586053
TOTAL PRODUCTION COST | 36485.65576681526 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 92.39062957992232
GOODS AVAILABLE | 36485.65576681526 |  | SAV. ACCOUNT INT. | 260 |  |  | INVENTORY - RAW MAT | 16800
ENDING INVENTORY | 92.39062957992232 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 15000
COST OF GOODS SOLD | 36393.26513723534 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 85581.61347540008
GROSS PROFIT | 18077.74136034627 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 46033.92430950551 |  |  | PLANT & EQUIP. VALUE | 48056.87189929301
TOTAL MARKETING COST | 7198.438230355378 |  | TOTAL SOURCES | 97511.77107563874 |  |  | TOTAL ASSETS | 133638.4853746931
PROFIT ON SALES | 10879.30312999089
 |  |  | TOTAL PRODUCTION COST | 39828.54149902221 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 7008.534374272705 |  | TOTAL MARKETING COST | 7198.438230355378
TOTAL OTHER INCOME | 260 |  | TOTAL OTHER COST | 7008.534374272705 |  |  | BONDS OUTSTANDING | 34000
NET PROFIT BEFORE TAXES | 4130.768755718188 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 2065.384377859094 |  | BONDS REDEEMED | 2000 |  |  | ACCUM. RET. EARNINGS | 35779.0853746931
 |  |  | INCOME TAXES | 2065.384377859094 |  |  | TOTAL STOCK EQUITY | 99638.48537469309
NET PROFIT AFTER TAXES | 2065.384377859094 |  | PROFIT SHARING | 77.45191416971603 |  |  | TOTAL LIABILITIES | 133638.4853746931
PROFIT SHARING COST | 77.45191416971603 |  | PLANT & EQUIP. INVEST. | 1801.2
 |  |  | SAVINGS ACCT. DEPOSIT | 2000
NET INCOME | 1987.932463689378 |  | TOTAL DISBURSEMENTS | 61979.55039567911
DIVIDENDS PAID | 0
[NAME] | 1987.932463689378 |  | CASH AVAILABLE | 35532.22067995963
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 35532.22067995963
5.  Economy and Stockmarket Report
Gross Domestic Product | 205 | $ Billions
Personal Consumption Expenditures | 16 | $ Billions
No. of [NAME] | 340 | 1000's
Raw Material Cost | 0.49 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.65833333333334 | 1.719122571032785 | 0 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 2.0532934747198 | 0 | 6000 | 10 | 13
Co.3 Name | 10.63323333333333 | 1.767960212613003 | 0 | 6000 | 10 | 13
Co.4 Name | 10.65833333333334 | 0.2964218283924673 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 0.4652547010717822 | 0 | 6000 | 16 | 19
Co.6 Name | 10.65821569295066 | -1.04417214550722 | 0 | 6020 | 10 | 13
[NAME] | 10.64323333333333 | 0.331322077281563 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333333 | 1.475692112819112 | 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 | 337.9937679001517 | 386.69761832317 | 1.827021123104922 | 4.401717872856319 | 1796.999020829335 | 6.093802416044007 | 4990.232134845876 | 264438.761550032 | 74.69264001775063 | 235524.684951422
Co.2 Name | 355.2229941309391 | 306.5604060748645 | 2.781477716296203 | 9.551943288248108 | 1590.428043774185 | 6.085116854576676 | 4651.902520372567 | 244709.4883839214 | 68.45150707564724 | 217835.1274186489
Co.3 Name | 359.4363645067612 | 358.0623745393985 | 1.221079869199744 | 4.404584744023094 | 1599.173839571364 | 5.596349837418787 | 4321.401309569394 | 241932.8091000038 | 64.16266343794919 | 175772.6086636788
Co.4 Name | 354.0456995401816 | 285.5720205793347 | 2.450714394929499 | 0.9880000557600209 | 1551.50120132758 | 5.576862493534902 | 4225.86902445471 | 151299.2190085353 | 70.47698051356726 | 140055.0393881822
Co.5 Name | 359.458285612493 | 364.8795232289658 | 2.829718653257453 | 0.9761632918786247 | 1568.627898472777 | 5.910728836558562 | 3625.641921255494 | 162765.9351680973 | 49.14138407817529 | 167244.0289362782
Co.6 Name | 381.9013279668524 | 528.3422534646094 | 4.916234543627811 | 9.72329420170051 | 1532.570819073884 | 6.714981015661434 | 9733.301805749143 | 185928.5551329501 | 61.24836791711882 | 215777.1478153938
[NAME] | 345.7555636815172 | 382.4635320861591 | 1.948110742065082 | 3.752277181616145 | 1659.58558542741 | 6.176551411931606 | 4649.436648457896 | 151757.2292862711 | 68.96892455589193 | 159114.6562422963
Co.8 Name | 344.1265798466716 | 340.8823890036127 | 2.486831200024628 | 5.263085967842737 | 1661.356344700284 | 6.264286063947848 | 4374.51461041618 | 199778.2037172705 | 79.65894883862772 | 204941.6759712705