BUDGETING AND PLANNING Iron Creatures Enterprises, a merchandising entity, has p
ID: 2471286 • Letter: B
Question
BUDGETING AND PLANNING
Iron Creatures Enterprises, a merchandising entity, has provided the following budgeted information:
Cash sales account for one-fifth of total sales, while the remaining four-fifths are on account. Iron Creatures budgets
for sales of 10,000 units in February. Unit sales projected for March, April, and May are 12,000 (March), 11,000
(April), and 14,000 units (May).
Past experience indicates collections on account are as follows:
• 40% will be collected in the month of sale
• 45% will be collected in the following month
• 10% will be collected in the 2nd month following the sale
• 5% are never collected
Purchases of merchandise inventory are all on credit; 25% is paid in the month of purchase, 50% is paid in the 1st
month after the purchase and 25% in the 2nd month following the purchase.
Other items budgeted include the following:
A) Selling and Administrative Expenses of $70,000 per year, including $10,000 of annual depreciation expense
B) Equipment costing $45,000 will be purchased for cash in April
C) Fixed assets with a cost of $30,000 and accumulated depreciation of $18,000 will be sold in May; a gain of
$5,000 is expected to be realized
D) The company will purchase stock of various other companies in the month of April, paying $20,000 cash
E) Interest on any line of credit loan must be paid monthly
Iron Creatures wishes to maintain a minimum cash balance of $12,000 at the end of each month. The company
borrows money from the bank at 6% interest if necessary to maintain the minimum cash balance. Borrowed money
is repaid in months when there is an excess cash balance. The beginning cash balance on April 1 is projected to be
$12,000. The beginning loan balance on April 1 is projected to be $31,000.
1) Complete the supporting schedules for cash collections from sales and cash payments for merchandise.
CASH COLLECTIONS ON SALES
Collection Month
CASH PAYMENTS ON MERCHANDISE PURCHASES
Payment Month
Purchase Month
CREDIT SALES
2) Prepare a cash budget for Iron Creatures Enterprises for the months of April and May. Be sure to indicate the
ending cash balance and ending loan balance for each month.
APRIL MAY
Beginning of Month Loan Balance $ ___________________ $ ___________________
Beginning of Month Cash Balance $ ___________________ $ ___________________
Add: Collections from Customers
Cash Sales ___________________ ___________________
Credit Sales ___________________ ___________________
Add: _______________________ ___________________ ___________________
Less: Payment for Merchandise Purchases ___________________ ___________________
Less: _______________________ ___________________ ___________________
Less: _______________________ ___________________ ___________________
Less: _______________________ ___________________ ___________________
Less: _______________________ ___________________ ___________________
Preliminary End of Month Cash Balance ___________________ ___________________
Add: Loan Additions ___________________ ___________________
Less: Loan Payments ___________________ ___________________
End of Month Cash Balance $ ___________________ $ ___________________
End of Month Loan Balance $ ___________________ $ ___________________
Explanation / Answer
Unit Selling Price in Feb. $100000/10000= $10 we have taken this price for all month.
CASH PAYMENTS ON MERCHANDISE PURCHASES
Sale for month of Feb. March April May Sale Unit 10000 12000 11000 14000 Selling Price $10.00 $10.00 $10.00 $10.00 Expected Sales $100,000.00 $120,000.00 $110,000.00 $140,000.00 Cash Sales @ 40% $20,000.00 $24,000.00 $22,000.00 $28,000.00 Credit Sales 60% $80,000.00 $96,000.00 $88,000.00 $112,000.00Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.