Spreadsheet: 145704d1331719288-autofill-across-worksheets-ef57_sample-workbook
Sheet: Y4Q2

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 4 | Quarter= | 2
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 350 |  | 340 |  | 330
Advertising ($1,000/Qtr.) |  |  | 450 |  | 400 |  | 450
Sales Force Change (No.) |  |  | 1 |  | 5 |  | 4
Product R&D ($1,000/Qtr.) |  | 650
Sales Commision (%) |  | 3.75
Profit Sharing (%) |  | 6.01
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.) |  | 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) |  | 4000
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 5253.614933793035
PRODUCTIVITY (Units/Production-Hr.) |  | 0.09698674545868034
RAW MAT. [NAME] (Lbs./Unit) |  | 153.0309433804944
PRODUCTION OUTPUT  (No. Units) |  |  | 20257.3409764076 |  | 21564.26620069196 |  | 23524.6540371185 |  | 65346.26121421807
FIN. PROD. INVENTORY   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
RAW MAT.INVENTORY (Million Lbs.) |  | 40
[NAME]  (No. Units) |  |  | 62983.65352834391 |  | 77769.51766717224 |  | 74636.6742167346 |  | 215389.8454122508
SALES   (No. Units) |  |  | 47271.85810282436 |  | 44675.33180591285 |  | 53082.4672422523 |  | 145029.6571509895
BACKORDERS   (No. Units) |  |  | 7855.897712759772 |  | 16547.0929306297 |  | 10777.10348724115 |  | 35180.09413063062
SALES  ($1000) |  |  | 16545.15033598853 |  | 15189.61281401037 |  | 17517.21418994326 |  | 49251.97733994215
SALESPEOPLE ACTIVE  (No.) |  |  | 29 |  | 24 |  | 25 |  | 78
SALES TRAINEES  (No.) |  |  | 1 |  | 5 |  | 4 |  | 10
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 20437.87549618835 |  | ADVERTISING | 1300 |  |  | R & D | 1300
MATERIAL | 4900 |  | SALARIES | 462 |  |  | CARRYING - FIN. PROD. | 318.7335837470858
MAINTENANCE | 3065.681324428253 |  | COMMISSIONS | 1846.949150247831 |  |  | CARRYING - RAW. Mat. | 40
TRAINING | 500 |  | TRANSPORTATION | 2357.77833912155 |  |  | BOND INTEREST | 800
PROD. LEVEL CHANGE | 0 |  | ADMINISTRATIVE | 3105.148285754948 |  |  | LOAN INTEREST | 0
EQUIPMENT | 490 |  | SALES FORCE CHANGE | 82 |  |  | ADMINISTRATIVE | 5065.083347135019
ADMINISTRATIVE | 1890.378216890993 |  | TRAINING | 500 |  |  | BOND CALL PREMIUM | 120
[NAME] | 484.7900318030008
TOTAL | 31768.7250693106 |  | TOTAL | 9653.875775124328 |  |  | TOTAL | 7643.816930882104
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 49251.97733994215 |  | ACCOUNTS COLLECTED | 50185.25065393 |  |  | CASH BALANCE | 13891.92574388388
BEGINNING INVENTORY | 16001.2305957588 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 16417.32577998072
TOTAL PRODUCTION COST | 31768.7250693106 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 0
GOODS AVAILABLE | 47769.9556650694 |  | SAV. ACCOUNT INT. | 340 |  |  | INVENTORY - RAW MAT | 18400
ENDING INVENTORY | 0 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 21000
COST OF GOODS SOLD | 47769.9556650694 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 69709.2515238646
GROSS PROFIT | 1482.021674872754 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 31448.3028334679 |  |  | PLANT & EQUIP. VALUE | 47994.21314849707
TOTAL MARKETING COST | 9653.875775124328 |  | TOTAL SOURCES | 81973.5534873979 |  |  | TOTAL ASSETS | 117703.4646723617
PROFIT ON SALES | -8171.854100251574
 |  |  | TOTAL PRODUCTION COST | 44783.9350375076 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 7643.816930882104 |  | TOTAL MARKETING COST | 9653.875775124328
