Need Help with making decisions on Capstone Round 2 in: R&D, Marketing, Production, Human Resources, Finances

Recalculate Ul Research & Development Name Draft saved at Sep 12, 2020 09:08PM PDT Perceptual Map (at end of this year) Pfmn Size Revision Date O MTBF Age at Revision 2.3 R&D Cost 20 Able 6.4 11.5 10500 10-Mar-24 $2194 18 Acre 4.0 15.0 10000 10-Nov-23 3.7 $1875 16 Acre ACVA Aft Adam 9.5 10.0 12000 1.7 $1746 14 Able (Agape 25-Sep-23 11-Feb-25 12 Aft 6.0 8.5 18000 2.6 $3116 Agarble Adam 10 Agawean Size 4.3 13.0 17000 1.9 $258 Agape Agape2 03-Apr-22 25-Mar-23 8 7.8 10.0 12000 0.0 $1231 6 NA 0.0 0.0 0 $0 4 2 NA 0.0 0.0 0 $0 0 Total $10420 0 2 4 6 8 10 12 14 16 18 20 Performance Material Cost Age Profile 7.5 Able 8.77 10.53 Acre 6.91 15.93 5.6 6.6 Adam 14.89 11.66 Aft 14.82 12.11 12.26 3.4 Perceived Age in Years 3.6 3.9 3. Agape 10.36 2.4 2.6 2.7 2 0 Agape2 11.26 1.6 $0 $2.5 $5 $12.5 $15 $17.5 $7.5 $10 Material Cost in dollars 0 0 O New Material Cost Old Material Cost Able . Acre - Adam Aft - Agape Agape2 Necdiculale Name Price Promo Budget 1500 Sales Budget $ 1000 Benchmark Prediction Your Forecast 1695 Able $ 40.00 0 $ 30.50 $ 1100 $ 900 0 2700 Acre Adam Gross Revenue $ 67,800 $ 82,350 $ 34,875 $ 33,300 $ 28,035 $0 Draft saved at Sep 17, 2020 12:31PM PDT Contrib Less Margin Promo/Sales $ 34,451 $ 31,951 $ 48,361 $ 46,361 $ 14,551 $ 13,251 $ 14,900 $ 13,200 $ 16,754 $ 15,054 $0 $ 0 Variable Costs $ 33,349 $ 33,989 $ 20,324 $ 18,400 $ 11,281 $0 $ 45.00 $ 600 $ 0 700 775 Aft $ 45.00 $ 700 $ 1000 0 740 44.50 $ 700 $ 1000 0 630 Agape Agape2 NA $0.0 0 $ 0 $ 0 $0 $ 0 $0.0 0 $0 $0 $0 $ 0 NA $0.0 $0 0 $0 $0 $ 0 $0 $0 $ 4,600 Total $ 4,600 0 6,540 $ 246,360 $ 117,343 $ 129,017 $ 119,817 A/R Lag (days) : 30 A/P Lag (days) 30 Revenue Forecast Unit Sales Forecast 100 $82,350 75 $67,800 0 0 0 0 0 0 Revenue forecast (in 000's) 50 Unit Sales forecast (in 000's) $34,875 $33,300 $28,035 25 $0 Able Acre Adam Aft Agape Agape Able Acre Adam Aft Agape Agape2 Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Recalculate Draft saved at Sep 17, 2020 12:33PM PDT Able Acre Adam Aft Agape Agape2 NA NA Total Production Schedule Unit Sales Forecast Inventory On Hand O Production Schedule 1,695 2,700 775 740 630 0 0 0 6,540 0 328 35 63 170 0 0 0 596 1800 2850 845 700 600 0 6,795 Production After Adj. O 1,782 2,822 837 693 594 0 0 0 6,729 71.4% 78.1% 76.1% 16.7% 0.0% 0.0% 0 0 $9.15 $5.68 $11.33 $10.04 $7.05 $0.00 0 0 Margins 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin $10.53 $6.91 $14.89 $14.82 $10.85 $11.26 0 0 $19.68 $12.59 $26.22 $24.86 $17.91 $11.26 0 0 50.8% 58.7% 41.7% 44.7% 59.8% 0.0% 0 0 Total 1,050 1,600 480 600 1,175 0 0 0 4,905 200 200 50 100 200 0 750 4.5 7.0 3.0 5.0 0.0 0.0 0.0 Physical Plant 1st Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment ($000) Workforce Complement 3.0 4.0 5.0 7.0 4.0 6.0 3.0 $ 7,300 $ 3,020 $0 $ 6,800 Needed $ 4,600 This Year $ 10,700 1st Shift $ 0 Overtime $ 32,420 $ 36,611 Last Year This Year % $ 0 Max Invest A/P Lag 2nd Shift 829 962 100 % 962 627 335 0.0% 30 Production vs Capacity Price vs Unit Cost $60 4k 3k 2k LLLL 1.111. ik ok Agape Agape2 Agape Agape2 Both Shifts Base Capacity Production Material Labor Margin Recalculate Staffing Last Year This Year 829 100% 829 nan Re Draft saved at Sep 17, 2020 12:35PM PDT Labor Negotiations Current Labor Negotiation Negotiation Position Position 962 Demands Contract Starting Ceiling 100% Hourly $22.05 $24.26 $ 22.05 $ 24.26 Wage 962 Benefits $ 2,500 $ 2,750 $ 2,500 $ 2,750 627 Profit 2.0% 2.2% 2.0% 2.2% 335 Sharing % Annual 0.0% 5.0% 5.5% 5.0% 5.5% Raise 8.1% Contract Expiration: 1-Oct-2029 211 638 191 0.0% 10.0% 212 Needed Complement Complement % 0 Complement 1st Shift Complemento 2nd Shift Complement Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index Recruiting Cost Separation Cost Training Cost Total HR Admin Costs 0 0 $0 $ 2700 0 50 100.0% 100.9% $781 $0 $962 $1743 Recalculate Draft saved at Sep 17, 2020 12:36PM PDT Finances Liabilities & Owner's Equity Accounts Payable : 4.7% $ 32,420 Current Debt: 3.3 % Plant Improvements Total Investments ($000) O Sales of Plant & Equipment Common Stock Shares Outstanding (000) O $ 0 Retained Earnings : 41.3% 2,426 Long Term Debt: 34.8 % $ 34.73 $ 22.68 Common Stock: 15.8%- $ 16,531 $ 1600 Price Per Share o Earnings Per Share Max Stock Issue ($000) O Issue Stock ($000) O Max Stock Retire ($000) O Retire Stock ($000) O Dividend Per Share o Current Debt Interest Rate $ 4,133 $ 0 0.00 11.2% Due This Year $ 20,000 Long Term Debt Retire Long Term Debt ($000) 0 $ 0 Issue Long Term Debt ($000) O 20000 Long Term Interest Rate 12.6% Maximum Issue This Year $ 20,080 A/R Lag (days) 30 A/P Lag (days) 30 Outstanding Bonds Series Number Face Amount Current Yield 2021 Close 11.0S2022 $ 6,950 11.2% $ 98.58 12.5S2024 $ 13,900 12.5% $ 99.76 14.0S2026 $ 20,850 13.3% $ 104.97 11.352031 $ 18,000 12.2% $ 92.83 Borrow ($000) 0 $ 0 Cash Positions December 31, 2021 $ 37,220 December 31, 2022 $ 63,018 Recalculate Ul Research & Development Name Draft saved at Sep 12, 2020 09:08PM PDT Perceptual Map (at end of this year) Pfmn Size Revision Date O MTBF Age at Revision 2.3 R&D Cost 20 Able 6.4 11.5 10500 10-Mar-24 $2194 18 Acre 4.0 15.0 10000 10-Nov-23 3.7 $1875 16 Acre ACVA Aft Adam 9.5 10.0 12000 1.7 $1746 14 Able (Agape 25-Sep-23 11-Feb-25 12 Aft 6.0 8.5 18000 2.6 $3116 Agarble Adam 10 Agawean Size 4.3 13.0 17000 1.9 $258 Agape Agape2 03-Apr-22 25-Mar-23 8 7.8 10.0 12000 0.0 $1231 6 NA 0.0 0.0 0 $0 4 2 NA 0.0 0.0 0 $0 0 Total $10420 0 2 4 6 8 10 12 14 16 18 20 Performance Material Cost Age Profile 7.5 Able 8.77 10.53 Acre 6.91 15.93 5.6 6.6 Adam 14.89 11.66 Aft 14.82 12.11 12.26 3.4 Perceived Age in Years 3.6 3.9 3. Agape 10.36 2.4 2.6 2.7 2 0 Agape2 11.26 1.6 $0 $2.5 $5 $12.5 $15 $17.5 $7.5 $10 Material Cost in dollars 0 0 O New Material Cost Old Material Cost Able . Acre - Adam Aft - Agape Agape2 Necdiculale Name Price Promo Budget 1500 Sales Budget $ 1000 Benchmark Prediction Your Forecast 1695 Able $ 40.00 0 $ 30.50 $ 1100 $ 900 0 2700 Acre Adam Gross Revenue $ 67,800 $ 82,350 $ 34,875 $ 33,300 $ 28,035 $0 Draft saved at Sep 17, 2020 12:31PM PDT Contrib Less Margin Promo/Sales $ 34,451 $ 31,951 $ 48,361 $ 46,361 $ 14,551 $ 13,251 $ 14,900 $ 13,200 $ 16,754 $ 15,054 $0 $ 0 Variable Costs $ 33,349 $ 33,989 $ 20,324 $ 18,400 $ 11,281 $0 $ 45.00 $ 600 $ 0 700 775 Aft $ 45.00 $ 700 $ 1000 0 740 44.50 $ 700 $ 1000 0 630 Agape Agape2 NA $0.0 0 $ 0 $ 0 $0 $ 0 $0.0 0 $0 $0 $0 $ 0 NA $0.0 $0 0 $0 $0 $ 0 $0 $0 $ 4,600 Total $ 4,600 0 6,540 $ 246,360 $ 117,343 $ 129,017 $ 119,817 A/R Lag (days) : 30 A/P Lag (days) 30 Revenue Forecast Unit Sales Forecast 100 $82,350 75 $67,800 0 0 0 0 0 0 Revenue forecast (in 000's) 50 Unit Sales forecast (in 000's) $34,875 $33,300 $28,035 25 $0 Able Acre Adam Aft Agape Agape Able Acre Adam Aft Agape Agape2 Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Recalculate Draft saved at Sep 17, 2020 12:33PM PDT Able Acre Adam Aft Agape Agape2 NA NA Total Production Schedule Unit Sales Forecast Inventory On Hand O Production Schedule 1,695 2,700 775 740 630 0 0 0 6,540 0 328 35 63 170 0 0 0 596 1800 2850 845 700 600 0 6,795 Production After Adj. O 1,782 2,822 837 693 594 0 0 0 6,729 71.4% 78.1% 76.1% 16.7% 0.0% 0.0% 0 0 $9.15 $5.68 $11.33 $10.04 $7.05 $0.00 0 0 Margins 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin $10.53 $6.91 $14.89 $14.82 $10.85 $11.26 0 0 $19.68 $12.59 $26.22 $24.86 $17.91 $11.26 0 0 50.8% 58.7% 41.7% 44.7% 59.8% 0.0% 0 0 Total 1,050 1,600 480 600 1,175 0 0 0 4,905 200 200 50 100 200 0 750 4.5 7.0 3.0 5.0 0.0 0.0 0.0 Physical Plant 1st Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment ($000) Workforce Complement 3.0 4.0 5.0 7.0 4.0 6.0 3.0 $ 7,300 $ 3,020 $0 $ 6,800 Needed $ 4,600 This Year $ 10,700 1st Shift $ 0 Overtime $ 32,420 $ 36,611 Last Year This Year % $ 0 Max Invest A/P Lag 2nd Shift 829 962 100 % 962 627 335 0.0% 30 Production vs Capacity Price vs Unit Cost $60 4k 3k 2k LLLL 1.111. ik ok Agape Agape2 Agape Agape2 Both Shifts Base Capacity Production Material Labor Margin Recalculate Staffing Last Year This Year 829 100% 829 nan Re Draft saved at Sep 17, 2020 12:35PM PDT Labor Negotiations Current Labor Negotiation Negotiation Position Position 962 Demands Contract Starting Ceiling 100% Hourly $22.05 $24.26 $ 22.05 $ 24.26 Wage 962 Benefits $ 2,500 $ 2,750 $ 2,500 $ 2,750 627 Profit 2.0% 2.2% 2.0% 2.2% 335 Sharing % Annual 0.0% 5.0% 5.5% 5.0% 5.5% Raise 8.1% Contract Expiration: 1-Oct-2029 211 638 191 0.0% 10.0% 212 Needed Complement Complement % 0 Complement 1st Shift Complemento 2nd Shift Complement Overtime% Turnover Rate New Employees Separated Employees Recruiting Spend Training Hours Productivity Index Recruiting Cost Separation Cost Training Cost Total HR Admin Costs 0 0 $0 $ 2700 0 50 100.0% 100.9% $781 $0 $962 $1743 Recalculate Draft saved at Sep 17, 2020 12:36PM PDT Finances Liabilities & Owner's Equity Accounts Payable : 4.7% $ 32,420 Current Debt: 3.3 % Plant Improvements Total Investments ($000) O Sales of Plant & Equipment Common Stock Shares Outstanding (000) O $ 0 Retained Earnings : 41.3% 2,426 Long Term Debt: 34.8 % $ 34.73 $ 22.68 Common Stock: 15.8%- $ 16,531 $ 1600 Price Per Share o Earnings Per Share Max Stock Issue ($000) O Issue Stock ($000) O Max Stock Retire ($000) O Retire Stock ($000) O Dividend Per Share o Current Debt Interest Rate $ 4,133 $ 0 0.00 11.2% Due This Year $ 20,000 Long Term Debt Retire Long Term Debt ($000) 0 $ 0 Issue Long Term Debt ($000) O 20000 Long Term Interest Rate 12.6% Maximum Issue This Year $ 20,080 A/R Lag (days) 30 A/P Lag (days) 30 Outstanding Bonds Series Number Face Amount Current Yield 2021 Close 11.0S2022 $ 6,950 11.2% $ 98.58 12.5S2024 $ 13,900 12.5% $ 99.76 14.0S2026 $ 20,850 13.3% $ 104.97 11.352031 $ 18,000 12.2% $ 92.83 Borrow ($000) 0 $ 0 Cash Positions December 31, 2021 $ 37,220 December 31, 2022 $ 63,018