1. Contribution margin per unit for weekly and for monthly subscriptions. Subscription Price Less: Variable costs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Contribution margin per unit for weekly and for monthly subscriptions. Subscription Price Less: Variable costs Contribution margin per subscription 2. Contribution margin ratio (CMR) for weekly and for monthly subscriptions Contribution margin per unit Subscription (selling) price Contribution margin ratio (CMR) 3. HPC's overall breakeven point in sales units and sales dollars. Weekly Monthly $52.00 $20.00 36.4 8.4 $41.90 $13.90 3.5 3.5 $10.10 $6.10 2 2 41.9 13.9 Weekly Monthly $10.10 $6.10 $52.00 $20.00 19.42% 30.50% 0.19 0.31 Breakeven point in units: Fixed costs per year = Weighted average contribution margin per unit Breakeven point in sales units $378,000.00 $7.10 $53,239.44 $2.53 $4.58 $7.10 Breakdown of overall breakeven point: % # Units Weekly Subscriptions Monthly Subscriptions= 25% $13,309.86 75% $39.929.58 Total = 100.00% $53,239.44 Breakeven point in dollars: Weighted-average selling price/unit: Weekly Subscriptions = Monthly Subscriptions= Breakeven ($): Total breakeven unite (subscrintions) Weight $13,309.86 $39,929.58 $53,239.44 Selling Price $52.00 $20.00 Product $692,112.68 $798,591.55 $1,490,704.23 $1 190 701.23. Breakeven ($): Total breakeven units (subscriptions) x Weighted-average selling price per unit Total B/E ($) = Breakeven point in dollars--alternative solution: Breakeven in $ = F + Weighted-average contribution margin ratio Weighted-average contribution margin ratio: $1,490,704.23 $53.239.44 $79,364,253,124.38 Weekly Subscriptions Monthly Subscriptions cm ratio weight product $0.19 $0.31 Breakeven ($) Annual fixed costs Weighted-average contribution margin ratio Annual fixed costs = + Weighted-average contribution margin ratio Breakeven point in total sales dollars = Composition of sales, by product: Sales mix, in terms of dollars: Weekly Subscriptions. Monthly Subscriptions Composition of sales, by product--alternative solution: Product Weekly subscriptions Sales Price Units Dollars Sales Mix % Allocation Fixed Costs per year Variable Costs: 378,000 Mailing $0.70 per issue Commission $3.50 per subscription Administrative $2.00 per subscription Sales Mix (based on # of subscriptions): HPC-Weekly 25% HPC-Monthly 75% Selling Price: HPC-Weekly $52.00 per subscription HPC-Monthly $20.00 per subscription Targeted after-tax profit, as a percent of sales dollars = Income tax rate (average) = 10.00% 30.00% Required 1. Contribution margin per unit for weekly and for monthly subscriptions 2. Contribution margin ratio for weekly and for monthly subscriptions 3 a. HPC's breakeven point in sales units and sales dollars. Use the weighted-average contribution margin approach and show calculations. (Hint: When calculating the weighted-average contribution margin per unit, the weights in the calculation are based on relative units sold. When calculating the weighted-average contribution margin ratio, the weights are based on relative sales dollars, not units, of the individual products.) b. At the overall breakeven point in units, what is the breakeven amount (in units) for each individual product? c. What is the breakeven amount (in sales dollars) for each product? 4. Explain the following quote: "For the multiproduct (or multiservice) firm, there is no breakeven point independent of the sales mix assumption." 5. Prepare a data table for the breakeven volume and percentage change in the breakeven point from the base case (above) for each 1% change in sales mix over for HPC Weekly over the range 20% to 30% 6. What is the required sales level (in units), at the assumed sales mix, to reach a before-tax profit of $75,000? 7. What is the required sales level (in units), at the assumed sales mix, to reach an after-tax profit equal to 10% of sales revenue? (Show calculations.) 8. Prepare the company's Contribution Form Income Statement based on the units in number 7 above. 9. What are the critical success factors for HPC? For its domestic subscribers? For its international subscribers? Breakeven point in dollars--alternative solution: Breakeven in $ F+ Weighted-average contribution margin ratio Weighted-average contribution margin ratio: Weekly Subscriptions Monthly Subscriptions cm ratio weight product $0.19 $0.31 Breakeven ($) = Annual fixed costs + Weighted-average contribution margin ratio Annual fixed costs = + Weighted-average contribution margin ratio Breakeven point in total sales dollars Composition of sales, by product: Sales mix, in terms of dollars: Weekly Subscriptions Monthly Subscriptions Composition of sales, by product--alternative solution: Product Weekly subscriptions Monthly subscriptions Sales Price Units Dollars Sales Mix % Allocation Requirement 4 Data Table: Breakeven Volumes and Percentage Changes in BE Point with changes in sales mix over the range 20% to 30% for HPC Weekly. Sales mix (based on units sold) HPC Weekly HPC Monthly Weighted- avg. CM/unit Weighted-average contribution margin per unit BE (units) B/E % change from base case % Change in Wtd- avg. CM/unit (from base) 6. Required sales (in units) to reach a target before-tax profit of $75,000 for the given sales mix (25%:75%): Targeted before-tax profit target, = Fixed costs (F) = F + TTB = Weighted-average CM per unit = Breakeven point in sales units = Breakdown by Product: Sales of HPC-Weekly (rounded up) Weight 25% 75% Sales of HPC-Monthly 7. Required sales (in units) to reach a targeted after-tax profit = 10% of sales for the given sales mix. Let Q = the required sales volume (in units) to achieve the profit objective B = Total sales - Total variable costs - Total fixed costs (F) (1), where t = Tax rate A (1) Total sales - Total variable costs - F Q = units (rounded up) 8. Prepare the company's Contribution Form Income Statement based on the units in number 7 above. Sales Variable cost Contribution margin 7. Required sales (in units) to reach a targeted after-tax profit = 10% of sales for the given sales mix. Let Q = the required sales volume (in units) to achieve the profit objective B = Total sales - Total variable costs - Total fixed costs (F) (1 t), where t = Tax rate (1) Total sales - Total variable costs - F Q = units (rounded up) 8. Prepare the company's Contribution Form Income Statement based on the units in number 7 above. Sales Variable cost Contribution margin Fixed costs Pre-tax income Income tax Profit after tax Requirement 9 1. Contribution margin per unit for weekly and for monthly subscriptions. Subscription Price Less: Variable costs Contribution margin per subscription 2. Contribution margin ratio (CMR) for weekly and for monthly subscriptions Contribution margin per unit Subscription (selling) price Contribution margin ratio (CMR) 3. HPC's overall breakeven point in sales units and sales dollars. Weekly Monthly $52.00 $20.00 36.4 8.4 $41.90 $13.90 3.5 3.5 $10.10 $6.10 2 2 41.9 13.9 Weekly Monthly $10.10 $6.10 $52.00 $20.00 19.42% 30.50% 0.19 0.31 Breakeven point in units: Fixed costs per year = Weighted average contribution margin per unit Breakeven point in sales units $378,000.00 $7.10 $53,239.44 $2.53 $4.58 $7.10 Breakdown of overall breakeven point: % # Units Weekly Subscriptions Monthly Subscriptions= 25% $13,309.86 75% $39.929.58 Total = 100.00% $53,239.44 Breakeven point in dollars: Weighted-average selling price/unit: Weekly Subscriptions = Monthly Subscriptions= Breakeven ($): Total breakeven unite (subscrintions) Weight $13,309.86 $39,929.58 $53,239.44 Selling Price $52.00 $20.00 Product $692,112.68 $798,591.55 $1,490,704.23 $1 190 701.23. Breakeven ($): Total breakeven units (subscriptions) x Weighted-average selling price per unit Total B/E ($) = Breakeven point in dollars--alternative solution: Breakeven in $ = F + Weighted-average contribution margin ratio Weighted-average contribution margin ratio: $1,490,704.23 $53.239.44 $79,364,253,124.38 Weekly Subscriptions Monthly Subscriptions cm ratio weight product $0.19 $0.31 Breakeven ($) Annual fixed costs Weighted-average contribution margin ratio Annual fixed costs = + Weighted-average contribution margin ratio Breakeven point in total sales dollars = Composition of sales, by product: Sales mix, in terms of dollars: Weekly Subscriptions. Monthly Subscriptions Composition of sales, by product--alternative solution: Product Weekly subscriptions Sales Price Units Dollars Sales Mix % Allocation Fixed Costs per year Variable Costs: 378,000 Mailing $0.70 per issue Commission $3.50 per subscription Administrative $2.00 per subscription Sales Mix (based on # of subscriptions): HPC-Weekly 25% HPC-Monthly 75% Selling Price: HPC-Weekly $52.00 per subscription HPC-Monthly $20.00 per subscription Targeted after-tax profit, as a percent of sales dollars = Income tax rate (average) = 10.00% 30.00% Required 1. Contribution margin per unit for weekly and for monthly subscriptions 2. Contribution margin ratio for weekly and for monthly subscriptions 3 a. HPC's breakeven point in sales units and sales dollars. Use the weighted-average contribution margin approach and show calculations. (Hint: When calculating the weighted-average contribution margin per unit, the weights in the calculation are based on relative units sold. When calculating the weighted-average contribution margin ratio, the weights are based on relative sales dollars, not units, of the individual products.) b. At the overall breakeven point in units, what is the breakeven amount (in units) for each individual product? c. What is the breakeven amount (in sales dollars) for each product? 4. Explain the following quote: "For the multiproduct (or multiservice) firm, there is no breakeven point independent of the sales mix assumption." 5. Prepare a data table for the breakeven volume and percentage change in the breakeven point from the base case (above) for each 1% change in sales mix over for HPC Weekly over the range 20% to 30% 6. What is the required sales level (in units), at the assumed sales mix, to reach a before-tax profit of $75,000? 7. What is the required sales level (in units), at the assumed sales mix, to reach an after-tax profit equal to 10% of sales revenue? (Show calculations.) 8. Prepare the company's Contribution Form Income Statement based on the units in number 7 above. 9. What are the critical success factors for HPC? For its domestic subscribers? For its international subscribers? Breakeven point in dollars--alternative solution: Breakeven in $ F+ Weighted-average contribution margin ratio Weighted-average contribution margin ratio: Weekly Subscriptions Monthly Subscriptions cm ratio weight product $0.19 $0.31 Breakeven ($) = Annual fixed costs + Weighted-average contribution margin ratio Annual fixed costs = + Weighted-average contribution margin ratio Breakeven point in total sales dollars Composition of sales, by product: Sales mix, in terms of dollars: Weekly Subscriptions Monthly Subscriptions Composition of sales, by product--alternative solution: Product Weekly subscriptions Monthly subscriptions Sales Price Units Dollars Sales Mix % Allocation Requirement 4 Data Table: Breakeven Volumes and Percentage Changes in BE Point with changes in sales mix over the range 20% to 30% for HPC Weekly. Sales mix (based on units sold) HPC Weekly HPC Monthly Weighted- avg. CM/unit Weighted-average contribution margin per unit BE (units) B/E % change from base case % Change in Wtd- avg. CM/unit (from base) 6. Required sales (in units) to reach a target before-tax profit of $75,000 for the given sales mix (25%:75%): Targeted before-tax profit target, = Fixed costs (F) = F + TTB = Weighted-average CM per unit = Breakeven point in sales units = Breakdown by Product: Sales of HPC-Weekly (rounded up) Weight 25% 75% Sales of HPC-Monthly 7. Required sales (in units) to reach a targeted after-tax profit = 10% of sales for the given sales mix. Let Q = the required sales volume (in units) to achieve the profit objective B = Total sales - Total variable costs - Total fixed costs (F) (1), where t = Tax rate A (1) Total sales - Total variable costs - F Q = units (rounded up) 8. Prepare the company's Contribution Form Income Statement based on the units in number 7 above. Sales Variable cost Contribution margin 7. Required sales (in units) to reach a targeted after-tax profit = 10% of sales for the given sales mix. Let Q = the required sales volume (in units) to achieve the profit objective B = Total sales - Total variable costs - Total fixed costs (F) (1 t), where t = Tax rate (1) Total sales - Total variable costs - F Q = units (rounded up) 8. Prepare the company's Contribution Form Income Statement based on the units in number 7 above. Sales Variable cost Contribution margin Fixed costs Pre-tax income Income tax Profit after tax Requirement 9
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A straight horizontal road is to be constructed through rough terrain. The width of the road is to be 10 m, with the sides of the embankment sloping at 1 (vertical) in 2 (horizontal), as shown in...
-
The city of Toledo has received a proposal to build a new multipurpose outdoor sports stadium. The expected life of the stadium is 20 years. It will be financed by a 20- year bond paying 8 percent...
-
Locate the 2009 financial statements for The Walt Disney Company on the Internet and consider the following questions: 1. Does Disney use the direct method or the indirect method? Explain. 2. Analyze...
-
(a) Graph g(x) = 3 x - 9. (b) Find the zero of g. (c) Based on the graph, solve g(x) > 0.
-
At \(2000 \mathrm{~K}\), the free energy change in calories for the reaction \[ \mathrm{N}_{2}+\mathrm{O}_{2} ightleftharpoons 2 \mathrm{NO} \] is given by \(\Delta G^{0}=22000-2.5 T\). Calculate...
-
The following report was prepared for evaluating the performance of the plant manager of Second Hand Inc. Evaluate and correct this report. Second Hand Inc. Manufacturing Costs For the Quarter Ended...
-
Describe the concept of an abstraction layer in an operating system. How does it contribute to OS portability across different hardware architectures ?
-
1. How many minutes, on average, does it takes for a first-edition patron to get the requested book from time of entry into the library? (State all assumptions and show the calculations.) 2. How many...
-
Consider the basic Solow model with population growth where the depreciation rate 8 is between 0 and 1, and where population evolves according to: Lt+1 = (1 +n)Lt Assume the usual Cobb-Douglas...
-
What is the criterion for a thermodynamic system to be at steady state?
-
Customers arrive an average of 10 per hour and an average of 16 customers can be served in an hour. Assuming this is an M/M/1 model, what is the system utilization?
-
State the zeroth law of thermodynamics. How does it play an important role in measuring temperature?
-
Customers arrive an average of 10 per hour and an average of 16 customers can be served in an hour. Assuming this is an M/M/1 model, what is the average number of customers in the system?
-
Differentiate between state function and path function. Prove that internal energy is a state function and work is a path function.
-
The condensed product-line income statement for Dish N Dat Company for the month of May is as follows: Dish N' Dat Company Product-Line Income Statement For the Month Ended May 31 Bowls Plates Cups...
-
If a and b are positive numbers, find the maximum value of f ( x ) = x a (9 x ) b on the interval 0 x 9.
-
Determine the order in which the following budgets are generally prepared. a. Material purchases budget b. Sales budget c. Budgeted income statement d. Production budget
-
Would an unexpected increase in sales and production result in underapplied or over- applied overhead? Explain.
-
Santiago's Salsa is in the process of preparing a production cost budget for May. Actual costs in April were: Santiago's Salsa Production Costs 42826 Ingredient cost (variable)...
-
Consider the binary variable version of the fixed effects model in Equation (10.11) except with an additional regressor, \(D 1_{i}\); that is, let \[ Y_{i t}=\beta_{0}+\beta_{1} X_{i t}+\gamma_{1} D...
-
Using the regression in Equation (10.11), what are the slope and intercept for a. Entity 1 in time period 1? b. Entity 1 in time period 3? c. Entity 3 in time period 1? d. Entity 3 in time period 3?...
-
Do the fixed effects regression assumptions in Key Concept 10.3 imply that \(\operatorname{cov}\left(\widetilde{v}_{i t}, \widetilde{v}_{i s} ight)=0\) for \(t eq s\) in Equation (10.28)? Explain....
Study smarter with the SolutionInn App