Spreadsheet: 145705d1331719402-autofill-across-worksheets-indirect
Sheet: Y4Q4

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 4 | Quarter= | 4
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 350 |  | 345 |  | 335
Advertising ($1,000/Qtr.) |  |  | 410 |  | 400 |  | 415
Sales Force Change (No.) |  |  | -3 |  | -2 |  | -2
Product R&D ($1,000/Qtr.) |  | 650
Sales Commision (%) |  | 3.75
Profit Sharing (%) |  | 5.21
Sales Salaries ($/Month) |  | 1661
[NAME] ($1,000/Qtr.) |  | 750
[NAME] ($1,000/Qtr.) |  | 500
Production Wages ($/Hour) |  | 6.3
Production Scheduled (Hours/week) |  | 42
Labor Force Change (No.) |  | 0
Allocation To Markets (%) |  |  | 31 |  | 33 |  | 36
Process R&D ($1,000/Qtr.) |  | 650
Raw Material Ordered (Million lbs.) |  | 50
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) |  | 0
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 5253.614933793035
PRODUCTIVITY (Units/Production-Hr.) |  | 0.1299713811635876
RAW MAT. [NAME] (Lbs./Unit) |  | 112.4919433888859
PRODUCTION OUTPUT  (No. Units) |  |  | 114123.9728848778 |  | 121486.8098451925 |  | 132531.0652856645 |  | 368141.8480157348
FIN. PROD. INVENTORY   (No. Units) |  |  | 57833.95560645264 |  | 55902.31972134458 |  | 74205.70405098595 |  | 187941.9793787832
RAW MAT.INVENTORY (Million Lbs.) |  | 58.58700807393413
[NAME]  (No. Units) |  |  | 79217.71027002907 |  | 88126.40371216029 |  | 87294.89393338183 |  | 254639.0079155712
SALES   (No. Units) |  |  | 79217.71027002907 |  | 88126.40371216029 |  | 87294.89393338183 |  | 254639.0079155712
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 27726.19859451018 |  | 30403.6092806953 |  | 29243.78946768291 |  | 87373.59734288839
SALESPEOPLE ACTIVE  (No.) |  |  | 27 |  | 27 |  | 27 |  | 81
SALES TRAINEES  (No.) |  |  | 0 |  | 0 |  | 0 |  | 0
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 18269.52132418154 |  | ADVERTISING | 1225 |  |  | R & D | 1300
MATERIAL | 19049.9762859903 |  | SALARIES | 403.623 |  |  | CARRYING - FIN. PROD. | 297.7565571144784
MAINTENANCE | 2740.42819862723 |  | COMMISSIONS | 3276.509900358315 |  |  | CARRYING - RAW. Mat. | 200
TRAINING | 500 |  | TRANSPORTATION | 2912.002017804462 |  |  | BOND INTEREST | 750
PROD. LEVEL CHANGE | 0 |  | ADMINISTRATIVE | 3583.195039577856 |  |  | LOAN INTEREST | 97.5
EQUIPMENT | 1904.99762859903 |  | SALES FORCE CHANGE | 29 |  |  | ADMINISTRATIVE | 6949.289716721175
ADMINISTRATIVE | 2240.709240078674 |  | TRAINING | 750 |  |  | BOND CALL PREMIUM | 0
[NAME] | 475.1427101701211
TOTAL | 45180.77538764689 |  | TOTAL | 12179.32995774063 |  |  | TOTAL | 9594.546273835653
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 87373.59734288839 |  | ACCOUNTS COLLECTED | 84598.21867433625 |  |  | CASH BALANCE | 0
BEGINNING INVENTORY | 11439.05953912347 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 29124.53244762946
TOTAL PRODUCTION COST | 45180.77538764689 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 23065.46892723707
GOODS AVAILABLE | 56619.83492677035 |  | SAV. ACCOUNT INT. | 420 |  |  | INVENTORY - RAW MAT | 24950.0237140097
ENDING INVENTORY | 23065.46892723707 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 21000
COST OF GOODS SOLD | 33554.36599953328 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 98140.02508887624
GROSS PROFIT | 53819.23134335511 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 2645.203013080216 |  |  | PLANT & EQUIP. VALUE | 47039.12830684199
TOTAL MARKETING COST | 12179.32995774063 |  | TOTAL SOURCES | 87663.42168741647 |  |  | TOTAL ASSETS | 145179.1533957182
PROFIT ON SALES | 41639.90138561447
 |  |  | TOTAL PRODUCTION COST | 46655.65639148647 |  |  | BANK LOAN BALANCE | 844.5109921975236
