WFU Corporation expects to have the sales and expenses shown for August, September,and October. The company expects to receive 55% of collections for sales in the month the sale occurs, 35% in the following month, and the remainder to be uncollectible. The company policy for manufacturing expenses requires that 70% of the expenses be paid in the month incurred and 30% in the following month. All other expenses are paid in the month incurred. The company also earns and collects $5,000 of rental revenue eachmonth. At the end of the quarter, WFU Corporation must make an estimated tax payment, which the company estimates will be 7% of the quarter's total sales. Prepare the cash budget for the three months if cash as of August 1, 2015, totaled $51,500. The company requires a $50,000 minimum cash balance. July $34,000 $39,000 August September October $46,000 $40,000 Sales Manufacturing costs Selling expenses Administrative expenses 15,200 16,800 20,100 19,900 10,000 10,200 14,500 16,500 12,000 12,500 13,000 13,500 Prepare the cash budget for the three months if cash as of August 1, 2015, totaled $51,500. The company requires a $50,000 minimum cash balance.

WFU Corporation expects to have the sales and expenses shown for August, September,and October. The company expects to receive 55% of collections for sales in the month the sale occurs, 35% in the following month, and the remainder to be uncollectible. The company policy for manufacturing expenses requires that 70% of the expenses be paid in the month incurred and 30% in the following month. All other expenses are paid in the month incurred. The company also earns and collects $5,000 of rental revenue eachmonth. At the end of the quarter, WFU Corporation must make an estimated tax payment, which the company estimates will be 7% of the quarter's total sales. Prepare the cash budget for the three months if cash as of August 1, 2015, totaled $51,500. The company requires a $50,000 minimum cash balance. July $34,000 $39,000 August September October $46,000 $40,000 Sales Manufacturing costs Selling expenses Administrative expenses 15,200 16,800 20,100 19,900 10,000 10,200 14,500 16,500 12,000 12,500 13,000 13,500 Prepare the cash budget for the three months if cash as of August 1, 2015, totaled $51,500. The company requires a $50,000 minimum cash balance.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 15E: Palmgren Company produces consumer products. The sales budget for four months of the year is...

See similar textbooks

Similar questions

All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?
Sports Socks has a policy of always paying within the discount period and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 85% of its payments are made in the month of purchase and 15% are made the following month. The direct materials budget provides for purchases of $129,582 in November, $294,872 in December, $239,582 in January, and $234,837 in February. What is the balance in accounts payable for January 31, and February 28?
One Device makes universal remote controls and expects to sell 500 units in January, 800 in February, 450 in March, 550 in April, and 600 in May. The required ending inventory is 20% of the next months sales. Prepare a production budget for the first four months of the year.
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Rehydrator makes a nutrition additive and expects to sell 3,000 units in January, 2,000 in February, 2,500 in March, 2,700 in April. and 2,900 in May. The required ending inventory is 20% of the next months sales, and the beginning inventory on January 1 was 600 units. Prepare a production budget for the first four months of the year.
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Cash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.