
Concept explainers
1.
Compute the amount of cash collection form the credit sales in each of the month of March and April.
1.

Explanation of Solution
Cash receipts Budget: This budget gives an estimation of all the
Compute the amount of cash collection form the credit sales in each of the month of March and April.
From sales in | Total | % Collected | March | April |
January | $396,000 | 23% | $91,080 | |
February | $495,000 | 35% | $173,250 | |
23% | $113,850 | |||
March | $418,000 | 40% | $167,200 | |
35% | $146,300 | |||
April | $412,500 | 40% | $165,000 | |
Total collected | $431,530 | $425,150 |
Table (1)
2.
Compute the budgeted ending inventories (in units) for January, February, March, and April.
2.

Explanation of Solution
Inventory: The account that reports the cost of unsold goods for a business is called inventory. Based on the accounting cycle, inventory is categorized as opening inventory that is the balance of inventory at the beginning of accounting period and closing inventory that is the balance of inventory at the end of accounting period.
Compute the budgeted ending inventories (in units) for January, February, March, and April.
Particulars | January | February | March | April |
Next month’s budgeted sales | 22,500 | 19,000 | 18,750 | 21,000 |
Multiply: Ratio of inventory to future sales | ||||
Budgeted “base” ending inventory | 4,500 | 3,800 | 3,750 | 4,200 |
Add: Safety stock | 100 | 100 | 100 | 100 |
Budgeted ending inventory | 4,600 | 3,900 | 3,850 | 4,300 |
Table (2)
3.
Prepare the merchandise purchase budgets for February, March, and April.
3.

Explanation of Solution
Merchandise Purchase Budget
The budget that shows the estimated cost of goods to be purchased to meet expected sales of a merchandiser is known as Merchandise Purchase Budget. It is similar to the production budget that is used by the manufacturer in a manufacturing concern.
Prepare the merchandise purchase budgets for February, March, and April.
Company C | |||
Merchandise Purchases Budgets | |||
For February, March, and April | |||
February | March | April | |
Budgeted ending inventory | $3,900 | $3,850 | $4,300 |
Add: Budgeted sales | $22,500 | $19,000 | $18,750 |
Required units of available merchandise | $26,400 | $22,850 | $23,050 |
Less: Beginning inventory | -$4,600 | -$3,900 | -$3,850 |
Budgeted purchases (units) | $21,800 | $18,950 | $19,200 |
Multiply: Budgeted cost per unit | |||
Budgeted cost of merchandise purchases | $261,600 | $227,400 | $230,400 |
Table (3)
4.
Compute the cash payments on product purchases for March and April.
4.

Explanation of Solution
Compute the cash payments on product purchases for March and April.
From purchases in | Total | % Paid | March | April |
February | $261,600 | 70% | $183,120 | |
March | $227,400 | 30% | $68,220 | |
70% | $159,180 | |||
April | $230,400 | 30% | $69,120 | |
Total paid | $251,340 | $228,300 |
Table (4)
5.
Prepare a
5.

Explanation of Solution
Cash Budget: The cash budget is a part of the financial statements which is a plan for the cash receipts and expenses for a particular accounting period. This budget gives an estimation of all the cash inflows and outflows of a business for the given financial period.
Prepare a cash budget for March and April.
Company C | ||
Cash Budget | ||
For March and April | ||
Particulars | March | April |
Beginning cash balance | $50,000 | $58,070 |
Cash receipts from customers | $431,530 | $425,150 |
Total available cash (1) | $481,530 | $483,220 |
Cash disbursements | ||
Payments on purchases | $251,340 | $228,300 |
Selling and administrative expenses | $160,000 | $160,000 |
Interest expense | $120 | $0 |
Total disbursements (2) | $411,460 | $388,300 |
Preliminary cash balance (3) | $70,070 | $94,920 |
Additional loan from bank | ||
Repayment of loan to bank | -$12,000 | ________ |
Ending cash balance | $58,070 | $94,920 |
Ending loan balance | $0 | $0 |
Table (5)
Working note:
Calculate the amount interest expense for March.
6.
Identify whether the company must borrow additional funds at the end of March, based on the analysis of cash budget, and suggest some reasons for knowing the loan needs in advance.
6.

Explanation of Solution
Cash budget for the month of March indicates that the company has no need to borrow additional funds at the end of March, because it has enough cash balance at the end of the March month.
However, management must be well informed about the future supply of cash for meeting the loan needs in advance. A good cash budget helps the management in negotiating the loan terms.
Want to see more full solutions like this?
Chapter 22 Solutions
Principles of Financial Accounting, Chapters 1-17 - With Access (Looseleaf)
- Suppose that Sandhill Trading Post has the following inventory data: July 1 Beginning inventory 46 units at $23 $1058 7 Purchases 162 units at $24 3888 22 Purchases 23 units at $26 598 $5544 The company uses a periodic inventory system. A physical count of merchandise inventory on July 31 reveals that there are 58 units on hand. Using the LIFO inventory method, the amount allocated to cost of goods sold for July is ○ $4198. ○ $4036. ○ $3932. ○ $4106.arrow_forwardSuppose that Sandhill Trading Post has the following inventory data: July 1 Beginning inventory 46 units at $23 $1058 7 Purchases 162 units at $24 3888 22 Purchases 23 units at $26 598 $5544 The company uses a periodic inventory system. A physical count of merchandise inventory on July 31 reveals that there are 58 units on hand. Using the LIFO inventory method, the amount allocated to cost of goods sold for July is ○ $4198. ○ $4036. ○ $3932. ○ $4106.arrow_forwardSuppose that Ivanhoe Depot Inc. has the following inventory data: July 1 Beginning inventory 24 units at $19 $456 7 Purchases 84 units at $20 1680 22 Purchases 12 units at $22 264 $2400 The company uses a periodic inventory system. A physical count of merchandise inventory on July 31 reveals that there are 40 units on hand. Using the FIFO inventory method, the amount allocated to ending inventory for July is ○ $824. 000 $800. ○ $880. ○ $776.arrow_forward
- Assume the following informationarrow_forwardThe addition of the cost of goods sold (COGS) and gross profit is the main way that a merchandising company's income statement differs from that of a service organization. Since a merchandising business makes their money by selling material goods, sales revenue, COGS, and gross profit before operating expenditures are subtracted which are all included in its income statement. A service company, on the other hand, does not have a COGS section because they have no inventory involved but instead generates their income through the delivery of services (Weygandt, Kimmel, & Kieso, 2022). The income statement of a merchandising company will usually have only a single-step or could have a multi-step style, with the multi-step clearly separating the net income from the operational income and gross profit. This difference is important because COGS is a major part of financial reporting for merchandising organizations, because it has a direct impact on profitability and financial analysis…arrow_forwardPLease Find correct this account general asolutionsarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





