China Company expects to have a cash balance of $40,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $90,000, February $200,000. Payments for direct materials: January $60,000, February $95,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,000, February $41,000. These costs include depre- ciation of $1,000 per month. All other overhead costs are paid as incured. Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $10,000 in cash. China Company has a line of credit at a local bank that enables it to borrow up to $25,000.. The company wants to maintain a minimum monthly cash balance of $25,000. Instructions Prepare a cash budget for January and February.

China Company expects to have a cash balance of $40,000 on January 1, 2017. Relevant monthly budget data for the first 2 months of 2017 are as follows. Collections from customers: January $90,000, February $200,000. Payments for direct materials: January $60,000, February $95,000. Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred. Manufacturing overhead: January $26,000, February $41,000. These costs include depre- ciation of $1,000 per month. All other overhead costs are paid as incured. Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $10,000 in cash. China Company has a line of credit at a local bank that enables it to borrow up to $25,000.. The company wants to maintain a minimum monthly cash balance of $25,000. Instructions Prepare a cash budget for January and February.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Major Landscaping Company is preparing its budget for the first quarter of 2017. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2017 are: November 2016, $120,000; December 2016, $110,000; January 2017, $140,000; February 2017, $160,000; March 2017, $170,000. Purchases on landscaping supplies (direct materials) are paid 40% in the month of purchase and 60% the following month. Actual purchases for 2016 and expected purchases for 2017 are: December 2016, $21,000; January 2017, $20,000; February 2017, $22,000; March 2017, $27,000. Instructions Prepare the following schedules for each month in the first quarter of 2017 and for the quarter in total: Expected…
Kingston budgets total sales for June and July of $430,000 and $338,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 25% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 10% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company’s budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $430,000 July 338,000 Total
Yeaman has $13,000 in cash on hand on January 1 and has collected the following budget data: (Click on the icon to view the budget data) Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Yeaman has cash payments for selling and administrative expenses including salaries of $65,000 per month plus commissions that are 1% of sales, all paid in the month of sale. The company requires a minimum cash balance of $1,000. Prepare a cash budget for January and February. Round to the nearest dollar. Will Yeaman need to borrow cash by the end of February? Begin by preparing the cash budget for January, then prepare the cash budget for February (Complete all input fields. Enter a "0" for any zero balances. Round all amounts entered into the cash budget to the nearest whole dollar.) Data table Sales Cash receipts from customers Cash payments for direct materials purchases Direct labor costs Manufacturing overhead costs (includes…
Kingston budgets total sales for June and July of $470,000 and $348,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 20% are collected in the month of sale, 60% are collected during the first month after the sale, and the remaining 20% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $ 470,000 July 348,000 Total
Dove Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business are $245,000, $302,000, and $402,000, respectively, for September, October, and November. The company expects to sell 25% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month of the sale and 30% in the month following the The cash collections expected in October are O & $267,120 O & $218120 Oc $278,520 O d. $289.175
In Paige Company, direct labor is $20 per hour. The company expects to operateat 10,000 direct labor hours each month. In January 2014, direct labor totaling $204,000is incurred in working 10,400 hours. Prepare (a) a static budget report and (b) a fl exiblebudget report. Evaluate the usefulness of each report.
Capstone Inc. collects 20% of its sales on account in the month of the sale and 80% in the month following the sale. If sales on account are budgeted to be $117,000 for September and $135,000 for October, what are the budgeted cash receipts from sales on account for October? $_________
During June, Tarras Corporation plans to serve 46,000 customers. The company uses the following revenueand cost formulas in its budgeting, where Q is the number of customers served. Revenue:$4.40Q Wages and salaries:$34,600 + $1.67Q Supplies:$0.87Q Insurance:$15,000 Miscellaneous expenses:$5,600 + $0.57Q Required:Prepare the company's planning budget for June. Show all your calculations and you may round youranswers to the nearest dollar.
Sheridan Company's direct materials budget shows direct materials purchases for January $300000, February $360000 and March $425000. Cash payments are 60% in the month of purchase and 40% in the following month. The budgeted cash disbursements for direct materials purchases in March are $386000. $314000. $360000. $399000.
A sales budget is given below for one of the products manufactured by N.Ltd .For sixmonths ended 30th June 2021.Month UnitsJanuary 60,000 February 105,000 March 180,000 April May June120,000 90,00075,000The inventory of finished goods at the end of each month equal 20% at the next month’s sales On 1st Jan 2021, finished goods inventory totaled 12,000 units. Each unit of the product requires nine units of a specialized liquid known as HN-2, sometimes this extract is in short supply for this reason, the company has a policy of maintaining an inventory at the end of each month equal to 30%of next month’s production needed. This requirement was met on 1st Jan 2021.Required(i) Prepare a budget showing the quantity of NH-2 to be purchased each month from January, February and March and in total for the three months period(ii) What is the significance of budgeting in any business organization