Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started