View the step-by-step solution to:

Industry = 7 Company 7 Name 1. Decision Report Year = 3 Quarter= 1 Market 1 Market 3 300 400 4 300 400 2 300 400 4 11 19 70 Market 1 Market 2 Market...

How to predict sales forecast, production force change and desired end inventory for a production plan year 3? How to predict GDP, personal consumption expenditures or household formations for year 3 for a sales forecast plan? How to predict required raw materials for next period and desired end inventory for next period for the raw materials inventory spreadsheet. Essentially I don't understand how to fill out the blank excels and need help filling it all out.
Industry = 7 Company 7 Name Year = 3 Quarter= 1 1. Decision Report Market 1 Market 2 Market 3 Price ($/Unit) 300 300 300 Advertising ($1,000/Qtr.) 400 400 400 Sales Force Change (No.) 4 2 4 Product R&D ($1,000/Qtr.) 65 Sales Commision (%) 0.0004 Profit Sharing (%) 0.0 Sales Salaries ($/Month) 1,500 Sales Training ($1,000/Qtr.) 30 Production Training ($1,000/Qtr.) 20 Production Wages ($/Hour) 5.00 Production Scheduled (Hours/week) 40 Labor Force Change (No.) 1,602 Al ocation To Markets (%) 11 19 70 Process R&D ($1,000/Qtr.) 65 Raw Material Ordered (Mil ion lbs.) 31 Bonds Sold or Redeemed ($1,000) 1 Bank Loan Requested ($1,000) 500 Dividends Paid ($1,000) 3 Stocks Issued (1,000 Shares) 1 Savings Account ($1,000) 20 2. Production and Sales Report Market 1 Market 2 Market 3 Total PRODUCTION WORKFORCE (No.) 5,602 PRODUCTIVITY (Units/Production-Hr.) 0.065 RAW MAT. REQ'MTS (Lbs./Unit) 234 PRODUCTION OUTPUT (No. Units) 17,461 30,159 111,114 158,734 FIN. PROD. INVENTORY (No. Units) 0 0 98,330 98,330 RAW MAT.INVENTORY (Mil ion Lbs.) 53.178 DEMAND (No. Units) 64,619 54,930 43,139 162,688 SALES (No. Units) 22,133 38,152 43,139 103,424 BACKORDERS (No. Units) 21,243 8,389 0 29,632 SALES ($1000) 6,640 11,446 12,942 31,027 SALESPEOPLE ACTIVE (No.) 24 21 9 54 SALES TRAINEES (No.) 4 2 4 10 3. Cost Report PRODUCTION ($1000) MARKETING ($1000) OTHER ($1000) LABOR 12,118 ADVERTISING 1,200 R & D 130 MATERIAL 15,482 SALARIES 288 CARRYING - FIN. PROD. 172 MAINTENANCE 1,818 COMMISSIONS 0 CARRYING - RAW. Mat. 237 TRAINING 20 TRANSPORTATION 1,027 BOND INTEREST 750 PROD. LEVEL CHANGE 1,603 ADMINISTRATIVE 2,657 LOAN INTEREST - EQUIPMENT 1,548 SALES FORCE CHANGE 82 ADMINISTRATIVE 3,969 ADMINISTRATIVE 1,194 TRAINING 30 BOND CALL PREMIUM - DEPRECIATION 476 TOTAL 34,259 TOTAL 5,284 TOTAL 5,258 4. Financial Statements INCOME STATEMENT ($1000) FLOW OF FUNDS ($1000) FINANCIAL POSITION ($1000) GROSS SALES REVENUE 31,027 ACCOUNTS COLLECTED 39,451 CASH BALANCE 2,202 BEGINNING INVENTORY 8,594 BANK LOAN REQUESTED 500 ACCOUNTS RECEIVABLE 10,342 TOTAL PRODUCTION COST 34,259 BOND SALE RETURN 1 INVENTORY - FIN. PROD. 21,222 GOODS AVAILABLE 42,853 SAV. ACCOUNT INT. 320 INVENTORY - RAW MAT 24,452 ENDING INVENTORY 21,222 SAV. ACCT. WITHDRAWAL - SAVINGS ACCT. BALANCE 16,020 COST OF GOODS SOLD 21,631 PLANT & EQUIP. SALE - TOTAL CURRENT ASSETS 74,238 GROSS PROFIT 9,396 STOCK SALE RETURN 11 BEGINNING CASH 8,378 PLANT & EQUIP. VALUE 49,553 TOTAL MARKETING COST 5,284 TOTAL SOURCES 48,661 TOTAL ASSETS 123,791 PROFIT ON SALES 4,112 TOTAL PRODUCTION COS 33,490 BANK LOAN BALANCE 500 TOTAL OTHER COST 5,258 TOTAL MARKETING COST 5,284 TOTAL OTHER INCOME 320 TOTAL OTHER COST 5,258 BONDS OUTSTANDING 30,001 NET PROFIT BEFORE TAXES (826) DIVIDENDS PAID 3 LOAN REPAYMENT - CAPITAL STOCK VALUE 63,961 INCOME TAXES - BONDS REDEEMED - ACCUM. RET. EARNINGS 29,330 INCOME TAXES - TOTAL STOCK EQUITY 93,290 NET PROFIT AFTER TAXES (826) PROFIT SHARING - TOTAL LIABILITIES 123,791 PROFIT SHARING COST - PLANT & EQUIP. INVEST. 2,404 SAVINGS ACCT. DEPOSIT 20 NET INCOME (826) TOTAL DISBURSEMENTS 46,460 DIVIDENDS PAID 3 RETAINED EARNINGS (829) CASH AVAILABLE 2,202 EMERGENCY BANK LOAN - CASH BALANCE 2,202 5. Economy and Stockmarket Report Gross Domestic Product 137 $ Bil ions Personal Consumption Expenditures 15 $ Bil ions No. of Household Formations 378 1000's Raw Material Cost 0.45 $ / lb. STOCK EARNINGS/ DIVIDENDS/ BOND LOAN COMPANY PRICE SHARE SHARE SHARES INTEREST INTEREST Company 1 Name 7.41 0.16 0.00 6,010 13 16 Company 2 Name 5.43 -2.74 0.00 13,000 10 13 Company 3 Name 7.41 -10.30 0.00 6,000 13 16 Company 4 Name 7.41 -3.95 0.00 6,000 13 16 Company 5 Name 7.41 -0.46 0.00 6,010 13 16 Company 6 Name 7.41 -0.97 0.00 6,000 13 16 Company 7 Name 7.64 -0.14 0.00 6,001 10 13 Company 8 Name 13.76 -0.27 0.50 6,000 13 16 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 Company 1 Name 302 340 0.00 0.60 1546 6.69 4819 182,388 58 160,949 Company 2 Name 304 305 3.99 4.11 1538 5.51 5067 210,248 54 184,191 Company 3 Name 301 293 0.02 0.03 106 21.89 5471 202,656 60 193,015 Company 4 Name 305 295 0.39 0.35 87921 10.10 5451 186,564 61 153,391 Company 5 Name 306 343 0.62 0.62 1466 7.76 3925 120,455 56 130,726 Company 6 Name 305 997 0.39 0.30 1469 5.54 4666 180,340 56 162,781 Company 7 Name 302 421 0.00 0.04 1503 5.20 4607 161,807 55 106,911 Company 8 Name 287 306 0.39 2.46 1462 5.48 5062 187,889 60 180,143
Background image of page 1
Industry = 7 Company 7 Name Year = 3 Quarter= 2 1. Decision Report Market 1 Market 2 Market 3 Price ($/Unit) 500 500 500 Advertising ($1,000/Qtr.) 500 500 500 Sales Force Change (No.) 3 2 5 Product R&D ($1,000/Qtr.) 50 Sales Commision (%) 0.0004 Profit Sharing (%) 0.1 Sales Salaries ($/Month) 1,500 Sales Training ($1,000/Qtr.) 40 Production Training ($1,000/Qtr.) 55 Production Wages ($/Hour) 5.00 Production Scheduled (Hours/week) 40 Labor Force Change (No.) 2,475 Al ocation To Markets (%) 45 45 10 Process R&D ($1,000/Qtr.) 85 Raw Material Ordered (Mil ion lbs.) 41 Bonds Sold or Redeemed ($1,000) 0 Bank Loan Requested ($1,000) 100 Dividends Paid ($1,000) 0 Stocks Issued (1,000 Shares) 1 Savings Account ($1,000) -5 2. Production and Sales Report Market 1 Market 2 Market 3 Total PRODUCTION WORKFORCE (No.) 7,136 PRODUCTIVITY (Units/Production-Hr.) 0.066 RAW MAT. REQ'MTS (Lbs./Unit) 231 PRODUCTION OUTPUT (No. Units) 91,067 91,067 20,237 202,372 FIN. PROD. INVENTORY (No. Units) 40,134 28,792 99,443 168,369 RAW MAT.INVENTORY (Mil ion Lbs.) 47.442 DEMAND (No. Units) 34,784 31,731 18,844 85,358 SALES (No. Units) 50,933 62,275 19,125 132,333 BACKORDERS (No. Units) 0 0 0 0 SALES ($1000) 25,466 31,138 9,562 66,166 SALESPEOPLE ACTIVE (No.) 26 20 11 57 SALES TRAINEES (No.) 3 2 5 10 3. Cost Report PRODUCTION ($1000) MARKETING ($1000) OTHER ($1000) LABOR 15,352 ADVERTISING 1,500 R & D 135 MATERIAL 21,490 SALARIES 302 CARRYING - FIN. PROD. 393 MAINTENANCE 2,303 COMMISSIONS 0 CARRYING - RAW. Mat. 213 TRAINING 55 TRANSPORTATION 1,831 BOND INTEREST 750 PROD. LEVEL CHANGE 2,476 ADMINISTRATIVE 2,832 LOAN INTEREST 16 EQUIPMENT 2,149 SALES FORCE CHANGE 82 ADMINISTRATIVE 6,100 ADMINISTRATIVE 1,412 TRAINING 40 BOND CALL PREMIUM - DEPRECIATION 496 TOTAL 45,731 TOTAL 6,587 TOTAL 7,607 4. Financial Statements INCOME STATEMENT ($1000) FLOW OF FUNDS ($1000) FINANCIAL POSITION ($1000) GROSS SALES REVENUE 66,166 ACCOUNTS COLLECTED 54,453 CASH BALANCE - BEGINNING INVENTORY 21,222 BANK LOAN REQUESTED 100 ACCOUNTS RECEIVABLE 22,055 TOTAL PRODUCTION COST 45,731 BOND SALE RETURN - INVENTORY - FIN. PROD. 37,243 GOODS AVAILABLE 66,953 SAV. ACCOUNT INT. 320 INVENTORY - RAW MAT 21,412 ENDING INVENTORY 37,243 SAV. ACCT. WITHDRAWAL 5 SAVINGS ACCT. BALANCE 16,015 COST OF GOODS SOLD 29,710 PLANT & EQUIP. SALE - TOTAL CURRENT ASSETS 96,726 GROSS PROFIT 36,456 STOCK SALE RETURN 8 BEGINNING CASH 2,202 PLANT & EQUIP. VALUE 52,771 TOTAL MARKETING COST 6,587 TOTAL SOURCES 57,088 TOTAL ASSETS 149,497 PROFIT ON SALES 29,869 TOTAL PRODUCTION COS 42,196 BANK LOAN BALANCE 14,916 TOTAL OTHER COST 7,607 TOTAL MARKETING COST 6,587 TOTAL OTHER INCOME 320 TOTAL OTHER COST 7,607 BONDS OUTSTANDING 30,001 NET PROFIT BEFORE TAXES 22,583 DIVIDENDS PAID - LOAN REPAYMENT 500 CAPITAL STOCK VALUE 63,968 INCOME TAXES 11,291 BONDS REDEEMED - ACCUM. RET. EARNINGS 40,612 INCOME TAXES 11,291 TOTAL STOCK EQUITY 104,580 NET PROFIT AFTER TAXES 11,291 PROFIT SHARING 9 TOTAL LIABILITIES 149,497 PROFIT SHARING COST 9 PLANT & EQUIP. INVEST. 3,714 SAVINGS ACCT. DEPOSIT - NET INCOME 11,282 TOTAL DISBURSEMENTS 71,904 DIVIDENDS PAID - RETAINED EARNINGS 11,282 CASH AVAILABLE (14,816) EMERGENCY BANK LOAN 14,816 CASH BALANCE - 5. Economy and Stockmarket Report Gross Domestic Product 188 $ Bil ions Personal Consumption Expenditures 19 $ Bil ions No. of Household Formations 381 1000's Raw Material Cost 0.39 $ / lb. STOCK EARNINGS/ DIVIDENDS/ BOND LOAN COMPANY PRICE SHARE SHARE SHARES INTEREST INTEREST Company 1 Name 5.31 -0.72 0.00 11,010 14 17.5 Company 2 Name 5.47 -1.53 0.00 13,000 11 14.5 Company 3 Name 7.40 -11.98 0.00 6,000 16 19 Company 4 Name 6.14 -2.13 0.00 8,300 17 20.5 Company 5 Name 7.32 -1.20 0.00 6,020 17 20.5 Company 6 Name 4.01 -0.27 0.00 16,000 14 17.5 Company 7 Name 7.50 1.88 0.00 6,002 14 17.5 Company 8 Name 13.97 0.55 0.49 6,100 14 17.5 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 Company 1 Name 307 367 1.76 1.00 1489 7.76 2969 118,920 57 134,794 Company 2 Name 286 386 4.94 5.91 1582 5.39 4441 195,381 72 248,949 Company 3 Name 308 307 0.03 0.03 112 20.98 5693 230,876 50 247,575 Company 4 Name 391 305 0.41 0.34 87202 9.81 1736 56,709 55 96,536 Company 5 Name 300 102 0.62 5.03 1525 8.00 7366 264,795 55 275,303 Company 6 Name 326 #DIV/0! 2.03 3.56 1489 5.55 3568 139,554 55 161,821 Company 7 Name 483 506 0.00 0.08 1462 4.97 6028 201,691 58 135,301 Company 8 Name 303 311 0.39 4.86 1523 5.41 4346 190,564 55 227,747
Background image of page 1
Page PRODUCTION PLAN Year 3 Year 4 Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Qtr. 1 Qtr. 2 Qtr. 3 1 Market 1 Sales Forecast 2 Desired End Inventory 3 Beginning Inventory Backorders 4 Production Required 0 0 0 0 5 Market 2 Sales Forecast 6 Desired End Inventory 7 Beginning Inventory Backorders 8 Production Required 0 0 0 0 0 9 Market 3 Sales Forecast 10 Desired End Inventory 11 Beginning Inventory Backorders 12 Production Required 0 0 0 0 0 13 Total Production Required 0 0 0 0 0 14 Productivity 15 Hours Scheduled 16 Production Force Required #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 17 Production Force Change 18 Market 1 Allocation (%) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 19 Market 2 Allocation (%) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 20 Market 3 Allocation (%) #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Background image of page 1
Page Year 5 Qtr. 4 Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4
Background image of page 2
Page RAW MATERIAL PLAN FORM Year 3 Year 4 Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Qtr. 1 Qtr. 2 Qtr. 3 1 Total Production Required 2 Raw Materials/unit 3 Raw Materials Required 0 4 Beginning R. M. Inv. (this per.) 5 R. M. Rem. After Prod. (this per.) 0 8 R. M. Required (next period) 9 Desired End. Inventory (next per.) 10 R. M. To Order (this period) 0 11 Process R & D
Background image of page 1
Sales Forecast Form Market _____________________ (Figures expressed in units) No Item Year 3 Year 4 Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 1 Previous Quarter Sales 2 Previous Quarter Demand 3 Customer Change 4 Backorders 5 Trend 6 Seasonal 7 Gross Domestic Product 8 Pers. Consumption Exp. 9 Household Formations 10 Price 11 Advertising 12 Sales Force Change 13 Product R&D 14 Sales Commission 15 Sales Training 16 Profit Sharing 17 Total Adjustments 18 Forecasted Demand 19 Stockout Effect 20 Forecasted Sales
Background image of page 1
INDUSTRY X Company 1 YEAR 2 QUARTER 4 1. Decision Report Market 1 Market 2 Market 3 Price ($/Unit) 300 300 300 Advertising ($1,000/Qtr.) 300 300 300 Sales Force Change (No.) 2 0 3 Product R&D ($1,000/Qtr.) 50 Sales Commision (%) 0.4 Profit Sharing (%) 0.3 Sales Salaries ($/Month) 1,500 Sales Training ($1,000/Qtr.) 25 Production Training ($1,000/Qtr.) 15 Production Wages ($/Hour) 5.50 Production Scheduled (Hours/week) 40 Labor Force Change (No.) 400 Allocation To Markets (%) 30 30 40 Process R&D ($1,000/Qtr.) 40 Raw Material Ordered (Million lbs.) 0 Bonds Sold or Redeemed ($1,000) 0 Bank Loan Requested ($1,000) 0 Dividends Paid ($1,000) 3,000 Stocks Issued (1,000 Shares) 0 Savings Account ($1,000) 15,000
Background image of page 1
2. Production & Sales Report Description Market 1 Market 2 Market 3 Total Production Workforce (No.) 4,000 Productivity (Units/Person-Hour) 0.069 Raw Material Requirement (lbs/Unit) 224 Production Output (No. of Units) 57,186 42,889 57,186 157,261 Finished Product Inventory (No. of Units) 4,672 7,993 30,355 43,020 Raw Material Inventory (Million lbs) 59.25 Demand (No. of Units) 72,827 61,904 52,934 187,665 Sales (No. of Units) 72,827 61,904 52,934 187,665 Back Orders (No of Units) 0 0 0 0 Sales ($1,000) 21,848 18,571 15,880 56,299 Salesman Active (No.) 22 24 9 55 Sales Trainee (No.) 2 0 3 5
Background image of page 2
Show entire document
Industry = 6 Company 7 Name Year = 3 Quarter= 2 1. Decision Report Market 1 Market 2 Market 3 Price ($/Unit) 300 500 300 Advertising ($1,000/Qtr.) 330 330 250 Sales Force Change (No.) 3 4 0 Product R&D ($1,000/Qtr.) 50why? Sales Commision (%) 0.5 Profit Sharing (%) 0.8 Sales Salaries ($/Month) 1,000 Sales Training ($1,000/Qtr.) 25 Production Training ($1,000/Qtr.) 50is this 5% of sales Production Wages ($/Hour) 2.00surely you jest… could you live on $2.00 an hour? Production Scheduled (Hours/week) 40 Labor Force Change (No.) 0 Al ocation To Markets (%) 43 30 27 Process R&D ($1,000/Qtr.) 70is this 5% of sales Raw Material Ordered (Mil ion lbs.) 75 Bonds Sold or Redeemed ($1,000) 0 Bank Loan Requested ($1,000) 0 Dividends Paid ($1,000) 350 Stocks Issued (1,000 Shares) 100 Savings Account ($1,000) -15,000 Rank Co 7 Productivity 3 Profitability ### Retained Earnings ### Stock Price ### Loan Interest 1 Raw Material Inv/RM Used 0 2. Production and Sales Report Market 1 Market 2 Market 3 Total Finished Product Inv/Demand 0 PRODUCTION WORKFORCE (No.) 5,620 Cash/Total Disbursements 0 PRODUCTIVITY (Units/Production-Hr.) 0.067if this were the real deal, you would not be able to catch the other teams!! SUM ### RAW MAT. REQ'MTS (Lbs./Unit) 227 MEAN ### PRODUCTION OUTPUT (No. Units) 63,369 44,211 39,790 147,370 OVERALL RANK ### FIN. PROD. INVENTORY (No. Units) 26,583 40,584 54,458 121,625 GRADE B- RAW MAT.INVENTORY (Mil ion Lbs.) 106.049 DEMAND (No. Units) 68,966 25,061 36,068 130,094 SALES (No. Units) 71,020 25,061 36,068 132,149 almost as much as demand, don't need to produce much BACKORDERS (No. Units) 0 0 0 0 SALES ($1000) 21,306 12,530 10,820 44,657 $2,232.84 SALESPEOPLE ACTIVE (No.) 21 24 10 55 above is what process R& D and Prod Training should be SALES TRAINEES (No.) 3 4 0 7 3. Cost Report PRODUCTION ($1000) MARKETING ($1000) OTHER ($1000) LABOR 4,397 ADVERTISING 910 R & D 120 MATERIAL 15,861 SALARIES 186 CARRYING - FIN. PROD. 426 MAINTENANCE 659 COMMISSIONS 223 CARRYING - RAW. Mat. 258 TRAINING 50 TRANSPORTATION 1,192 BOND INTEREST 975 PROD. LEVEL CHANGE - ADMINISTRATIVE 2,781 LOAN INTEREST 358 EQUIPMENT 1,586 SALES FORCE CHANGE 58 ADMINISTRATIVE 4,520 ADMINISTRATIVE 1,137 TRAINING 25 BOND CALL PREMIUM - DEPRECIATION 502 TOTAL 24,192 TOTAL 5,375 TOTAL 6,656 4. Financial Statements INCOME STATEMENT ($1000) FLOW OF FUNDS ($1000) FINANCIAL POSITION ($1000) GROSS SALES REVENUE 44,657 ACCOUNTS COLLECTED 44,924 CASH BALANCE - BEGINNING INVENTORY 22,720 BANK LOAN REQUESTED - ACCOUNTS RECEIVABLE 14,886 TOTAL PRODUCTION COST 24,192 BOND SALE RETURN - INVENTORY - FIN. PROD. 20,690 GOODS AVAILABLE 46,913 SAV. ACCOUNT INT. 320 INVENTORY - RAW MAT 48,458 ENDING INVENTORY 20,690 SAV. ACCT. WITHDRAWAL 15,000 SAVINGS ACCT. BALANCE 1,015 COST OF GOODS SOLD 26,223 PLANT & EQUIP. SALE - TOTAL CURRENT ASSETS 85,048 GROSS PROFIT 18,434 STOCK SALE RETURN 1,123 BEGINNING CASH - PLANT & EQUIP. VALUE 49,720 TOTAL MARKETING COST 5,375 TOTAL SOURCES 61,368 TOTAL ASSETS 134,768 PROFIT ON SALES 13,059 good TOTAL PRODUCTION COS 41,579 BANK LOAN BALANCE 4,919 TOTAL OTHER COST 6,656 TOTAL MARKETING COST 5,375 TOTAL OTHER INCOME 320 TOTAL OTHER COST 6,656 BONDS OUTSTANDING 30,005 NET PROFIT BEFORE TAXES 6,723 DIVIDENDS PAID 350 LOAN REPAYMENT 8,938 CAPITAL STOCK VALUE 65,179 INCOME TAXES 3,362 BONDS REDEEMED - ACCUM. RET. EARNINGS 34,664 INCOME TAXES 3,362 TOTAL STOCK EQUITY 99,844 NET PROFIT AFTER TAXES 3,362 PROFIT SHARING 27 TOTAL LIABILITIES 134,768 PROFIT SHARING COST 27 PLANT & EQUIP. INVEST. - SAVINGS ACCT. DEPOSIT - NET INCOME 3,335 TOTAL DISBURSEMENTS 66,287 DIVIDENDS PAID 350 RETAINED EARNINGS 2,985 good CASH AVAILABLE (4,919)must calculate costs EMERGENCY BANK LOAN 4,919 CASH BALANCE - 5. Economy and Stockmarket Report Gross Domestic Product 188 $ Bil ions Personal Consumption Expenditures 19 $ Bil ions No. of Household Formations 381 1000's Raw Material Cost 0.39 $ / lb. STOCK EARNINGS/ DIVIDENDS/ BOND LOAN COMPANY PRICE SHARE SHARE SHARES INTEREST INTEREST Company 1 Name 11.71 1.27 0.17 6,000 10 13 Company 2 Name 7.23 0.68 0.00 6,000 16 19 Company 3 Name 7.59 -1.15 0.00 6,000 13 16 Company 4 Name 7.28 0.31 0.00 6,300 16 19 Company 5 Name 13.25 -0.89 0.50 6,060 16 19 Company 6 Name 7.02 -0.08 0.00 6,950 16 19 Company 7 Name 9.58 0.55 0.06 6,110 16 19 Company 8 Name 11.20 -3.67 0.17 6,060 16 19 Did workers quit? They will if profit sharing is higher in other companies. 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 Company 1 Name 359 417 4.98 3.00 1503 5.61 4578 180,100 58 221,149 Company 2 Name 669 302 0.51 4.23 1481 5.65 3085 143,459 58 38,999 Company 3 Name 294 928 5.29 3.87 1492 5.56 5162 181,996 59 186,263 Company 4 Name 350 359 0.45 5.95 1454 5.33 6098 236,676 65 178,060 Company 5 Name 348 295 0.50 4.48 1517 5.88 14934 282,748 55 195,876 Company 6 Name 303 373 0.96 0.10 1470 5.60 5702 220,296 59 213,571 Company 7 Name 374 305 0.51 0.81 1019 1.96 4233 148,959 56 126,764 Company 8 Name 344 375 45.22 5.67 1515 5.84 7687 317,275 54 184,140
Background image of page 1
Industry = 7 Company 7 Name Year = 3 Quarter= 2 1. Decision Report Market 1 Market 2 Market 3 Price ($/Unit) 500 500 500 Advertising ($1,000/Qtr.) 500 500 500 plan on sales increasing next quarter Sales Force Change (No.) 3 2 5 Product R&D ($1,000/Qtr.) 50 Sales Commision (%) 0.0004 this is .0004 of 1% Profit Sharing (%) 0.1 this is .1 of 1% Sales Salaries ($/Month) 1,500 Sales Training ($1,000/Qtr.) 40 Production Training ($1,000/Qtr.) 55 Production Wages ($/Hour) 5.00 Production Scheduled (Hours/week) 40 Labor Force Change (No.) 2,475 Al ocation To Markets (%) 45 45 10 Process R&D ($1,000/Qtr.) 85 these should be 5% of total sales in $ Raw Material Ordered (Mil ion lbs.) 41 Bonds Sold or Redeemed ($1,000) 0 Bank Loan Requested ($1,000) 100 Dividends Paid ($1,000) 0 Stocks Issued (1,000 Shares) 1 Savings Account ($1,000) -5 55 and 85 are why this is so low 2. Production and Sales Report Market 1 Market 2 Market 3 Total PRODUCTION WORKFORCE (No.) 7,136 PRODUCTIVITY (Units/Production-Hr.) 0.066 RAW MAT. REQ'MTS (Lbs./Unit) 231 PRODUCTION OUTPUT (No. Units) 91,067 91,067 20,237 202,372 FIN. PROD. INVENTORY (No. Units) 40,134 28,792 99,443 168,369large inventory RAW MAT.INVENTORY (Mil ion Lbs.) 47.442 DEMAND (No. Units) 34,784 31,731 18,844 85,358 because you raised your price SALES (No. Units) 50,933 62,275 19,125 132,333 BACKORDERS (No. Units) 0 0 0 0 SALES ($1000) 25,466 31,138 9,562 66,166 SALESPEOPLE ACTIVE (No.) 26 20 11 57 SALES TRAINEES (No.) 3 2 5 10 3. Cost Report PRODUCTION ($1000) MARKETING ($1000) OTHER ($1000) LABOR 15,352 ADVERTISING 1,500 R & D 135 MATERIAL 21,490 SALARIES 302 CARRYING - FIN. PROD. 393 MAINTENANCE 2,303 COMMISSIONS 0 CARRYING - RAW. Mat. 213 TRAINING 55 TRANSPORTATION 1,831 BOND INTEREST 750 PROD. LEVEL CHANGE 2,476 ADMINISTRATIVE 2,832 LOAN INTEREST 16 EQUIPMENT 2,149 SALES FORCE CHANGE 82 ADMINISTRATIVE 6,100 ADMINISTRATIVE 1,412 TRAINING 40 BOND CALL PREMIUM - DEPRECIATION 496 TOTAL 45,731 TOTAL 6,587 TOTAL 7,607 This is because of the increase in price--goody goody 4. Financial Statements INCOME STATEMENT ($1000) FLOW OF FUNDS ($1000) FINANCIAL POSITION ($1000) GROSS SALES REVENUE 66,166 ACCOUNTS COLLECTED 54,453 CASH BALANCE - BEGINNING INVENTORY 21,222 BANK LOAN REQUESTED 100 ACCOUNTS RECEIVABLE 22,055 TOTAL PRODUCTION COST 45,731 BOND SALE RETURN - INVENTORY - FIN. PROD. 37,243 GOODS AVAILABLE 66,953 SAV. ACCOUNT INT. 320 INVENTORY - RAW MAT 21,412 ENDING INVENTORY 37,243 SAV. ACCT. WITHDRAWAL 5 SAVINGS ACCT. BALANCE 16,015 COST OF GOODS SOLD 29,710 PLANT & EQUIP. SALE - TOTAL CURRENT ASSETS 96,726 GROSS PROFIT 36,456 STOCK SALE RETURN 8 BEGINNING CASH 2,202 PLANT & EQUIP. VALUE 52,771 TOTAL MARKETING COST 6,587 TOTAL SOURCES 57,088 TOTAL ASSETS 149,497 PROFIT ON SALES 29,869 TOTAL PRODUCTION COST 42,196 BANK LOAN BALANCE 14,916 TOTAL OTHER COST 7,607 TOTAL MARKETING COST 6,587 TOTAL OTHER INCOME 320 TOTAL OTHER COST 7,607 BONDS OUTSTANDING 30,001 NET PROFIT BEFORE TAXES 22,583 DIVIDENDS PAID - LOAN REPAYMENT 500 CAPITAL STOCK VALUE 63,968 INCOME TAXES 11,291 BONDS REDEEMED - ACCUM. RET. EARNINGS 40,612 INCOME TAXES 11,291 TOTAL STOCK EQUITY 104,580 NET PROFIT AFTER TAXES 11,291 PROFIT SHARING 9 TOTAL LIABILITIES 149,497 PROFIT SHARING COST 9 PLANT & EQUIP. INVEST. 3,714 SAVINGS ACCT. DEPOSIT - NET INCOME 11,282 TOTAL DISBURSEMENTS 71,904 DIVIDENDS PAID - RETAINED EARNINGS 11,282 CASH AVAILABLE (14,816) EMERGENCY BANK LOAN 14,816 must calculate your costs CASH BALANCE - 5. Economy and Stockmarket Report Gross Domestic Product 188 $ Bil ions Personal Consumption Expenditures 19 $ Bil ions No. of Household Formations 381 1000's Raw Material Cost 0.39 $ / lb. STOCK EARNINGS/ DIVIDENDS/ BOND LOAN COMPANY PRICE SHARE SHARE SHARES INTEREST INTEREST Company 1 Name 5.31 -0.72 0.00 11,010 14 17.5 Company 2 Name 5.47 -1.53 0.00 13,000 11 14.5 Company 3 Name 7.40 -11.98 0.00 6,000 16 19 Company 4 Name 6.14 -2.13 0.00 8,300 17 20.5 Company 5 Name 7.32 -1.20 0.00 6,020 17 20.5 Company 6 Name 4.01 -0.27 0.00 16,000 14 17.5 Company 7 Name 7.50 1.88 0.00 6,002 14 17.5 Company 8 Name 13.97 0.55 0.49 6,100 14 17.5 sales commission so low it registers as 0 did you lose production workers--they quit and try to go to other companies 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 Company 1 Name 307 367 1.76 1.00 1489 7.76 2969 118,920 57 134,794 Company 2 Name 286 386 4.94 5.91 1582 5.39 4441 195,381 72 248,949 Company 3 Name 308 307 0.03 0.03 112 20.98 5693 230,876 50 247,575 Company 4 Name 391 305 0.41 0.34 87202 9.81 1736 56,709 55 96,536 Company 5 Name 300 102 0.62 5.03 1525 8.00 7366 264,795 55 275,303 Company 6 Name 326 #DIV/0! 2.03 3.56 1489 5.55 3568 139,554 55 161,821 Company 7 Name 483 506 0.00 0.08 1462 4.97 6028 201,691 58 135,301 Company 8 Name 303 311 0.39 4.86 1523 5.41 4346 190,564 55 227,747
Background image of page 1

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question