90.2K

Verified Solution

Link Copied!

1.Using Sales Budget Provided, please answer questions.

Fashion Boutique. Sales Budget For Year Ending Dec 31st 2021 Year Product Unit Sales Volume Unit Selling Price Sales Revenue 2020 Best Selling Dress 100,000 $800 80,000,000 2021 Best Selling Dress 130,000 $700 91,000,000 2) Prepare a Production Budget. a) b) c) Use year 2021 Sales Units. Beginning inventory should be at least 10% of your year 2020 sales units. Ending inventory should be at least 10% of your year 2021 sales units. 3) Prepare one Direct Materials (DM) Purchases Budget. a) Keep it simple; 1 type of material is good. b) DM Budget Assumptions: i) ii) iii) iv) Use year 2021 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) i) ii) iii) Determine additional Budget Assumptions: Direct Materials (DM): Use product specifications from your DM Budget (step 3). Direct Labor (DL): Determine DL hours per product unit, and average 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. How much does it cost to manufacture each unit of your product? Show calculation, please. b) 5) Prepare a Budgeted Income Statement for 2021. (use format Exhibit 8, text pg. 212). Additional Budget Assumptions: i) ii) iii) Use product units and Sales Revenue from you Sales Revenue Budget (step 1). Use Average Variable Cost per product unit from step 4 above. Determine fixed Selling and Admin cost for the year 2021. Please budget a Net Income (profit) for the year 2021. No losses, please. 6) CVP Analysis; Use your Income Statement from Part 5 to calculate: a) b) c) d) Break-even Sales Units (round to nearest unit). Break-even Sales Revenue (round to nearest $). Margin of Safety percentage at your Budget Net Income. Calculate the units needed to be produced and sold to achieve a Net Income that is 50% higher than your budgeted Net Income. 7) Make up some actual product variable costs incurred in 2021 with details. >Suggestion: Make actual product units produced equal your Sales Budget units. >Example; actual cost details for 12,000 actual product units (DO NOT USE THESE NUMBERS): Total Variable Cost >DM used (total) 3,120,000 kg x DM cost per kg: $1.08 $3,369,600 >DL used (total): 14,600 hours x DL cost per hour: $21.10 308,060 >Variable FO cost incurred (total) 222,340 >Total Variable Cost $3,900,000 actual variable cost per product unit ($3,900,000/12,000): $325 8) Use budget data and actual cost data (step 7) to calculate variances (variance analysis): (show all calculations and indicate "F" favorable or "U" unfavorable with your answers) a) Total variable cost variance (total actual 2021 variable cost-total 2021 budget variable b) DM price variance c) DM quantity variance d) DM cost variance e) DL rate variance f) DL time variance g) DL cost variance h) Total variable FO variance 9) Briefly explain how you can use the variance analysis (step 8) above to control costs and improve your company's performance. Fashion Boutique. Sales Budget For Year Ending Dec 31st 2021 Year Product Unit Sales Volume Unit Selling Price Sales Revenue 2020 Best Selling Dress 100,000 $800 80,000,000 2021 Best Selling Dress 130,000 $700 91,000,000 2) Prepare a Production Budget. a) b) c) Use year 2021 Sales Units. Beginning inventory should be at least 10% of your year 2020 sales units. Ending inventory should be at least 10% of your year 2021 sales units. 3) Prepare one Direct Materials (DM) Purchases Budget. a) Keep it simple; 1 type of material is good. b) DM Budget Assumptions: i) ii) iii) iv) Use year 2021 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) i) ii) iii) Determine additional Budget Assumptions: Direct Materials (DM): Use product specifications from your DM Budget (step 3). Direct Labor (DL): Determine DL hours per product unit, and average 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. How much does it cost to manufacture each unit of your product? Show calculation, please. b) 5) Prepare a Budgeted Income Statement for 2021. (use format Exhibit 8, text pg. 212). Additional Budget Assumptions: i) ii) iii) Use product units and Sales Revenue from you Sales Revenue Budget (step 1). Use Average Variable Cost per product unit from step 4 above. Determine fixed Selling and Admin cost for the year 2021. Please budget a Net Income (profit) for the year 2021. No losses, please. 6) CVP Analysis; Use your Income Statement from Part 5 to calculate: a) b) c) d) Break-even Sales Units (round to nearest unit). Break-even Sales Revenue (round to nearest $). Margin of Safety percentage at your Budget Net Income. Calculate the units needed to be produced and sold to achieve a Net Income that is 50% higher than your budgeted Net Income. 7) Make up some actual product variable costs incurred in 2021 with details. >Suggestion: Make actual product units produced equal your Sales Budget units. >Example; actual cost details for 12,000 actual product units (DO NOT USE THESE NUMBERS): Total Variable Cost >DM used (total) 3,120,000 kg x DM cost per kg: $1.08 $3,369,600 >DL used (total): 14,600 hours x DL cost per hour: $21.10 308,060 >Variable FO cost incurred (total) 222,340 >Total Variable Cost $3,900,000 actual variable cost per product unit ($3,900,000/12,000): $325 8) Use budget data and actual cost data (step 7) to calculate variances (variance analysis): (show all calculations and indicate "F" favorable or "U" unfavorable with your answers) a) Total variable cost variance (total actual 2021 variable cost-total 2021 budget variable b) DM price variance c) DM quantity variance d) DM cost variance e) DL rate variance f) DL time variance g) DL cost variance h) Total variable FO variance 9) Briefly explain how you can use the variance analysis (step 8) above to control costs and improve your company's performance

Answer & Explanation Solved by verified expert

See Answer