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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 3 | Quarter= | 2
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 370 |  | 325 |  | 300
Advertising ($1,000/Qtr.) |  |  | 350 |  | 370 |  | 410
Sales Force Change (No.) |  |  | 5 |  | 2 |  | 3
Product R&D ($1,000/Qtr.) |  | 65
Sales Commision (%) |  | 0.84
Profit Sharing (%) |  | 0.75
Sales Salaries ($/Month) |  | 1500
[NAME] ($1,000/Qtr.) |  | 40
[NAME] ($1,000/Qtr.) |  | 30
Production Wages ($/Hour) |  | 6.15
Production Scheduled (Hours/week) |  | 42
Labor Force Change (No.) |  | 0
Allocation To Markets (%) |  |  | 40 |  | 35 |  | 25
Process R&D ($1,000/Qtr.) |  | 70
Raw Material Ordered (Million lbs.) |  | 20
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) |  | -3000
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 3657.5
PRODUCTIVITY (Units/Production-Hr.) |  | 0.06325032994476941
RAW MAT. [NAME] (Lbs./Unit) |  | 240.5608074989761
PRODUCTION OUTPUT  (No. Units) |  |  | 47998.02520626082 |  | 41998.27205547821 |  | 29998.76575391302 |  | 119995.063015652
FIN. PROD. INVENTORY   (No. Units) |  |  | 2980.055945320906 |  | 0 |  | 0 |  | 2980.055945320906
RAW MAT.INVENTORY (Million Lbs.) |  | 37.64501282064663
[NAME]  (No. Units) |  |  | 52135.38102656182 |  | 62880.27184941842 |  | 60731.04789867115 |  | 175746.7007746514
SALES   (No. Units) |  |  | 52135.38102656182 |  | 46686.19858876934 |  | 55911.63547353321 |  | 154733.2150888644
BACKORDERS   (No. Units) |  |  | 0 |  | 8097.036630324536 |  | 2409.706212568974 |  | 10506.74284289351
SALES  ($1000) |  |  | 19290.09097982787 |  | 15173.01454135004 |  | 16773.49064205996 |  | 51236.59616323787
SALESPEOPLE ACTIVE  (No.) |  |  | 20 |  | 25 |  | 10 |  | 55
SALES TRAINEES  (No.) |  |  | 5 |  | 2 |  | 3 |  | 10
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 11945.23955625 |  | ADVERTISING | 1130 |  |  | R & D | 135
MATERIAL | 12953.38986072006 |  | SALARIES | 292.5 |  |  | CARRYING - FIN. PROD. | 150.8728320741329
MAINTENANCE | 1791.7859334375 |  | COMMISSIONS | 430.3874077711981 |  |  | CARRYING - RAW. Mat. | 186.0444883023296
TRAINING | 30 |  | TRANSPORTATION | 995.959023029912 |  |  | BOND INTEREST | 1000
PROD. LEVEL CHANGE | 0 |  | ADMINISTRATIVE | 2923.666075444322 |  |  | LOAN INTEREST | 162.5
EQUIPMENT | 1295.338986072006 |  | SALES FORCE CHANGE | 82 |  |  | ADMINISTRATIVE | 4623.717308161894
ADMINISTRATIVE | 999.9753150782602 |  | TRAINING | 40 |  |  | BOND CALL PREMIUM | 120
[NAME] | 470.5815825770512
TOTAL | 29486.31123413487 |  | TOTAL | 5894.512506245432 |  |  | TOTAL | 6378.134628538357
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 51236.59616323787 |  | ACCOUNTS COLLECTED | 50245.47190751618 |  |  | CASH BALANCE | 43007.76858815222
BEGINNING INVENTORY | 8810.949416829415 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 17078.86538774595
TOTAL PRODUCTION COST | 29486.31123413487 |  | BOND SALE RETURN | 0 |  |  | INVENTORY - FIN. PROD. | 732.2872699138002
GOODS AVAILABLE | 38297.26065096429 |  | SAV. ACCOUNT INT. | 280 |  |  | INVENTORY - RAW MAT | 16918.03038451252
ENDING INVENTORY | 732.2872699138002 |  | SAV. ACCT. WITHDRAWAL | 3000 |  |  | SAVINGS ACCT. BALANCE | 11000
COST OF GOODS SOLD | 37564.97338105048 |  | PLANT & EQUIP. SALE | 0 |  |  | TOTAL CURRENT ASSETS | 88736.95163032449
GROSS PROFIT | 13671.62278218738 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 34663.06758863715 |  |  | PLANT & EQUIP. VALUE | 46587.57667512807
TOTAL MARKETING COST | 5894.512506245432 |  | TOTAL SOURCES | 88188.53949615333 |  |  | TOTAL ASSETS | 135324.5283054525
PROFIT ON SALES | 7777.110275941952
 |  |  | TOTAL PRODUCTION COST | 25062.33979083776 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 6378.134628538357 |  | TOTAL MARKETING COST | 5894.512506245432
