Baltic Supplies presented the following unadjusted trial balance as at December 31, 2016
| Accounts | Debit | Credit |
| cash | ||
| Accounts Receivable | 410,000 | |
| Merchandise Inventory | 330,000 | |
| Store supplies | 144,800 | |
| Prepaid Insurance Expense | 156,000 | |
| Building and Equipment | 800,000 | |
| Accumulated depreciation- Building and Equipment | 237,000 | |
| Accounts payable | 435,000 | |
| Travelling expense payable | ||
| unearned sales revenue | 220,000 | |
| Note payable long term | 345,000 | |
| Baltic capital | 1,791,900 | |
| Baltic Withdrawal | 35,000 | |
| Sales revenue earned | 917,000 | |
| Sales discount | 35,000 | |
| Sales returns and allowances | 42,100 | |
| Cost of goods sold | 585,000 | |
| Salaries expense | 300,000 | |
| Telephone expense | 33,000 | |
| Depreciation expense- building and equipment | ||
| Insurance expense | 182,000 | |
| Store supplies expense | 45,200 | |
| Electricity expense | 85,000 | |
| bad debt expense | 49,500 | |
| Travelling expense | 62,000 | |
| Interest expense | 31,300 | |
| 3,945,900 | 3,945,900 |
The following information was made available at December 31, 2016
A.) Unearned revenue still not earned at December 31, 2016 amounted 120,000
B.) The prepaid insurance of 156,000 was paid on August 1, 2016 for 6 months to January 2017
C.) The building and equipment has an estimated life of (10) years and is being depreciated on the straight line method of depreciation, down to residual value of 10,000
D.) Accrued travelling expense amounted to 2,300 at December 31, 2016
E.) A physical count of inventory at December 31, 2016, reveals 315,000 worth of inventory on hand
Required to:
1 Prepare the necessary adjusting entries on December 31, 2016
2 Prepare the adjusted trial balance as at December 31, 2016
3 Prepare the company multi-step Income Statement for the year ended December 31, 2016
4 Prepare the company statement of Owner's Equity for the year ended December 31, 2016
5 Prepare the company classified Balance Sheet at December 31, 2016
In: Accounting
Starcups Coffee Company is launching a new sustainability
initiative that would reward customers for purchasing a reusable
cup. During the cup promotion, customers would pay an extra $1.00
for the reusable cup and would receive a 20% discount each time
they return with the cup to buy a cup of coffee.
Each week Starcups serves 41,000 customers who purchase an average
of 2.00 cups of coffee per week (82,000 cups total). Starcups’s
contribution margin income statement for a typical week is shown
below:
| Units | Per Unit | Total | ||||
| Sales Revenue | 82,000 | $ | 4.20 | $ | 344,400 | |
| Variable Cost | 82,000 | 1.60 | 131,200 | |||
| Contribution Margin | 82,000 | $ | 2.60 | $ | 213,200 | |
| Fixed Costs | 101,000 | |||||
| Net Operating Income | $ | 112,200 | ||||
Assume the new cup promotion is expected to impact sales volume,
revenue, fixed, and variable costs as follows:
Required:
1. Prepare a contribution margin income statement to
predict how the reusable cup promotion will impact weekly net
operating income.
2. Compute the difference in total revenue, total
variable costs, total contribution margin, total fixed costs, and
total operating income before and after the promotion.
In: Accounting
Create a level 1 Dataflow diagram for a ticket booking system based on the information from a usecase below
1.) the data of the ticket price can be accessed after the user logs in to the system
2.) In order for the ticket to be available in the system, the ticket has to be bought
3.) The ticket must be sold and the prices are already set or can be changed
The normall course will be,
1.1 Ticketprice data is asked for from system
I) the data of the ticket price can be accessed after the emplyee logs in to the system
II) the employe will type in the price of the ticket in the system
III) for the give time period, the system will create the reports
IV) the user will be asked to enter a destination
V) the info is sent to the entered destination
VI) the system will save the info
The alternativw course will be,
1.1 Boss or some employee from another section/dept generates the reports
1 the user is asked for a destination
2 user sends it to their own destination (themselve)
The postconditions will be,
1.) The information on reports is stored and can be altered/ modded later on
2.) report,s sent
The exceptions are going to be,
E #1 The reports don’t got enough info
1.) the system will tell the user that it cant generate the rport due to lack of provided info
2.) the employee will the be given the option to reenter the info to exit orr cancel
3.) the emp requests to again enter the info
4.) the normall course is restarted by the systm
5.) the emp tells the sys to exit
The current usecasse is terminated by the systm and exited
The sum inpurts are: the log in id and pswd of the emp, the needed info, the destination address of the recipient
The source is emp, emp, employee
The outputs are ticket price/cost data, Revenue, Cost and Net Profit Report
SentReport
The destination is system,system, recipientt
In: Computer Science
Create a level 1 Dataflow diagram for a ticket booking system based on the information from a usecase below
1.) the data of the ticket price can be accessed after the user logs in to the system
2.) In order for the ticket to be available in the system, the ticket has to be bought
3.) The ticket must be sold and the prices are already set or can be changed
The normall course will be,
1.1 Ticketprice data is asked for from system
I) the data of the ticket price can be accessed after the emplyee logs in to the system
II) the employe will type in the price of the ticket in the system
III) for the give time period, the system will create the reports
IV) the user will be asked to enter a destination
V) the info is sent to the entered destination
VI) the system will save the info
The alternativw course will be,
1.1 Boss or some employee from another section/dept generates the reports
1 the user is asked for a destination
2 user sends it to their own destination (themselve)
The postconditions will be,
1.) The information on reports is stored and can be altered/ modded later on
2.) report,s sent
The exceptions are going to be,
E #1 The reports don’t got enough info
1.) the system will tell the user that it cant generate the rport due to lack of provided info
2.) the employee will the be given the option to reenter the info to exit orr cancel
3.) the emp requests to again enter the info
4.) the normall course is restarted by the systm
5.) the emp tells the sys to exit
The current usecasse is terminated by the systm and exited
The sum inpurts are: the log in id and pswd of the emp, the needed info, the destination address of the recipient
The source is emp, emp, employee
The outputs are ticket price/cost data, Revenue, Cost and Net Profit Report
SentReport
The destination is system,system, recipientt
In: Computer Science
Create a level 1 Dataflow diagram for a ticket booking system based on the information from a usecase below
1.) the data of the ticket price can be accessed after the user logs in to the system
2.) In order for the ticket to be available in the system, the ticket has to be bought
3.) The ticket must be sold and the prices are already set or can be changed
The normall course will be,
1.1 Ticketprice data is asked for from system
I) the data of the ticket price can be accessed after the emplyee logs in to the system
II) the employe will type in the price of the ticket in the system
III) for the give time period, the system will create the reports
IV) the user will be asked to enter a destination
V) the info is sent to the entered destination
VI) the system will save the info
The alternativw course will be,
1.1 Boss or some employee from another section/dept generates the reports
1 the user is asked for a destination
2 user sends it to their own destination (themselve)
The postconditions will be,
1.) The information on reports is stored and can be altered/ modded later on
2.) report,s sent
The exceptions are going to be,
E #1 The reports don’t got enough info
1.) the system will tell the user that it cant generate the rport due to lack of provided info
2.) the employee will the be given the option to reenter the info to exit orr cancel
3.) the emp requests to again enter the info
4.) the normall course is restarted by the systm
5.) the emp tells the sys to exit
The current usecasse is terminated by the systm and exited
The sum inpurts are: the log in id and pswd of the emp, the needed info, the destination address of the recipient
The source is emp, emp, employee
The outputs are ticket price/cost data, Revenue, Cost and Net Profit Report
SentReport
The destination is system,system, recipientt
In: Computer Science
The Unadjusted Trial Balance has been prepared (provided below and also in ThreeBrothers worksheet.xlsx), showing only those accounts with a non-zero balance. You have gathered the following information that will be helpful in preparing any necessary adjusting entries (add any accounts necessary). Good luck!
|
ThreeBrothers |
Unadjusted Trial Balance |
|
|
Dec. 31, 2017 |
||
|
debit |
credit |
|
|
Cash |
4,400,000 |
|
|
Accounts Receivable |
22,500,000 |
|
|
Allowance for Bad Debts |
20,000 |
|
|
Inventory |
2,500,000 |
|
|
Purchases |
85,832,500 |
|
|
Construction in Progress Inventory |
36,000,000 |
|
|
Billings on Contract |
35,000,000 |
|
|
PP&E |
60,000,000 |
|
|
Accumulated Depreciation |
36,000,000 |
|
|
Accounts Payable |
18,000,000 |
|
|
Income Tax Payable |
136,000 |
|
|
Common Stock |
1,500,000 |
|
|
Retained Earnings |
33,444,000 |
|
|
Sales Revenue |
134,500,000 |
|
|
Sales Returns |
2,017,500 |
|
|
NEWPROD Revenue |
9,000,000 |
|
|
FITTRACKER Revenue |
10,000,000 |
|
|
Cost of NEWPROD Sold |
8,100,000 |
|
|
Cost of FITTRACKER Sold |
4,500,000 |
|
|
General and Admin |
51,750,000 |
|
|
TOTAL |
277,600,000 |
277,600,000 |
Also, in addition to its normal operations, ThreeBrothers's management entered into a long-term agreement on September 1, 2017 to supply its internally developed smart-phone-interactive fitness equipment, FITTRACKER, and maintenance support to a regional 24-hour fitness chain. The details of the agreement call for ThreeBrothers to be paid $10,000,000 up front for the equipment and 3 years of maintenance support (beginning on agreement date). The fitness chain could have bought just the equipment for $9,000,000 with no support, and they could have independently contracted for the maintenance support for $2,000,000 for the three-year period. ThreeBrothers has arranged with a 3rd-party manufacturer to make and ship the equipment direct to customers so ThreeBrothers does not carry any FITTRACKER inventory. The cost of the equipment sold to the fitness chain was $4,500,000. ThreeBrothers has recorded the $10,000,000 as a point-of-sale transaction.
1. I need the adjusting journal entry and closing journal entry, if necessary. Thank You.
In: Accounting
|
BALANCE SHEET |
||
|
December 31, 20X8 and 20X7 |
||
|
(in thousands) |
||
|
20X8 |
20X7 |
|
|
Assets |
||
|
Current assets |
||
|
Cash and cash equivalents |
$3,019 |
$1,050 |
|
Trade receivables |
485 |
450 |
|
Prepaid advertising expenses |
59 |
609 |
|
Prepaid expenses and other current assets |
175 |
230 |
|
Total current assets |
3,738 |
2,339 |
|
Fixed assets, net |
3,321 |
3,926 |
|
Total assets |
$7,059 |
$6,265 |
|
Liabilities and shareholders' equity |
||
|
Current liabilities |
||
|
Accounts payable |
$1,070 |
$ 909 |
|
Current maturities of notes payable |
42 |
316 |
|
Deferred revenue |
1,973 |
1,396 |
|
Other current liabilities |
171 |
12 |
|
Total current liabilities |
3,256 |
2,633 |
|
Long-term debt, less current maturity |
34 |
176 |
|
Accrued liabilities |
792 |
690 |
|
Deferred tax liability |
15 |
145 |
|
Total liabilities |
4,097 |
3,644 |
|
Shareholders' equity |
||
|
Common stock |
6,040 |
4,854 |
|
Retained earnings |
(3,078) |
(2,233) |
|
Total shareholders' equity |
2,962 |
2,621 |
|
Total liabilities plus shareholders' equity |
$7,059 |
$6,265 |
|
DietWeb, Inc. |
||
|
INCOME STATEMENT |
||
|
Two Years Ended December 31, 20X8 and 20X7 |
||
|
(in thousands) |
||
|
20X8 |
20X7 |
|
|
Revenue |
$19,166 |
$14,814 |
|
Costs and expenses |
||
|
Cost of revenue |
2,326 |
1,528 |
|
Product development |
725 |
653 |
|
Sales and marketing |
13,903 |
8,710 |
|
General and administrative |
2,531 |
2,575 |
|
Interest Expense |
13 |
22 |
|
Depreciation and amortization |
629 |
661 |
|
Impairment of intangible assets |
35 |
-- |
|
Total costs and expenses |
20,162 |
14,149 |
|
Net income before taxes |
(970) |
665 |
|
Income tax benefit |
129 |
125 |
|
Net income (loss) |
$ (841) |
$ 790 |
The auditor is trying to determine whether to use a horizontal or vertical analysis. In the analytic to be performed the auditor wants to understand whether the numbers as presented are reasonable.
The auditor decided to perform a horizontal analysis why did the auditor decide to so this instead of a vertical analysis?
For the balance sheet and income statement prepare a horizontal analysis
In: Accounting
What are the journal entries for the following?
13) The Board of Directors declared dividends for the common shareholders of $50,000 plus the amount due for the preferred shareholders. No dividends have been paid for the year 2018.
14) The income tax rate is 20%.
| Unadjusted | ||
| Trial | Balance | |
| ACCOUNT | DR | CR |
| Cash | 244000 | |
| Cash Equivalents | 65000 | |
| Accounts Receivable | 195000 | |
| Allowance for Doubtful Accounts | 2500 | |
| Short-Term Investments | 240000 | |
| Merchandise Inventory | 285000 | |
| Supplies Inventory | 25000 | |
| Prepaid Rent | 90000 | |
| Prepaid Insurance | 0 | |
| Long-Term Investment (60% ownership) | 360000 | |
| Land for Future Expansion | 400000 | |
| Debt Service Fund | 950000 | |
| Land | 400000 | |
| Machinery & Equipment | 4600000 | |
| Buildings | 3100000 | |
| Accumulated Depreciation | 542500 | |
| Patents | 245000 | |
| Copyright | 123000 | |
| Goodwill | 75000 | |
| Trademark | 135000 | |
| Derivatives | 50000 | |
| Deferred Tax Assets | 240000 | |
| Deferred Pension Assets | 230000 | |
| Accounts Payable | 175000 | |
| Income Taxes Payable | 95000 | |
| Sales Taxes Payable | 34000 | |
| Dividends Payable | 0 | |
| Interest Payable | 14000 | |
| Notes Payable (8% interest rate) | 1000000 | |
| Mortgage Payable (5% interest rate) | 850000 | |
| Bonds Payable (6% interest rate) | 2500000 | |
| Common Stock (1,000,000 shares outstanding) | 1000000 | |
| Preferred Stock (4%) | 500000 | |
| Paid-in Capital in Excess of Par - Common | 1800000 | |
| Paid-in Capital in Excess of Par - Preferred | 200000 | |
| Retained Earnings | ||
| Accumulated Other Comprehensive Income | 29000 | |
| Sales Revenue | 9800000 | |
| Sales Returns & Allowances | 37000 | |
| Sales Discounts | 56000 | |
| Cost of Goods Sold | 3517000 | |
| Selling Expense | 482200 | |
| General Administrative Expense | 2120000 | |
| Rent Expense | 0 | |
| Insurance Expense | 136000 | |
| Research and Development Expense | 120000 | |
| Impairment Expense | 0 | |
| Bad Debts Expense | 0 | |
| Interest Revenue | 22000 | |
| Dividend Revenue | 35000 | |
| Other Expense | ||
| Interest Expense | 95000 | |
| Income Tax Expense | 0 | |
| Gain / Loss on Derivatives | 0 | 0 |
|
TOTALS |
18640700 | 18640700 |
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 65 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,960 | |||||
| Classroom supplies | $ | 270 | |||||
| Utilities | $ | 1,210 | $ | 70 | |||
| Campus rent | $ | 4,700 | |||||
| Insurance | $ | 2,000 | |||||
| Administrative expenses | $ | 3,800 | $ | 41 | $ | 6 | |
For example, administrative expenses should be $3,800 per month plus $41 per course plus $6 per student. The company’s sales should average $870 per student.
The company planned to run four courses with a total of 65 students; however, it actually ran four courses with a total of only 59 students. The actual operating results for September appear below:
| Actual | ||
| Revenue | $ | 53,650 |
| Instructor wages | $ | 11,120 |
| Classroom supplies | $ | 17,400 |
| Utilities | $ | 1,900 |
| Campus rent | $ | 4,700 |
| Insurance | $ | 2,140 |
| Administrative expenses | $ | 3,780 |
Required:
Prepare a flexible budget performance report that shows both revenue and spending variances and activity variances for September. (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
Suppose you are the Chief Marketing Officer for a retailer that has data on the home addresses of its
1,000,000 most active customers. You hope to determine whether sending out “20% off your entire
purchase” coupons by mail will increase revenues.
You conjecture that customers who have access to this coupon will spend more in the store over the
next year. However, skeptics in your company argue that the coupons will just allow customers to
spend less on items they would have purchased anyway. This is a debate that an experiment can
resolve.
In thinking about how large of an experiment you need to have enough statistical power, you realize
that many of the customers you send the coupons to in the mail will not open the mail and so will not
realize they received the coupon.
1. The CEO argues that to estimate the effects of the coupons on revenue, you should compare
the difference in revenues from a) people you sent the coupons and who used them and b)
people you sent the coupons but who did not use them. Write a response to your CEO:
describe the flaw with this plan in language the CEO will understand, and advocate for your
proposed experiment.
2. To avoid the cost of sending out coupons you do not need to, you ask the data science team
to plan an experiment just large enough (with just enough statistical power) to reliably detect
a treatment effect if the true effect on those who open the mail and realize they have the
coupon is a $2 increase in revenue over the next year. The data science team tells you that
an experiment with 100,000 people in the treatment group (leaving the remaining 900,000 in
the control group) will be well-powered to detect an overall difference between the entire
treatment and control groups of $2 in revenue over the next year. To send out the minimum
number of coupons required while still having enough statistical power to detect a $2 effect of
opening the mail, can you send out fewer, the same number of, or more coupons than
100,000?
In: Statistics and Probability