2)
BUDGETED CASH PAYMENTS FOR PURCHASE | ||
January | February | |
40% of last month purchase | 11000 | 40600*40%=16240 |
60% of current month purchase | 40600*60%=24360 | 41500*60%= 24900 |
Total cash payment for purchase | 35360 | 41140 |
3)
SELLING AND ADMINISTRATIVE EXPENSE | ||
JAN | FEB | |
Variable expense | ||
30% in the month incurred | 1215 [4050*30%] | 1242 [4140*30%] |
70% in following month | 1180 | 2835 [4050*70%] |
Total payment for variable expense | 2395 | 4077 |
Fixed expense | ||
30% in the month incurred | 1050 [3500*30%] | 1050 |
70% in following month | 1770 | 2450 [3500*70%] |
Rent expense | 2400 | 2400 |
Total payment for fixed expense | 5220 | 5900 |
Total payment for S AND A | 7615 | 9977 |
Out of beginning salaries and commission:
commission =2950*40%=1180
salaries = 2950*60%=1770
4)
PRINTER COMPANY CASH BUDGET FOR THE TWO MONTH ENDED FEBRUARY 28 ,2018 |
||
January | February | |
Beginning cash balance | 26000 | 64425 |
cash receipt from customers | 83800 | 82440 |
cash available | 109800 | 146865 |
cash payments: | ||
cash payment for merchandise inventory | 35360 | 41140 |
selling and administrative expense | 7615 | 9977 |
payment for income taxes | 2400 | 2400 |
Total cash payment | (45375) | (53517) |
Ending cash balance | 64425 | 93348 |
how do i do requiremnet 2-4? requirment 3 is not my calculations, they sre used with...
please explain how to get each answer, i am very confused i Requirements 1. 2. Prepare the schedule of cash receipts from customers for January and February 2018. Assume cash receipts are 80% in the month of the sale and 20% in the month following the sale. Prepare the schedule of cash payments for purchases for January and February 2018. Assume purchases are paid 60% in the month of purchase and 40% in the month following the purchase. Prepare the...
Brett's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: (Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show amounts for each month and totals for January and February. 2. Prepare a combined cash budget. If no financing...
Gary's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: A (Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January and February combined. 2. Prepare a combined cash budget. If...
a. Sales are 60% cash and 40% credit. Credit sales are collected 20% in the month of sale and the remainder in the month after sale. Actual sales in December were $56,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue January ................ $62,000 February .............. $72,000 b. Actual purchases of direct materials in December were $23,000. The company's purchases of direct materials in January are budgeted to be $20,000 and...
Information/Data table provided Positive rating upon answer completion provided~ Thank you Roan's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....
REQUIRMENT 1 AND 2 IS SOLVED. PLEASE SOLVE REQUIREMENT 3,4,5 AND 6. region, and the company as a WHIC. 2. As the Manitoba region manager, would you investigate the Winnipeg SIO this report? Why or why not? 3. Briefly discuss the benefits of budgeting. Base your discussion on Winnie's World's perfor- mance report. P9-64A Prepare an inventory purchases, and cost of goods sold budget (Learning Objective sy University Logos buys logo-imprinted merchandise and then sells it to university bookstores Sales...
Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $240,000 January $320,000 April forecast $360,000 December 260,000 February 360,000 March 370,000 Of the firm's sales, 60 percent are for cash and the...
The budget committee of printer office supply has assembled the following data: Question 2: The budget committee of Printer Office Supply has assembled the following data: Printer Office Supply Balance Sheet March 31, 2014 Liabilities Current Assets Cash Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable S 34,000 15,000 19,500 1,400 16.250 4,725 Salaries and Commissions Payable Total Liabilities $ 20,975 $ 69,900 Stockholders' Equity Prepaid Insurance Total Current Assets Property, Plant, and Equipment: Equipment and Fixtures Common Stock 17,000...
A) Prepare Drew Consulting's cash budget for January AND February B) How much cash will Drew borrow in February if cash receipts from customers that month total $39,000 instead of $49,000 Assume Drew Consulting began January with $15,000 cash. Management forecasts that cash receipts from credit customers will be $48,000 in January and $49,000 in February. Projected cash payments include equipment purchases ($18,000 in January and $41,000 in February) and selling and administrative expenses ($3,000 each month). Drew's bank requires...