help in an attempt to prepare a target profit analysis baded on financial goals and strategys within an excel file
ACCTG 432 TERPSim Budgeting Assignment (36 points) Introduction - Budgeting Budgeting is most useful when it is integrated with a company's strategy, which specifies Also, budgets are an integral part of management control systems. In this assignment, you will develop a sales budget based on your company's strategy (you also need to consider cash flow). Then, you can use this sales budget to investigate any deviations and complete an Excel Variance Chart. Requirements: Part 1 (16 points) 1) Describe your team financial goals (such as ROE & target profit), overall strategy (such as cost leadership or product differentiation, with details) and marketing strategy (including your 4 Ps). Prepare a target profit analysis based on your financial goals and strategy discussed above. Submit your word document & Excel file to Bb in class. Part 2 (20 points) 1) Prepare a sales budget for the ERPSim Advanced Game R1 & R2. Explain how you formulate your sales budget based on your financial goals, target profit analysis and strategy discussed in part 1. The sales budget should be by products, distribution channels & market segments. Submit your word document and Excel file to Blackboard by November 5 midnight. Hints: 1) Your sales budget has 5 components (time, place, products, quantity, price). Make sure you discuss the relationship between your part 1 & part 2 (in other words, how your 5 components D. Ford Die @ L3 Pitsc ins F10 F11 F12 ACCTG 432 TERPSim Budgeting Assignment (36 points) Introduction - Budgeting Budgeting is most useful when it is integrated with a company's strategy, which specifies Also, budgets are an integral part of management control systems. In this assignment, you will develop a sales budget based on your company's strategy (you also need to consider cash flow). Then, you can use this sales budget to investigate any deviations and complete an Excel Variance Chart. Requirements: Part 1 (16 points) 1) Describe your team financial goals (such as ROE & target profit), overall strategy (such as cost leadership or product differentiation, with details) and marketing strategy (including your 4 Ps). Prepare a target profit analysis based on your financial goals and strategy discussed above. Submit your word document & Excel file to Bb in class. Part 2 (20 points) 1) Prepare a sales budget for the ERPSim Advanced Game R1 & R2. Explain how you formulate your sales budget based on your financial goals, target profit analysis and strategy discussed in part 1. The sales budget should be by products, distribution channels & market segments. Submit your word document and Excel file to Blackboard by November 5 midnight. Hints: 1) Your sales budget has 5 components (time, place, products, quantity, price). Make sure you discuss the relationship between your part 1 & part 2 (in other words, how your 5 components D. Ford Die @ L3 Pitsc ins F10 F11 F12