Module 5 Assignment 1-Word References Mailings Review View Acrobat Tell me what you w Corning Classification (Requir Non-Corning Public Restricted -Personal Data Styles Editing Share Upload Call Styles Box Click To Call Corning Classi show all of your work for all problems (can be formulas entered into Excel) the following information, create a line item budget showing the areas of Sales and M rch and Development, and Administrative for Globex Corp. Project your budget out fo ts should be broken down by each area (aka department) and reflect the total for eadl tment. It is suggested that you use a spreadsheet to complete this assignment. The fiscal year for Globex Corp. runs from January 1t through December 31 year. Commissions are estimated to be at 10% of sales for Q1, 1 There are no promotions anticipated for this department. and $500,000, respectively. (Q1-04) are fixed at $40,000 per year Salaries and wages for the marketing and sales department are a fixed cost of $300,0 . 5% for Q2, 25% for Q for Q4 based on past data and incentive programs. Payroll taxes are figured at 8.4% a 3. The company anticipates that sales each quarter will be $1.5 million, $2.3 million, $2.9 4. Office expenses for both the marketing and sales department and research and develo S. The marketing and sales department has an overall advertising budget of $500,000 per Advertising expenses follow the same percentage breakdown as commission paid for ea quarter 6. The marketing and sales department has an overall travel budget of $100,000 annually Managers are allowed to determine how that budget will be distributed over the course year A category of "other" expenses is included in each departments budget, for an Module 5 Assignment 1-Word References Mailings Review View Acrobat Tell me what you w Corning Classification (Requir Non-Corning Public Restricted -Personal Data Styles Editing Share Upload Call Styles Box Click To Call Corning Classi show all of your work for all problems (can be formulas entered into Excel) the following information, create a line item budget showing the areas of Sales and M rch and Development, and Administrative for Globex Corp. Project your budget out fo ts should be broken down by each area (aka department) and reflect the total for eadl tment. It is suggested that you use a spreadsheet to complete this assignment. The fiscal year for Globex Corp. runs from January 1t through December 31 year. Commissions are estimated to be at 10% of sales for Q1, 1 There are no promotions anticipated for this department. and $500,000, respectively. (Q1-04) are fixed at $40,000 per year Salaries and wages for the marketing and sales department are a fixed cost of $300,0 . 5% for Q2, 25% for Q for Q4 based on past data and incentive programs. Payroll taxes are figured at 8.4% a 3. The company anticipates that sales each quarter will be $1.5 million, $2.3 million, $2.9 4. Office expenses for both the marketing and sales department and research and develo S. The marketing and sales department has an overall advertising budget of $500,000 per Advertising expenses follow the same percentage breakdown as commission paid for ea quarter 6. The marketing and sales department has an overall travel budget of $100,000 annually Managers are allowed to determine how that budget will be distributed over the course year A category of "other" expenses is included in each departments budget, for an