You are presented with a trial balance as of the end of 2018 and must add the transactions and activities that occurred in the first quarter of 2019 as listed below. You can add accounts to the trial balance, as needed.
January 1: The owners hire Nina Marton to manage the store, paying her a salary of $2,600 a month. Lisa is paid on the 1st of every month, starting on February 1 (which would represent her January pay). They have one other employee who they pay $1,600 a month, also on the 1st of the following month. Employees work 40 hours a week.
January 14: Paid utilities for 4th quarter of 2018, $775.
February 1: Installed new light fixtures and display cases in the leased store. CWB paid $1,900 for the fixtures, $150 for shipping to the store, and $400 to an electrician to install. CWB paid 6% sales tax on the fixtures and shipping in addition to the cost of the fixtures and equipment. It did not pay a sales tax to the electrician.
The landlord gave CWB permission to remove and dispose of the old fixtures. CWB sold the old fixtures for $200. CWB anticipates being in the store for at least 5 years. CWB cannot take the light fixtures with them if they relocate as they will revert to the lessor.
CWB can take the display cases if they move. The display cases cost $2,800. CWB also incurred 6% sales tax on the display cases on addition to their cost.
Both the display cases and light-fixtures have a seven-year useful life.
February 10: CWB made a payment of $5,500 on its accounts payable.
March 1: CWB invests in a $4,000 3-month treasury bill paying interest of 3.0%.
March 12: One of the standard bikes sold on February 21 was returned by the customer. The bike sold for $400. CWB provided a full refund. CWB’s policy is to provide a customer with a full refund within 30 day of purchase as long as the bike is returned in good condition. While the bike is in good working condition, CWB does not anticipate being able to sell the bike as new – rather it anticipates marking it down and selling it for $190.
March 24: A customer puts down a deposit of $500 on a high-end racing bike that sells for $2,900. CWB ordered the bike from the manufacturer. The manufacturer promises CWB will have the bike at the store on April 3.
Here is other information on other activity and recurring transactions that occurred during the period.
Month |
Number of Tune-Ups |
January |
14 |
February |
36 |
March |
42 |
Date |
Transaction |
Quantity |
Cost per Bike |
Beginning Inventory |
25 |
$110 |
|
January 25 |
Sale |
15 |
|
February 8 |
Purchase |
30 |
$115 |
February 14 |
Sale |
16 |
|
February 27 |
Sale |
15 |
|
March 2 |
Purchase |
28 |
$120 |
March 17 |
Sale |
20 |
+All purchasers of standard bikes are given the option of buying a bike for $400, or a bike with two years of tune-ups for $500. Four of the bikes sold on February 21st were sold with the tune-up option.
**All purchases were made using cash except the March 2nd purchase for which CWB obtained two-months credit from the bike supplier.
Cherry & White Bike Company
Post-Closing Trial Balance
12/31/2018
Account Title |
Debit |
Credit |
Cash |
$30,100 |
|
Store supplies |
460 |
|
Prepaid rent |
900 |
|
Prepaid insurance |
1,650 |
|
Inventory – standard bikes (25 bikes) |
2,750 |
|
Equipment |
15,500 |
|
Accumulated depreciation - equipment |
$4,350 |
|
Accounts payable |
8,724 |
|
Utilities payable |
775 |
|
Salaries payable |
1,600 |
|
Interest payable |
1,200 |
|
Loans payable |
10,000 |
|
Capital stock |
20,000 |
|
Retained Earnings |
4,711 |
|
Totals |
$51,360 |
$51,360 |
Round all intermediate computations to three decimals. Enter your final answer in dollars (no cents). Make your allocation using the standalone selling prices for the tune-ups and the bike for 2.
1. What is the total amount of the tune-up revenue for the three months ending March 31, 2019? 2. For one bike sold with the tune-up option on February 27th, what is the amount of the transaction price allocated to bike sales? Price to tune ups? 3. What is the total sales revenue and unearned revenue for bike sales for the three months ending March 31, 2019?
1 | Total amount of Tune up revenue for the three months ending March 31, 2019 | |||
Month | Number of tune-up | Tune-up price | Tune-up revenue | |
January | 14 | $80 | $1,120 | |
February | 36 | $80 | $2,880 | |
March | 42 | $80 | $3,360 | |
Total revenue | $7,360 | |||
Deferred revenue for tune-up on option of buying bike with two-years tune-ups is $332 (4 x $83) | ||||
2 | Amount of transaction price allocated to bike sale and tune-ups | |||
Stand alone price of bike sale | $400 | |||
Stand alone price of tune-up | $80 | |||
Total | $480 | |||
Allocation of price to bike sale (400/480*500) | $417 | |||
Allocation of price to tune-up(80/480*500) | $83 | |||
Total transaction price | $500 | |||
3 | Total sales revenue and unearned revenue for bike sales for the three months ending March 31, 2019 | |||
Month | Number of bikes sold | Sale Price | Sales Revenue | |
January | 15 | $400 | $6,000 | |
February | 27 | $400 | $10,800 | |
February | 4 | $417 | $1,667 | |
March | 20 | $400 | $8,000 | |
Total revenue | $26,467 | |||
Less: Sales return | $400 | |||
Net Sales revenue | $26,067 | |||
Unearned revenue for bike sales is $500 for high end bike |
You are presented with a trial balance as of the end of 2018 and must add...
please full calculation and explanation. PetPlace requires a minimum cash balance of $30,000 at the end of March of the current year in order to remodel its store. Any required borrowings take place in increments of $10,000 with interest of 1.5% per month. Repayments of borrowed funds are also made in increments of $10,000. Assume that borrowings are made on the first day of the month in which the cash is required, and that repayments are made on the last...
To prepare a master budget for January, February, and March of 2020, management gathers the following information. The company’s single product is purchased for $20 per unit and resold for $56 per unit. The expected inventory level of 5,250 units on December 31, 2019, is more than management’s desired level, which is 20% of the next month’s expected sales (in units). Expected sales are January, 7,250 units; February, 9,000 units; March, 10,750 units; and April, 10,000 units.Cash sales and credit sales...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 612,000 Less: Accumulated depreciation 76,500 Equipment, net 535,500 Total assets $ 1,197,000 Liabilities and Equity Accounts payable $ 375,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 476,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 612,000 Less: Accumulated depreciation 76,500 Equipment, net 535,500 Total assets $ 1,197,000 Liabilities and Equity Accounts payable $ 375,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 476,000...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,000 Accounts receivable 520,000 Inventory 135,000 Total current assets $ 691,000 Equipment 600,000 Less: Accumulated depreciation 75,000 Equipment, net 525,000 Total assets $ 1,216,000 Liabilities and Equity Accounts payable $ 340,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 88,000 Total liabilities $ 440,000...
SlippyLtd has been in business for several years. They are in the midst of preparing their quarterly budgets for the first three months starting on 1" January 2019. 1. Sales for November 2018 and December 2018were $75,000 and $83,000 respectively. Forecast sales for the first three months in 2019 are as follows: January 2019 $90,000 February 2019 $100,000 March 2019 $120,000 All sales are on the following terms: 20% on cash basis and remainder is on credit terms. All credit sales are on average are...
PROBLEM 83 Objective The objective of Problem is to reinforce your understanding of the preparation of Operating and Financial Budgets. come concerned about the cashed for the business ows. You have been asked to prepare the productive and sales of water bottles for the first quarter of 2020: the three months March and the quarter to L i the process with a poc es but at the h at he will have no need to purchase additional lids through the...
This is all one question. Thank you, I will give you a thumbs up if correct! Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 Unit sales for December 2019 Expected unit sales for January 2020 Expected unit sales for February 2020 Expected unit...
Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017 DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2817 Assets Cash Accounts receivable Inventory Total current assets Equipment Less: accumulated depreciation $ 36,588 52e,888 2,500 699,800 576,8e0 Equipment, net Total assets 504,888 $1,283,8e8 Liabilities and Equity Accounts payable Bank loan payable Taxes payable (due 3/15/2818) Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. Estimated Balance Sheet Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 612,000 Less: Accumulated depreciation 76,500 Equipment, net 535,500 Total assets $ 1,197,000 Liabilities and Equity Accounts payable $ 375,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 476,000 Common stock 474,500 Retained earnings 246,500...