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

Industry = | 51 | Co.7 = | [NAME] |  |  | Year = | 5 | Quarter= | 2
1.  Decision Report |  |  | Market 1 |  | Market 2 |  | Market 3
Price ($/Unit) |  |  | 345 |  | 340 |  | 335
Advertising ($1,000/Qtr.) |  |  | 450 |  | 440 |  | 440
Sales Force Change (No.) |  |  | 0 |  | 0 |  | 0
Product R&D ($1,000/Qtr.) |  | 500
Sales Commision (%) |  | 5
Profit Sharing (%) |  | 5.45
Sales Salaries ($/Month) |  | 1750
[NAME] ($1,000/Qtr.) |  | 200
[NAME] ($1,000/Qtr.) |  | 500
Production Wages ($/Hour) |  | 6.51
Production Scheduled (Hours/week) |  | 40
Labor Force Change (No.) |  | -200
Allocation To Markets (%) |  |  | 32 |  | 33 |  | 35
Process R&D ($1,000/Qtr.) |  | 500
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) |  | 0
2.  Production and Sales Report |  |  | Market 1 |  | Market 2 |  | Market 3 |  | Total
[NAME]No.) |  | 4916.61378149444
PRODUCTIVITY (Units/Production-Hr.) |  | 0.1741740752229333
RAW MAT. [NAME] (Lbs./Unit) |  | 94
PRODUCTION OUTPUT  (No. Units) |  |  | 139275.3167552887 |  | 143627.6704038915 |  | 152332.377701097 |  | 435235.3648602772
FIN. PROD. INVENTORY   (No. Units) |  |  | 132959.8115807065 |  | 110631.5501822577 |  | 171970.2877346802 |  | 415561.6494976444
RAW MAT.INVENTORY (Million Lbs.) |  | 63.98708921816097
[NAME]  (No. Units) |  |  | 115571.6201842887 |  | 133923.6418460213 |  | 114635.7770997513 |  | 364131.0391300614
SALES   (No. Units) |  |  | 115571.6201842887 |  | 133923.6418460213 |  | 114635.7770997513 |  | 364131.0391300614
BACKORDERS   (No. Units) |  |  | 0 |  | 0 |  | 0 |  | 0
SALES  ($1000) |  |  | 39872.20896357961 |  | 45534.03822764726 |  | 38402.9853284167 |  | 123809.2325196436
SALESPEOPLE ACTIVE  (No.) |  |  | 24 |  | 27 |  | 20 |  | 71
SALES TRAINEES  (No.) |  |  | 0 |  | 0 |  | 0 |  | 0
3. Cost Report
PRODUCTION  ($1000) |  |  | MARKETING  ($1000) |  |  |  | OTHER ($1000)
LABOR | 16267.53132814875 |  | ADVERTISING | 1330 |  |  | R & D | 1000
MATERIAL | 16866.4530127936 |  | SALARIES | 372.75 |  |  | CARRYING - FIN. PROD. | 1754.839853536395
MAINTENANCE | 2440.129699222313 |  | COMMISSIONS | 6190.461625982179 |  |  | CARRYING - RAW. Mat. | 239.9101494557883
TRAINING | 500 |  | TRANSPORTATION | 3455.768796990601 |  |  | BOND INTEREST | 1137.5
PROD. LEVEL CHANGE | 80.4 |  | ADMINISTRATIVE | 4030.655195650307 |  |  | LOAN INTEREST | 0
EQUIPMENT | 1686.64530127936 |  | SALES FORCE CHANGE | 0 |  |  | ADMINISTRATIVE | 8653.407436700783
ADMINISTRATIVE | 2576.176824301386 |  | TRAINING | 200 |  |  | BOND CALL PREMIUM | 0
[NAME] | 465.6873702377356
TOTAL | 40883.02353598315 |  | TOTAL | 15579.63561862309 |  |  | TOTAL | 12785.65743969297
4.  Financial Statements
INCOME STATEMENT  ($1000) |  |  | FLOW OF FUNDS  ($1000) |  |  |  | FINANCIAL POSITION  ($1000)
GROSS SALES REVENUE | 123809.2325196436 |  | ACCOUNTS COLLECTED | 110978.873646268 |  |  | CASH BALANCE | 17664.84087834797
BEGINNING INVENTORY | 35050.97443380066 |  | BANK LOAN REQUESTED | 0 |  |  | ACCOUNTS RECEIVABLE | 41269.74417321452
TOTAL PRODUCTION COST | 40883.02353598315 |  | BOND SALE RETURN | 2000 |  |  | INVENTORY - FIN. PROD. | 39188.65575986839
GOODS AVAILABLE | 75933.99796978381 |  | SAV. ACCOUNT INT. | 420 |  |  | INVENTORY - RAW MAT | 30841.23577380821
ENDING INVENTORY | 39188.65575986839 |  | SAV. ACCT. WITHDRAWAL | 0 |  |  | SAVINGS ACCT. BALANCE | 21000
COST OF GOODS SOLD | 36745.34220991543 |  | PLANT & EQUIP. SALE | 120.6 |  |  | TOTAL CURRENT ASSETS | 149964.4765852391
GROSS PROFIT | 87063.89030972814 |  | STOCK SALE RETURN | 0
 |  |  | BEGINNING CASH | 6895.410194154814 |  |  | PLANT & EQUIP. VALUE | 45982.44965353583
