Note: Make up your own numbers; No copies. Show all calculations, please. Operating Budget Management needs to issue a budget and profit forecast for 2021, and use it to evaluate actual 2021 Operating results 1) Prepare a Sales Revenue Budget a) Keep it simple; 1 product is good. b) Include unit sales volume, unit price, and total sales revenue 21 Prepare a Production Budget a) Use 2021 Sales Units. b) Determine beginning and ending inventory assumptions. 3) Prepare one Direct Materials (DM) Purchases Budget. a) Keep it simple 1 type of material is good. b) DM Budget Assumptions: 0 Use product units from the Production Budget (step 2). Determine ending Materials inventory on Dec. 31, 2021. Determine Beginning Materials inventory on Jan 1, 2021. Determine DM quantity per product unit Example: pounds (lbs) or kilograms (kg) Determine average DM cost per pound, kilogram, etc. 4 Calculate Average Budgeted Total Variable Cost per product unit (Standard Cost). a) Determine additional Budget Assumptions: o Direct Materials (DM): Use product specifications from your DM Budget (step 3). a) Direct Labor (DL): Determine DL hours per product unit, and average DL rate per hour. Factory Overhead (FOJ: Make up a predetermined Factory Overhead Rate, and use it to apply FO cost to each unit of your product b) How much does it cost to manufacture each unit of your product? Show calculation, please 5) Prepare a Budgeted Income Statement for 2021 (use format Exhibit & text pg. 212). Additional Budget Assumptions: Use product units and Sales Revenue from your Sales Revenue Budget (step 1). #) Use Average Variable Cost per product unit from step 4 above. 1) Determine fixed Selling and Admin cost for 2021. Please budget a Net Income (profit) for 2021. No losses, please 6 CVP Analysis: Use your Income Statement from Part 5 to calculate a) Break-even Sales Units (round to nearest unit) b) Break-even Sales Revenue fround to nearest 5). c) Margin of Safety percentage at your Budget Net Income. d) How many units need to be produced and sold to achieve a Net Income that is 50% higher than your budgeted Net Income? Note: Make up your own numbers; No copies. Show all calculations, please. Operating Budget Management needs to issue a budget and profit forecast for 2021, and use it to evaluate actu2021 operating results 1) Prepare a Sales Revenue Budget a) Keep it simple: 1 product is good. b) Include unit sales volume, unit price, and total sales revence 2) Prepare a Production Budget a) Use 2021 Sales Units. b) Determine beginning and ending inventory assumptions Prepare one Direct Materials (DM) Purchases Budget a) Keep it simple: 1 type of material is good. DM Budget Assumptions: 3) b) 0) Use product units from the Production Budget (step 2 Determine ending Materials inventory on Dec. 31, 2021 *) Determine Beginning Materials inventory on Jan 1, 2021 Determine DM quantity per product unit Example: pounds lbs) or kilograms (kg) Determine average DM cost per pound, kilogram,etc 4) Calculate Average Budgeted Total Variable Cost per product unit (Standard Costi. a) Determine additional Budget Assumptions: 0 Direct Materials (DM): Use product Specifications from your Budget (step 3) ) Direct Labor (DL: Determine DL hours per product unit and everage DL rate per hour. Factory Overhead (FO): Make up a Predetermined Factory Overhead Rate and use it to apply FO cost to each unit of your product b) How much does it cost to manufacture each unit of your product? Show calculation, please 5) Prepare a Budgeted Income Statement for 2021 (use format Exhibit 8 text pg 212) Additional Budget Assumptions: 0 Use product units and Sales Revenue from your Sales Revenue Budget (step). Use Average Variable Cost per product unit from step 4 above Determine fixed Selling and Admin cost for 2021. IV) Please budget a Net Income (profit) for 2021. No losses, please a) b) c) d) CVP Analysis: Use your Income Statement from Part 5 to calculate Break-even Sales Units round to nearest unit). Break-even Sales Revenue (round to nearest) Margin of Safety percentage at your Budget Net Income How many units need to be produced and sold to achieve a Net Income that is 50% higher than your budgeted Net Income? Note: Make up your own numbers; No copies. Show all calculations, please. Operating Budget Management needs to issue a budget and profit forecast for 2021, and use it to evaluate actual 2021 Operating results 1) Prepare a Sales Revenue Budget a) Keep it simple; 1 product is good. b) Include unit sales volume, unit price, and total sales revenue 21 Prepare a Production Budget a) Use 2021 Sales Units. b) Determine beginning and ending inventory assumptions. 3) Prepare one Direct Materials (DM) Purchases Budget. a) Keep it simple 1 type of material is good. b) DM Budget Assumptions: 0 Use product units from the Production Budget (step 2). Determine ending Materials inventory on Dec. 31, 2021. Determine Beginning Materials inventory on Jan 1, 2021. Determine DM quantity per product unit Example: pounds (lbs) or kilograms (kg) Determine average DM cost per pound, kilogram, etc. 4 Calculate Average Budgeted Total Variable Cost per product unit (Standard Cost). a) Determine additional Budget Assumptions: o Direct Materials (DM): Use product specifications from your DM Budget (step 3). a) Direct Labor (DL): Determine DL hours per product unit, and average DL rate per hour. Factory Overhead (FOJ: Make up a predetermined Factory Overhead Rate, and use it to apply FO cost to each unit of your product b) How much does it cost to manufacture each unit of your product? Show calculation, please 5) Prepare a Budgeted Income Statement for 2021 (use format Exhibit & text pg. 212). Additional Budget Assumptions: Use product units and Sales Revenue from your Sales Revenue Budget (step 1). #) Use Average Variable Cost per product unit from step 4 above. 1) Determine fixed Selling and Admin cost for 2021. Please budget a Net Income (profit) for 2021. No losses, please 6 CVP Analysis: Use your Income Statement from Part 5 to calculate a) Break-even Sales Units (round to nearest unit) b) Break-even Sales Revenue fround to nearest 5). c) Margin of Safety percentage at your Budget Net Income. d) How many units need to be produced and sold to achieve a Net Income that is 50% higher than your budgeted Net Income? Note: Make up your own numbers; No copies. Show all calculations, please. Operating Budget Management needs to issue a budget and profit forecast for 2021, and use it to evaluate actu2021 operating results 1) Prepare a Sales Revenue Budget a) Keep it simple: 1 product is good. b) Include unit sales volume, unit price, and total sales revence 2) Prepare a Production Budget a) Use 2021 Sales Units. b) Determine beginning and ending inventory assumptions Prepare one Direct Materials (DM) Purchases Budget a) Keep it simple: 1 type of material is good. DM Budget Assumptions: 3) b) 0) Use product units from the Production Budget (step 2 Determine ending Materials inventory on Dec. 31, 2021 *) Determine Beginning Materials inventory on Jan 1, 2021 Determine DM quantity per product unit Example: pounds lbs) or kilograms (kg) Determine average DM cost per pound, kilogram,etc 4) Calculate Average Budgeted Total Variable Cost per product unit (Standard Costi. a) Determine additional Budget Assumptions: 0 Direct Materials (DM): Use product Specifications from your Budget (step 3) ) Direct Labor (DL: Determine DL hours per product unit and everage DL rate per hour. Factory Overhead (FO): Make up a Predetermined Factory Overhead Rate and use it to apply FO cost to each unit of your product b) How much does it cost to manufacture each unit of your product? Show calculation, please 5) Prepare a Budgeted Income Statement for 2021 (use format Exhibit 8 text pg 212) Additional Budget Assumptions: 0 Use product units and Sales Revenue from your Sales Revenue Budget (step). Use Average Variable Cost per product unit from step 4 above Determine fixed Selling and Admin cost for 2021. IV) Please budget a Net Income (profit) for 2021. No losses, please a) b) c) d) CVP Analysis: Use your Income Statement from Part 5 to calculate Break-even Sales Units round to nearest unit). Break-even Sales Revenue (round to nearest) Margin of Safety percentage at your Budget Net Income How many units need to be produced and sold to achieve a Net Income that is 50% higher than your budgeted Net Income