Reference no: EM131696309
Kline Sisters Company operates a gift shop where peak sales and activity occur in the months of December and January. Data regarding the store's operations follow:
Sales are budgeted at $360,000 for January, 320,000 for February, and $250,000 for March and $240,000 in April.
Collections are expected to be 30% in the month of sale, 65% in the month following the sale, 3% in the second month following sale and 2% uncollectible.
The cost of goods sold is 76% of sales.
The company desires ending merchandise inventory to equal 13% of the following month's cost of goods sold. Payment for merchandise is made 50% in the month of purchase and 50% in the month following the purchase.
Monthly operating expenses to be paid in cash are $12,000.
Equipment purchases of $40,000 in February and $30,000 in March were paid in cash.
Monthly depreciation is $15,000.
Dividends of $40,000 were declared and paid in January.
Any borrowings must be in $1,000 increments at 12% annual interest. Assume interest accrues at the beginning of the month and is paid at the end of the month.
The company must maintain a minimum cash balance of $30,000.
Ignore income taxes.
All accounts receivable from December 31 will be collected in January and all accounts payable at December 31 will be paid in January.
The balance sheet as of December 31st:
Kline Sisters Company
|
|
|
Balance Sheet
|
|
|
12/31/14
|
|
|
|
|
|
|
|
Assets:
|
|
|
|
Cash
|
|
|
$22,000
|
Net Accounts Receivable
|
|
$83,000
|
Merchandise Inventory
|
|
$36,000
|
Property Plant and Equipment
|
$1,600,000
|
|
Less: accumulated depreciation
|
$588,000
|
$1,012,000
|
Total Assets
|
|
|
$1,153,000
|
|
|
|
|
Liabilities & Stockholder's Equity
|
|
Accounts Payable
|
|
$190,000
|
Common Stock
|
|
$350,000
|
Retained Earnings
|
|
$613,000
|
Total liabilities and stockholder's equity
|
|
$1,153,000
|
Prepare the following budgets for each month January, February, March and Total for the quarter in good form in excel with proper use of formulas and formatting:
a. Prepare a Schedule of Expected Cash Collections
b. Prepare a Merchandise Purchases Budget and a Schedule of Expected Cash Disbursements
c. What is the budgeted accounts payable at March 31st ?How much does the company need to borrow for the quarter? How much can the company repay for the quarter?
d. Prepare a Budgeted Income Statement
Discuss significant differences in americas approach
: Discuss 2 significant differences in America's approach to imprisonment before, and after the US Constitution was written. (Minumum 100 words).
|
Commenting on plans for correcting the medical coder
: Health Information Management (HIM) professionals must be aware of the laws affecting fraud and abuse, in addition to the laws affecting the management
|
Quality thinking is significant for an accurate evaluation
: Explain why it is significant for an accurate evaluation of your own critical thinking
|
Discuss the merits of blocking
: Discuss the merits of blocking in this case as compared with the completely randomized design.
|
Prepare merchandise purchases budget
: ACCT 116 Budget Assignment - Prepare a Schedule of Expected Cash Collections and Prepare Merchandise Purchases Budget and a Schedule of Expected Cash Disbursem
|
Promote correct coding and avoid inappropriate
: The National Correct Coding Initiative (NCCI), also known as CCI, was established to promote correct coding and avoid inappropriate payment to providers.
|
Eliminate all the information about content themes.
: Eliminate all the information about content themes. Eliminate all other questions, (save them for creating interview questions).
|
What do you believe the future of community policing is
: How do law enforcement and community members in the community policing effort that you chose to analyze go about establishing and maintaining.
|
Explain all the training methods are equally effective
: The results were analyzed using a block design ANOVA. The results of the analysis include: SSTR = 9,875, SSBL = 1,445, and SST = 22,364.
|