PLease help :) 1 More Info a. The company pays for 45% of its direct materials p
ID: 2335214 • Letter: P
Question
PLease help :)
1 More Info a. The company pays for 45% of its direct materials purchases in the month of purchase and the remainder the following month. The company's direct material purchases for March through June are anticipated to be as follows March April May June S 118,000 S 138,000 S121,000 144,000 b. Direct labor is paid in the month in which it is incurred. Direct labor for each month of the second quarter is budgeted as follows: April May June S 60,000 S 70,000 S 85,000 C. Manufacturing overhead is estimated to be 130% of direct labor cost each month. This monthly estimate includes $35,000 of depreciation on the plant and equipment. All manufacturing overhead (excluding depreciation) is paid in the month in which it is incurred d. Monthly operating expenses for March through June are projected to be as follows: March April May 84,000 S87,000 S 92,000 June S 77,000 Monthly operating expenses are paid in the month after they are incurred. Monthly operating expenses include $10,000 for monthly depreciation on administrative offices and equipment, and $2,900 for bad debt expense e. The company plans to pay $8,000 (cash) for a new server in May f. The company must make an estimated tax payment of $12,000 on June 15 Print DoneExplanation / Answer
THE KERWIN COMPANY
Cash payment Budget
For the month of April through June
April
May
June
Quarter
Cash Payments for Direct material
45% of the current month's Purchases
$ 62,100.00
$ 54,450.00
$ 64,800.00
$ 181,350.00
55% of the last month's Purchases
$ 64,900.00
$ 75,900.00
$ 66,550.00
$ 207,350.00
Total payments for direct material`
$ 127,000.00
$ 130,350.00
$ 131,350.00
$ 388,700.00
Payments for direct material
$ 60,000.00
$ 70,000.00
$ 85,000.00
$ 215,000.00
Payments for manufacturing overheads
$ 43,000.00
$ 56,000.00
$ 75,500.00
$ 174,500.00
Payments for Operating Expenses
$ 71,100.00
$ 74,100.00
$ 79,100.00
$ 224,300.00
Payment for new server
$ 8,000.00
$ 8,000.00
payment for tax
$ 12,000.00
$ 12,000.00
Total Cash Payments
$ 301,100.00
$ 338,450.00
$ 382,950.00
$ 1,022,500.00
Working
March
April
May
June
Purchases
$ 118,000.00
$ 138,000.00
$ 121,000.00
$ 144,000.00
45% of Purchase
$ 53,100.00
$ 62,100.00
$ 54,450.00
$ 64,800.00
55% of Purchase
$ 64,900.00
$ 75,900.00
$ 66,550.00
$ 79,200.00
April
May
June
Total Manufacturing Overheads
$ 78,000.00
$ 91,000.00
$ 110,500.00
Depreciation
$ 35,000.00
$ 35,000.00
$ 35,000.00
Total cash manufacturing overheads
$ 43,000.00
$ 56,000.00
$ 75,500.00
March
April
May
June
Total Monthly operating expenses
$ 77,000.00
$ 84,000.00
$ 87,000.00
$ 92,000.00
Depreciation
$ 10,000.00
$ 10,000.00
$ 10,000.00
$ 10,000.00
Bad debts
$ 2,900.00
$ 2,900.00
$ 2,900.00
$ 2,900.00
Total Cash Operating expenses
$ 64,100.00
$ 71,100.00
$ 74,100.00
$ 79,100.00
Depreciation and Bad debts are non cash expense that is why they are deducted to calculate cash expenses.
THE KERWIN COMPANY
Cash payment Budget
For the month of April through June
April
May
June
Quarter
Cash Payments for Direct material
45% of the current month's Purchases
$ 62,100.00
$ 54,450.00
$ 64,800.00
$ 181,350.00
55% of the last month's Purchases
$ 64,900.00
$ 75,900.00
$ 66,550.00
$ 207,350.00
Total payments for direct material`
$ 127,000.00
$ 130,350.00
$ 131,350.00
$ 388,700.00
Payments for direct material
$ 60,000.00
$ 70,000.00
$ 85,000.00
$ 215,000.00
Payments for manufacturing overheads
$ 43,000.00
$ 56,000.00
$ 75,500.00
$ 174,500.00
Payments for Operating Expenses
$ 71,100.00
$ 74,100.00
$ 79,100.00
$ 224,300.00
Payment for new server
$ 8,000.00
$ 8,000.00
payment for tax
$ 12,000.00
$ 12,000.00
Total Cash Payments
$ 301,100.00
$ 338,450.00
$ 382,950.00
$ 1,022,500.00
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.