Solve all parts of question number 6

CPV BREAKEVEN Total expenses Revenue 45 Total expenses $3,386,000.00 $3,727,000.00 $4,005,000.00 $4,372,000.00 $15,490,000.00 46 Net income $514,000.00 $498,000.00 $545,000.00 $528,000.00 $2,085,000.00 47 48 CPV Analysis Data 49 50 CPV Units Total expense Revenue Fixed Costs 51 QO 0 $110,000.00 $0.00 $110,000.00 $20,000,000.00 52 Q1 1300000 $3,386,000.00 $3,900,000.00 $110,000.00 $18,000,000.00 53 Q2 2600000 $7,732,000.00 $8,125,000.00 $223,000.00 $16,000,000.00 54 Q3 4000000 $11,118,000.00 ############ $336,000.00 $14,000,000.00 55 Q4 5400000 $15,490,000.00 ############ $452,000.00, $12,000,000.00 56 $10,000,000.00 $8,000,000.00 7 6) Answers $6,000,000.00 58 Break-even sales units ? $4,000,000.00 59 Break-even sales revenue ? $2,000,000.00 60 Margin of safety percentage at your budget net income ? $0.00 61 Units needed to be produced and sold to achieve a net incom? 62 63 Actual Variable Costs 01 Q2 Q3 Q4 Annual Total 54 Price per unit of milk to produce (gallons) $1.85 $2.00 $2.00 $2.25 $2.03 65 Direct labor hours per product unit 0.01 0.01 0.01 0.01 0.01 66 Average direct labor rate per hour $21.00 $22.00 $22.00 $23.00 $22.00 0 1300000 2600000 4000000 5400000 CPV BREAKEVEN Total expenses Revenue 45 Total expenses $3,386,000.00 $3,727,000.00 $4,005,000.00 $4,372,000.00 $15,490,000.00 46 Net income $514,000.00 $498,000.00 $545,000.00 $528,000.00 $2,085,000.00 47 48 CPV Analysis Data 49 50 CPV Units Total expense Revenue Fixed Costs 51 QO 0 $110,000.00 $0.00 $110,000.00 $20,000,000.00 52 Q1 1300000 $3,386,000.00 $3,900,000.00 $110,000.00 $18,000,000.00 53 Q2 2600000 $7,732,000.00 $8,125,000.00 $223,000.00 $16,000,000.00 54 Q3 4000000 $11,118,000.00 ############ $336,000.00 $14,000,000.00 55 Q4 5400000 $15,490,000.00 ############ $452,000.00, $12,000,000.00 56 $10,000,000.00 $8,000,000.00 7 6) Answers $6,000,000.00 58 Break-even sales units ? $4,000,000.00 59 Break-even sales revenue ? $2,000,000.00 60 Margin of safety percentage at your budget net income ? $0.00 61 Units needed to be produced and sold to achieve a net incom? 62 63 Actual Variable Costs 01 Q2 Q3 Q4 Annual Total 54 Price per unit of milk to produce (gallons) $1.85 $2.00 $2.00 $2.25 $2.03 65 Direct labor hours per product unit 0.01 0.01 0.01 0.01 0.01 66 Average direct labor rate per hour $21.00 $22.00 $22.00 $23.00 $22.00 0 1300000 2600000 4000000 5400000