Reference no: EM131286286
Lewis is a merchandising company. Each month they buy the inventory that they expect to sell the next month. Then they pay for it 50% in the month of purchase and 50% the next month. The purchase price is $50.
The sales commission is 6% and is paid in the month following the sales. Variable costs are 20% of sales and is paid 80% in the month incurred and 20% the following month.
Fixed costs are: Depreciation = $3,000 per month
Insurance = $1,200 per month paid on 1-1 and 7-1
Taxes = $800 per month and paid on 1-1.
Salaries = $12,000 per month paid when incurred
They plan on buying equipment for $10,000 in January and pay for it then.
The beginning cash balance is $10,000
Sales Price is $80 per unit. 10% of sales are cash and the rest credit. The collection pattern is: 30% in month of sale, 50% the next month and 20% two months later.
Sales
October, 2015= 8,000
November, 2015 = 9,000
December, 2015 = 10,000
January, 2016 = 9,000
February, 2016 = 8,000
March, 2016 = 8,500
April ,2016 = 10,000
Prepare a cash budget for the first quarter of 2016. If a loan is needed, a line of credit has been established at the bank. The loan would be taken out on the first of the month and repaid at the end of the month when all can be paid. The rate is 6%.
|
Prepare journal entry to record the estimated uncollectibles
: During its first year of operations, Sandhill Co. had credit sales of $3,208,100, of which $434,300 remained uncollected at year-end. The credit manager estimates that $19,120 of these receivables will become uncollectible. Prepare the journal entry ..
|
|
The sarbanes-oxley act
: The Sarbanes-Oxley Act
|
|
LIFO versus FIFO
: You have just been hired as a consultant to Tangier Industries, a newly formed company. The company president, John Meeks, is seeking your advice as to the appropriate inventory method Tangier should use to value its inventory and cost of goods sold...
|
|
Company uses perpetual inventory system
: On September 1, Boylan Office Supply had an inventory of 35 calculators at a cost of $13 each. The company uses a perpetual inventory system. During September, the following transactions occurred. 14 Granted credit of $41 to Lee Book Store for the re..
|
|
Line of credit has been established at the bank
: Lewis is a merchandising company. Each month they buy the inventory that they expect to sell the next month. Then they pay for it 50% in the month of purchase and 50% the next month. The purchase price is $50. Prepare a cash budget for the first quar..
|
|
Determine total comprehensive income
: Matilda Company reported the following amounts (in euros) in 2015: Net income, €150,000; Unrealized gain related to revaluation of buildings, €10,000; and Unrealized loss on non-trading securities, €(35,000). Determine Matilda’s total comprehensive i..
|
|
Effective interest method-prepare bond amortization schedule
: Metlock Co. is building a new hockey arena at a cost of $2,420,000. It received a downpayment of $510,000 from local businesses to support the project, and now needs to borrow $1,910,000 to complete the project. Prepare a bond amortization schedule u..
|
|
The amount of net income or net loss was
: If beginning capital was $28,000, ending capital is $65,000, and the owner's withdrawals were $31,000, the amount of net income or net loss was: The balance in the prepaid rent account before adjustment at the end of the year is $15,000, which repres..
|
|
Compute the total-price and quantity variances for materials
: Ceelo Company purchased (at a cost of $10,200) and used 2,400 pounds of materials during May. Ceelo's standard cost of materials per unit produced is based on 2 pounds per unit at a cost $5 per pound. Production in May was 1,050 units. Compute the to..
|