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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 4 | Quarter= | 3
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 350 |  | 345 |  | 335
Advertising ($1,000/Qtr.) |  |  | 450 |  | 400 |  | 430
Sales Force Change (No.) |  |  | 0 |  | 0 |  | 0
Product R&D ($1,000/Qtr.) |  | 650
Sales Commision (%) |  | 3.75
Profit Sharing (%) |  | 5.61
Sales Salaries ($/Month) |  | 1750
[NAME] ($1,000/Qtr.) |  | 500
[NAME] ($1,000/Qtr.) |  | 500
Production Wages ($/Hour) |  | 6.3
Production Scheduled (Hours/week) |  | 45
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) |  | 3000
[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.1122741835287687
RAW MAT. [NAME] (Lbs./Unit) |  | 131.2050431156121
PRODUCTION OUTPUT  (No. Units) |  |  | 94508.56236580531 |  | 100605.8889700508 |  | 109751.8788764191 |  | 304866.3302122751
FIN. PROD. INVENTORY   (No. Units) |  |  | 22927.69270414961 |  | 22541.91519188028 |  | 28969.53421486632 |  | 74439.14211089621
RAW MAT.INVENTORY (Million Lbs.) |  | 50
[NAME]  (No. Units) |  |  | 71580.8696616557 |  | 78063.9737781705 |  | 80782.34466155274 |  | 230427.188101379
SALES   (No. Units) |  |  | 71580.8696616557 |  | 78063.9737781705 |  | 80782.34466155274 |  | 230427.188101379
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 25053.3043815795 |  | 26932.07095346882 |  | 27062.08546162017 |  | 79047.46079666849
SALESPEOPLE ACTIVE  (No.) |  |  | 30 |  | 29 |  | 29 |  | 88
SALES TRAINEES  (No.) |  |  | 0 |  | 0 |  | 0 |  | 0
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 20437.87549618835 |  | ADVERTISING | 1280 |  |  | R & D | 1300
MATERIAL | 18400 |  | SALARIES | 462 |  |  | CARRYING - FIN. PROD. | 0
MAINTENANCE | 3065.681324428253 |  | COMMISSIONS | 2964.279779875068 |  |  | CARRYING - RAW. Mat. | 160
TRAINING | 500 |  | TRANSPORTATION | 2729.420775125061 |  |  | BOND INTEREST | 750
PROD. LEVEL CHANGE | 0 |  | ADMINISTRATIVE | 3532.135940506895 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1840 |  | SALES FORCE CHANGE | 0 |  |  | ADMINISTRATIVE | 6554.857519971335
ADMINISTRATIVE | 2125.297582253515 |  | TRAINING | 500 |  |  | BOND CALL PREMIUM | 0
[NAME] | 479.9421314849707
TOTAL | 46848.79653435509 |  | TOTAL | 11467.83649550702 |  |  | TOTAL | 8764.857519971334
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 79047.46079666849 |  | ACCOUNTS COLLECTED | 69115.63295269864 |  |  | CASH BALANCE | 2645.202731686339
BEGINNING INVENTORY | 0 |  | BANK LOAN REQUESTED | 3000 |  |  | ACCOUNTS RECEIVABLE | 26349.15359888949
TOTAL PRODUCTION COST | 46848.79653435509 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 11439.05993330615
GOODS AVAILABLE | 46848.79653435509 |  | SAV. ACCOUNT INT. | 420 |  |  | INVENTORY - RAW MAT | 23000
ENDING INVENTORY | 11439.05993330615 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 21000
COST OF GOODS SOLD | 35409.73660104893 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 84433.41626388198
GROSS PROFIT | 43637.72419561955 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 13891.92538395974 |  |  | PLANT & EQUIP. VALUE | 47514.27101701211
TOTAL MARKETING COST | 11467.83649550702 |  | TOTAL SOURCES | 86427.55833665837 |  |  | TOTAL ASSETS | 131947.6872808941
PROFIT ON SALES | 32169.88770011253
 |  |  | TOTAL PRODUCTION COST | 50968.85440287012 |  |  | BANK LOAN BALANCE | 3000
TOTAL OTHER COST | 8764.857519971334 |  | TOTAL MARKETING COST | 11467.83649550702
TOTAL OTHER INCOME | 420 |  | TOTAL OTHER COST | 8764.857519971334 |  |  | BONDS OUTSTANDING | 30000
NET PROFIT BEFORE TAXES | 23825.03018014119 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 11912.5150900706 |  | BONDS REDEEMED | 0 |  |  | ACCUM. RET. EARNINGS | 35088.2872808941
 |  |  | INCOME TAXES | 11912.5150900706 |  |  | TOTAL STOCK EQUITY | 98947.68728089408
NET PROFIT AFTER TAXES | 11912.5150900706 |  | PROFIT SHARING | 668.2920965529604 |  |  | TOTAL LIABILITIES | 131947.6872808941
PROFIT SHARING COST | 668.2920965529604 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 0
NET INCOME | 11244.22299351763 |  | TOTAL DISBURSEMENTS | 83782.35560497204
DIVIDENDS PAID | 0
[NAME] | 11244.22299351763 |  | CASH AVAILABLE | 2645.202731686339
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 2645.202731686339
5.  Economy and Stockmarket Report
Gross Domestic Product | 150 | $ Billions
Personal Consumption Expenditures | 18 | $ Billions
No. of [NAME] | 302 | 1000's
Raw Material Cost | 0.42 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.36913333333335 | 3.018722696680197 | 2.5 | 6000 | 10 | 13
Co.2 Name | 10.65833333333335 | 3.83655013112647 | 0 | 6000 | 10 | 13
Co.3 Name | 10.60313333333334 | 4.087851697455866 | 0 | 6000 | 10 | 13
Co.4 Name | 10.65833333333334 | 0.7212746937362893 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 2.48672089744178 | 0 | 6000 | 16 | 19
Co.6 Name | 10.34495987899719 | 7.094875017065013 | 0 | 6020 | 16 | 19
[NAME] | 10.64323333333333 | 1.874037165586272 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333334 | 4.363782649849104 | 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 | 344.1917194212863 | 495.7334588630847 | 3.818160780921684 | 4.940566670466994 | 1692.647412470837 | 6.139710742430753 | 2817.529272957845 | 213918.9582926209 | 75.34250905668783 | 300260.2801309
Co.2 Name | 336.6711136371675 | 319.0099293284546 | 4.05054347309783 | 10.21517428595038 | 1635.765121758226 | 6.188793140322819 | 5081.914938243332 | 278055.8483515143 | 80.11401882190998 | 354997.7323187689
Co.3 Name | 356.3172410397108 | 492.8049151683695 | 3.306915334172194 | 4.614701825386656 | 1679.702871450087 | 5.779036420279948 | 3457.213954611503 | 289448.1861991839 | 72.25316094620538 | 319501.9895371199
Co.4 Name | 338.3532744090015 | 387.3891754806413 | 2.890461302489719 | 1.735288866152306 | 1563.245346644193 | 5.757111774532031 | 4192.803395932698 | 197062.5839844354 | 60.04594710331902 | 143801.1038772299
Co.5 Name | 341.3136058863459 | 396.2674399528301 | 4.096585182565718 | 4.018126536169373 | 1691.674418604863 | 5.667209185034303 | 4259.006031271072 | 264416.220502071 | 59.78490457057989 | 303848.8845841442
Co.6 Name | 322.2411703638633 | 466.7757421989327 | 5.1854799122274 | 5.144953235938143 | 1492.682457808861 | 6.596977169448543 | 5994.502768067073 | 576222.4305233669 | 54.45651808874073 | 569713.8592078428
[NAME] | 339.0872641669806 | 429.498851953136 | 3.81734551170398 | 5.316703941589266 | 1782.729877848632 | 6.358753655231054 | 5298.674026749993 | 299791.6237863036 | 88.01413181957265 | 239710.2305005728
Co.8 Name | 340.8884477526109 | 412.0473188553462 | 3.721736339138218 | 7.035373207803486 | 1824.907992005971 | 6.589338365454711 | 4217.911163462385 | 322477.5465258621 | 78.33955892756839 | 374349.8596727374