Prepare Strange Things cash budget for the months of October, November, and December showing all receipts, disbursements, and credit line activity, where applicable.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 39P
icon
Related questions
Question
100%

Helping tags: Accounting, Cost accounting

.

.

.

WILL UPVOTE, just pls help me answer what is needed at the end of the picture and show complete solutions. Thank you!

Case 2:
Strange Things is an independently owned major appliance and electronics discount
chain with seven stores located in a Midwest metropolitan area. Rapid expansion has
created the need for careful planning of cash requirements to ensure that the chain is
able to replenish stock adequately and meet payment schedules to creditors. Steve
Harrington, founder of the chain, has established a banking relationship that provides a
$200,000 line of credit to Strange Things. The bank requires that a minimum balance of
$8,200 be kept in the chain's checking account at the end of each month. When the
balance goes below $8,200, the bank automatically extends the line of credit in multiples
of $1,000 so that the checking account balance is at least $8,200 at month-end. Strange
Things attempts to borrow as little as possible and repays the loans quickly in multiples.
of $1,000 plus 2 percent monthly interest on the entire loan balance. Interest payments
and any principal payments are paid at the end of the month following the loan. The chain
currently has no outstanding loans.
The following cash receipts and disbursements data apply to the fourth quarter of the
current calendar year:
www
Strategic Cost Management (STRACO)
1954
Estimated beginning cash balance
Estimated cash sales:
October
November
December
Sales on account:
$ 8,800
$ 14,000
29,000
44,000
$130,000
July (actual)
August (actual)
September (actual)
104,000
128,000
October (estimated)
135,000
142,000
November (estimated)
December (estimated)
188,000
Projected cash collection of sales on account is estimated to be 70 percent in the month
following the sale, 20 percent in the second month following the sale, and 6 percent in
the third month following the sale. The 4 percent beyond the third month following the
sale is determined to be uncollectible. In addition, the chain is scheduled to receive
$13,000 cash on a note receivable in October.
All inventory purchases are made on account as the chain has excellent credit with all
vendors because of a strong payment history. The following information regarding
inventory purchases is available:
Inventory Purchases
September (actual)
$120,000
October (estimated)
112,000
November (estimated)
128,000
December (estimated)
95,000
Cash disbursements for inventory are made in the month following purchase using an
average cash discount of 3 percent for timely payment. Monthly cash disbursements for
operating expenses during October, November, and December are estimated to be
$38,000, $41,000, and $46,000, respectively.
Required:
Prepare Strange Things cash budget for the months of October, November, and
December showing all receipts, disbursements, and credit line activity, where applicable.
Transcribed Image Text:Case 2: Strange Things is an independently owned major appliance and electronics discount chain with seven stores located in a Midwest metropolitan area. Rapid expansion has created the need for careful planning of cash requirements to ensure that the chain is able to replenish stock adequately and meet payment schedules to creditors. Steve Harrington, founder of the chain, has established a banking relationship that provides a $200,000 line of credit to Strange Things. The bank requires that a minimum balance of $8,200 be kept in the chain's checking account at the end of each month. When the balance goes below $8,200, the bank automatically extends the line of credit in multiples of $1,000 so that the checking account balance is at least $8,200 at month-end. Strange Things attempts to borrow as little as possible and repays the loans quickly in multiples. of $1,000 plus 2 percent monthly interest on the entire loan balance. Interest payments and any principal payments are paid at the end of the month following the loan. The chain currently has no outstanding loans. The following cash receipts and disbursements data apply to the fourth quarter of the current calendar year: www Strategic Cost Management (STRACO) 1954 Estimated beginning cash balance Estimated cash sales: October November December Sales on account: $ 8,800 $ 14,000 29,000 44,000 $130,000 July (actual) August (actual) September (actual) 104,000 128,000 October (estimated) 135,000 142,000 November (estimated) December (estimated) 188,000 Projected cash collection of sales on account is estimated to be 70 percent in the month following the sale, 20 percent in the second month following the sale, and 6 percent in the third month following the sale. The 4 percent beyond the third month following the sale is determined to be uncollectible. In addition, the chain is scheduled to receive $13,000 cash on a note receivable in October. All inventory purchases are made on account as the chain has excellent credit with all vendors because of a strong payment history. The following information regarding inventory purchases is available: Inventory Purchases September (actual) $120,000 October (estimated) 112,000 November (estimated) 128,000 December (estimated) 95,000 Cash disbursements for inventory are made in the month following purchase using an average cash discount of 3 percent for timely payment. Monthly cash disbursements for operating expenses during October, November, and December are estimated to be $38,000, $41,000, and $46,000, respectively. Required: Prepare Strange Things cash budget for the months of October, November, and December showing all receipts, disbursements, and credit line activity, where applicable.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Challenges in accounting and analysis of international transactions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT