Concept explainers
1.
the value of the collection in the month of July, August, September and October
Introduction: Budget is the evaluation of the revenue and the expense which is expected incur in the specified period.
1.
Explanation of Solution
Total cash collection of the July August, September and December are $209,500, 217,500, 226,500 and $227,000.
Calculate the expected cash collection,
Particulars | July | August | September | October |
Sales | 210,000 | 230,000 | 220,000 | 240,000 |
Collection | ||||
35% in month of sales | 73,500 | 80,500 | 77,000 | 84,000 |
65% in the month of following | 0 | 136,500 | 149,500 | 143,000 |
Collection from | 136,000 | 0 | 0 | 0 |
Total cash collection | 209,500 | 217,000 | 226,500 | 227,000 |
2.
a.
the value of the merchandise purchase for the quarter ended September
Introduction: Budget is the evaluation of the revenue and the expense which is expected incur in the specified period.
2.
a.
Explanation of Solution
Formula to calculate the merchandise purchase for the quarter ended September,
Substitute, $41,400 for the closing inventory July, $39,600 for the closing inventory of August and $43,200 for the September
Working notes:
Calculation of merchandise purchase budget
Particulars | July | August | September | October |
Sales | 210,000 | 230,000 | 220,000 | 240,000 |
Cost of goods sold (60%) | 126,000 | 138,000 | 132,000 | 144,000 |
Less: Opening inventory | 62,000 | 41,400 | 39,600 | |
Add: closing inventory(30% of the next month cost of goods sold) | 41,400 | 39,600 | 43,200 | |
b.
The value of the merchandise purchases
Introduction: Budget is the evaluation of the revenue and the expense which is expected incur in the specified period.
b.
Explanation of Solution
Formula to calculate total cash disbursement for merchandise purchase for the quarter ended September,
Substitute, $113,200 for merchandise purchase in month July, $117,200for merchandise purchase in month of August and $135,800 for merchandise purchase in month September
Working notes:
Particulars | July | August | September |
Purchases | 105,400 | 136,200 | 135,200 |
Cash payment (40%) | $42,160 | $54,480 | 54,080 |
60% on the following month | 0 | 63,240 | 81,720 |
Payment of account payable in month of July | 71,100 | 0 | 0 |
Total | 113,260 | 117,720 | 135,800 |
Calculate the purchase in the month of July,
Calculate the purchase in the month of August,
Calculate the purchase in the month of September,
3.
To prepare: Income statement of the company
Introduction: Budget is the evaluation of the revenue and the expense which is expected incur in the specified period.
3.
Explanation of Solution
Particulars | JulyAmount ($) | AugustAmount ($) | September Amount ($) |
Sales | 210,000 | 230,000 | 220,000 |
Cost of goods sold (60%) | 126,000 | 138,000 | 132,000 |
Gross profit | 84,000 | 92,000 | 88,000 |
Less: Selling & Administration expense | (60,000) | (60,000) | (60,000) |
Less: Depreciation | (5,000) | (5,000) | (5,000) |
Less: remaining expense | (55,000) | (55,000) | (55,000) |
Net | (36,000) | (28,000) | (32,000) |
4.
To Prepare: Balance sheet of the company
Introduction: Budget is the evaluation of the revenue and the expense which is expected incur in the specified period.
4.
Explanation of Solution
Balance sheetas on September 31 | |
Assets: | Amount
($) |
Cash | 226,500 |
Account receivable | 143,000 |
Inventory | 62,000 |
Plant and equipment, net of depreciation | 132,000 |
Total assets | 563,500 |
Liability and stockholder’ equity | |
Account payable | 232,600 |
Common stock | 327,000 |
3,900 | |
Total liabilities and stockholder’s equity | 563,500 |
Working notes:
Calculate the retained earnings,
Want to see more full solutions like this?
Chapter 8 Solutions
INTRO.TO MGRL.ACCT.(LL)W/CONNECT>IP<
- Cash Flows; Budgeted Income Statement and Balance Sheet Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Budgeting Assumptions: 1. All sales are on account. Thirty percent of the credit sales are collected in the month of sale and the remaining 70% are collected in the month subsequent to the sale. The accounts receivable at June 30 will be collected in July. 2. All merchandise purchases are on account. Twenty percent of merchandise inventory purchases are paid in the month of the purchase and the remaining 80% is paid in the month after the purchase. 3. The budgeted inventory balance at July 31 is $22,000. 4. Depreciation expense is $3,000 per month. All other selling and administrative expenses are paid in full in the month the expense is incurred. 5. The company’s cash budget for July shows expected cash collections of $77,000, expected cash disbursements for merchandise purchases of $44,500, and…arrow_forwardRequired: 1. Prepare a schedule of expected cash collections for July, August, and September. 1. Cash Collections for Q3 July August September Q3 From A/R From July sales From Aug sales From Sep sales Total cash collectionsarrow_forwardYou are provided with the following information taken from Wildhorse Inc.'s March 31, 2025, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1. 2. 3. 4. 5. Additional information concerning Wildhorse Inc. is as follows. 6. 7. Gross profit is 25% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April Purchases March $48,200 $19,280 42,420 $61,700 Purchases April $11,600 70,700 20,180 36,010 Sales are both cash and credit. Cash collections expected in April are: (40% of $48,200) (60% of $70,700) 120,800 22,560 154,500 11.680 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte $22,560 28,320 $50,880 Cash operating costs are anticipated to be $12,630 for the month of April. Equipment costing $2,560 will be purchased for cash in April. The company wishes to maintain a minimum cash balance…arrow_forward
- Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Assets Cash Deacon Company Balance Sheet March 31 Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Budgeted Income Statements Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Budgeting Assumptions: $ 65,200 38,800 43,300 125,000 $ 272,300 $ 66,200 70,000 136,100 $ 272,300 Total cash collections April May June $ $$ 111,000 121,000 141,000 66,600 72,600 84,600 44,400 48,400 56,400 23,300 24,800 27,800 $ 21,100 $ 23,600 $ 28,600 a. 60% of sales are cash sales and 40% of sales are credit sales. Twenty percent of all credit sales are collected in the month of sale and the remaining 80% are collected in the month subsequent to the…arrow_forwardAssume a merchandising company provides the following information from its master budget for the month of May: Sales Cost of goods sold Selling and administrative expenses Accounts receivable, May 1st Accounts receivable, May 31st If all of the company's sales are on account, what is the amount of cash collections from customers included in the cash budget for May? Multiple Choice $109,000 $106,000 $129,000 $ 125,000 $ 90,000 $ 24,000 $ 16,000 $ 35,000 $125,000arrow_forward2 Arrangon Ltd. is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is September 30. A listing of the estimated ledger balances for the company's current year of September 30, 2024 is given below: Cash Accounts receivable Inventory-raw materials Inventory-finished goods Capital assets (net) $370,058 674,730 420,090 453,122 2,632,000 $4,550,000 The sales forecast consisted of these few lines: Accounts payable $719,488 Income tax payable 42,000 Capital stock Retained earnings 2.000.000 1,788,512 $4,550,000 • For the year ended September 30, 2024: 450,000 units at $42.00 each* For the year ended September 30, 2025: 475,000 units at $43.00 each . For the year ended September 30, 2026: 500,000 units at $44.00 each *Sales for the year ended September 30, 2024 are based on actual sales to date and budgeted sales for the duration…arrow_forward
- give working notes The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales on account Purchase August September October November December $85,000 $70,000 $88,550 $77,160 $174,870 $640,000 $550,000 $600,000 $800,000 $500,000 $420,000 $550,000 $500,000 $600,000 $450,000 An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale Expected purchases include monthly cash purchases of 5%. All other purchases are on account. Accounts payable are…arrow_forwardGIVE NOTES SHOW ACCOUNT RECEIVABLE AND ACCOUNT PAYABLE The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales on account Purchase August September October November December $85,000 $70,000 $88,550 $77,160 $174,870 $640,000 $550,000 $600,000 $800,000 $500,000 $420,000 $550,000 $500,000 $600,000 $450,000 An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale Expected purchases include monthly cash purchases of 5%. All other purchases are…arrow_forwardCash Budget; Income Statement; Balance Sheet; Changing Assumptions Refer to the data for Minden Company in Problem 8-19. The company is considering making the following changes to the assumptions underlying its master budget: 1. Sales are budgeted for $220,000 for May. 2. Each month’s credit sales are collected 60% in the month of sale and 40% in the month following the sale. 3. The company pays for 50% of its merchandise purchases in the month of the purchase and the remaining 50% in the month following the purchase. All other information from Problem 8-19 that is not mentioned above remains the same. Required: Using the new assumptions described above, complete the following requirements; 1. Calculate the expected cash collections for May. 2. Calculate the expected cash disbursements tor merchandise purchases for May. 3. Prepare a cash budget for May. 4. Using Schedule 9 as your guide, prepare a budgeted income statement for May. 5. Prepare a budgeted balance sheet as of May 31.arrow_forward
- Required Information TES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Cash Accounts receivable 129,808 Inventory 52,508 217,000 Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity ps payable 347,808 Retained earnings Total liabilities and stockholders' equity 488,508 TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for 40% of its merchandise…arrow_forwardAccounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…arrow_forwardRequired information [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 84,000 Accounts receivable 144,000 Inventory 63,750 223,000 Plant and equipment, net of depreciation Total assets $ 514,750 Liabilities and Stockholders' Equity Accounts payable Common stock $84,000 349,000 81,750 Retained earnings Total liabilities and stockholders' equity $ 514,750 Beech's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $340,000, $360,000, $350,000, and $370,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% In the month following the sale. All of the…arrow_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