Wally’s Widget World is an online retailer that makes and sells widgets. There are three models of widgets, each with its own cost of materials and labor.
|
Model |
Percent of sales |
Materials cost |
Labor cost |
Selling price |
|
Econowidget – base-level widget for the budget-conscious widget user |
35% |
$3.50 |
$1.50 |
$6.99 |
|
Superwidget – adds additional feature for the more demanding widget user |
45% |
$4.00 |
$1.75 |
$8.99 |
|
Widget Supreme – for the more discerning and sophisticated widget user |
20% |
$5.25 |
$2.00 |
$11.99 |
The widgets are all the same size and approximate weight, so shipping costs for each widget (regardless of model) are $2.50, and customers are charged $3.99 per widget. Wally’s Widget World has monthly costs below:
Rent
$10,000
Utilities
2,000
Administrative salaries 6,000
Overhead/supplies 1,000
In addition, Wally’s budgets $3,000 each month on banner ads and search-engine marketing. Assuming the percentage of sales for each product in the product line remains constant, perform the following analyses:
Calculate the break-even volume
Calculate the break-even revenue
Wally’s Widget World has a monthly target profit of $5,000. What should be the target volume and revenue for this objective?
Is this a viable target profit? Explain using your calculations. Give an example of another target profit that you think would work and explain why
In: Accounting
Sandy is an accountant with ABC, Inc. She is newly hired and her first assignment is to review the processes in the REVENUE cycle for internal control weaknesses. Sandy finds the following procedures in the Revenue Cycle at ABC.
1. Sales are made via telephone. Most sales are on credit-with ABC extending the credit.
2. Sales data are entered into the system by a sales clerk in the batch mode at the end of the day.
3. The sales clerk manually enters the price and quantity on an order sheet and totals it.
4. The clerk then sends a copy of the sales order to the shipping department.
5. Upon receipt of the sales order, the shipping department “pulls” the merchandise, assembles it on a pallet, and completes the bill of lading.
6. The merchandise is then loaded on a truck and sent on its way.
7. The shipping department enters “SHIPPED” on the sales order and sends it to the sales accounting department.
8. The sales accounting department invoices customers by manually entering the customer name, part-number, quantity, price, and total from the sales order.
9. A copy of the invoice is sent to the customer and another copy is sent to the credit department for account receivable balance update.
10. Payment is made directly to the A/R department who posts the payment and deposits the checks.
REQUIRED: IN TWO PAGES OR LESS, LIST THE INTERNAL CONTROL WEAKNESSES IN THE ABOVE SCENARIO AND LIST THE INTERNAL CONTROLS THAT SHOULD BE PRESENT. ORGANIZE YOUR ANSWER AS FOLLOWS:
NUMBER WEAKNESS(S) INTERNAL CONTROL(S)
In: Accounting
Porter Company shows the following accounts in its partial unadjusted trial balance at December 31, 2017. Dr Cr Cash $71,300 Accounts receivable 40,000 Trading securities 7,000 Available for sale securities 50,000 Allowance for Doubtful accounts 2,000 Furniture and Fixtures 181,000 Accumulated depreciation – F&F 14,000 Accounts Payable 10,800 Common Stock 104,000 Retained Earnings 75,000 Service Revenue 324,100 Insurance expense 11,300 Salaries Expense 149,700 Rent Expense 15,600 TOTALS $527,900 $527,900 Additional Information 1. On May 1, 2017, the company paid $8,700 to renew its comprehensive insurance coverage for one year. The premium on the previous 1-year policy, which expired on April 30, 2017, was $7,800. 2. Bad debts are estimated at 10% of gross accounts receivable. 3. On December 1, 2017, the company paid $2,400, for two months of rent, beginning on that date. 4. The company received $12,000 on November 1, 2017 from a customer for 3 months’ worth of services which will be provided by Porter in 2018. The company recorded the entire $12,000 in Service Revenue. 5. Employees are paid bi-weekly on Friday. December 31st fell on a Sunday. Employees average $1,000 for a five day work week. All salaries were paid in full on Friday, December 22nd for the week ended December 22nd.
In: Accounting
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made.
The pizzeria’s cost formulas appear below:
| Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
| Pizza ingredients | $ | 4.00 | ||||||||
| Kitchen staff | $ | 6,050 | ||||||||
| Utilities | $ | 680 | $ | 1.00 | ||||||
| Delivery person | $ | 2.80 | ||||||||
| Delivery vehicle | $ | 700 | $ | 2.20 | ||||||
| Equipment depreciation | $ | 456 | ||||||||
| Rent | $ | 2,010 | ||||||||
| Miscellaneous | $ | 800 | $ | 0.20 | ||||||
In November, the pizzeria budgeted for 1,770 pizzas at an average selling price of $14 per pizza and for 210 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
| Actual Results | |||
| Pizzas | 1,870 | ||
| Deliveries | 190 | ||
| Revenue | $ | 26,800 | |
| Pizza ingredients | $ | 8,470 | |
| Kitchen staff | $ | 5,990 | |
| Utilities | $ | 920 | |
| Delivery person | $ | 532 | |
| Delivery vehicle | $ | 1,000 | |
| Equipment depreciation | $ | 456 | |
| Rent | $ | 2,010 | |
| Miscellaneous | $ | 832 | |
Required:
1. Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November. (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
Problem 9-19 More Than One Cost Driver [LO9-2, LO9-3]
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made.
The pizzeria’s cost formulas appear below:
| Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
| Pizza ingredients | $ | 4.90 | ||||||||
| Kitchen staff | $ | 6,010 | ||||||||
| Utilities | $ | 660 | $ | 0.80 | ||||||
| Delivery person | $ | 2.60 | ||||||||
| Delivery vehicle | $ | 680 | $ | 2.00 | ||||||
| Equipment depreciation | $ | 440 | ||||||||
| Rent | $ | 1,970 | ||||||||
| Miscellaneous | $ | 780 | $ | 0.10 | ||||||
In November, the pizzeria budgeted for 1,710 pizzas at an average selling price of $20 per pizza and for 190 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
| Actual Results | |||
| Pizzas | 1,810 | ||
| Deliveries | 170 | ||
| Revenue | $ | 36,800 | |
| Pizza ingredients | $ | 8,110 | |
| Kitchen staff | $ | 5,950 | |
| Utilities | $ | 910 | |
| Delivery person | $ | 442 | |
| Delivery vehicle | $ | 996 | |
| Equipment depreciation | $ | 440 | |
| Rent | $ | 1,970 | |
| Miscellaneous | $ | 820 | |
Required:
1. Compute the revenue and spending variances for the pizzeria for November. (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
The results for July for Brahms & Sons
follow:
| Actual (based on actual sales of 64,000 units) | Master Budget (based on budgeted sales 62,000 units) | ||||||||||
| Sales revenue | $ | 500,000 | $ | 527,000 | |||||||
| Less | |||||||||||
| Variable costs | |||||||||||
| Direct material | 64,000 | 52,700 | |||||||||
| Direct labor | 81,000 | 93,000 | |||||||||
| Variable overhead | 88,000 | 93,000 | |||||||||
| Marketing | 15,400 | 15,500 | |||||||||
| Administrative | 14,100 | 15,500 | |||||||||
| Total variable costs | $ | 262,500 | $ | 269,700 | |||||||
| Contribution margin | $ | 237,500 | $ | 257,300 | |||||||
| Less | |||||||||||
| Fixed costs | |||||||||||
| Manufacturing | 110,000 | 104,000 | |||||||||
| Marketing | 23,500 | 15,500 | |||||||||
| Administrative | 83,400 | 82,000 | |||||||||
| Total fixed costs | $ | 216,900 | $ | 201,500 | |||||||
| Operating profits | $ | 20,600 | $ | 55,800 | |||||||
Required:
Prepare a profit variance analysis for Brahms & Sons. ( Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Waves Corp., which has a calendar fiscal year, purchased its only depreciable capital asset on 1 January 2013. Information related to the asset:
Original cost $900,000
Estimated residual value 107,000
Depreciation method Declining balance
Depreciation rate 30%
In 2015, Waves decreased the estimated residual value to $33,800, and increased the depreciation rate to 40%. Both changes are the result of experience with the asset and revised expectations about the pattern of usage.
Additional information:
| 2015 | 2014 | ||||||
| Revenue | $ | 3,359,000 | $ | 2,781,000 | |||
| Expenses other than depreciation and tax | 1,998,000 | 1,530,000 | |||||
| Gain (loss) from discontinued operations, before tax | 56,100 | 0 | |||||
| Tax rate | 30 | % | 30 | % | |||
Required:
1-a. Calculate the ending 2015 balance of accumulated
depreciation.
1-b. Prepare the 2015 entry for depreciation. (If no entry
is required for a transaction/event, select "No journal entry
required" in the first account field.)
2. Provide the condensed comparative statement of comprehensive
income for 2015, including disclosures related to the accounting
change.
|
|||||||||||||||||||||||||||||||||||||
In: Accounting
The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in its budgeting and performance reports—the number of courses and the total number of students. For example, the school might run two courses in a month and have a total of 64 students enrolled in those two courses. Data concerning the company’s cost formulas appear below:
| Fixed Cost per Month | Cost per Course | Cost per Student |
|||||
| Instructor wages | $ | 2,900 | |||||
| Classroom supplies | $ | 260 | |||||
| Utilities | $ | 1,250 | $ | 55 | |||
| Campus rent | $ | 5,200 | |||||
| Insurance | $ | 2,300 | |||||
| Administrative expenses | $ | 3,600 | $ | 43 | $ | 4 | |
For example, administrative expenses should be $3,600 per month plus $43 per course plus $4 per student. The company’s sales should average $870 per student.
The company planned to run four courses with a total of 64 students; however, it actually ran four courses with a total of only 56 students. The actual operating results for September appear below:
| Actual | ||
| Revenue | $ | 52,780 |
| Instructor wages | $ | 10,880 |
| Classroom supplies | $ | 16,490 |
| Utilities | $ | 1,880 |
| Campus rent | $ | 5,200 |
| Insurance | $ | 2,440 |
| Administrative expenses | $ | 3,454 |
Required:
1. Prepare the company’s planning budget for September.
Prepare the company’s planning budget for September.
2. Prepare the company’s flexible budget for September. |
3. Calculate the revenue and spending variances for September.
In: Accounting
EZ-Tax is a tax accounting practice with partners and staff members. Each billable hour of partner time has a $550 budgeted price and $270 budgeted variable cost. Each billable hour of staff time has a budgeted price of $130 and a budgeted variable cost of $60. For the most recent year, the partnership budget called for 8,700 billable partner-hours and 34,600 staff-hours. Actual results were as follows:
| Partner revenue | $ | 4,465,000 | 8,300 | hours | |
| Staff revenue | $ | 4,455,000 | 34,000 | hours | |
Required:
a. Compute the sales price variance. (Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
b. Compute the total sales activity variance. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
c. Compute the total sales mix variance. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
d. Compute the total sales quantity variance. (Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.)
In: Accounting
Natalie had a very busy December. At the end of the month, after
journalizing and posting the December transactions and adjusting
entries, Natalie prepared the following adjusted trial
balance.
|
COOKIE CREATIONS |
||||
|
Debit |
Credit |
|||
|
Cash |
$1,180 | |||
|
Accounts Receivable |
875 | |||
|
Supplies |
350 | |||
|
Prepaid Insurance |
1,210 | |||
|
Equipment |
1,200 | |||
|
Accumulated Depreciation—Equipment |
$40 | |||
|
Accounts Payable |
75 | |||
|
Salaries and Wages Payable |
56 | |||
|
Unearned Service Revenue |
300 | |||
|
Notes Payable |
2,000 | |||
|
Interest Payable |
15 | |||
|
Common Stock |
800 | |||
|
Dividends |
500 | |||
|
Service Revenue |
4,515 | |||
|
Salaries and Wages Expense |
1,006 | |||
|
Utilities Expense |
125 | |||
|
Advertising Expense |
165 | |||
|
Supplies Expense |
1,025 | |||
|
Depreciation Expense |
40 | |||
|
Insurance Expense |
110 | |||
|
Interest Expense |
15 | |||
|
$7,801 |
$7,801 |
|||
Using the information in the adjusted trial balance, do the
following.
1 ) Prepare an income statement for the 2 months ended December 31, 2019
2 ) Prepare an retained earnings statement for the 2 months ended December 31, 2019.
3 ) Prepare a classified balance sheet at December 31, 2019. The note payable has a stated interest rate of 6%, and the principal and interest are due on November 16, 2018
4 ) Natalie has decided that her year-end will be December 31, 2019. Prepare closing entries as of December 31, 2019
5 ) Prepare a post closing trial balance
In: Accounting