Required:
1- prepare a cash collection schedule from customers
2- prepare a schedule of cash payments for materials
3- prepare the cash budget
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Required: 1- prepare a cash collection schedule from customers 2- prepare a schedule of cash payments...
Requirement 1. Prepare Cooke Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018 Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash Receipts from Customers First Quarter 2018 i Data Table Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2017 1st Qtr-Sales Total cash receipts from customers Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing...
How do I prepare a direct labor budget that is similar to Illustration 22.11 of the textbook. (illustration included below) (Please show how you calculated the budget, and round to the nearest hour.) Illustration 22.11 below H C D E F G Serious Business, Inc. The company is preparing its budget for the coming year, 2020. The first step is to plan for the FIRST QUARTER of that 2 coming year. The following information has been gathered from their managers...
I would like the excel part of 311 and the schedule of cash payments to be done and possibly with the work shown thank you! MATERIAL 311: Materials per Finished Component: 9 feet Cost per foot: $2.00 Inventory at March 31: 69,000 feet Material No. 208 is sometimes in short supply. Therefore, the East Division requires that enough of the material be on hand at the end of each month to provide for 50% of the following month's production needs....
3. Prena 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare a production budget. (Hint: Unit sales - Sales in dollars / Selling price per unit.) Prepare a direct materials budget. 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 7. Prepare a cash payments...
Show Attempt History Current Attempt in Progress On January 1, 2017, the Blue Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,700; second quarter 6,200; third quarter 7,200 Ending raw materials inventory: 40% of the next quarter's production requirements Ending finished goods inventory: 25% of the next quarter's expected sales units Third-quarter production: 7,670 units. The ending raw materials and finished goods inventories at December 31,...
Prepare budgeted income statement and supporting budgets. (LO 1, 2, 3) r! Bolivar Farm Supply Company manufactures and sells a fertilizer called Basic II. The following data are available for preparing budgets for Basic Il for the first 2 quarters of 2017. 1. Sales: Quarter 1,40,000 bags; quarter 2.50,000 bags. Selling price is $60 per bag. 2. Direct materials: Each bag of Basic II requires 6 pounds of Crup at a cost of $4 per pound and 10 pounds of...
Use all available data (Assumptions Row 4-Row 52, Balance Sheet for 2016, results from other Soultions) Answer format also included. 1a. Create a DIRECT MATERIALS BUDGET for the year ended December 31, 2017. 1b. Create a SCHEDULE OF EXPECTED CASH DISBURSEMENTS FOR PURCHASES OF MATERIALS for the year ended December 31, 2017. 2. Create a DIRECT LABOR BUDGET for year ended December 31, 2017. 3. Create a MANUFACTURING OVERHEAD BUDGET for the year ended December 31, 2017. Budgeted Unitsales 01...
Please solve for answers with RED X in image Required 2 c-e, use 365 days in a year. Please solve for equity multiplier in Required 3 b. THE BALANCE SHEET IS CORRECT. I VERIFIED IT WITH THE SOFTWARE'S CHECK MY WORK PROBLEM. PLEASE SOLVE. USE THE FOLLOWING INFORMATION TO HELP: Required information [The following information applies to the questions displayed below.) Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product...
Part B2: Hayes Company Continued O At Hayes, 2 hours of direct labor are required to produce each unit of finished goods. O The anticipated hourly wage rate is $10. Hayes Company expects variable costs to fluctuate with production volume on the basis of the following rates per direct labor hours: indirect materials $1, indirect labor $1.4, utilities $0.4 and maintainence $0.2. All amounts for fixed costs are assumed. Variable expense rates per unit of sales are sales commission $3...
1. Prepare the sales budget for the year. 2. Prepare the production budget for the year. 3. Prepare the direct materials budget for the year. 4. Prepare the direct labor budget for the year. (Round Direct labor time per unit answers to 1 decimal place, e.g. 52.5.) 5. Prepare the budegeted multiple-step income statement for the year. (Note: income taxes are not allocated to the products). Ayayai Inc. is preparing its annual budgets for the year ending December 31, 2017....