Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a simulation. Please help me manage companies finances so that debt and profit is attained at the most accurate rate Research & Development

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
This is a simulation. Please help me manage companies finances so that debt and profit is attained at the most accurate rate
Research & Development CRAFT LAVED AT 16, MEN Decisions Name New Pfm Perchased New Size "MTBF NOU SANG Ark Dote Able Acre 13.2 5.7 8.4 11.1 0.0 26000 20000 22000 24000 so $0 $0 Ae 9.2 14.5 11.8 72 0.0 0.0 0.0 Awe so AN NA 0 50 10 0 NA NA NA 0.0 0.0 $0 0 $0 0.0 0.0 50 Total $0 Material Com Bow w 315 20 Age Profiles 100 90 BO An An Atle Abre . NA NA Awe Pancave Agent 50 NE 30 18 00 Marketing CART LAVED ATUPUEST Marketing Decisions Name Price Sales Budget Promo Budget Benchmark Prediction Your Less Promo Variable Costs Sales Forecast Contrib Margin Forecast & Sales 0 0 42.00 $ 25,00 32.00 $ 40.00 $ 1,487 769 1,959 2,047 Able Acre Awe NA NA NA NA Total 5 3 $ $ $0.0 $0.0 50.0 $0.0 1200$ 1200 $ 1200$ 1200$ $0 $0 $0 $0 $ 4,800 1000 2000 1000 1000 $0 $0 $0 $0 $5,000 Gross Revenue Forecast Costs $ 62,460 $ 20,002 $ 62,702 $ 81,866 $0 $0 $0 $0 $ 227,031 $ 38,139 $ 10,984 $ 37,993 $ 52,786 $0 $0 $0 $0 $ 139,902 $ 24,321 $ 9,017 $ 24,710 $ 29,080 $0 $0 $0 SO $ 87,129 $22,121 $5,817 $ 22,510 $ 26,880 $0 $0 $0 $0 $77,329 0 0 6,263 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 A/R Lag (days) AVP Lag (days) 30 30 Revenue Forecast 380.000 370.000 500.000 350,000 140.000 130.000 120 00 310.000 SO Unit Sales Forecast 2.200 2.000 1.800 1.600 1.400 200 1.000 800 800 400 200 0 All Able Ark NA Vers NA Maryn Afler Mann Acre Awe NA NA DE Nano Core The Production DRAET SAVED AT M 16.2020 MEST NA NA NA NA SCHEDULE Unit Sales Forecast Inventory On Hand Production Schedule Production Alter Ad). Ark 1,487 214 750 743 Able 769 756 2150 2,129 Acre 1,959 41 1800 1,782 Awe 2,047 261 950 941 - Total 6,263 1,272 5,650 5,595 5.196 $9.67 $15.98 $25.65 38.9% 90.396 $8.28 $6.00 $14.28 45.1% 50.0% $9.39 $10.00 $19.39 39.4% 30.5% $10.50 $15.29 $25.79 35.5% 0.0% $0.00 $0.00 $0.00 0.0% 0.096 $0.00 $0.00 $0.00 0.096 0.0% $0.00 $0.00 $0.00 0.0% 0.096 $0.00 $0.00 $0.00 0.096 MARGINS 2nd Shift Production 46 Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin PHYSICAL PLANT ist Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment (5000) WORKFORCE Complement Total 3,772 0 714 0 4.0 4.0 $0 Last Year 804 1,130 0 6.0 6.0 $0 Needed 804 1,200 0 5.0 5.0 $0 This Year % 10098 728 0 4.0 4.0 $0 This Year 804 $0 1st Shift $0 2nd Shift 252 $0 SO Overtime Max Invest 0.0% AP Lag SO $ 59,852 30 552 Production Vs. Capacity 2.500 Both Shifts Base Capact Production Price Vs. Unit Cost 30 Material Laborar 349 2.000 530 1 500 1 DOO 310 500 AN MA NA NA DRAFT LAVED AT H 16, 20:21 PM EST Human Resources Staffing Labor Negotiations Last Year This Year 804 804 100% 10096 804 804 525 552 279 0.0% 0.0% 10.0% 10.0% 80 0 0 Hourly Wage Benefits Profit Sharing % Annual Raise Current Contract $ 25.53 $2,500 2.0% 5.0% Labor Demands $ 28.08 $2,750 2.2% 5.5% Negotiation Postion Starting Ceiling $25.53 $ 28.0B $ 2,500 $ 2,750 2.0% 2.2% 5.0% 5.5% 252 Contract Expiration: 1-Oct-2024 Needed Complement Complement % Complement 1st 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 140 $0 $ 0 0 0 100.0% 100.0% $80 $0 $0 $80 CAPSIM Decisions Proformas File Undo Finance Inquirer Help AT LAVEDATNI 15. MEST Llabilities & Owner's Equlty Cormon Stock $0 $0 Retired Earnings Long Term Delt 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) Rotire Stock (5000) Dividend Per Share 2,051 $ 95.81 $ 12.28 $ 39,301 Current Det Accounts Pay $ 0 $9,825 0 $ Long Term Debt "Retire Long Term Debt (5000) Issue Long Term Debt (5000) "Long Term Interest Rate Maximum Issue This Year $ $ 0.00 11.4% $ 14,722 30 30 AVR Lag (days) A/P Lao (days) 10.0% $ 15,717 0 CURRENT DEBT Interest Rate Due This Year Borrow (5000) CASH POSITIONS December 31, 2019 December 31, 2020 $ 32,442 $ 41,696 Outstanding Bonds Series Number 13.552021 11.252026 11.952027 Face Amount $0 $ 11,300 $ 8,83 $7,072 Current Yield 13.0% 11.3% 11.6% 2019 "Close $ 103.58 $99.07 $ 102.54 TQM Initiative CAFT SAVED AY NY2929 19 VEST Process Management Initiatives Projected Impact Budget (5000) $ 0 Total Current Expenditures ($000): $0 CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs $ $ $ PROJECTED CUMULATIVE IMPACTS Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction in Admin Costs Demand increase Worst Case 0.0% 0.0% 0.0% 0.0% 0.0% Best Case 0.0% 0.0% 0.0% 0.0% 0.0% TON INITIATIVES Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TOEM Sustainability Initiatives $ $ $ $ 0 0 0 0 Reduction in Cost of Gada For the Year Just Ended Admin Cost Reductions For the Year Just Ended 09 R&D Cycle Time Reductions For the Year Just Ended 0% Demand Increase For the Year Just Ended 0 204 109 Andrews Andrews Andrews Baldw Baldwin Badw Chester Chester Chester Doby Dy Digby des Chester Oy NA NA 0.0 0.0 0.0 0.0 Products RAD DECISION Performance Isine MTOF Istice Promo Budget Sales Bolo Your Sales Forecast Scheduled Production Capacity Change Automation Rating Ark 13_2 92 26000 $42.00 $ 1,200 $1,000 0 750 0 4.0 Alle 5.7 14.5 20000 $26.00 $1,200 $2,000 0 2,150 0 6,0 Acre 8.4 11.8 22000 $ 32.00 $ 1,200 $1,000 0 1,800 0 5.0 Awe 11.1 22 24000 $ 40,00 $ 1,200 $1,000 0 950 0 40 NA 0.0 0.0 0 $ 0.00 $0 $0 NA 0.0 0.0 0 $ 0.00 $0 $0 0 0 0 0.0 $ 0.00 $0 $0 $ 0.00 $0 0 0 0 0 0.0 0.0 Ceiling Finances Stock ISSUE Stock Retire Dresden Per Share Short Term Debt Bond Retre Bond Issue AR Policy AP Policy $0 $0 $ 0.00 $0 50 $0 30 30 Human Resources LABOR NEGOTIATIONS Wages Benefits Profit Sharing Annual Wage Increase Coffplement Recruiting Spend Training Hours Starting $25.53 $2500 2.09 5.0% 804 $0 0 $28.08 $2750 2.29 5.5% TQM Vendor/JIT QIT CSS CE Benchmark QFDE CCE/6 UNEPGreen GEMETQEM OOOOOOOOO 0 Research & Development CRAFT LAVED AT 16, MEN Decisions Name New Pfm Perchased New Size "MTBF NOU SANG Ark Dote Able Acre 13.2 5.7 8.4 11.1 0.0 26000 20000 22000 24000 so $0 $0 Ae 9.2 14.5 11.8 72 0.0 0.0 0.0 Awe so AN NA 0 50 10 0 NA NA NA 0.0 0.0 $0 0 $0 0.0 0.0 50 Total $0 Material Com Bow w 315 20 Age Profiles 100 90 BO An An Atle Abre . NA NA Awe Pancave Agent 50 NE 30 18 00 Marketing CART LAVED ATUPUEST Marketing Decisions Name Price Sales Budget Promo Budget Benchmark Prediction Your Less Promo Variable Costs Sales Forecast Contrib Margin Forecast & Sales 0 0 42.00 $ 25,00 32.00 $ 40.00 $ 1,487 769 1,959 2,047 Able Acre Awe NA NA NA NA Total 5 3 $ $ $0.0 $0.0 50.0 $0.0 1200$ 1200 $ 1200$ 1200$ $0 $0 $0 $0 $ 4,800 1000 2000 1000 1000 $0 $0 $0 $0 $5,000 Gross Revenue Forecast Costs $ 62,460 $ 20,002 $ 62,702 $ 81,866 $0 $0 $0 $0 $ 227,031 $ 38,139 $ 10,984 $ 37,993 $ 52,786 $0 $0 $0 $0 $ 139,902 $ 24,321 $ 9,017 $ 24,710 $ 29,080 $0 $0 $0 SO $ 87,129 $22,121 $5,817 $ 22,510 $ 26,880 $0 $0 $0 $0 $77,329 0 0 6,263 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 A/R Lag (days) AVP Lag (days) 30 30 Revenue Forecast 380.000 370.000 500.000 350,000 140.000 130.000 120 00 310.000 SO Unit Sales Forecast 2.200 2.000 1.800 1.600 1.400 200 1.000 800 800 400 200 0 All Able Ark NA Vers NA Maryn Afler Mann Acre Awe NA NA DE Nano Core The Production DRAET SAVED AT M 16.2020 MEST NA NA NA NA SCHEDULE Unit Sales Forecast Inventory On Hand Production Schedule Production Alter Ad). Ark 1,487 214 750 743 Able 769 756 2150 2,129 Acre 1,959 41 1800 1,782 Awe 2,047 261 950 941 - Total 6,263 1,272 5,650 5,595 5.196 $9.67 $15.98 $25.65 38.9% 90.396 $8.28 $6.00 $14.28 45.1% 50.0% $9.39 $10.00 $19.39 39.4% 30.5% $10.50 $15.29 $25.79 35.5% 0.0% $0.00 $0.00 $0.00 0.0% 0.096 $0.00 $0.00 $0.00 0.096 0.0% $0.00 $0.00 $0.00 0.0% 0.096 $0.00 $0.00 $0.00 0.096 MARGINS 2nd Shift Production 46 Labor Cost/Unit Material Cost/Unit Total Unit Cost Contribution Margin PHYSICAL PLANT ist Shift Capacity Buy/Sell Capacity Automation Rating New Autom. Rating Investment (5000) WORKFORCE Complement Total 3,772 0 714 0 4.0 4.0 $0 Last Year 804 1,130 0 6.0 6.0 $0 Needed 804 1,200 0 5.0 5.0 $0 This Year % 10098 728 0 4.0 4.0 $0 This Year 804 $0 1st Shift $0 2nd Shift 252 $0 SO Overtime Max Invest 0.0% AP Lag SO $ 59,852 30 552 Production Vs. Capacity 2.500 Both Shifts Base Capact Production Price Vs. Unit Cost 30 Material Laborar 349 2.000 530 1 500 1 DOO 310 500 AN MA NA NA DRAFT LAVED AT H 16, 20:21 PM EST Human Resources Staffing Labor Negotiations Last Year This Year 804 804 100% 10096 804 804 525 552 279 0.0% 0.0% 10.0% 10.0% 80 0 0 Hourly Wage Benefits Profit Sharing % Annual Raise Current Contract $ 25.53 $2,500 2.0% 5.0% Labor Demands $ 28.08 $2,750 2.2% 5.5% Negotiation Postion Starting Ceiling $25.53 $ 28.0B $ 2,500 $ 2,750 2.0% 2.2% 5.0% 5.5% 252 Contract Expiration: 1-Oct-2024 Needed Complement Complement % Complement 1st 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 140 $0 $ 0 0 0 100.0% 100.0% $80 $0 $0 $80 CAPSIM Decisions Proformas File Undo Finance Inquirer Help AT LAVEDATNI 15. MEST Llabilities & Owner's Equlty Cormon Stock $0 $0 Retired Earnings Long Term Delt 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) Rotire Stock (5000) Dividend Per Share 2,051 $ 95.81 $ 12.28 $ 39,301 Current Det Accounts Pay $ 0 $9,825 0 $ Long Term Debt "Retire Long Term Debt (5000) Issue Long Term Debt (5000) "Long Term Interest Rate Maximum Issue This Year $ $ 0.00 11.4% $ 14,722 30 30 AVR Lag (days) A/P Lao (days) 10.0% $ 15,717 0 CURRENT DEBT Interest Rate Due This Year Borrow (5000) CASH POSITIONS December 31, 2019 December 31, 2020 $ 32,442 $ 41,696 Outstanding Bonds Series Number 13.552021 11.252026 11.952027 Face Amount $0 $ 11,300 $ 8,83 $7,072 Current Yield 13.0% 11.3% 11.6% 2019 "Close $ 103.58 $99.07 $ 102.54 TQM Initiative CAFT SAVED AY NY2929 19 VEST Process Management Initiatives Projected Impact Budget (5000) $ 0 Total Current Expenditures ($000): $0 CPI Systems Vendor/JIT Quality Initiative Training Channel Support Systems Concurrent Engineering UNEP Green Programs $ $ $ PROJECTED CUMULATIVE IMPACTS Material Cost Reduction Labor Cost Reduction Reduction R&D Cycle Time Reduction in Admin Costs Demand increase Worst Case 0.0% 0.0% 0.0% 0.0% 0.0% Best Case 0.0% 0.0% 0.0% 0.0% 0.0% TON INITIATIVES Benchmarking Quality Function Deployment Effort CCE/6 Sigma Training GEMI TOEM Sustainability Initiatives $ $ $ $ 0 0 0 0 Reduction in Cost of Gada For the Year Just Ended Admin Cost Reductions For the Year Just Ended 09 R&D Cycle Time Reductions For the Year Just Ended 0% Demand Increase For the Year Just Ended 0 204 109 Andrews Andrews Andrews Baldw Baldwin Badw Chester Chester Chester Doby Dy Digby des Chester Oy NA NA 0.0 0.0 0.0 0.0 Products RAD DECISION Performance Isine MTOF Istice Promo Budget Sales Bolo Your Sales Forecast Scheduled Production Capacity Change Automation Rating Ark 13_2 92 26000 $42.00 $ 1,200 $1,000 0 750 0 4.0 Alle 5.7 14.5 20000 $26.00 $1,200 $2,000 0 2,150 0 6,0 Acre 8.4 11.8 22000 $ 32.00 $ 1,200 $1,000 0 1,800 0 5.0 Awe 11.1 22 24000 $ 40,00 $ 1,200 $1,000 0 950 0 40 NA 0.0 0.0 0 $ 0.00 $0 $0 NA 0.0 0.0 0 $ 0.00 $0 $0 0 0 0 0.0 $ 0.00 $0 $0 $ 0.00 $0 0 0 0 0 0.0 0.0 Ceiling Finances Stock ISSUE Stock Retire Dresden Per Share Short Term Debt Bond Retre Bond Issue AR Policy AP Policy $0 $0 $ 0.00 $0 50 $0 30 30 Human Resources LABOR NEGOTIATIONS Wages Benefits Profit Sharing Annual Wage Increase Coffplement Recruiting Spend Training Hours Starting $25.53 $2500 2.09 5.0% 804 $0 0 $28.08 $2750 2.29 5.5% TQM Vendor/JIT QIT CSS CE Benchmark QFDE CCE/6 UNEPGreen GEMETQEM OOOOOOOOO 0

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

M: Finance

Authors: Marcia Cornett, Troy Adair, John Nofsinger

5th Edition

1260772357, 9781260772357

More Books

Students also viewed these Finance questions

Question

Why should an employer be concerned about negligent hiring?

Answered: 1 week ago

Question

What are the various methods of interviewing? Define each.

Answered: 1 week ago