-10 Jx B C D E F G H | J K L M N A...

Transcribed Image Text:

-10 Jx B C D E F G H | J K L M N A Coopie Awards would like to do some deeper analysis based on unit sold and is asking you to complete a flexible budget based on 40,000, 45,000, and 50,000 brass plaques sold. Complete the template below to complet Note: this is based on units sold not units produced like you did in the previous budgets which is why your numbers do not match for 45,000 units. Selling and administrative costs are calculated by taking selling and administrative costs for 45,000 units and dividing by 45,000 to get a cost per unit and then multiplying by units budgeted to be sold Overhead costs are calculated by taking overhead costs for 45,000 units and dividing by 45,000 to get a cost per unit and then multiplying by units budgeted to be sold Budget based on 40000 units Budget based on Budget based 45000 units on 50000 units Sales Revenue $ 1,575,000 3 Direct Materials costs $ 518,400 O Direct Labor Costs S 99,000 O Overhead Costs $ 126,000 1 Gross Margin $ 743,400 2 Selling and administrative cost $ 729,550 8 operating income $ 102,050 4 5 5 7 eady > Selling and Admin Budget Income Statement Flexible Budget + Accessibility: Investigate q + 100% -10 Jx B C D E F G H | J K L M N A Coopie Awards would like to do some deeper analysis based on unit sold and is asking you to complete a flexible budget based on 40,000, 45,000, and 50,000 brass plaques sold. Complete the template below to complet Note: this is based on units sold not units produced like you did in the previous budgets which is why your numbers do not match for 45,000 units. Selling and administrative costs are calculated by taking selling and administrative costs for 45,000 units and dividing by 45,000 to get a cost per unit and then multiplying by units budgeted to be sold Overhead costs are calculated by taking overhead costs for 45,000 units and dividing by 45,000 to get a cost per unit and then multiplying by units budgeted to be sold Budget based on 40000 units Budget based on Budget based 45000 units on 50000 units Sales Revenue $ 1,575,000 3 Direct Materials costs $ 518,400 O Direct Labor Costs S 99,000 O Overhead Costs $ 126,000 1 Gross Margin $ 743,400 2 Selling and administrative cost $ 729,550 8 operating income $ 102,050 4 5 5 7 eady > Selling and Admin Budget Income Statement Flexible Budget + Accessibility: Investigate q + 100%