Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is business policy I need help with capsim to input this information In. Proformas Reports Help Recalculate Name Price Baker Bead Bid Bold Buddy
this is business policy I need help with capsim to input this information In.
Proformas Reports Help Recalculate Name Price Baker Bead Bid Bold Buddy NA $ $ $ $ $ 28.00 21.00 38.00 33.00 33.00 $0.0 $0.0 $0.0 Promo Budget $ 1000 $ 900 800 S 700 700 Sales Budget s 1000 900 $ 800 $ 700 $ 700 $ 0 $0 $0 $ 4,100 My Marketing Teamname: Baldwin SimID: C114522 | Round: 1 Year: 2020 Draft saved at Apr 01, 2020 10:19PM EDT Benchmark Your Gross Variable Contrib Prediction Forecast Revenue Costs Margin Promo/Sales 896 0 $ 25,078 $ 17,130 $ 7,948 $5,948 1,357 L0 $ 28,502 $ 20,482 $ 8,020 $ 6,220 355 $ 13,507 $ 8,707 $ 4,800 $ 3,200 366 0 $ 12,074 $ 8,936 $3,138 $ 1,738 390 0 $ 12,873 $ 8,659 $ 4,213 $ 2,813 $0 $ 0 $0 $0 $0 $0 $ 0 $ 0 $0 $0 3,364 $ 92,034 $ 63,913 $ 28,121 $ 19,921 SL $0 0 $0 $ 0 NA NA $ 0 $0 $ 4,100 Total A/R Lag (days) : 30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast $28,502 1.357 $25,078 896 Revenue forecast (in 000's) $13,507 $ 12,074 $12,872 Unit Sales forecast (in 000's) 355 366 390 0 Bid Buddy Baker Bold Buddy Baker Bead Variable Cost Bold Margin After Marketing Bead Trad Low Bid High Marketing Pfmn Size S TONE Coach File Undo Decisions Proformas Reports Help Recalculate Ol Research & Development Teamname: Baldwin SimID: C114522 | Round: 1 Year: 2020 Draft saved at Apr 01, 2020 10:21PM EDT Perceptual Map (at end of this year) o Name Pfmn Size 0 MTBF Revision Date Age at Revision R&D Costo Baker 5.5 14.5 Bead Bead 17.0 17500 14000 23000 Bold Baka Bid 8.0 12.0 Bid Buddy Size Bold 9.4 15.5 25000 Buddy 11.0 19000 NA 0.0 0.0 | 10.0 0.0 NA 10. 000.000 NA 0 2 4 6 8 10 12 14 16 18 20 Performance Total Material Cost Age Profile Baker Bead 28 Bid Perceived Age in Years Bold 15.45 15.45 Buddy 13:23 $0 $2.5 $5 $12.5 $7.5 $ 10 Material Cost in dollars $15 $17.5 New Material Cost Old Material Cost + Baker + Bead + Bid + Bold + Buddy Diall saveu al API UI, 2020 10.21PM EDI Baker Bead Bid Bold Buddy NA NA Total 896 1,357 366 390 0 0 Production Schedule Unit Sales Forecast Inventory On Hand Production Schedule Production After Adj. O 355 40 3,364 408 39 78 189 1200 1820 410 4 440 62 380 376 4,250 1,188 1,802 406 436 4,209 0.0% 30.0% 0.0% 0.0% 0.0% $7.85 $7.46 $8.97 $8.97 Margins 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin 0 $8.97 $15.45 $15.53 $13.23 $11.28 $19.13 31.7% $7.63 $15.09 28.1% $24.42 $22.20 $24.50 35.5% 26.0% 32.7% Total 900 600 600 5,300 1,800 0 1,400 0 5.0 5.0 4.0 Co 3.0 [ 3.0 3.0 3.0 Physical Plant 1st Shift Capacity 0 Buy/Sell Capacity Automation Rating O New Autom. Rating Investment ($000) Workforce Complement 0.0 0.0 4.0 [ 3.0 3.0 $0 $ 0 $ 0 $ 0 $0 $ 0 $ 0 2nd Shift Over Last Year 700 Needed 701 This Year % 0 100 % This Year 700 $ 0 Overtime 0.0% 1st Shift 640 Max Invest A/P Lag @ $ 32,694 30 Production vs Capacity Price vs Unit Cost $40 4k 2k $20 LLLL !!! Ok Baker $0 Bead Bid Bold Buddy Baker Bead Bold Buddy Bid Labor Both Shifts Base Capacity Production Material Margin Chats Recalculate Finance Teamname: Baldwin 2020 Liabilities & Owner's Equity SimID: C114522 Round: 1 Year: Draft saved at Apr 01, 2020 10:22PM EDT Finances Accounts Payable : 6.5% Current Debt: 1.1% Retained Earnings : 31.9% 2,000 - Long Term Debt: 42% $ 34.25 Common Stock : 18.5% $ 1.04 $ 13,700 0 Plant Improvements Total Investments ($000) Sales of Plant & Equipment Common Stock Shares Outstanding (000) Price Per Share o Earnings Per Share Max Stock Issue ($000) O Issue Stock (5000) Max Stock Retire (5000) Retire Stock ($000) Dividend Per Share Current Debt Interest Rate Due This Year Borrow (5000) Cash Positions December 31, 2019 December 31, 2020 0 $ $ 3,425 0 0.00 $L 0 11.3% $ 18,994 9.9% Long Term Debt Retire Long Term Debt ($000) Issue Long Term Debt $000) Long Term Interest Rate Maximum Issue This Year o A/R Lag (days) A/P Lag (days) Outstanding Bonds Series Number Face Amount Current Yield 11.0S2021 $ 6,950 11.1% 12.552023 $ 13,900 12.0% 14.0S2025 $ 20,850 12.6% 30 30 $ 0 $ 3,434 ($ 1,093) 2019 Close $ 99.49 $ 103.70 $ 111.32 Proformas Reports Help Recalculate Name Price Baker Bead Bid Bold Buddy NA $ $ $ $ $ 28.00 21.00 38.00 33.00 33.00 $0.0 $0.0 $0.0 Promo Budget $ 1000 $ 900 800 S 700 700 Sales Budget s 1000 900 $ 800 $ 700 $ 700 $ 0 $0 $0 $ 4,100 My Marketing Teamname: Baldwin SimID: C114522 | Round: 1 Year: 2020 Draft saved at Apr 01, 2020 10:19PM EDT Benchmark Your Gross Variable Contrib Prediction Forecast Revenue Costs Margin Promo/Sales 896 0 $ 25,078 $ 17,130 $ 7,948 $5,948 1,357 L0 $ 28,502 $ 20,482 $ 8,020 $ 6,220 355 $ 13,507 $ 8,707 $ 4,800 $ 3,200 366 0 $ 12,074 $ 8,936 $3,138 $ 1,738 390 0 $ 12,873 $ 8,659 $ 4,213 $ 2,813 $0 $ 0 $0 $0 $0 $0 $ 0 $ 0 $0 $0 3,364 $ 92,034 $ 63,913 $ 28,121 $ 19,921 SL $0 0 $0 $ 0 NA NA $ 0 $0 $ 4,100 Total A/R Lag (days) : 30 A/P Lag (days) : 30 Revenue Forecast Unit Sales Forecast $28,502 1.357 $25,078 896 Revenue forecast (in 000's) $13,507 $ 12,074 $12,872 Unit Sales forecast (in 000's) 355 366 390 0 Bid Buddy Baker Bold Buddy Baker Bead Variable Cost Bold Margin After Marketing Bead Trad Low Bid High Marketing Pfmn Size S TONE Coach File Undo Decisions Proformas Reports Help Recalculate Ol Research & Development Teamname: Baldwin SimID: C114522 | Round: 1 Year: 2020 Draft saved at Apr 01, 2020 10:21PM EDT Perceptual Map (at end of this year) o Name Pfmn Size 0 MTBF Revision Date Age at Revision R&D Costo Baker 5.5 14.5 Bead Bead 17.0 17500 14000 23000 Bold Baka Bid 8.0 12.0 Bid Buddy Size Bold 9.4 15.5 25000 Buddy 11.0 19000 NA 0.0 0.0 | 10.0 0.0 NA 10. 000.000 NA 0 2 4 6 8 10 12 14 16 18 20 Performance Total Material Cost Age Profile Baker Bead 28 Bid Perceived Age in Years Bold 15.45 15.45 Buddy 13:23 $0 $2.5 $5 $12.5 $7.5 $ 10 Material Cost in dollars $15 $17.5 New Material Cost Old Material Cost + Baker + Bead + Bid + Bold + Buddy Diall saveu al API UI, 2020 10.21PM EDI Baker Bead Bid Bold Buddy NA NA Total 896 1,357 366 390 0 0 Production Schedule Unit Sales Forecast Inventory On Hand Production Schedule Production After Adj. O 355 40 3,364 408 39 78 189 1200 1820 410 4 440 62 380 376 4,250 1,188 1,802 406 436 4,209 0.0% 30.0% 0.0% 0.0% 0.0% $7.85 $7.46 $8.97 $8.97 Margins 2nd Shift Production% Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin 0 $8.97 $15.45 $15.53 $13.23 $11.28 $19.13 31.7% $7.63 $15.09 28.1% $24.42 $22.20 $24.50 35.5% 26.0% 32.7% Total 900 600 600 5,300 1,800 0 1,400 0 5.0 5.0 4.0 Co 3.0 [ 3.0 3.0 3.0 Physical Plant 1st Shift Capacity 0 Buy/Sell Capacity Automation Rating O New Autom. Rating Investment ($000) Workforce Complement 0.0 0.0 4.0 [ 3.0 3.0 $0 $ 0 $ 0 $ 0 $0 $ 0 $ 0 2nd Shift Over Last Year 700 Needed 701 This Year % 0 100 % This Year 700 $ 0 Overtime 0.0% 1st Shift 640 Max Invest A/P Lag @ $ 32,694 30 Production vs Capacity Price vs Unit Cost $40 4k 2k $20 LLLL !!! Ok Baker $0 Bead Bid Bold Buddy Baker Bead Bold Buddy Bid Labor Both Shifts Base Capacity Production Material Margin Chats Recalculate Finance Teamname: Baldwin 2020 Liabilities & Owner's Equity SimID: C114522 Round: 1 Year: Draft saved at Apr 01, 2020 10:22PM EDT Finances Accounts Payable : 6.5% Current Debt: 1.1% Retained Earnings : 31.9% 2,000 - Long Term Debt: 42% $ 34.25 Common Stock : 18.5% $ 1.04 $ 13,700 0 Plant Improvements Total Investments ($000) Sales of Plant & Equipment Common Stock Shares Outstanding (000) Price Per Share o Earnings Per Share Max Stock Issue ($000) O Issue Stock (5000) Max Stock Retire (5000) Retire Stock ($000) Dividend Per Share Current Debt Interest Rate Due This Year Borrow (5000) Cash Positions December 31, 2019 December 31, 2020 0 $ $ 3,425 0 0.00 $L 0 11.3% $ 18,994 9.9% Long Term Debt Retire Long Term Debt ($000) Issue Long Term Debt $000) Long Term Interest Rate Maximum Issue This Year o A/R Lag (days) A/P Lag (days) Outstanding Bonds Series Number Face Amount Current Yield 11.0S2021 $ 6,950 11.1% 12.552023 $ 13,900 12.0% 14.0S2025 $ 20,850 12.6% 30 30 $ 0 $ 3,434 ($ 1,093) 2019 Close $ 99.49 $ 103.70 $ 111.32Step 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