Business & Finance HOMEWORK

profileRVP2021
MBA610module2ASSIGNMENT5TEMPLATEProductPlanningBudget.xlsx

Sheet1

Product Planning Budget
Budget CR 1 CR 2 CR 3 CR 4 CR 5 CR 6 CR 7 CR 8
Decision/Forecast Decision/Forecast Decision/Forecast Decision/Forecast Decision/Forecast Decision/Forecast Decision/Forecast Decision/Forecast
$ Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A Product 1 Product 2 Product 3 Product 4 Product 5 N/A N/A N/A
Product Decisions
Richard C Thompson: Richard C Thompson: At the minimum, walk out your product decisions for all 8 competition rounds. Do take a look at HR and financing and decide if you anticipate change in those areas. During the course, revisit this budget page and compare your planned decisions against actual results.
ProductName Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape Able Acre Adam Aft Agape
Performance 5.5 3.0 8.0 9.4 4.0
Size 14.5 17 12 15.5 11
MTBFrdSpec (End State) 17,500 14,000 23,000 25,000 19,000
Price $ 28.00 $ 21.00 $ 38.00 $ 33.00 $ 33.00
PromoBudget $ - 0 $ 1,000,000.00 $ 900,000.00 $ 800,000.00 $ 700,000.00 $ 700,000.00
SalesBudget $ - 0 $ 1,000,000.00 $ 900,000.00 $ 800,000.00 $ 700,000.00 $ 700,000.00
UnitSalesForecast $ - 0 0 0 0 0 0
ProductionOrdered 1,200,000 1,820,000 410,000 440,000 380
CapacityChange 0 0 0 0 0
AutomationNextRound 4 5 3 3 3
TQM $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Research & Development $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Finance Decisions Finance Decisions Finance Decisions Finance Decisions Finance Decisions Finance Decisions Finance Decisions Finance Decisions Finance Decisions
FinanceFunction StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP StIssue StRetire Dividend ShortDebt BondRetire BondIssue AR AP
FinanceDecisions 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30 0 0 0 0 0 0 30 30
HR Decisions HR Decisions HR Decisions HR Decisions HR Decisions HR Decisions HR Decisions HR Decisions HR Decisions
Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs Complement RecrSpend TrainHrs
701 0 0 701 0 0 701 0 0 701 0 0 701 0 0 701 0 0 701 0 0 701 0 0 701 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0