TOTAL MARKETING COST | 15579.63561862309 |  | TOTAL SOURCES | 120414.8838404229 |  |  | TOTAL ASSETS | 195946.9262387749
PROFIT ON SALES | 71484.25469110506
 |  |  | TOTAL PRODUCTION COST | 43150.88315295181 |  |  | BANK LOAN BALANCE | 0
TOTAL OTHER COST | 12785.65743969297 |  | TOTAL MARKETING COST | 15579.63561862309
TOTAL OTHER INCOME | 540.6 |  | TOTAL OTHER COST | 12785.65743969297 |  |  | BONDS OUTSTANDING | 37000
NET PROFIT BEFORE TAXES | 59239.19725141209 |  | DIVIDENDS PAID | 0
 |  |  | [NAME] | 0 |  |  | CAPITAL STOCK VALUE | 63738.8
INCOME TAXES | 29619.59862570605 |  | BONDS REDEEMED | 0 |  |  | ACCUM. RET. EARNINGS | 95208.12623877487
 |  |  | INCOME TAXES | 29619.59862570605 |  |  | TOTAL STOCK EQUITY | 158946.9262387749
NET PROFIT AFTER TAXES | 29619.59862570605 |  | PROFIT SHARING | 1614.268125100979 |  |  | TOTAL LIABILITIES | 195946.9262387749
PROFIT SHARING COST | 1614.268125100979 |  | PLANT & EQUIP. INVEST. | 0
 |  |  | SAVINGS ACCT. DEPOSIT | 0
NET INCOME | 28005.33050060507 |  | TOTAL DISBURSEMENTS | 102750.0429620749
DIVIDENDS PAID | 0
[NAME] | 28005.33050060507 |  | CASH AVAILABLE | 17664.84087834797
 |  |  | EMERGENCY BANK LOAN | 0
 |  |  | CASH BALANCE | 17664.84087834797
5.  Economy and Stockmarket Report
Gross Domestic Product | 199 | $ Billions
Personal Consumption Expenditures | 20 | $ Billions
No. of [NAME] | 321 | 1000's
Raw Material Cost | 0.42 | $ / lb.
 | STOCK | EARNINGS/ | DIVIDENDS/ |  | BOND | LOAN
COMPANY | PRICE | SHARE | SHARE | SHARES | INTEREST | INTEREST
Co.1 Name | 10.36913333333336 | 3.493369465725861 | 0 | 6000 | 10 | 13
Co.2 Name | 10.55813333333335 | 9.734406295777248 | 0 | 6000 | 10 | 13
Co.3 Name | 10.57303333333335 | 6.709809232440754 | 0 | 6000 | 11 | 14.5
Co.4 Name | 10.61813333333335 | 2.230647754979211 | 0 | 6000 | 10 | 13
Co.5 Name | 10.38823333333334 | 7.502408868097609 | 0 | 6000 | 16 | 19
Co.6 Name | 10.34495987899719 | 12.62319256820676 | 0 | 6020 | 16 | 19
[NAME] | 10.62313333333334 | 4.667555083434178 | 0 | 6000 | 13 | 16
Co.8 Name | 10.65833333333335 | 6.898521120697936 | 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 | 341.347017092785 | 1010.982090737153 | 5.927968810973554 | 5.846077895297068 | 1966.144225517911 | 6.612894711168094 | 3968.553294777423 | 386991.7226224675 | 81.33795457738151 | 538881.8251793906
Co.2 Name | 344.8835270625061 | 474.6137145266404 | 5.001914429279602 | 8.948341191417976 | 1667.790648394117 | 6.447550492401516 | 6131.547231963787 | 455331.8560803762 | 72.4743893405653 | 676082.0537321296
Co.3 Name | 352.9347017455729 | 534.0211688350585 | 3.679751102604575 | 4.872588471450592 | 1764.814936808535 | 6.302788833045919 | 3147.767808169117 | 299222.5582453248 | 80.51912837776537 | 417638.8598882455
Co.4 Name | 346.7318005584436 | 894.9131563014965 | 5.203624966819591 | 3.026524188126275 | 1627.678915552674 | 5.446466880812133 | 2793.713848615362 | 198902.2316026203 | 76.5799453608848 | 235132.7590933512
Co.5 Name | 334.0832145406749 | 495.884243857509 | 5.848729115543319 | 6.035193956461361 | 1621.764455650729 | 5.973855266645865 | 7201.487150981212 | 613859.8227640656 | 86.99599044492003 | 599916.613945818
Co.6 Name | 334.993811922368 | 633.7236038363628 | 4.638057432983874 | 10.05245465191036 | 1421.528250374307 | 6.826794584294249 | 7165.856599333218 | 703871.6705188799 | 88.85595281263542 | 885266.4684566485
[NAME] | 341.3975679635649 | 434.3416789857774 | 5.054704342396988 | 5.27922620480881 | 1713.659683107673 | 6.303759189712161 | 4702.921972881522 | 417284.4797679196 | 73.14793620538146 | 368677.4119012783
Co.8 Name | 362.2208599766994 | 497.3155593048135 | 4.398473749705869 | 7.471228449660111 | 1859.126545599382 | 7.306035757372817 | 4929.155634050356 | 417836.4377855885 | 92.75527212213433 | 482994.7096319124