Reference no: EM13503452
Question
Kobayashi LLP wants a cash budget for the next three months, beginning January 1, 2015. The company desires an ending minimum cash balance of $10,000 each month. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid only at the time of payment of principal. The interest rate is 12 percent per annum. (Calculate interest on whole months, e.g., 1/12, 2/12)
The following data have been gathered for the preparation of the cash budget for the first quarter of 2015:
a) Balance sheet as at 31 December 2014 are as follows:
Kobayashi LLP
Balance Sheet as at 31 December 2014
|
Assets
Cash
|
$ 20,000
|
|
Accounts receivable
|
200,000
|
|
Inventory
|
80,000
|
|
Plant and equipment, net
|
500,000
|
|
Total
|
800,000
|
|
Liabilities and Equity
Accounts payable
|
$ 98,000
|
|
Capital stock
|
500,000
|
|
Retained earnings
|
202,000
|
|
Total
|
800,000
|
b) Actual sales for December 2014 and budgeted sales for the next four months are as follows:
December (actual) . . . . . . . . $250,000
|
January . . . . . . . . . . . . . . . .
|
350,000
|
|
February . . . . . . . . . . . . . . . .
|
400,000
|
|
March . . . . . . . . . . . . . . . . .
|
500,000
|
|
April . . . . . . . . . . . . . . . . . .
|
400,000
|
c) Sales are 20 percent for cash and 80 percent on credit. All credit sale terms are net 30; therefore, accounts are collected in the month following sale.
d) The company's gross profit rate is 60 percent of sales.
e) Monthly expenses are budgeted as follows: salaries and wages, $40,000 per month; advertising, $30,000 per month; sales commissions, 3 percent of sales; depreciation, $8,000 per month; other operating expense, 5 percent of sales. These expenses are paid in the month they are incurred.
e) The company's inventory policy is to acquire enough inventories each month to equal the following month's projected cost of goods sold. All purchases are paid for in the month following purchase.
f) The company plans to buy a new machine for $200,000 cash in January. During March, other equipment will be purchased for cash at a cost of $40,000
g) The company will declare and pay $10,000 in cash dividends in January.
Required:
Using the data above, prepare the following schedules for a master budget for the first quarter:
i. Sales budget and schedule of expected cash collections
ii. Cost of goods sold and inventory purchases budget
iii. Schedule of cash disbursements for purchases
iv. Schedule of cash disbursements for expenses
v. Cash budget
|
Explain what is the concentraton of kmno4 solution
: Other Kinds of titrations are possible in addition to acid-base titrations. For example, the concentration of a solution of potassium permanganate, KMnO4, can be determined by titration against a known amount of oxalic acid, H2C2O4, accoiding to t..
|
|
Find how much power is dissipated by each bulb
: Two 75.0 W (120 V) lightbulbs are wired in series, then the combination is connected to a 230 V supply. How much power is dissipated by each bulb
|
|
Explain deodorized by reaction with household bleech
: The order of skunks is caused by chemical compounds called thiols. These compounds, of which butanethiol(C4H10S) is a representative example, can be deodorized by reaction with household bleech (NaOCl) according to the following equition:
|
|
Find the moment of inertia of the earth
: Assume the earth is a sphere with its mass evenly distributed throughout. Find the moment of inertia of the earth about its axis of rotation
|
|
Discuss cash budget
: Kobayashi LLP wants a cash budget for the next three months, beginning January 1, 2015. The company desires an ending minimum cash balance of $10,000 each month. An open line of credit is available at a local bank for any borrowing that may be nee..
|
|
Find the magnitude of the current flowing through the tube
: A tube with a 5.0 mm radius has ions flowing through it. To determine the rate at which the charge is being moved through the tube, find the magnitude of the current flowing through the tube
|
|
Explain what error does this minimize and why
: Glass cuvette, used for precision measurements in a spectrometer, are marked so that they always have the same orientation in the sample compartment. What error does this minimize and why
|
|
Compute the mass of ice melted as a result of the friction
: A block of ice at 0°C whose mass initially is m = 48.4 kg slides along a horizontal surface, starting at a speed vo = 4.91 m/s, Compute the mass of ice melted as a result of the friction between the block and the surface
|
|
Explain the rate of the reaction of methyl ethyl acetate
: The rate of the reaction of methyl ethyl acetate with hydroxide to form acetate ion and ethanol as shown in the following reaction, CH3COOC2H5(aq) + OH-(aq) => CH3COO-(aq) + C2H5OH(aq) was measured at several temperatures and the following dat..
|