Product Planning with Taxes
Assume that last year, Cliff Consulting, a firm in Berkeley, CA,
had the following contribution income statement:
| CLIFF CONSULTING Contribution Income Statement For the Year Ended September 30 |
||
|---|---|---|
| Sales revenue | $ 1,200,000 | |
| Variable costs | ||
| Cost of services | $ 480,000 | |
| Selling and administrative | 60,000 | 540,000 |
| Contribution margin | 660,000 | |
| Fixed Costs -selling and administrative | 440,000 | |
| Before-tax profit | 220,000 | |
| Income taxes (21%) | 46,200 | |
| After-tax profit | $ 173,800 | |
(a) Determine the annual break-even point in sales revenue.
Round contribution margin ratio to two decimal places for your
calculation. Round final answer to nearest dollar.
$Answer
(b) Determine the annual margin of safety in sales revenue.
Use rounded answer from above for calculation.
$Answer
(c) What is the break-even point in sales revenue if management
makes a decision that increases fixed costs by $80,000?
Use rounded contribution margin ratio (2 decimal places) for
your calculation.
Round your answer to the nearest dollar.
$Answer
(d) With the current cost structure, including fixed costs of
$440,000, what dollar sales revenue is required to provide an
after-tax net income of $250,000?
Use rounded contribution margin (2 decimal places) for
calculation. Round your answer to the nearest dollar.
$Answer
(e) Prepare an abbreviated contribution income statement to verify
that the solution to requirement (d) will provide the desired
after-tax income.
Use rounded contribution margin (2 decimal places) for variable
cost/contribution margin computations. Round your answers to the
nearest dollar.
Use rounded answers for subsequent calculations. Do not use
negative signs with any of your answers.
| CLIFF CONSULTING Income Statement |
|
|---|---|
| Sales | Answer |
| Variable costs | Answer |
| Contribution margin | Answer |
| Fixed costs | Answer |
| Net income before taxes | Answer |
| Income taxes (21%) | Answer |
| Net income after taxes | Answer |
In: Accounting
Arberg Company’s controller prepared the following budgeted income statement for the coming year:
| Sales | $417,000 |
| Variable cost | 287,730 |
| Contribution margin | $129,270 |
| Fixed cost | 75,950 |
| Operating income | $53,320 |
| Required: | |
| 1. | What is Arberg’s variable cost ratio? What is its contribution margin ratio? |
| 2. | Suppose Arberg’s actual revenues are $29,900 more than budgeted. By how much will operating income increase? Give the answer without preparing a new income statement. |
| 3. | How much sales revenue must Arberg earn to break even? Prepare a contribution margin income statement to verify the accuracy of your answer. |
| 4. | What is Arberg’s expected margin of safety? |
| 5. | What is Arberg’s margin of safety if sales revenue is $378,000? |
Amount Descriptions
Refer to the list below for the exact wording of text items within your income statement.
| Amount Descriptions | |
| Operating income | |
| Operating loss | |
| Sales | |
| Total contribution margin | |
| Fixed cost | |
| Variable cost |
Ratios and Revenue
1. What is Arberg’s variable cost ratio? What is its contribution margin ratio?
| Variable cost ratio | % |
| Contribution margin ratio | % |
2. Suppose Arberg’s actual revenues are $29,900 more than budgeted. By how much will operating income increase?
3(a) How much sales revenue must Arberg earn to break even?
Contribution Margin Income Statement
3(b) Prepare a contribution margin income statement to verify the accuracy of your answer. Refer to the list of Amount Descriptions for the exact wording of text items within your income statement.
|
Arberg Company |
|
Contribution Margin Income Statement |
|
For the Coming Year |
|
1 |
||
|
2 |
||
|
3 |
||
|
4 |
||
|
5 |
Margin of Safety
4. What is Arberg’s expected margin of safety?
5. What is Arberg’s margin of safety if sales revenue is $378,000?
In: Accounting
O(True) or X(False)
() 1. A trade-off is a principle for market activities.
() 2. A manager's salary is the opportunity cost.
() 3. A trade provides a division of labor.
() 4. The market failure always results in the negative externality.
() 5. An analysis on Trump’s tax policy is the normative analysis.
() 6. The demand change due to a related commodity price change is a demand law.
() 7. The supply change due to that input price change is a supply law.
() 8. The right demand shift results into an increase in equilibrium price.
() 9. The price down of necessity goods results in increases of both demand and total revenue.
() 10. The price down for long-run results in increases of both demand and total revenue.
() 11. A control of gasoline price results in more demand for gasolines than supply.
() 12. An indifference curve is a curve of 2 goods purchase not related to satisfaction.
() 13. A budget line is a line of 2 goods purchase with a given budget not related to prices.
() 14. A budget line shifts left as a budget increases.
() 15. The substitution effect of price change is always an inverse relationship.
() 16. The income effect of price change is always a positive relationship.
() 17. A consumer surplus is the surplus of consumption which a consumer spends for.
() 18. A producer surplus is the surplus of producer above the price.
() 19. The cost equation is not related to output prices.
() 20. The revenue function is related to output..
() 21. The export results in extra gain, while the import does not result in extra gain.
() 22. The Giffen goods are those whose demand decreases due to price change.
() 23. The labor marginal product is the labor productivity.
() 24. As the average product decreases, the marginal product decreases always.
() 25. The average product and marginal product do not cross each other.
() 26. When price elasticity of demand is less than 1, production increase increases revenue.
() 27. When price elasticity of demand is greater than 1, productiondecrease decreases revenue.
In: Economics
The performance report compares data from Remember When’s Inc. static master budget with the actual costs of its Watch Division for the year ended December 31.
Remember When, Inc.
Performance Report-Watch Division
For the Year Ended December 31
|
Cost Category |
Budgeted Costs * |
Actual Costs † |
Difference Under (Over) Budget |
|
Direct materials |
$42,000 |
$46,000 |
($4,000) |
|
Direct labor |
10,325 |
11,779 |
(1,454) |
|
Variable overhead |
|||
|
Indirect materials |
3,500 |
3,600 |
(100) |
|
Indirect labor |
5,250 |
5,375 |
(125) |
|
Utilities |
1,750 |
1,810 |
(60) |
|
Other |
2,100 |
2,200 |
(100) |
|
Fixed overhead |
|||
|
Supervisory salaries |
4,000 |
3,500 |
500 |
|
Depreciation |
2,000 |
2,000 |
---- |
|
Utilities |
450 |
450 |
---- |
|
Other |
3,000 |
3,200 |
(200) |
|
Totals |
$74,375 |
$79,914 |
($5,539) |
* Budgeted costs are based on an output of 17,500 units.
† Actual output was 19,100 units.
Actual costs exceeded budgeted costs by $5,539, or 7.4 percent. On the face of it, most managers would consider such a cost overrun significant. But was there really a cost overrun? The budgeted amounts are based on sales of 17,500 units at $8 each; however, actual sales was 19,100 units for a total sales of $143,250. “Remember When, Inc. uses a Just In Time inventory system and thus does not have any beginning or ending inventory. Output are units sold.
Required:
Construct a flexible budged performance report and explain activity (volume), revenue, and spending variances.
Check Figures: Activity (Volume) Variance – Revenue 12,800F, Variable Costs 5,936U,
Net Income 6,864F
Revenue Variance – 9,550U
Spending Variance – Total Variable Costs 97F,
- Total Fixed Costs 300F
Activity (volume) generated $6,864 additional profit, but the revenue variance was unfavorable by $9,550. Fixed and variable costs were close to flexible budge amounts, so income is down overall due to poor revenue management
In: Accounting
The trial balance columns of the worksheet for Swifty Company at June 30, 2022, are as follows.
|
Swifty Company |
||||
|---|---|---|---|---|
|
Trial Balance |
||||
|
Account Titles |
Dr. |
Cr. |
||
| Cash | 2,000 | |||
| Accounts Receivable | 2,780 | |||
| Supplies | 1,980 | |||
| Accounts Payable | 1,040 | |||
| Unearned Service Revenue | 440 | |||
| Common Stock | 2,560 | |||
| Service Revenue | 3,400 | |||
| Salaries and Wages Expense | 560 | |||
| Miscellaneous Expense | 120 | |||
| 7,440 | 7,440 | |||
Other data:
|
1. |
A physical count reveals $350 of supplies on hand. | |
|
2. |
$150 of the unearned revenue is still unearned at month-end. | |
|
3. |
Accrued salaries are $250. |
Complete the worksheet.
|
Swifty Company |
||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Trial Balance |
Adjustments |
Adj. Trial Balance |
Income Statement |
Balance Sheet |
||||||||||||||||
|
Account Titles |
Dr |
Cr. |
Dr |
Cr. |
Dr |
Cr. |
Dr |
Cr. |
Dr |
Cr. |
||||||||||
| Cash |
2,000 |
|||||||||||||||||||
| Accounts Receivable |
2,780 |
|||||||||||||||||||
| Supplies |
1,980 |
|||||||||||||||||||
| Accounts Payable |
1,040 |
|||||||||||||||||||
| Unearned Service Revenue |
440 |
|||||||||||||||||||
| Common Stock |
2,560 |
|||||||||||||||||||
| Service Revenue |
3,400 |
|||||||||||||||||||
| Salaries and Wages Expense |
560 |
|||||||||||||||||||
| Miscellaneous Expense |
120 |
|||||||||||||||||||
| Totals |
7,440 |
7,440 |
||||||||||||||||||
| Supplies Expense | ||||||||||||||||||||
| Salaries and Wages Payable | ||||||||||||||||||||
| Totals | enter a total for the debit column | enter a total for the credit column | enter a total for the debit column | enter a total for the credit column |
enter a total for the debit column |
enter a total for the credit column |
enter a total for the debit column |
enter a total for the credit column |
||||||||||||
| Net Income | enter a total net income or loss amount | enter a total net income or loss amount | enter a total net income or loss amount | enter a total net income or loss amount | ||||||||||||||||
| Totals | enter a total of the two previous amounts | enter a total of the two previous amounts | enter a total of the two previous amounts | enter a total of the two previous amounts | ||||||||||||||||
In: Accounting
Texas-Q Company produces and sells barbeque grills. Texas-Q sells three models: a small portable gas grill, a larger stationary gas grill, and the specialty smoker. In the coming year, Texas-Q expects to sell 14,700 portable grills, 53,900 stationary grills, and 4,900 smokers. Information on the three models is as follows:
| Portable | Stationary | Smokers | |
|---|---|---|---|
| Price | $94 | $199 | $250 |
| Variable cost | |||
| per unit | 43 | 135 | 142 |
Total fixed cost is $2,026,500.
| Required: | |||||||||||||||||||||||||||||
| 1. | What is the sales mix of portable grills to stationary grills to smokers? | ||||||||||||||||||||||||||||
| 2. | Compute the break-even quantity of each product. | ||||||||||||||||||||||||||||
| 3. | Prepare an income statement for Texas-Q for the coming year. What is the overall contribution margin ratio? Use the contribution margin ratio to compute overall break-even sales revenue. Enter the contribution margin ratio as a percentage rounded to two decimal places; round the break-even sales revenue to the nearest dollar. | ||||||||||||||||||||||||||||
| 4. |
Compute the margin of safety for the coming year. 1. What is the sales mix of portable grills to stationary grills to smokers? 2. Compute the break-even quantity of each product.
3(a) What is the overall contribution margin ratio? Use the contribution margin ratio to compute overall break-even sales revenue. Enter the contribution margin ratio as a percentage rounded to two decimal places; round the break-even sales revenue to the nearest dollar.
|
In: Accounting
Multiple Product Planning with Taxes
In the year 2017, Pyramid Consulting had the following contribution
income statement:
| PYRAMID CONSULTING Contribution Income Statement For the Year 2017 |
||
|---|---|---|
| Sales revenue | $ 1,300,000 | |
| Variable costs | ||
| Cost of services | $ 420,000 | |
| Selling and administrative | 200,000 | (620,000) |
| Contribution margin | 680,000 | |
| Fixed Costs -selling and administrative | (285,000) | |
| Before-tax profit | 395,000 | |
| Income taxes (36%) | (142,200) | |
| After-tax profit | $ 252,800 | |
(a) Determine the annual break-even point in sales revenue.
Round contribution margin ratio to two decimal places for your
calculation. Round final answer to nearest
dollar.
$Answer
(b) Determine the annual margin of safety in sales revenue.
Use rounded answer from above for calculation.
$Answer
(c) What is the break-even point in sales revenue if management
makes a decision that increases fixed costs by $57,000?
Use rounded contribution margin ratio (2 decimal places) for
your calculation.
$Answer
(d) With the current cost structure, including fixed costs of
$285,000, what dollar sales revenue is required to provide an
after-tax net income of $200,000?
Use rounded contribution margin (2 decimal places) for
calculation. Round your answer to the nearest
dollar.
$Answer
(e) Prepare an abbreviated contribution income statement to verify
that the solution to requirement (d) will provide the desired
after-tax income.
Use rounded contribution margin (2 decimal places) for variable cost/contribution margin computations. Round your answers to the nearest dollar. Use rounded answers for subsequent calculations. Do not use negative signs with any of your answers.
| PYRAMID CONSULTING Income Statement For the Year 2017 |
|
|---|---|
| Sales | $Answer |
| Variable costs | Answer |
| Contribution margin | Answer |
| Fixed costs | Answer |
| Net income before taxes | Answer |
| Income taxes (36%) | Answer |
| Net income after taxes | $Answer |
In: Accounting
The Palace Theater opened on April 1. All facilities were
completed on March 31. At this time, the ledger showed No. 101 Cash
$6,000, No. 140 Land $12,000, No. 145 Buildings (concession stand,
projection room, ticket booth, and screen) $8,000, No. 157
Equipment $6,000, No. 201 Accounts Payable $2,000, No. 275 Mortgage
Payable $10,000, and No. 311 Common Stock $20,000. During April,
the following events and transactions occurred.
| Apr. 2 | Paid film rental of $800 on first movie. | |
| 3 | Ordered two additional films at $950 each. | |
| 9 | Received $1,800 cash from admissions. | |
| 10 | Made $2,000 payment on mortgage and $1,000 for accounts payable due. | |
| 11 | Palace Theater contracted with Dever Company to operate the concession stand. Dever is to pay 18% of gross concession receipts (payable monthly) for the rental of the concession stand. | |
| 12 | Paid advertising expenses $320. | |
| 20 | Received one of the films ordered on April 3 and was billed $950. The film will be shown in April. | |
| 25 | Received $5,200 cash from admissions. | |
| 29 | Paid salaries $1,600. | |
| 30 | Received statement from Dever showing gross concession receipts of $1,000 and the balance due to The Palace Theater of $180 ($1,000 × 18%) for April. Dever paid one-half of the balance due and will remit the remainder on May 5. | |
| 30 | Prepaid $1,000 rental on special film to be run in May. |
In addition to the accounts identified above, the chart of accounts
shows No. 112 Accounts Receivable, No. 136 Prepaid Rent, No. 400
Service Revenue, No. 429 Rent Revenue, No. 610 Advertising Expense,
No. 726 Salaries and Wages Expense, and No. 729 Rent Expense.
A. Enter the beginning balances in the ledger as of April 1
b.Journalize the April transactions. Palace records admission revenue as service revenue, rental of the concession stand as rent revenue, and film rental expense as rent expense.
c.Post the April journal entries to the ledger.
d.Prepare a trial balance on April 30, 2017.
In: Accounting
Implementing change in any organization can be a daunting task. change is inevitable, and organizations need to embrace a culture of change for long term survival. However not all changes are worthwhile. Blindly implementing change can result in sub-optimal performance and in some cases, it can diminish performance. Change initiatives must be evaluated from a business perspective. Consider an example of an automobile dealership is evaluating a new protocol in their auto-service department. The service department generates more revenue than the sales department, on an annualized basis. Sales revenues have been down in recent years, and management would like to find ways to increase service revenue to offset any shortfalls from the sales department. The service department has proposed to senior management that they can make a change to their service offerings to increase revenue. Currently, the service department offers ala carte offerings for service. Patrons can opt for separate services on an as needed basis (e.g. oil, change, spark plug change, timing belt service, transmission service and so on). A key change proposed would involve offering packaged service solutions (e.g. 10K mileage service, 30K mileage service, 75K mileage service, and so on). Each package service would bundle many of the previously offered services. If implemented, the change could yield an extra $1M of service revenue for the dealership. Without this change, substantially growing service revenue would be very unlikely for the dealership. The change implementation will involve having to re-market its services appropriately, changing advertising, increasing promotions, training staff, and so on, They would have to do so without making long-time customers feel like they are being offered more services than then need at any given time. How should the dealership go about evaluating this change? Should they embark on this change? Please explain your answer sufficiently.
In: Operations Management
In: Economics