TOTAL OTHER COST | 9594.546273835653 |  | TOTAL MARKETING COST | 12179.32995774063
TOTAL OTHER INCOME | 420 |  | TOTAL OTHER COST | 9594.546273835653 |  |  | BONDS OUTSTANDING | 30000
NET PROFIT BEFORE TAXES | 32465.35511177882 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 3000 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 16232.67755588941 |  | BONDS REDEEMED | 0 |  |  | ACCUM. RET. EARNINGS | 50475.24240352068
 |  |  | INCOME TAXES | 16232.67755588941 |  |  | TOTAL STOCK EQUITY | 114334.6424035207
NET PROFIT AFTER TAXES | 16232.67755588941 |  | PROFIT SHARING | 845.7225006618385 |  |  | TOTAL LIABILITIES | 145179.1533957182
PROFIT SHARING COST | 845.7225006618385 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 0
NET INCOME | 15386.95505522757 |  | TOTAL DISBURSEMENTS | 88507.932679614
DIVIDENDS PAID | 0
[NAME] | 15386.95505522757 |  | CASH AVAILABLE | -844.5109921975236
 |  |  | EMERGENCY BANK LOAN | 844.5109921975236
 |  |  | CASH BALANCE | 0
5.  Economy and Stockmarket Report
Gross Domestic Product | 207 | $ Billions
Personal Consumption Expenditures | 18 | $ Billions
No. of [NAME] | 312 | 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 | 2.227690895030797 | 0 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 6.13684690079349 | 0 | 6000 | 10 | 13
Co.3 Name | 10.57303333333333 | 4.673922197306593 | 0.3333333333333333 | 6000 | 10 | 13
Co.4 Name | 10.64823333333334 | 0.8908371745482729 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 3.372859978902931 | 0 | 6000 | 16 | 19
Co.6 Name | 10.34495987899719 | 8.634134231047796 | 0 | 6020 | 16 | 19
[NAME] | 10.64323333333334 | 2.564492509204596 | 0 | 6000 | 13 | 16
Co.8 Name | 10.65833333333334 | 5.587657181764498 | 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 | 322.0226361449257 | 1003.956909776184 | 4.002170280755505 | 6.155978352738051 | 1676.157636095268 | 6.076876332751216 | 4022.254914509514 | 409136.0848861389 | 82.34329378413702 | 348525.0695533514
Co.2 Name | 349.2328931698733 | 317.6324062108515 | 4.172493908345539 | 9.419842424250144 | 1601.377874426302 | 6.563381287310609 | 7086.923840215671 | 640829.784548463 | 78.7756885856298 | 479270.3368118554
Co.3 Name | 341.6197837300268 | 498.2836623731849 | 3.391560711105074 | 4.962661009466491 | 1839.660398618687 | 5.631615456122001 | 3365.736853491341 | 303432.4009611969 | 66.6605723175642 | 329627.9459983337
Co.4 Name | 328.4924469686513 | 473.5972051557928 | 3.439790202777092 | 3.529250320353472 | 1579.746615568515 | 5.654988254436802 | 3524.169611155542 | 207232.3137629274 | 70.11127731037645 | 164572.3319121959
Co.5 Name | 345.9581386542328 | 377.8866191542785 | 3.965562337610851 | 4.534104483293097 | 1628.062962270272 | 6.190873025200235 | 5270.269211834233 | 380432.6527597299 | 59.29894879858632 | 345262.9596971846
Co.6 Name | 334.8717743752993 | 457.1843033225028 | 4.839351182985751 | 5.084147284534285 | 1514.249925373417 | 6.425337924927319 | 6091.267304702863 | 621342.0370256574 | 58.08198467953971 | 666111.0346836068
[NAME] | 343.5053799133998 | 396.1647406317698 | 3.729782762594783 | 5.223619435566151 | 1574.022607133809 | 6.335491713106022 | 4858.854791834132 | 359500.0000230015 | 77.61863410493226 | 256853.7575545803
Co.8 Name | 364.6632997104219 | 445.6411023656889 | 3.87752341499714 | 6.961127446998356 | 1912.065444525104 | 7.064336230090073 | 4769.509793412417 | 376400.6722996862 | 77.99171973665463 | 394333.6960829893