Classwork on operating leverages and breakeven analysis for multiple products
Question 1
Penguin Co’s income statement in the contribution format for 2017 showed the following:
$
Revenue
20,000
Variable
costs 10,000
Contribution
margin 10,000
Fixed
costs
2,000
Operating income 8,000
Required
1. Calculate the operating leverage.
2. Using the operating leverage formula, calculate the new operating income if sales rise by 10%.
3. Using the operating leverage formula, calculate the new operating income if sales fall by 15%.
Question 2
Peregrine Inc’s income statement in the contribution format for 2018 showed the following:
$
Revenue
8,000
Variable
costs 2,000
Contribution
margin 6,000
Fixed
costs 2,000
Operating income 4,000
Required
1) Calculate the contribution margin percentage.
2) Calculate the breakeven point in $ revenue.
3) Calculate the operating leverage.
4) Using the operating leverage formula, calculate the new operating income if sales rise by 50%.
5) How much $ revenue is needed in order to generate a net income of $5,000 if the company is liable to 20% income tax?
Question 3
Wayne’s Workshop shows average revenue per customer of $400. Monthly fixed costs are $40,000. Variable costs in the last month were in total $32,000. During that month the workshop had 1,200 customers.
Required
1. Calculate the contribution margin ratio.
2. Calculate the breakeven point.
3. What was the profit last month?
4. Prepare an income statement for last month using the contribution format.
5. What was the operating leverage?
6. Using the operating leverage formula, calculate the new operating income if sales fall by 5%.
Question 4
Polkadot Co produce 3 types of soft toys: teddy bears, falcons, and snakes (TB, F, S). The following table shows for each product the expected sales volumes for 2019, sales prices (SP), variable costs per unit (VC), and company total budgeted fixed costs for 2019.
|
TB |
F |
S |
Total |
|
|
Sales volume (units) |
600 |
300 |
100 |
1000 |
|
SP ($) |
20 |
30 |
15 |
|
|
VC ($) |
10 |
12 |
7 |
|
|
Fixed costs ($) |
2000 |
Required
1. Calculate the sales mix for 2019.
2. Calculate the contribution margin per unit for each product.
3. Calculate the contribution margin per unit for the “average product”.
4. Calculate the breakeven point in units of “average product”.
5. How many units of each product need to be sold so that Polkadot Co breaks even?
Question 5
Moniker Bros. are budgeting to achieve half of their sales for 2020 with milk chocolate bars, a third with hazelnut chocolate bars, and the rest with bitter chocolate bars. Unit sales prices are as follows (variable costs in brackets): milk chocolate bars $4 ($3) , hazelnut chocolate bars $6 ($4), and the rest with bitter chocolate bars $8 ($5). Budgeted fixed costs for 2020 are $200,000.
How many bars of milk chocolate, hazelnut chocolate, and bitter chocolate does the company need to sell in 2020 to break even?
In: Accounting
Blue Spruce Company’s trial balance at December 31, 2019, is presented below. All 2019 transactions have been recorded except for the items described following the trial balance.
|
Debit |
Credit |
||
|
Cash |
$26,000 |
||
|
Accounts Receivable |
36,500 |
||
|
Notes Receivable |
8,900 |
||
|
Interest Receivable |
–0– |
||
|
Inventory |
36,200 |
||
|
Prepaid Insurance |
3,780 |
||
|
Land |
21,800 |
||
|
Buildings |
132,000 |
||
|
Equipment |
55,000 |
||
|
Patents |
10,300 |
||
|
Allowance for Doubtful Accounts |
$400 |
||
|
Accumulated Depreciation—Buildings |
44,000 |
||
|
Accumulated Depreciation—Equipment |
22,000 |
||
|
Accounts Payable |
27,100 |
||
|
Salaries and Wages Payable |
–0– |
||
|
Unearned Rent Revenue |
3,300 |
||
|
Notes Payable (due in 2020) |
13,000 |
||
|
Interest Payable |
–0– |
||
|
Notes Payable (due after 2020) |
36,000 |
||
|
Common Stock |
46,500 |
||
|
Retained Earnings |
57,580 |
||
|
Dividends |
15,000 |
||
|
Sales Revenue |
903,000 |
||
|
Interest Revenue |
–0– |
||
|
Rent Revenue |
–0– |
||
|
Gain on Disposal of Plant Assets |
–0– |
||
|
Bad Debts Expense |
–0– |
||
|
Cost of Goods Sold |
640,000 |
||
|
Depreciation Expense |
–0– |
||
|
Insurance Expense |
–0– |
||
|
Interest Expense |
–0– |
||
|
Other Operating Expenses |
61,400 |
||
|
Amortization Expense |
–0– |
||
|
Salaries and Wages Expense |
106,000 | ||
|
Total |
$1,152,880 | $1,152,880 |
Unrecorded transactions:
| 1. | On May 1, 2019, Blue Spruce purchased equipment for $17,800 plus sales taxes of $1,400 (all paid in cash). | |
| 2. | On July 1, 2019, Blue Spruce sold for $3,600 equipment which originally cost $5,100. Accumulated depreciation on this equipment at January 1, 2019, was $2,000; 2019 depreciation prior to the sale of the equipment was $450. | |
| 3. | On December 31, 2019, Blue Spruce sold on account $5,400 of inventory that cost $3,200. | |
| 4. | Blue Spruce estimates that uncollectible accounts receivable at year-end is $4,000. | |
| 5. | The note receivable is a one-year, 8% note dated April 1, 2019. No interest has been recorded. | |
| 6. | The balance in prepaid insurance represents payment of a $3,780 6-month premium on September 1, 2019. | |
| 7. | The buildings are being depreciated using the straight-line method over 30 years. The salvage value is $30,000. | |
| 8. | The equipment owned prior to this year is being depreciated using the straight-line method over 5 years. The salvage value is 10% of cost. | |
| 9. | The equipment purchased on May 1, 2019, is being depreciated using the straight-line method over 5 years, with a salvage value of $2,100. | |
| 10. | The patent was acquired on January 1, 2019, and has a useful life of 10 years from that date. | |
| 11. | Unpaid salaries and wages at December 31, 2019, total $2,200. | |
| 12. | The unearned rent revenue of $3,300 was received on December 1, 2019, for 3 months’ rent. | |
| 13. | Both the short-term and long-term notes payable are dated January 1, 2019, and carry a 9% interest rate. All interest is payable in the next 12 months. |
Prepare journal entries for the transactions listed above.
In: Accounting
Multiple steps are requried for this question
Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below:
| Fixed Element per Month |
Variable Element per Customer Served | Actual Total for May |
|||||
| Revenue | $ | 5,600 | $ | 182,000 | |||
| Employee salaries and wages | $ | 55,000 | $ | 1,600 | $ | 110,300 | |
| Travel expenses | $ | 850 | $ | 27,200 | |||
| Other expenses | $ | 34,000 | $ | 32,600 | |||
When preparing its planning budget the company estimated that it would serve 30 customers per month; however, during May the company actually served 35 customers.
Please answer the following letters towards the question
a. What amount of revenue would be included in Adger’s flexible budget for May?
b. What amount of employee salaries and wages would be included in Adger’s flexible budget for May?
c. What amount of travel expenses would be included in Adger’s flexible budget for May?
d. What amount of other expenses would be included in Adger’s flexible budget for May?
e. What net operating income would appear in Adger’s flexible budget for May?
f. What is Adger’s revenue variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
g. What is Adger’s employee salaries and wages spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
h. What is Adger’s travel expenses spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
i What is Adger’s other expenses spending variance for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
j. What amount of revenue would be included in Adger’s planning budget for May?
k. What amount of employee salaries and wages would be included in Adger’s planning budget for May?
l. What amount of travel expenses would be included in Adger’s planning budget for May?
m. What amount of other expenses would be included in Adger’s planning budget for May?
n. What activity variance would Adger report in May with respect to its revenue? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
o. What activity variances would Adger report with respect to each of its expenses for May? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Utilizing the CAFR obtained for City of Jackson in MS, review the governmental fund financial statements and related data and government-wide financial statements. Note particularly these items:
Are charts, graphs, or tables included in the statistical section of the CAFR that show the changes over time in reliance on each revenue source? What have been the trends in revenue sources over time?
Are charts, tables, or graphs presented in the statistical section of the CAFR to show the trend of General Fund expenditures, by category, for a period of 10 years? What has been the trend in expenditure categories? How does the trend in expenditures compare to the trend in revenues? Is expenditure data related to nonfinancial measures such as population of the government or workload statistics (e.g., tons of solid waste removed or number of miles of street constructed)?
In: Accounting
1. In long-run monopolistic competition,
a) all firms will produce an identical product
b) entry or exit will shift the demand curve until all firms earn zero profit
c) firms might earn positive profits since strategic barriers prevent new firms from entering
d) entry or exit will shift the supply curve until all firms earn zero profit
e) firms may operate at a loss if the tax advantage are sufficiently large
2. What is the profit maximizing output level for a monopolistic competitive firm facing demand of P=50-2q, constant marginal costs of $10 and fixed costs are $50?
a) 19 units
b)10 units
c) 30 units
d) 25 units
e) 20 units
3. What is the profit maximizing price for a monopolistically competitive firm facing demand of P=50-2q, constant marginal costs of $10 and fixed costs of $50?
a) $50
b) $10
c) $2
d) $20
e) $30
4. What is the maximum profit that can be earned by a monopolistically competitive firm facing demand of P=50-2q, constant marginal costs of $10 and fixed costs of $50?
a) $150
b) $100
c) $500
d) $200
e) $300
5. How much deadweight loss will be created by a monopolistically competitive firm facing demand of P=50-2q, content marginal costs of $10 and fixed costs of $50?
a) $100
b) $300
c) $150
d) $50
e) $200
6. Which of the following is NOT true regarding perfect competition and monopolistic competition?
a) firms in each market structure operate in the long-run where LRAC and demand are tangent
b) there are no barriers to entry or exit in either type of competition
c) all of the answers are true
d) firms in each market structure operate at optimal scale
e) firms in each market structure earn zero profits in the long-run
7. Which characteristic of a monopolistically competitive market implies that firms will be unable to earn a profit in the long-run?
a) monopolistically competitive firms are able to earn a long-run profit
b) there are no barriers to entry
c) firms face a downward sloping demand curve
d) few sellers, many buyers
e) output is differentiated
8. In short-run monopolistic competition a firm maximizes its profit by selecting an output at which
a) marginal revenue exceeds marginal cost
b) marginal revenue equals marginal cost
c) total revenue equals total cost
d) marginal revenue equals average total cost
e) marginal revenue equals average variable cost
9. Which of the following is NOT true of a firm operating in a monopolistically competitive market in the long-run?
a) the firm produces less than optimal scale
b) the demand curve facing the firm is tangent to the marginal cost curve
c) the firm sets a price above the minimum average cost
d) the firm operates with excess capacity
e) all of the answers are true
In: Economics
The following income statement items appeared on the adjusted trial balance of Schembri Manufacturing Corporation for the year ended December 31, 2021 ($ in thousands): sales revenue, $17,500; cost of goods sold, $7,300; selling expenses, $1,410; general and administrative expenses, $910; interest revenue, $160; interest expense, $290. Income taxes have not yet been recorded. The company’s income tax rate is 25% on all items of income or loss. These revenue and expense items appear in the company’s income statement every year. The company’s controller, however, has asked for your help in determining the appropriate treatment of the following nonrecurring transactions that also occurred during 2021 ($ in thousands). All transactions are material in amount.
Required:
1. Prepare Schembri’s single, continuous
multiple-step statement of comprehensive income for 2021, including
earnings per share disclosures. One million shares of common stock
were outstanding at the beginning of the year and an additional
800,000 shares were issued on July 1, 2021.
2. Prepare a separate statement of comprehensive
income for 2021.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
In: Accounting
Chapter 2
Critical Thinking Case 2 - Part 2
Brooke Stauffer Learns to Budget
Brooke Stauffer recently graduated from college and moved to Atlanta to take a job as a market research analyst. She was pleased to be financially independent and was sure that, with her $45,000 salary, she could cover her living expenses and have plenty of money left over to furnish her studio apartment and enjoy the wide variety of social and recreational activities available in Atlanta. She opened several department-store charge accounts and obtained a bank credit card.
For a while, Brooke managed pretty well on her monthly take-home pay of $2,893, but by the end of 2017, she was having trouble fully paying all her credit card charges each month. Concerned that her spending had gotten out of control and that she was barely making it from paycheck to paycheck, she decided to list her expenses for the past calendar year and develop a budget. She hoped not only to reduce her credit card debt but also to begin a regular savings program.
Brooke prepared the following summary of expenses for 2017.
| Item | Annual Expenditure |
| Rent | $12,000 |
| Auto insurance | 1,855 |
| Auto loan payments | 3,840 |
| Auto expenses (gas, repairs, and fees) | 1,560 |
| Clothing | 3,200 |
| Installment loan for stereo | 540 |
| Personal care | 424 |
| Phone | 600 |
| Cable TV | 440 |
| Gas and electricity | 1,080 |
| Medical care | 120 |
| Dentist | 70 |
| Groceries | 2,500 |
| Dining out | 2,600 |
| Furniture purchases | 1,200 |
| Recreation and entertainment | 2,900 |
| Other expenses | 600 |
After reviewing her 2017 expenses, Brooke made the following assumptions about her expenses for 2018:
All expenses will remain at the same levels, with these exceptions:
Auto insurance, auto expenses, gas and electricity, and groceries will increase 5 percent.
Clothing purchases will decrease to $2,250.
Phone and cable TV will increase $5 per month.
Furniture purchases will decrease to $660, most of which is for a new television.
He will take a one-week vacation to Colorado in July at a cost of $2,100.
All expenses will be budgeted in equal monthly installments except for the vacation and these items:
Auto insurance is paid in two installments due in June and December.
She plans to replace the brakes on her car in February at a cost of $220.
Visits to the dentist will be made in March and September.
She will eliminate her bank credit card balance by making extra monthly payments of $75 during each of the first six months.
Regarding her income, Brooke has just received a small raise, so her take-home pay will be $3,200 per month.
Make any necessary adjustments to Brooke’s estimated monthly expenses, and revise her annual cash budget for the year ending December 31, 2018, using Worksheet 2.3. Enter all expense amounts as positive values. Round your answers to nearest cent.
| ANNUAL CASH BUDGET BY MONTH | |||||||||||||
| Name(s) Brooke Stauffer | |||||||||||||
| For the year | Ending December 31, 2018 | ||||||||||||
| INCOME | Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sept. | Oct. | Nov. | Dec. | Total |
| Take-home pay | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| [1] Total Income | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| EXPENDITURES | |||||||||||||
| Rent | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Gas & electricity | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Phone | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Cable TV | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Groceries | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Dining out | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Auto loan payments | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Car expenses (gas, repairs, and fees) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Medical care, dentist | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Clothing | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Auto insurance | $ | $ | $ | ||||||||||
| Installment loan for stereo | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Personal care | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Vacation | $ | $ | |||||||||||
| Other recreation & entertainment | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Appliance purchases | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Miscellaneous expenses | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Credit card payments | $ | $ | $ | $ | $ | $ | $ | ||||||
| Roth IRA contributions | |||||||||||||
| [2] Total Expenditures | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| MONTHLY CASH SURPLUSES (DEFICIT) [1-2] | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| CUMULATIVE CASH SURPLUS (DEFICIT) | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
Analyze the budget and advise Brooke on her financial situation.
Suggest some long-term, intermediate, and short-term financial
goals for Brooke, and discuss some steps she can take to reach
them.
In: Finance
Exceptional Electronics began operations September 1, 2019. The firm sells its merchandise for cash and on open account. Sales are subject to a 7 percent sales tax. During September, Exceptional Electronics engaged in the following transactions.
| DATE | TRANSACTIONS | ||
| 2019 | |||
| Sept. | 1 |
Sold a high-definition television set on credit to Candy Cho; issued Sales Slip 101 for $2,900 plus sales tax of $203. |
|
| 3 |
Sold stereo equipment on credit to Jim Peterson; issued Sales Slip 102 for $1,000 plus sales tax of $70. |
||
| 7 |
Sold a microwave oven on credit to Bridgette Huffman; issued Sales Slip 103 for $200 plus sales tax of $14. |
||
| 12 |
Accepted return of defective stereo equipment from Jim Peterson; issued Credit Memorandum 101 for $200 plus sales tax of $14. The stereo equipment was sold on September 3. |
||
| 15 |
Recorded cash sales for the period from September 1 to September 15 of $9,300 plus sales tax of $651. |
||
| 16 |
Sold a gas dryer on credit to Kathy Sundstrand; issued Sales Slip 104 for $500 plus sales tax of $35. |
||
| 17 |
Sold a home entertainment system on credit to Mark Navalta; issued Sales Slip 105 for $1,900 plus sales tax of $133. |
||
| 18 | Received $750 from Candy Cho on account. | ||
| 20 |
Received payment in full from Jim Peterson for the sale of September 3, less the return of September 12. |
||
| 25 |
Gave Mark Navalta an allowance because of scratches on his home entertainment system sold on September 17, Sales Slip 105; issued Credit Memorandum 102 for $300 plus sales tax of $21 |
||
| 27 | Received payment in full from Bridgette Huffman for the sale of September 7 | ||
| 29 |
Sold a dishwasher on credit to Mark Navalta; issued Sales Slip 106 for $600 plus sales tax of $42. |
||
| 30 |
Recorded cash sales for the period from September 16 to September 30 of $11,600 plus sales tax of $812. |
||
GENERAL LEDGER ACCOUNTS
| 101 | Cash | 401 | Sales | |
| 111 | Accounts Receivable | 421 | Sales Returns and Allowances | |
| 221 | Sales Tax Payable | |||
ACCOUNTS RECEIVABLE LEDGER ACCOUNTS
| Candy Cho | Jim Peterson | ||
| Bridgette Huffman | Kathy Sundstrand | ||
| Mark Navalta |
Required:
Post the entries from the general journal into the appropriate accounts in the general ledger and in the accounts receivable ledger.
Prepare a schedule of accounts receivable.
Analyze:
What is the amount of sales tax owed at September 30,
2019?
General Ledgers
Schedule of AR
Analyze
Post the entries from the general journal into the appropriate accounts in the general ledger and in the accounts receivable ledger.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Complete this question by entering your answers in the tabs below.
General Ledgers
Schedule of AR
Analyze
Prepare a schedule of accounts receivable.
|
|||||||||||||||||||
Complete this question by entering your answers in the tabs below.
General Ledgers
Schedule of AR
Analyze
What is the amount of sales tax owed at September 30, 2019?
|
In: Accounting
Use the following information to solve for ROE. Your answer should be entered as a percent. For example 7.31% should be entered as 7.31. Include two decimals and a negative if appropriate
Current Assets are $98, net fixed assets are $115, total common equity is $178
Revenue is $194, total operating expenses are $63, depreciation expense is $32
Interest expense is $43 and taxes are $32
In: Finance
Sroufe Manufacturing intends to increase capacity by overcoming a bottleneck operation by adding new equipment. Two vendors have presented proposals. The fixed costs are $50,000 for proposal A and $70,000 for proposal B. The variable cost is $12.00 for A and $10.00 for B. The revenue generated by each unit is $20.00,
a) The break-even point in units for the proposal by Vendor A-units (enter your response as a whole number).
In: Accounting