Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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.32

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing And Assurance Services

Authors: Alvin Arens, Randal J. Elder

14th Global Edition

0273755013, 978-0273755012

More Books

Students also viewed these Accounting questions

Question

What is CSMA/CD? How does it operate?

Answered: 1 week ago