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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 3 | Quarter= | 1
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 375 |  | 330 |  | 290
Advertising ($1,000/Qtr.) |  |  | 325 |  | 325 |  | 300
Sales Force Change (No.) |  |  | 1 |  | 1 |  | 3
Product R&D ($1,000/Qtr.) |  | 60
Sales Commision (%) |  | 0.42
Profit Sharing (%) |  | 0.4
Sales Salaries ($/Month) |  | 1500
[NAME] ($1,000/Qtr.) |  | 30
[NAME] ($1,000/Qtr.) |  | 20
Production Wages ($/Hour) |  | 6.15
Production Scheduled (Hours/week) |  | 45
Labor Force Change (No.) |  | -150
Allocation To Markets (%) |  |  | 37 |  | 33 |  | 30
Process R&D ($1,000/Qtr.) |  | 55
Raw Material Ordered (Million lbs.) |  | 20
Bonds Sold or Redeemed ($1,000) |  | 10000
Bank Loan Requested ($1,000) |  | 5000
[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.) |  | 3850
PRODUCTIVITY (Units/Production-Hr.) |  | 0.06536235790014244
RAW MAT. [NAME] (Lbs./Unit) |  | 234.1070515450285
PRODUCTION OUTPUT  (No. Units) |  |  | 51745.14825907943 |  | 46151.07817701679 |  | 41955.52561546981 |  | 139851.752051566
FIN. PROD. INVENTORY   (No. Units) |  |  | 7117.413647534777 |  | 4687.930484415767 |  | 25912.86865382009 |  | 37718.21278577063
RAW MAT.INVENTORY (Million Lbs.) |  | 46.51112177744181
[NAME]  (No. Units) |  |  | 49299.62245551327 |  | 49455.81015710963 |  | 46398.09071162112 |  | 145153.523324244
SALES   (No. Units) |  |  | 49299.62245551327 |  | 49455.81015710963 |  | 46398.09071162112 |  | 145153.523324244
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 18487.35842081748 |  | 16320.41735184618 |  | 13455.44630637012 |  | 48263.22207903378
SALESPEOPLE ACTIVE  (No.) |  |  | 19 |  | 24 |  | 12 |  | 55
SALES TRAINEES  (No.) |  |  | 1 |  | 1 |  | 3 |  | 5
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 13889.8134375 |  | ADVERTISING | 950 |  |  | R & D | 115
MATERIAL | 13672.80541638564 |  | SALARIES | 270 |  |  | CARRYING - FIN. PROD. | 172.0799362337945
MAINTENANCE | 2083.472015625 |  | COMMISSIONS | 202.7055327319418 |  |  | CARRYING - RAW. Mat. | 237.0056124145613
TRAINING | 20 |  | TRANSPORTATION | 1131.400674097169 |  |  | BOND INTEREST | 750
PROD. LEVEL CHANGE | 60.4 |  | ADMINISTRATIVE | 2825.76761662122 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1367.280541638565 |  | SALES FORCE CHANGE | 42 |  |  | ADMINISTRATIVE | 4528.411103951689
ADMINISTRATIVE | 1099.25876025783 |  | TRAINING | 30 |  |  | BOND CALL PREMIUM | 0
[NAME] | 476.2500834111628
TOTAL | 32669.2802548182 |  | TOTAL | 5451.873823450331 |  |  | TOTAL | 5802.496652600044
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 48263.22207903377 |  | ACCOUNTS COLLECTED | 50941.9307962407 |  |  | CASH BALANCE | 34663.06692304664
BEGINNING INVENTORY | 8594.326341099566 |  | BANK LOAN REQUESTED | 5000 |  |  | ACCOUNTS RECEIVABLE | 16087.74069301126
TOTAL PRODUCTION COST | 32669.2802548182 |  | BOND SALE RETURN | 10000 |  |  | INVENTORY - FIN. PROD. | 8810.950496743597
GOODS AVAILABLE | 41263.60659591777 |  | SAV. ACCOUNT INT. | 320 |  |  | INVENTORY - RAW MAT | 20871.42012072483
ENDING INVENTORY | 8810.950496743597 |  | SAV. ACCT. WITHDRAWAL | 2000 |  |  | SAVINGS ACCT. BALANCE | 14000
COST OF GOODS SOLD | 32452.65609917418 |  | PLANT & EQUIP. SALE | 90.6 |  |  | TOTAL CURRENT ASSETS | 94433.17823352633
GROSS PROFIT | 15810.5659798596 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 8378.462700789925 |  |  | PLANT & EQUIP. VALUE | 47058.15825770512
TOTAL MARKETING COST | 5451.873823450331 |  | TOTAL SOURCES | 76730.99349703063 |  |  | TOTAL ASSETS | 141491.3364912315
PROFIT ON SALES | 10358.69215640927
 |  |  | TOTAL PRODUCTION COST | 28320.2247550214 |  |  | BANK LOAN BALANCE | 5000
