manufacturing overhead is 90,000.

Tice update to keep up-to-date with secur updates, Tixes, and improvements, choose check for updates Name Box fx (you fill in) A B D E F G 1 2 3 PROJECT 1: MASTER BUDGET 4. 5 The real-world (this company is in the northwest suburbs of Chicago) scenario: 6 Your company assembles wire (light-metal) closet Shelving units at a manufacturing facility and 7 ships them to home builders and chain "big box" do-it-yourself stores. 8 9 It is October, 2021 and you, the budget manager, 10 just received an e-mail from the CFO, asking you to put together a 2022 budget. 11 12 The projected (because the year is not yet over) 2021 financial information is below. 13 There are three items for you to complete by filling in the applicable personalized information. 14 Then you need to prepare a 2022 budget by filling in the 2022 boxes below and submitting to the CFO. 16 So how to get that done? 17 For a successful Master Budget, you would seek information and input from your company's: 18 Sales Manager 19 Production Manager 20 Administration Manager 21 This information (reflecting some real-world vagueness and uncertainty) is in the detail further below: 22 2021 Projected 2022 Budget 23 Sales $ 2,400,000 2,212,500 24 25 Production Costs: 26 Direct Material 630,000 655,875 27 Direct Labor 420,000 397,500 28 Manufacturing Overhead 90.000 94.50010 Proiect 1 Master Budaet A B D E F G 27 Direct Labor 420,000 397,500|hc 28 Manufacturing Overhead 90,000 94,500 ch 29 30 Other Expenses: Di 31 Sales commissions 480,000 442,500 32 Office/Mgmt. Salaries 325,000 B3 Rent 156,000 34 Utilities 9,000 B5 Supplies 25,000 36 All Other 60,000 B7 88 Total costs and expenses 2,195,000 39 10 Net Income (you fill in) 11 12 Budget input from key personnel: 13 14 SALES MANAGER 15 16 The Sales Manager is in charge of sales of wire shelving in linear feet (the key metric for this business).. 17 She solicits and receive orders from home builders and chain stores 18 Project 1 Master Budget + Ready A B D E F G 5 The Sales Manager is in charge of sales of wire shelving in linear feet (the key metric for this business).. 7 She solicits and receive orders from home builders and chain stores 8 9 The following is projected sales data for (full year) 2021: 1 150,000 linear feet to the home builders market at a sales price of $10 per linear foot. 2 60,000 linear feet to the chain store market at a sales price of $15 per linear foot. 3 Name Box 4 In 2022, the home build expected to improve ("a little") over 2021 5 5 However, COVID-19 had a favorable impact on the chain store market as more people 7 had more time to work on home improvement projects in 2020 and 2021. This is expected to B "decline significantly" in 2022 as people are tired of being at home and home improvement projects!. 2 Sales prices (what is charged to the customers) per linear foot are planned to remain the same in 2022. 1 2 Salespersons are compensated fully on commission (and the 2022 commission rate is the same as 2021). 3 4 PRODUCTION MANAGER 5 5 The production manager in charge of assembly of these units in the assembly 7 facility adjacent to the office. 3 Production at the company facility is based on the assembly of the shelving by the linear foot. You assemble what you need to fill orders, since there is no space for unsold inventory. 1 2 The production manager is also responsible for procurement of the raw materials (metal). 3 You currently pay at a rate of $3 per linear foot, but your supplier is planning a price increase. 4 5 The production manager is also responsible for the assemblers that she directly supervises. 5 They are paid by production at $2 per linear foot. 7 3 The production manager earns an annual salary (which is the entire manufacturing overhead). Project 1 Master Budget + Ready JX A B D E F G Patty: The production manager earns an annual salary (which is the entire manufacturing overhead). That salary (unique to each student in the class, evidently some are more generous than others!) is as follows: Kassie: $53,000 John: $55,000 Aidan: $57,000 Mike: $60,000 Christian: $62,000 Sakai: $64,000 Maggie: $66,000 $68,000 Will H. $70,000 Tori: $72,000 Amber: $74,000 William M. $76,000 Marko: $78,000 Jen: $80,000 Hannah: $81,000 Natalia: $82,000 Angela: $84,000 Awilda: $85,000 Roberto: $86,000 Melissa: $88,000 Marcus: $89,000 Jonathon: $90,000 B Sean: $92,000 Jes: $95,000 However, in each of the salary scenarios above, the production manager wants a raise next year! Reminder: direct material and direct labor are both variable costs - An appropriate budget would be based on expected cost per linear foot produced. Project 1 Master Budget + A B D E F G 11 12 ADMINISTRATION MANAGER 13 14 15 The administration manager is in charge of basically everything at your facility except sales 16 and production. 17 18 A few of the issues she is working on include: 19 20 Negotiating with the landlord - your lease is up in December and she wants to increase the rent. 21 22 Hiring an administrative assistant to help implement the new accounts payable software. 23 24 Dealing with increase worker's comp insurance (in "Other") due to an "accident". 25 26 27 PROJECT 1 REQUIREMENTS: 28 29 Using either this Excel document or separate format (for example, a Word document, but NOT Google Docs or ".numbers"!) 30 prepare a 2022 Master Budget by completing where applicable for 2021 and then filling in the boxes as applicable for 2022. 31 32 In addition, provide a 200-300 word description 33 (either within the same document or a separate document such as Word, or in "Write Submission" tab/area, your choice!) 34 that specifies how you determined the 2022 Sales Budget (for each of the two markets) and the assumptions, 35 as well as how you determined the numbers for all of the costs and expenses budgeted for 2022. 36 In other words, clearly show how you arrived at all of the numbers that you entered into the 2022 boxes, do NOT make 37 instructor (or in the future, your supervisor, company controller or CFO) go on an analytical safari to try to figure it out! 38 (Frustrated CFOs who need further explanations on budget numbers is common at this time of year!) 39 If using an Excel document, please make it in an easily printable (watch margin settings, etc.) format. 40 41 Submit as appropriate on Blackboard ("saving" your documents just in case is also recommended!) 42 no later than Wednesday, March 24 at 11:59 PM (NO extensions will be granted, a 0 score if missed) 43 Do NOT email it! And be sure to not "submit" until truly ready to submit! 44 45 46 PROJECT 1 SCORING/GRADING: Project 1 Master Budget + Tice update to keep up-to-date with secur updates, Tixes, and improvements, choose check for updates Name Box fx (you fill in) A B D E F G 1 2 3 PROJECT 1: MASTER BUDGET 4. 5 The real-world (this company is in the northwest suburbs of Chicago) scenario: 6 Your company assembles wire (light-metal) closet Shelving units at a manufacturing facility and 7 ships them to home builders and chain "big box" do-it-yourself stores. 8 9 It is October, 2021 and you, the budget manager, 10 just received an e-mail from the CFO, asking you to put together a 2022 budget. 11 12 The projected (because the year is not yet over) 2021 financial information is below. 13 There are three items for you to complete by filling in the applicable personalized information. 14 Then you need to prepare a 2022 budget by filling in the 2022 boxes below and submitting to the CFO. 16 So how to get that done? 17 For a successful Master Budget, you would seek information and input from your company's: 18 Sales Manager 19 Production Manager 20 Administration Manager 21 This information (reflecting some real-world vagueness and uncertainty) is in the detail further below: 22 2021 Projected 2022 Budget 23 Sales $ 2,400,000 2,212,500 24 25 Production Costs: 26 Direct Material 630,000 655,875 27 Direct Labor 420,000 397,500 28 Manufacturing Overhead 90.000 94.50010 Proiect 1 Master Budaet A B D E F G 27 Direct Labor 420,000 397,500|hc 28 Manufacturing Overhead 90,000 94,500 ch 29 30 Other Expenses: Di 31 Sales commissions 480,000 442,500 32 Office/Mgmt. Salaries 325,000 B3 Rent 156,000 34 Utilities 9,000 B5 Supplies 25,000 36 All Other 60,000 B7 88 Total costs and expenses 2,195,000 39 10 Net Income (you fill in) 11 12 Budget input from key personnel: 13 14 SALES MANAGER 15 16 The Sales Manager is in charge of sales of wire shelving in linear feet (the key metric for this business).. 17 She solicits and receive orders from home builders and chain stores 18 Project 1 Master Budget + Ready A B D E F G 5 The Sales Manager is in charge of sales of wire shelving in linear feet (the key metric for this business).. 7 She solicits and receive orders from home builders and chain stores 8 9 The following is projected sales data for (full year) 2021: 1 150,000 linear feet to the home builders market at a sales price of $10 per linear foot. 2 60,000 linear feet to the chain store market at a sales price of $15 per linear foot. 3 Name Box 4 In 2022, the home build expected to improve ("a little") over 2021 5 5 However, COVID-19 had a favorable impact on the chain store market as more people 7 had more time to work on home improvement projects in 2020 and 2021. This is expected to B "decline significantly" in 2022 as people are tired of being at home and home improvement projects!. 2 Sales prices (what is charged to the customers) per linear foot are planned to remain the same in 2022. 1 2 Salespersons are compensated fully on commission (and the 2022 commission rate is the same as 2021). 3 4 PRODUCTION MANAGER 5 5 The production manager in charge of assembly of these units in the assembly 7 facility adjacent to the office. 3 Production at the company facility is based on the assembly of the shelving by the linear foot. You assemble what you need to fill orders, since there is no space for unsold inventory. 1 2 The production manager is also responsible for procurement of the raw materials (metal). 3 You currently pay at a rate of $3 per linear foot, but your supplier is planning a price increase. 4 5 The production manager is also responsible for the assemblers that she directly supervises. 5 They are paid by production at $2 per linear foot. 7 3 The production manager earns an annual salary (which is the entire manufacturing overhead). Project 1 Master Budget + Ready JX A B D E F G Patty: The production manager earns an annual salary (which is the entire manufacturing overhead). That salary (unique to each student in the class, evidently some are more generous than others!) is as follows: Kassie: $53,000 John: $55,000 Aidan: $57,000 Mike: $60,000 Christian: $62,000 Sakai: $64,000 Maggie: $66,000 $68,000 Will H. $70,000 Tori: $72,000 Amber: $74,000 William M. $76,000 Marko: $78,000 Jen: $80,000 Hannah: $81,000 Natalia: $82,000 Angela: $84,000 Awilda: $85,000 Roberto: $86,000 Melissa: $88,000 Marcus: $89,000 Jonathon: $90,000 B Sean: $92,000 Jes: $95,000 However, in each of the salary scenarios above, the production manager wants a raise next year! Reminder: direct material and direct labor are both variable costs - An appropriate budget would be based on expected cost per linear foot produced. Project 1 Master Budget + A B D E F G 11 12 ADMINISTRATION MANAGER 13 14 15 The administration manager is in charge of basically everything at your facility except sales 16 and production. 17 18 A few of the issues she is working on include: 19 20 Negotiating with the landlord - your lease is up in December and she wants to increase the rent. 21 22 Hiring an administrative assistant to help implement the new accounts payable software. 23 24 Dealing with increase worker's comp insurance (in "Other") due to an "accident". 25 26 27 PROJECT 1 REQUIREMENTS: 28 29 Using either this Excel document or separate format (for example, a Word document, but NOT Google Docs or ".numbers"!) 30 prepare a 2022 Master Budget by completing where applicable for 2021 and then filling in the boxes as applicable for 2022. 31 32 In addition, provide a 200-300 word description 33 (either within the same document or a separate document such as Word, or in "Write Submission" tab/area, your choice!) 34 that specifies how you determined the 2022 Sales Budget (for each of the two markets) and the assumptions, 35 as well as how you determined the numbers for all of the costs and expenses budgeted for 2022. 36 In other words, clearly show how you arrived at all of the numbers that you entered into the 2022 boxes, do NOT make 37 instructor (or in the future, your supervisor, company controller or CFO) go on an analytical safari to try to figure it out! 38 (Frustrated CFOs who need further explanations on budget numbers is common at this time of year!) 39 If using an Excel document, please make it in an easily printable (watch margin settings, etc.) format. 40 41 Submit as appropriate on Blackboard ("saving" your documents just in case is also recommended!) 42 no later than Wednesday, March 24 at 11:59 PM (NO extensions will be granted, a 0 score if missed) 43 Do NOT email it! And be sure to not "submit" until truly ready to submit! 44 45 46 PROJECT 1 SCORING/GRADING: Project 1 Master Budget +