The budgeted sales of Berries Batteries for March and April are as follows: April $600 000 May $580 000 Cost of goods sold for the company is 40% of sales. Company policy states that ending inventory must be 150% of next month's cost of goods sold. 60% of purchases are paid in the month of purchase, with the rest paid in the following month. The budgeted cost of purchases in March is $250,000. Based on this information, what are the cash disbursements for purchases in April?
Question
The budgeted sales of Berries Batteries for March and April are as follows: April 580 000 Cost of goods sold for the company is 40% of sales. Company policy states that ending inventory must be 150% of next month's cost of goods sold. 60% of purchases are paid in the month of purchase, with the rest paid in the following month. The budgeted cost of purchases in March is $250,000. Based on this information, what are the cash disbursements for purchases in April?
Solution
First, we need to calculate the cost of goods sold (COGS) for April and May:
April COGS = April Sales * 40% = 240,000 May COGS = May Sales * 40% = 232,000
Next, we calculate the ending inventory for April, which should be 150% of May's COGS:
April Ending Inventory = May COGS * 150% = 348,000
The cost of purchases in April is the sum of April's COGS and April's ending inventory:
April Purchases = April COGS + April Ending Inventory = 348,000 = $588,000
Finally, we calculate the cash disbursements for purchases in April. 60% of purchases are paid in the month of purchase:
Cash Disbursements in April = April Purchases * 60% = 352,800
Therefore, the cash disbursements for purchases in April are $352,800.
Similar Questions
A company budgeted the following purchases for raw materials:Month January February March April May June JulyBudget $10,000 $20,000 $25,000 $22,000 $27,000 $30,000 $24,000The company has a policy of paying for 40% of the purchases in the month of purchase, 35% in the month following the purchase, and 25% in the second month following the purchase.Based on this information, what are the budgeted cash disbursements for May? $18,500 $27,300 $25,050 $24,750
Based on the following information, cash disbursements for March equals $. (Enter your answer as a whole number.) January purchases = $200,000February purchases = $300,000March purchases = $350,000 Assumptions for the budget:• 55 percent is paid in the month of purchase• 43 percent is paid in the month following the purchase• 2 percent taken as a cash discount for early payment
The Model Company is to begin operations in April. It has budgeted April sales of $70,000, May sales of $74,000, June sales of $80,000, July sales of $82,000, and August sales of $78,000. Note that 10% of each month's sales is expected to represent cash sales; 75% of the balance is expected to be collected in the month following the sale, 17% the second month, 6% the third month, and the balance is expected to be uncollectible.The Model Company is considering charging 1 1/2% on any balance that is not collected in the month following the month of sale. This charge would also change the collection percentages to 15% cash sales, 80% of the balance collected in the month following the sale, 16% the second month, and 3% the third month. This stricter credit policy will reduce the estimated sales budgets by 7% each month. Under this stricter credit policy, what is the amount of cash to be collected in July?Multiple Choice$77,157$73,216$71,338$79,191
Given the following information, calculate cash disbursements for February: January purchases = $200,000February purchases = $300,000March purchases = $350,000 Assumptions for the budget:• 55 percent is paid in the month of purchase• 43 percent is paid in the month following the purchase• 2 percent taken as a cash discount for early paymentMultiple choice question.$315,070$245,980$239,000$251,000
During March a firm purchased $38,300 of merchandise and paid freight charges of $5,370. If the net delivered cost of purchases at the end of March is $33,980, what is the total purchases returns and allowances for March?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.