TOTAL OTHER INCOME | 340 |  | TOTAL OTHER COST | 7643.816930882104 |  |  | BONDS OUTSTANDING | 30000
NET PROFIT BEFORE TAXES | -15475.67103113368 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 0 |  | BONDS REDEEMED | 2000 |  |  | ACCUM. RET. EARNINGS | 23844.06467236165
 |  |  | INCOME TAXES | 0 |  |  | TOTAL STOCK EQUITY | 87703.46467236168
NET PROFIT AFTER TAXES | -15475.67103113368 |  | PROFIT SHARING | 0 |  |  | TOTAL LIABILITIES | 117703.4646723617
PROFIT SHARING COST | 0 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 4000
NET INCOME | -15475.67103113368 |  | TOTAL DISBURSEMENTS | 68081.62774351402
DIVIDENDS PAID | 0
[NAME] | -15475.67103113368 |  | CASH AVAILABLE | 13891.92574388388
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 13891.92574388388
5.  Economy and Stockmarket Report
Gross Domestic Product | 226 | $ Billions
Personal Consumption Expenditures | 19 | $ Billions
No. of [NAME] | 315 | 1000's
Raw Material Cost | 0.46 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.56923333333334 | 2.323457032323688 | 1 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 3.71020970209993 | 0 | 6000 | 10 | 13
Co.3 Name | 10.60313333333334 | 2.842335074989906 | 0 | 6000 | 10 | 13
Co.4 Name | 10.65833333333334 | 0.1448358494646343 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 1.153106328753004 | 0 | 6000 | 16 | 19
Co.6 Name | 10.40894658996064 | 4.088477709680904 | 0 | 6020 | 16 | 19
[NAME] | 10.64323333333334 | -2.579278505188947 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333333 | 3.14325701600328 | 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 | 376.1846155461375 | 505.2742073712226 | 3.177311663895984 | 4.834697628618689 | 1665.180019132973 | 5.757456817690904 | 4838.808040051693 | 360283.5553993278 | 81.46473144070264 | 228162.7293481509
Co.2 Name | 325.5737554645298 | 325.5015113465769 | 3.507136233999072 | 9.685975898763587 | 1548.044230398685 | 6.333549031200769 | 4902.889820102601 | 349503.9564909511 | 78.22829716519445 | 348448.4066720585
Co.3 Name | 383.8739083393701 | 516.5176006967632 | 2.803341893469078 | 4.855438785079619 | 1760.033109063388 | 5.647064451543388 | 4026.714843021089 | 248934.5857843587 | 74.28793528516128 | 220239.5617574083
Co.4 Name | 364.6769910762789 | 338.7832836669556 | 2.856970004719863 | 1.519949084683258 | 1550.872089947809 | 5.559587233815983 | 4132.731205233816 | 171302.2745962267 | 51.15716964146613 | 129257.3652211045
Co.5 Name | 316.5069128631159 | 376.8144382455498 | 2.907900386879436 | 3.043535204192125 | 1615.598542359415 | 5.861885756463588 | 3942.916100590922 | 231889.4688950033 | 68.40768512987219 | 203343.4056051788
Co.6 Name | 319.0957929105397 | 465.8695555591181 | 5.204461358188865 | 4.955867938945934 | 1559.999320506389 | 6.753432792854329 | 6640.584576019054 | 493551.2669024097 | 60.05523812483654 | 381328.7655809288
[NAME] | 342.1896640287721 | 439.6975711704322 | 3.611380007479196 | 6.040542662023824 | 1762.968698428837 | 6.444368610506294 | 5118.876888287825 | 63624.69102699722 | 76.5987154324864 | 139344.6450841052
Co.8 Name | 324.342686370414 | 416.8104784870314 | 3.038453026910295 | 6.202062065906167 | 1687.177939808586 | 6.693955870026442 | 4299.642795085959 | 266740.1238310491 | 84.42498352629947 | 313342.2688626238