TOTAL OTHER INCOME | 280 |  | TOTAL OTHER COST | 6378.134628538357 |  |  | BONDS OUTSTANDING | 38000
NET PROFIT BEFORE TAXES | 1678.975647403595 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 5000 |  |  | CAPITAL STOCK VALUE | 63859.4
INCOME TAXES | 839.4878237017974 |  | BONDS REDEEMED | 2000 |  |  | ACCUM. RET. EARNINGS | 33465.12830545254
 |  |  | INCOME TAXES | 839.4878237017974 |  |  | TOTAL STOCK EQUITY | 97324.52830545255
NET PROFIT AFTER TAXES | 839.4878237017974 |  | PROFIT SHARING | 6.296158677763481 |  |  | TOTAL LIABILITIES | 135324.5283054525
PROFIT SHARING COST | 6.296158677763481 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 0
NET INCOME | 833.1916650240339 |  | TOTAL DISBURSEMENTS | 45180.77090800111
DIVIDENDS PAID | 0
[NAME] | 833.1916650240339 |  | CASH AVAILABLE | 43007.76858815222
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 43007.76858815222
5.  Economy and Stockmarket Report
Gross Domestic Product | 188 | $ Billions
Personal Consumption Expenditures | 19 | $ Billions
No. of [NAME] | 381 | 1000's
Raw Material Cost | 0.39 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.65833333333333 | 0.7362467776160476 | 0 | 6000 | 10 | 13
Co.2 Name | 10.65833333333334 | 1.129722282670955 | 0 | 6000 | 10 | 13
Co.3 Name | 10.63323333333332 | 0.851921000140472 | 0 | 6000 | 10 | 13
Co.4 Name | 10.65833333333333 | 0.381606726663709 | 0 | 6000 | 10 | 13
Co.5 Name | 10.65833333333334 | -1.102509097311648 | 0.1666666666666667 | 6000 | 16 | 19
Co.6 Name | 10.65821569295067 | 0.7367565139103943 | 0 | 6020 | 10 | 13
[NAME] | 10.64323333333333 | 0.1388652775040057 | 0 | 6000 | 10 | 13
Co.8 Name | 10.65833333333333 | 0.6390288518430086 | 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 | 330.0378302498055 | 401.8831685942321 | 1.536032044234952 | 3.18755799869503 | 1658.024322635729 | 5.577528603163278 | 4116.955340461011 | 162225.097836038 | 64.03549587871134 | 172566.168554319
Co.2 Name | 342.3576539470624 | 321.5390641173213 | 1.874754603264256 | 1.152481867407021 | 1555.087604103307 | 5.817887423891754 | 3979.201730878958 | 161067.2187506952 | 61.99007090720535 | 190302.8945100065
Co.3 Name | 364.7137108662675 | 247.323662155754 | 0.6651533553199156 | 0.8897336807946824 | 1595.677517905347 | 5.92314762465908 | 3750.61006963846 | 106384.7893815036 | 60.61027284175364 | 165929.5565219799
Co.4 Name | 331.3937394516383 | 302.0203001380311 | 2.535395499373685 | 1.014150295103848 | 1459.872006382432 | 5.551150844624123 | 4541.942470391264 | 171296.2585935368 | 45.27814926253982 | 171909.4127834106
Co.5 Name | 350.1663466620178 | 343.6046115570036 | 1.054963337223549 | 0.3037197634132679 | 1605.210094049521 | 5.529025569458324 | 6564.647308639056 | 245890.9018120334 | 60.31029995303641 | 186791.7798848793
Co.6 Name | 328.8317740389426 | 367.825632114748 | 1.735377277946199 | 9.029999818606328 | 1483.823003720453 | 5.812649261842056 | 5045.68699797228 | 213663.1570832018 | 57.14176106122744 | 203152.2867741472
[NAME] | 329.861649437853 | 378.8986833546262 | 0.8267826018026426 | 0.7459980791810732 | 1513.416329054391 | 6.089623235598384 | 3570.936472248045 | 120282.395220321 | 56.40715762880578 | 157295.537683683
Co.8 Name | 341.691006660112 | 303.8868974449553 | 2.084082497316056 | 0.9863593750477745 | 1601.154046346732 | 5.848283267306618 | 4443.282437153503 | 141394.361226282 | 75.16025037784232 | 148722.3084223263