TOTAL OTHER COST | 5802.496652600044 |  | TOTAL MARKETING COST | 5451.873823450331
TOTAL OTHER INCOME | 410.6 |  | TOTAL OTHER COST | 5802.496652600044 |  |  | BONDS OUTSTANDING | 40000
NET PROFIT BEFORE TAXES | 4966.795503809224 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 2483.397751904612 |  | BONDS REDEEMED | 0 |  |  | ACCUM. RET. EARNINGS | 32631.93649123143
 |  |  | INCOME TAXES | 2483.397751904612 |  |  | TOTAL STOCK EQUITY | 96491.33649123146
NET PROFIT AFTER TAXES | 2483.397751904612 |  | PROFIT SHARING | 9.933591007618448 |  |  | TOTAL LIABILITIES | 141491.3364912315
PROFIT SHARING COST | 9.933591007618448 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 0
NET INCOME | 2473.464160896994 |  | TOTAL DISBURSEMENTS | 42067.926573984
DIVIDENDS PAID | 0
[NAME] | 2473.464160896994 |  | CASH AVAILABLE | 34663.06692304664
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 34663.06692304664
5.  Economy and Stockmarket Report
Gross Domestic Product | 137 | $ Billions
Personal Consumption Expenditures | 15 | $ Billions
No. of [NAME] | 378 | 1000's
Raw Material Cost | 0.45 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.65833333333333 | 0.5654399515550744 | 0 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 0.7698212713621498 | 0 | 6000 | 10 | 13
Co.3 Name | 10.65833333333333 | 0.5611137314018533 | 0.1666666666666667 | 6000 | 10 | 13
Co.4 Name | 10.65833333333333 | 0.2444414895927196 | 0 | 6000 | 10 | 13
Co.5 Name | 10.65833333333333 | 0.2999948707789697 | 0.4166666666666667 | 6000 | 13 | 16
Co.6 Name | 10.65821569295067 | 0.4336062422266061 | 0 | 6020 | 10 | 13
[NAME] | 10.64323333333334 | 0.4122440268161656 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333333 | 0.689480301759553 | 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 | 343.2111928566693 | 303.464781177038 | 0.45424986386961 | 0.5849279545461437 | 1555.991248133082 | 5.493036483736219 | 3675.828060102419 | 143457.5428391777 | 52.05368284439335 | 142411.4343954086
Co.2 Name | 355.6379010857093 | 275.8654703468367 | 1.855152831389416 | 1.010338977306336 | 1507.869671555044 | 5.828301253356948 | 4271.921773337655 | 152557.4964385925 | 55.52383303270729 | 158752.5539667695
Co.3 Name | 347.9759237937957 | 349.6196393975515 | 0.6286916569907947 | 0.8759758118172681 | 1555.007811756716 | 5.49131393735088 | 4413.846706240071 | 173268.3505971166 | 53.05962191467427 | 159745.5744814957
Co.4 Name | 313.4617564718776 | 311.2375192849913 | 2.486889625239204 | 0.9576060298756875 | 1498.686733209813 | 5.585682003123495 | 3993.97812757596 | 140833.5170453144 | 61.16305347424671 | 154434.2869596414
Co.5 Name | 318.6793344964855 | 298.6572842227509 | 0.9855339859497911 | 0.3035585622555561 | 1628.201451640263 | 5.371416015485209 | 5304.743484544779 | 198534.493675409 | 58.90526288409293 | 146149.2201131018
Co.6 Name | 345.0555857943331 | 298.3487142781038 | 1.001406356412825 | 1.534979481838393 | 1430.592305021264 | 6.102796933244168 | 5005.738457353649 | 201600.426469662 | 57.55874567141732 | 138729.0701436553
[NAME] | 354.8276530617154 | 330.1881978334528 | 0.425062893324592 | 0.3689329797847357 | 1485.283151090721 | 6.153582861137982 | 3729.937074220447 | 141672.6227182616 | 54.61262044168576 | 141709.1532432571
Co.8 Name | 365.041657384741 | 270.0264963952758 | 1.949311948842124 | 1.016805666321318 | 1627.00685816791 | 5.953826625054364 | 4502.075933402753 | 150589.7172714136 | 58.40663651886164 | 140123.3481370167