Khaled Industries, a defense contractor, is developing a cash budget for October, November, and December. (i)...

Khaled Industries, a defense contractor, is developing a cash budget for October, November, and December.

(i) Khaled’s sales in August and September were $100,000 and $200,000 respectively. Forecasted Sales for October, November, and December are as below: October - $400,000 November - $300,000 December - $200,000
30% of the firm’s sales have been for cash, 50% have been collected after 1 month, and the remaining 20% after 2 months. Bad-debt expenses (uncollectible accounts) have been negligible. In December, Khaled will receive a $30,000 dividend from stock in a subsidiary.

(ii) Khaled has also gathered the relevant information for the development of a cash disbursement schedule. Purchases will represent 70% of sales - 40% will be paid immediately in cash, 60% is paid the month following the purchase. The firm will also expend cash on rent, wages and salaries every month of $52,000.
Prepare a Cash Budget for October, November and December.

Expert Solution

ekkarill92 answered 2 years ago

At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December.

At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . ....

Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary...

Prepare a selling and administrative expenses budget. October November December Selling and Administrative Expense Budget Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses $0 $0 $0 Required information Problem 14-23 Preparing a master budget for retail company with no beginning account balances LO 14-2, 14-3, 14-4, 14-5, 14-6 [The following information applies to the questions displayed below.] Munoz Company is a retail company that specializes in selling outdoor camping equipment. The company...

Garry's Corporation's most recent production budget indicates the following required production: October November December Required Production...

Garry's Corporation's most recent production budget indicates the following required production: October November December Required Production (units) 210,000 175,000 110,000 Each unit of a finished product requires 5 pounds of raw materials. The company maintains raw materials inventory equal to 25% of the next month's expected production needs. How many pounds of raw material should Garry plan on purchasing for the month of November? A. 893,500 B. 793,750 C. 1,006,250 D. 1,012,500 I know the answer is B, but I'm...

a Using the information provided, construct a monthly cash budget for October through December 2014. Based...

a Using the information provided, construct a monthly cash budget for October through December 2014. Based on your analysis, will Noble enjoy a surfeit of cash, or require external financing? b Construct a pro forma income statement for the first fiscal quarter of 2015 and a pro forma balance sheet as of December 31, 2014. What is your estimated external financine needed for December 31? c Does the December 31, 2014, estimated external financing equal your cash surplus (deficit) for...

Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the...

Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the beginning of November and anticipates total sales of $1,000,000, consisting of 25% cash sales and 75% bank credit-card sales. The bank charges 3% for credit-card deposits. The firm sets its selling price at 160% of the cost of purchases and pays the cost of each month's sales at the end of the month. Operating expenses are $45,000 per month, of which $25,000 is depreciation...

Use the following information to prepare a cash budget for December. The cash balance on December...

Use the following information to prepare a cash budget for December. The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18%...

Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December,...

Goldman has the following budget plans: Sales are budgeted at $440,000 for November, $420,000 for December, and $410,000 for January. Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. Other...

Prepare a cash budget, properly labeled and in good accounting order, for October based on the...

Prepare a cash budget, properly labeled and in good accounting order, for October based on the following: Forecast sales July $150,000 Credit sales are 40% of total sales and are collected August $170,000 as follows: 20% one month after the sale, 30% Sept. $180,000 two months after the sale and 50% three months Oct $190,000 after the sale Accounts payable are paid as follows: 70% one month after the purchase and 30% two months after the purchase. Rent is $1,500 per month and utilities are $700 per month....

I. (25) Cash Budget for New Toys Company: Prepare a cash budget and provide advices for...

I. (25) Cash Budget for New Toys Company: Prepare a cash budget and provide advices for the second quarter of 201x based upon the following information:  The firms’ sales during February and March of 201x were $1,528,000 and $1,662,000, respectively. Sales during the next four months are projected to be : April $1,950,000 May $2,700,000 June $2,400,000 July $2,100,000  Historically, 100% of the firm’s sales are on credit, with about 60% of each month’s sales collected one month...

5) Garry Corporation's most recent production budget indicates the following required production: October 210,000 November 175.000...

Garry's Corporation's most recent production budget indicates the following required production:OctoberNovemberDecemberRequired Production (units)210,000175,000110,000Each unit of a finished product requires 5 pounds of raw materials. The company maintains raw materials inventory equal to 25% of the next month's expected production needs. How many pounds of raw material should Garry plan on purchasing for the month of November?39) Magno Cereal Corporation uses a standard cost system for its "crunchy pickle" cereal. The materials standard for each batch of cereal produced is 1.4...

Question