Need to Figure out Production and Marketing side please help ASAP
Recalculate Olle Research & Development Teamname: Andrews | SimID: C127157_037 Round: 1 Year: 2022 Draft saved at Apr 07, 2021 18:42 EDT Perceptual Map (at end of this year) o Name Pfmn Size 0 MTBF Revision Date 0 Age at Revision R&D Cost 20 Able 5.5 14.5 17500 $0 18 Acre Acre 3.0 17.0 14000 $0 16 Aft Able Adam 8.0 12.0 23000 $0 14 12 Adany Agape Aft 9.4 15.5 25000 $0 10 8 Agape 4.0 11.0 19000 $0 6 NA 0.0 0.0 0 0 $0 4 =|||||| NA 0.0 0.0 0 $0 2 NA 0.0 0.0 0 $0 0 0 2 4 6 8 10 12 14 16 18 20 Performance Total $0 Material Cost Age Profile 7.5 Able 11:38 5.6 Acre 7.83 5 4.6 41 Adam 3.5 3.6 Aft Perceived Age in Years 15:45 3.1 2.6 2.5 Agape 13:23 1.7 $0 $2.5 $5 $ $12.5 $15 $17.5 $7.5 $10 Material Cost in dollars 0 New Material Cost Old Material Cost + Able Acre + Adam * Aft + Agape - Recalculate Finance Teamname: Andrews SimID: C127157_037 Round: 1 | Year: 2022 Draft saved at Apr 07, 2021 19:13 EDT Liabilities & Owner's Equity Finances Plant Improvements Total Investments ($000) O $0 Accounts Payable : 6.5 % Current Debt: 1.1 % % Retained Earnings : 31.9% Sales of Plant & Equipment $ 0 Common Stock Shares Outstanding (000) O 2,000 Long Term Debt: 42% Price Per Share o $ 34.25 Common Stock: 18.5 % Earnings Per Share o $ 1.04 Max Stock Issue ($000) $ 13,700 Issue Stock ($000) $ 0 $ 0 Max Stock Retire ($000) $ 3,425 Long Term Debt Retire Long Term Debt ($000) O Issue Long Term Debt ($000) O Long Term Interest Rate Maximum Issue This Year $ 0 Retire Stock ($000) $ 0 11.3% $ 18,994 Dividend Per Share o $ 0.00 30 Current Debt A/R Lag (days) A/P Lag (days) Interest Rate O 9.9% 30 Due This Year $0 $ $ 0 Borrow $000) Cash Positions December 31, 2021 Outstanding Bonds Series Number Face Amount Current Yield 2021 Close 11.0S2023 $ 6,950 11.1% $ 99.49 12.5S2025 $ 13,900 12.0% $ 103.70 14.052027 $ 20,850 12.6% $ 111.32 $ 3,434 December 31, 2022 ($ 1,093) CAPSTONE. Coach File Undo- Decisions Proformas Reports Help Acre Adam Aft Agape NA NA NA ll. RESEARCH & DEVELOPMENT Able Performance Size MTBF 3.0 4.0 0.0 5.5 14.5 8.0 12.0 23000 9.4 15.5 0.0 0.0 0.0 0.0 17.0 0.0 11.0 19000 17500 14000 25000 0 0 0 M MARKETING Able Acre Adam Aft NA NA NA $28.00 $ 1,000 $ 1,000 Price Promo Budget Sales Budget Your Sales Forecast $ 21.00 $ 900 $ 900 0 $ 38.00 $ 800 $ 800 $ 33.00 $ 700 $ 700 $ 0.00 $0 Agape $ 33.00 $ 700 $ 700 0 $ 0.00 $ 0 $0 0 $ 0.00 $ 0 $ 0 $0 0 0 0 0 0 PRODUCTION Able Acre Adam Aft Agape NA NA NA 1,200 1,820 410 440 380 0 0 Scheduled Production Capacity Change Automation Rating 0 0 0 0 0 0 0 0 0 4.0 5.0 3.0 3.0 3.0 0 0 0 HR HUMAN RESOURCES FINANCE Stock Issue Stock Retire Dividend Per Share Short Term Debt Bond Retire Bond Issue A/R Policy A/P Policy $ 0 $ 0 $ 0.00 $0 $0 $0 Labor Negotiations Wages Benefits Profit Sharing Annual Wage Increase Complement Recruiting Spend Training Hours Starting $20.00 $2500 2.0% 5.0% 700.000 $ 0 Ceiling $20.00 $2500 2.0% 5.0% 30 30 0 Recalculate M Marketing Name Price Promo Budget $ 1000 Sales Budget $ 1000 Benchmark Prediction Your Forecast Teamname: Andrews | SimID: C127157_037 Round: 1 | Year: 2022 Draft saved at Apr 07, 2021 19:12 EDT Gross Variable Contrib Less Revenue Costs Margin 0 Promo/Sales $ 25,078 $ 17,130 $ 7,948 $ 5,948 Able $ $ 28.00 896 0 Acre $ 21.00 $ $ 900 $ 900 1,357 0 0 $ 28,502 $ 20,482 $ 8,020 $ 6,220 Adam $ 38.00 $ 800 $ 800 355 0 $ 13,507 $ 8,707 $ 4,800 $ 3,200 Aft $ 33.00 $ 700 $ 700 366 0 $ 12,074 $ 8,936 $ 3,138 $ 1,738 Agape $ 33.00 $ 700 700 390 0 $ 12,873 $ 8,659 $ 4,213 $ 2,813 NA $0.0 $0 $ 0 0 $0 $0 $0 $0 NA $0.0 $0 $ 0 0 $0 $ 0 $ 0 $0 NA $0.0 $ 0 $0 0 $ 0 $0 $0 $ 0 Total $ 4,100 $ 4,100 3,364 0 $ 92,034 $ 63,913 $ 28,121 $ 19,921 A/R Lag (days) 30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast 1.5 30 $28,502 1,357 $25,078 20 896 Revenue forecast (in 000's) $13,507 $12,074 $12,872 Unit Sales forecast (in 000's) 10 0.5 355 366 390 Able Acre Adam Aft Agape Able Acre Adam Aft Agape Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Recalculate Production Teamname: Andrews SimID: C127157_037 Round: 1 Year: 2022 Draft saved at Apr 07, 2021 19:13 EDT Production Schedule Able Acre Adam Aft Agape NA NA NA Total Unit Sales Forecast 896 1,357 355 366 390 0 0 0 3,364 Inventory On Hand 189 39 40 78 62 0 0 0 0 408 Production Schedule 1200 1820 410 440 380 4,250 Production After Adj. 1,188 1,802 406 436 376 0 0 0 4,209 Margins 2nd Shift Production% 0.0% 30.0% 0.0% 0.0% 0.0% 0 0 0 0 0 $7.85 $7.46 $8.97 $8.97 $8.97 0 0 0 0 Labor Cost/Unit Material Cost/Unit $11.28 $7.63 $15.53 $15.45 $13.23 0 0 0 Total Unit Cost $19.13 $15.09 $24.50 $24.42 $22.20 0 0 0 0 Contribution Margin 31.7% 28.1% 35.5% 26.0% 32.7% 0 0 0 Physical Plant Total 1st Shift Capacity 1,800 1,400 900 600 600 0 0 0 5,300 Buy/Sell Capacity 0 0 0 0 0 0 Automation Rating 4.0 5.0 3.0 3.0 3.0 0.0 0.0 0.0 New Autom. Rating 4.0 5.0 3.0 3.0 3.0 Investment ($000) $ 0 $ 0 $ 0 $ $ 0 $ 0 $ 0 $ $ 0 $ 0 $ $ 0 Workforce Last Year Needed This Year % 0 This Year 1st Shift 2nd Shift Overtime Max Invest $ 32,694 Complement 700 701 100 % 700 640 61 0.0% A/P Lag 30 Recalculate Olle Research & Development Teamname: Andrews | SimID: C127157_037 Round: 1 Year: 2022 Draft saved at Apr 07, 2021 18:42 EDT Perceptual Map (at end of this year) o Name Pfmn Size 0 MTBF Revision Date 0 Age at Revision R&D Cost 20 Able 5.5 14.5 17500 $0 18 Acre Acre 3.0 17.0 14000 $0 16 Aft Able Adam 8.0 12.0 23000 $0 14 12 Adany Agape Aft 9.4 15.5 25000 $0 10 8 Agape 4.0 11.0 19000 $0 6 NA 0.0 0.0 0 0 $0 4 =|||||| NA 0.0 0.0 0 $0 2 NA 0.0 0.0 0 $0 0 0 2 4 6 8 10 12 14 16 18 20 Performance Total $0 Material Cost Age Profile 7.5 Able 11:38 5.6 Acre 7.83 5 4.6 41 Adam 3.5 3.6 Aft Perceived Age in Years 15:45 3.1 2.6 2.5 Agape 13:23 1.7 $0 $2.5 $5 $ $12.5 $15 $17.5 $7.5 $10 Material Cost in dollars 0 New Material Cost Old Material Cost + Able Acre + Adam * Aft + Agape - Recalculate Finance Teamname: Andrews SimID: C127157_037 Round: 1 | Year: 2022 Draft saved at Apr 07, 2021 19:13 EDT Liabilities & Owner's Equity Finances Plant Improvements Total Investments ($000) O $0 Accounts Payable : 6.5 % Current Debt: 1.1 % % Retained Earnings : 31.9% Sales of Plant & Equipment $ 0 Common Stock Shares Outstanding (000) O 2,000 Long Term Debt: 42% Price Per Share o $ 34.25 Common Stock: 18.5 % Earnings Per Share o $ 1.04 Max Stock Issue ($000) $ 13,700 Issue Stock ($000) $ 0 $ 0 Max Stock Retire ($000) $ 3,425 Long Term Debt Retire Long Term Debt ($000) O Issue Long Term Debt ($000) O Long Term Interest Rate Maximum Issue This Year $ 0 Retire Stock ($000) $ 0 11.3% $ 18,994 Dividend Per Share o $ 0.00 30 Current Debt A/R Lag (days) A/P Lag (days) Interest Rate O 9.9% 30 Due This Year $0 $ $ 0 Borrow $000) Cash Positions December 31, 2021 Outstanding Bonds Series Number Face Amount Current Yield 2021 Close 11.0S2023 $ 6,950 11.1% $ 99.49 12.5S2025 $ 13,900 12.0% $ 103.70 14.052027 $ 20,850 12.6% $ 111.32 $ 3,434 December 31, 2022 ($ 1,093) CAPSTONE. Coach File Undo- Decisions Proformas Reports Help Acre Adam Aft Agape NA NA NA ll. RESEARCH & DEVELOPMENT Able Performance Size MTBF 3.0 4.0 0.0 5.5 14.5 8.0 12.0 23000 9.4 15.5 0.0 0.0 0.0 0.0 17.0 0.0 11.0 19000 17500 14000 25000 0 0 0 M MARKETING Able Acre Adam Aft NA NA NA $28.00 $ 1,000 $ 1,000 Price Promo Budget Sales Budget Your Sales Forecast $ 21.00 $ 900 $ 900 0 $ 38.00 $ 800 $ 800 $ 33.00 $ 700 $ 700 $ 0.00 $0 Agape $ 33.00 $ 700 $ 700 0 $ 0.00 $ 0 $0 0 $ 0.00 $ 0 $ 0 $0 0 0 0 0 0 PRODUCTION Able Acre Adam Aft Agape NA NA NA 1,200 1,820 410 440 380 0 0 Scheduled Production Capacity Change Automation Rating 0 0 0 0 0 0 0 0 0 4.0 5.0 3.0 3.0 3.0 0 0 0 HR HUMAN RESOURCES FINANCE Stock Issue Stock Retire Dividend Per Share Short Term Debt Bond Retire Bond Issue A/R Policy A/P Policy $ 0 $ 0 $ 0.00 $0 $0 $0 Labor Negotiations Wages Benefits Profit Sharing Annual Wage Increase Complement Recruiting Spend Training Hours Starting $20.00 $2500 2.0% 5.0% 700.000 $ 0 Ceiling $20.00 $2500 2.0% 5.0% 30 30 0 Recalculate M Marketing Name Price Promo Budget $ 1000 Sales Budget $ 1000 Benchmark Prediction Your Forecast Teamname: Andrews | SimID: C127157_037 Round: 1 | Year: 2022 Draft saved at Apr 07, 2021 19:12 EDT Gross Variable Contrib Less Revenue Costs Margin 0 Promo/Sales $ 25,078 $ 17,130 $ 7,948 $ 5,948 Able $ $ 28.00 896 0 Acre $ 21.00 $ $ 900 $ 900 1,357 0 0 $ 28,502 $ 20,482 $ 8,020 $ 6,220 Adam $ 38.00 $ 800 $ 800 355 0 $ 13,507 $ 8,707 $ 4,800 $ 3,200 Aft $ 33.00 $ 700 $ 700 366 0 $ 12,074 $ 8,936 $ 3,138 $ 1,738 Agape $ 33.00 $ 700 700 390 0 $ 12,873 $ 8,659 $ 4,213 $ 2,813 NA $0.0 $0 $ 0 0 $0 $0 $0 $0 NA $0.0 $0 $ 0 0 $0 $ 0 $ 0 $0 NA $0.0 $ 0 $0 0 $ 0 $0 $0 $ 0 Total $ 4,100 $ 4,100 3,364 0 $ 92,034 $ 63,913 $ 28,121 $ 19,921 A/R Lag (days) 30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast 1.5 30 $28,502 1,357 $25,078 20 896 Revenue forecast (in 000's) $13,507 $12,074 $12,872 Unit Sales forecast (in 000's) 10 0.5 355 366 390 Able Acre Adam Aft Agape Able Acre Adam Aft Agape Variable Cost Marketing Margin After Marketing Trad Low High Pfmn Size Recalculate Production Teamname: Andrews SimID: C127157_037 Round: 1 Year: 2022 Draft saved at Apr 07, 2021 19:13 EDT Production Schedule Able Acre Adam Aft Agape NA NA NA Total Unit Sales Forecast 896 1,357 355 366 390 0 0 0 3,364 Inventory On Hand 189 39 40 78 62 0 0 0 0 408 Production Schedule 1200 1820 410 440 380 4,250 Production After Adj. 1,188 1,802 406 436 376 0 0 0 4,209 Margins 2nd Shift Production% 0.0% 30.0% 0.0% 0.0% 0.0% 0 0 0 0 0 $7.85 $7.46 $8.97 $8.97 $8.97 0 0 0 0 Labor Cost/Unit Material Cost/Unit $11.28 $7.63 $15.53 $15.45 $13.23 0 0 0 Total Unit Cost $19.13 $15.09 $24.50 $24.42 $22.20 0 0 0 0 Contribution Margin 31.7% 28.1% 35.5% 26.0% 32.7% 0 0 0 Physical Plant Total 1st Shift Capacity 1,800 1,400 900 600 600 0 0 0 5,300 Buy/Sell Capacity 0 0 0 0 0 0 Automation Rating 4.0 5.0 3.0 3.0 3.0 0.0 0.0 0.0 New Autom. Rating 4.0 5.0 3.0 3.0 3.0 Investment ($000) $ 0 $ 0 $ 0 $ $ 0 $ 0 $ 0 $ $ 0 $ 0 $ $ 0 Workforce Last Year Needed This Year % 0 This Year 1st Shift 2nd Shift Overtime Max Invest $ 32,694 Complement 700 701 100 % 700 640 61 0.0% A/P Lag 30
