Question
1. Herron Company has budgeted the following unit sales: 2008 Units April 25,000 May 50,000 The selling price is $15 per unit. Instructions: Prepare separate
1. Herron Company has budgeted the following unit sales: 2008 Units April 25,000 May 50,000 The selling price is $15 per unit. Instructions: Prepare separate sales budgets for the company for 2008. 2. Kelso Company budgeted units to be produced are as follows: 2008 Units July 10,000 August 6,000 September 9,000 It takes 3 pounds of direct materials to produce the product. It is the company's policy to maintain an inventory of direct materials on hand at the end of each month equal to 30% of the next month's production needs. Direct materials inventory on hand at June 30 were 9,000 pounds. The cost per pound of materials is $5. Instructions: Prepare a direct materials budget for 2008. 3. Young Company has budgeted the following unit sales: 2009 Units January 10,000 February 8,000 March 9,000 The finished goods units on hand on December 31, 2008, was 2,000 units. Each unit requires 2 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 10% of next month's anticipated sales. They also have a policy of maintaining a raw materials inventory at the end of each month equal to 20% of the pounds needed for the following month's production. There were 3,920 pounds of raw materials on hand at December 31, 2008. Instructions: For the first quarter of 2009, prepare a production budget. 4. Payton Company is preparing its direct labor budget for 2008 from the following production budget based on a calendar year: Quarter Units 1 40,000 2 20,000 Each unit requires 1.5 hours of direct labor. The union contract provides a wage rate of $11 per hour. Instructions Prepare a direct labor budget for the first two quarters of 2008. 5. Neeley Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2008, the following data are developed: 1. Sales: 20,000 units; unit selling price: $35 2. Variable costs per dollar of sales: Sales commissions 6% Delivery expense 2% Advertising 4% 3. Fixed costs per quarter: Sales salaries $24,000 Office salaries 17,000 Depreciation 6,000 Insurance 2,000 Utilities 1,000 Instructions Prepare a selling and administrative expense budget for the first quarter of 2008. 6. Farley Company has budgeted sales revenues as follows: June Credit sales $135,000 Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are: June $300,000 Other cash disbursements budgeted: (a) selling and administrative expenses of $48,000, (b) dividends of $103,000 will be paid in June, and (c) purchase of equipment in June is $30,000. The company wishes to maintain a minimum cash balance of $50,000 at the end of each month. The beginning cash balance on July 1 was $50,000. Instructions: Prepare a cash budget for the month of June.
1. Herron Company has budgeted the following unit sales: 2008 April May Units 25,000 50,000 The selling price is $15 per unit. Instructions: Prepare separate sales budgets for the company for 2008. 2. Kelso Company budgeted units to be produced are as follows: 2008 July August September Units 10,000 6,000 9,000 It takes 3 pounds of direct materials to produce the product. It is the company's policy to maintain an inventory of direct materials on hand at the end of each month equal to 30% of the next month's production needs. Direct materials inventory on hand at June 30 were 9,000 pounds. The cost per pound of materials is $5. Instructions: Prepare a direct materials budget for 2008. 3. Young Company has budgeted the following unit sales: 2009 January February March Units 10,000 8,000 9,000 The finished goods units on hand on December 31, 2008, was 2,000 units. Each unit requires 2 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 10% of next month's anticipated sales. They also have a policy of maintaining a raw materials inventory at the end of each month equal to 20% of the pounds needed for the following month's production. There were 3,920 pounds of raw materials on hand at December 31, 2008. Instructions: For the first quarter of 2009, prepare a production budget. 4. Payton Company is preparing its direct labor budget for 2008 from the following production budget based on a calendar year: Quarter 1 2 Units 40,000 20,000 Each unit requires 1.5 hours of direct labor. The union contract provides a wage rate of $11 per hour. Instructions Prepare a direct labor budget for the first two quarters of 2008. 5. Neeley Company combines its operating expenses for budget purposes in a selling and administrative expense budget. For the first quarter of 2008, the following data are developed: 1. Sales: 20,000 units; unit selling price: 2. Variable costs per dollar of sales: Sales commissions Delivery expense Advertising 3. Fixed costs per quarter: Sales salaries Office salaries Depreciation Insurance Utilities $35 6% 2% 4% $24,000 17,000 6,000 2,000 1,000 Instructions Prepare a selling and administrative expense budget for the first quarter of 2008. 6. Farley Company has budgeted sales revenues as follows: June $135,000 Credit sales Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the following month. Purchases of inventory are all on credit and 50% is paid in the month of purchase and 50% in the month following purchase. Budgeted inventory purchases are: June $300,000 Other cash disbursements budgeted: (a) selling and administrative expenses of $48,000, (b) dividends of $103,000 will be paid in June, and (c) purchase of equipment in June is $30,000. The company wishes to maintain a minimum cash balance of $50,000 at the end of each month. The beginning cash balance on July 1 was $50,000. Instructions: Prepare a cash budget for the month of JuneStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started