i neee help getting a good balanced scorecord for round 1 of the capsim.
#ww2.capsim.com/Webseite/indexom?template-RDIM CAPSIM 2 comp-am Fle Undo - Decisions Proformas - Inquirer Research & Development Andrew C50569 Round 1.2020 Help ONETE POISON) Decisions "Name New Pfmn "New Size MTBF Revision Date Age Revision SRDC (8000) SO Abby Alan SO 10.8 12.9 5.4 8.1 0.0 Aft Agape 7.3 9.3 14.6 11.9 0.0 24000 26000 20000 22000 0 $0 A Na 50 Na 0.0 0.0 0 SO Abey Na 0.0 0 $0 0.0 0.0 Na 0.0 $0 SO Total Material Cost ou New 310 20 Age Profiles 100 30 30 70 Abby A Abby A AR Perceveden 50 so 40 30 20 10 10 Type here to search B File Undo Decisions Proformas Marketing Inquirer Help DRAFT SAVED AT AL 2020 STAVEDT Marketing Decisions Name Price Promo Budget Sales Budget Benchmark Preaktion Your Sales Forecast GROSS Revenue Forecast Variable Costs contrib Margin Forecast Less Promo & Sales $ $ $ $ $0.0 $0.0 40.00 $ 42.00 25.00 $ 32.00$ 1000 1000 2000 Abby Alan Alt Agape NA NA NA NA Total 1200 $ 1200 $ 12001 $ 1200 $ $0 $0 $0 olololo 1000 2.045 1,485 769 1,958 0 0 0 0 6,258 $0 $0 $0 $0 $5,000 Costs $ 81,800 $ 62,416 $ 19.988 $ 62,658 $0 $0 $0 $0 $ 226,870 $ 52.748 $ 38,112 $10.9721 $ 37,966 $0 $0 $0 $0 $ 139,800 wenn $ 29,060 $ 24,304 $9.011 $24,692 $0 $0 50 $0 $ 87,067 $ 26,860 $ 22.104 $ 5,811 $ 22.492 $0 $0 $0 $0 $77,267 $0.0 $0.0 30 $4,800 0 Note The Benchmark Prediction estimates unit sales assuming your product competes with a standardized, mediocre playing field. It does not use your actual competitors products. It is useful for experimenting with price, promo and sales budgets. It is useless for forecasting TAR Lag (days) A/P Lag (day) Revenue Forecast 2000 370,000 Unit Sales Forcast 2204 140,000 550.000 1.600 1.800 200 000 300 $10.000 400 200 Abby An Vos NA NA NA NA Atra Abby Alan NA DEMO Type here to search D CAPSIM 2 comp-xM Andrews C59569 Round 1 - 2020 File Undo Decisions - Proformas - Inquirer Help Production ORAFT VEDATA 2020 -BAMEOT $ Alt NA NA Abby 2,045 NA NA 254 Alan 1.486 216 750 743 269 758 2150 2.129 Agape 1.958 47 1800 1,782 Total 6,258 1,285 5,650 5.595 950 941 SCHEDULE Unit Sales Forecast Inventory On Hand Production Schedule Production After Ads MARGINS 2nd Shift Production Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin PHYSICAL PLANT 1st Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment (5000) WORKFORCE Complement 30.5% $10.50 $15.29 $25.79 35.59 5.196 $9.67 $15.98 $25.65 38.99 90.3% $8.28 $6.00 $14.28 45.196 50.096 $9.39 $10.00 $19.39 39.496 0.046 $0.00 $0.00 50.00 0.09 0.096 $0.00 $0.00 $0.00 0.046 0.096 $0.00 $0.00 $0.00 0.09 0.09 50.00 $0.00 $0.00 0.046 Total 3,772 0 728 0 4.0 4.0 $0 "Last Year 804 714 0 4.0 4.0 SO Needed 804 1,130 0 6.00 6.0 $0 This Year 100 1,200 0 5.0 5.0 $0 This Year 804 SO Ist Shift 552 $0 2nd Shift 252 $0 $0 Overtime Max Invest 0.0% AP Lag $0 $ 59,668 30 Production Vs. Capacity 2500 Base Capacity Productos Price U Cout Lab ON 2000 $40 1,500 1000 will 110 500 41 A Abby AR A NA w NA Agro NA RA CAPSIM 2 compx Andrews 59559 Round 1.2020 Pille Undo - Decisions Proformas Inquirer - Help Human Resources DRAFT MATEO Staffing Labor Negotiations Last Year This Year 804 10096 Current Contract $ 25.53 Ceiling $ 2.500 Negotiation Postion Starting $ 25.53 $28.08 $ 2,500 $2,750 2.096 2.296 5.096 5.5% Hourly Wade Benefits Profit Sharing % Annual Raise 804 525 Labor Demands $ 28.08 $ 2.750 2.2% 5.5% 279 2.0% 5.0% Needed Complement Complement % Complement ist Shift Complement 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 804 100% 804 552 252 0.0% 10.0% 80 0 0 Contract Expiration: 1-Oct-2024 0.0% 10.0% 140 0 $0$ 0 100.0% 100.0% $80 $0 SO $80 CAPSIM 2 File Undo Finance IL Decisions Proformas - Inquirer Help CRAFT SAMFUATA HIMET Liabilities Owner's Equity Common Se $0 $0 Long Terme Current ASP Finances PLANT IMPROVEMENTS Total investments (5000) Sales Of Plant & Equipment COMMON STOCK Shares Outstanding (000) Price Per Share Earnings Per Share Max Stock Issue (5000) Issue Stock (5000) Max Stock Retire (5000) Retire Stock (5000) "Dividend Per Share CURRENT DEBT Interest Rate *Due This Year Borrow (5000) CASH POSITIONS December 31, 2019 December 31, 2020 2,051 $ 96.61 $ 12.32 $39.219 0 $9.805 0 $ $ $ Long Term Debt Retre Long Term Debt (5000) se Long Term Debt (2000) Long Term Interest Rate "Mmm This Year 0.00 11.49 514,722 0 TAR dors) Alaga) 10.0% $15.717 $ 0 Outstanding Bonds " Sumber 13.552021 $32014 $ 41,547 Amount 10 $ 11,300 SERT $70/2 cu ild 13.09 11.39 11.6 2019 ore $107.50 $990 $102.54 11.952022 Type here to search D WWacom UMA templitetom.com CAPSIM 2 comp-xm Fle Undo - Decisions Proforma TQM Initiative Andrews C59559 Hound 1.2020 Inquirer Help DRAWEONTRACTAMEO Process Management Initiatives Projected Impact Total Current Expenditures (5000): $0 CP Systems Vendor/UIT *Quality Initiative Training Channel Support Systems concurrent Engineering UNEP Green Programs "Budget (5000) $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 PROJECTED CUMULATIVE THPACTS Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction in Admin Costs Demand increase Worst Case Best Case 0.0% 0.096 0.096 0.0% 0.0% 0.0% 0.096 0.0% 0.0% 0.09 TOM INITIATIVES Benchmarking Quality Function Deployment Effort OCE/6 Sigma Training GEMI TQEM Sustainability Initiatives $ s $ $ 0 0 0 0 Reduction in Cost of God For the Year Just Ended 1.0% Admin Cost Reductions For the Year Just Ended R&D Cycle Time Reductions For the Year Just Ended Demand increase For the Year Just Ended 201 w Andrew Balan OS Che 0.0% Andrews Baldwin Chester D #ww2.capsim.com/Webseite/indexom?template-RDIM CAPSIM 2 comp-am Fle Undo - Decisions Proformas - Inquirer Research & Development Andrew C50569 Round 1.2020 Help ONETE POISON) Decisions "Name New Pfmn "New Size MTBF Revision Date Age Revision SRDC (8000) SO Abby Alan SO 10.8 12.9 5.4 8.1 0.0 Aft Agape 7.3 9.3 14.6 11.9 0.0 24000 26000 20000 22000 0 $0 A Na 50 Na 0.0 0.0 0 SO Abey Na 0.0 0 $0 0.0 0.0 Na 0.0 $0 SO Total Material Cost ou New 310 20 Age Profiles 100 30 30 70 Abby A Abby A AR Perceveden 50 so 40 30 20 10 10 Type here to search B File Undo Decisions Proformas Marketing Inquirer Help DRAFT SAVED AT AL 2020 STAVEDT Marketing Decisions Name Price Promo Budget Sales Budget Benchmark Preaktion Your Sales Forecast GROSS Revenue Forecast Variable Costs contrib Margin Forecast Less Promo & Sales $ $ $ $ $0.0 $0.0 40.00 $ 42.00 25.00 $ 32.00$ 1000 1000 2000 Abby Alan Alt Agape NA NA NA NA Total 1200 $ 1200 $ 12001 $ 1200 $ $0 $0 $0 olololo 1000 2.045 1,485 769 1,958 0 0 0 0 6,258 $0 $0 $0 $0 $5,000 Costs $ 81,800 $ 62,416 $ 19.988 $ 62,658 $0 $0 $0 $0 $ 226,870 $ 52.748 $ 38,112 $10.9721 $ 37,966 $0 $0 $0 $0 $ 139,800 wenn $ 29,060 $ 24,304 $9.011 $24,692 $0 $0 50 $0 $ 87,067 $ 26,860 $ 22.104 $ 5,811 $ 22.492 $0 $0 $0 $0 $77,267 $0.0 $0.0 30 $4,800 0 Note The Benchmark Prediction estimates unit sales assuming your product competes with a standardized, mediocre playing field. It does not use your actual competitors products. It is useful for experimenting with price, promo and sales budgets. It is useless for forecasting TAR Lag (days) A/P Lag (day) Revenue Forecast 2000 370,000 Unit Sales Forcast 2204 140,000 550.000 1.600 1.800 200 000 300 $10.000 400 200 Abby An Vos NA NA NA NA Atra Abby Alan NA DEMO Type here to search D CAPSIM 2 comp-xM Andrews C59569 Round 1 - 2020 File Undo Decisions - Proformas - Inquirer Help Production ORAFT VEDATA 2020 -BAMEOT $ Alt NA NA Abby 2,045 NA NA 254 Alan 1.486 216 750 743 269 758 2150 2.129 Agape 1.958 47 1800 1,782 Total 6,258 1,285 5,650 5.595 950 941 SCHEDULE Unit Sales Forecast Inventory On Hand Production Schedule Production After Ads MARGINS 2nd Shift Production Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin PHYSICAL PLANT 1st Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment (5000) WORKFORCE Complement 30.5% $10.50 $15.29 $25.79 35.59 5.196 $9.67 $15.98 $25.65 38.99 90.3% $8.28 $6.00 $14.28 45.196 50.096 $9.39 $10.00 $19.39 39.496 0.046 $0.00 $0.00 50.00 0.09 0.096 $0.00 $0.00 $0.00 0.046 0.096 $0.00 $0.00 $0.00 0.09 0.09 50.00 $0.00 $0.00 0.046 Total 3,772 0 728 0 4.0 4.0 $0 "Last Year 804 714 0 4.0 4.0 SO Needed 804 1,130 0 6.00 6.0 $0 This Year 100 1,200 0 5.0 5.0 $0 This Year 804 SO Ist Shift 552 $0 2nd Shift 252 $0 $0 Overtime Max Invest 0.0% AP Lag $0 $ 59,668 30 Production Vs. Capacity 2500 Base Capacity Productos Price U Cout Lab ON 2000 $40 1,500 1000 will 110 500 41 A Abby AR A NA w NA Agro NA RA CAPSIM 2 compx Andrews 59559 Round 1.2020 Pille Undo - Decisions Proformas Inquirer - Help Human Resources DRAFT MATEO Staffing Labor Negotiations Last Year This Year 804 10096 Current Contract $ 25.53 Ceiling $ 2.500 Negotiation Postion Starting $ 25.53 $28.08 $ 2,500 $2,750 2.096 2.296 5.096 5.5% Hourly Wade Benefits Profit Sharing % Annual Raise 804 525 Labor Demands $ 28.08 $ 2.750 2.2% 5.5% 279 2.0% 5.0% Needed Complement Complement % Complement ist Shift Complement 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 804 100% 804 552 252 0.0% 10.0% 80 0 0 Contract Expiration: 1-Oct-2024 0.0% 10.0% 140 0 $0$ 0 100.0% 100.0% $80 $0 SO $80 CAPSIM 2 File Undo Finance IL Decisions Proformas - Inquirer Help CRAFT SAMFUATA HIMET Liabilities Owner's Equity Common Se $0 $0 Long Terme Current ASP Finances PLANT IMPROVEMENTS Total investments (5000) Sales Of Plant & Equipment COMMON STOCK Shares Outstanding (000) Price Per Share Earnings Per Share Max Stock Issue (5000) Issue Stock (5000) Max Stock Retire (5000) Retire Stock (5000) "Dividend Per Share CURRENT DEBT Interest Rate *Due This Year Borrow (5000) CASH POSITIONS December 31, 2019 December 31, 2020 2,051 $ 96.61 $ 12.32 $39.219 0 $9.805 0 $ $ $ Long Term Debt Retre Long Term Debt (5000) se Long Term Debt (2000) Long Term Interest Rate "Mmm This Year 0.00 11.49 514,722 0 TAR dors) Alaga) 10.0% $15.717 $ 0 Outstanding Bonds " Sumber 13.552021 $32014 $ 41,547 Amount 10 $ 11,300 SERT $70/2 cu ild 13.09 11.39 11.6 2019 ore $107.50 $990 $102.54 11.952022 Type here to search D WWacom UMA templitetom.com CAPSIM 2 comp-xm Fle Undo - Decisions Proforma TQM Initiative Andrews C59559 Hound 1.2020 Inquirer Help DRAWEONTRACTAMEO Process Management Initiatives Projected Impact Total Current Expenditures (5000): $0 CP Systems Vendor/UIT *Quality Initiative Training Channel Support Systems concurrent Engineering UNEP Green Programs "Budget (5000) $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 PROJECTED CUMULATIVE THPACTS Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction in Admin Costs Demand increase Worst Case Best Case 0.0% 0.096 0.096 0.0% 0.0% 0.0% 0.096 0.0% 0.0% 0.09 TOM INITIATIVES Benchmarking Quality Function Deployment Effort OCE/6 Sigma Training GEMI TQEM Sustainability Initiatives $ s $ $ 0 0 0 0 Reduction in Cost of God For the Year Just Ended 1.0% Admin Cost Reductions For the Year Just Ended R&D Cycle Time Reductions For the Year Just Ended Demand increase For the Year Just Ended 201 w Andrew Balan OS Che 0.0% Andrews Baldwin Chester D
