Question

In: Accounting

ABC Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for...

ABC Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for the next five months are;

· July 20,681 units

· Aug 50,020 units

· Sept 30,150 units

· Oct 25,309 units

· Nov 15,000 units

The selling price is $15 per unit. All sales are on account. ABC’s collection pattern is 60% collected in the month of sale and remaining amount in the month following sale.

The June 30 Accounts Receivable balance of $50,000 will be collected in full.

The management at ABC Company wants ending Finished Goods Inventory to be equal to 25% of the following month’s budgeted sales in units. At ABC Company, five pounds of material are required per unit of product. Management wants materials on hand at the end of each month equal to 15% of the following month’s production. Material cost is $0.50 per pound.

30% of a month’s purchases is paid for in the month of purchase and the remainder is paid in the following month. The June 30 Accounts Payable balance is $20,000.

At ABC, each unit of product requires 0.06 hours (3.6 minutes) of direct labor. The company has a “no layoff” policy and in exchange for the “no layoff” policy, workers agree to a wage rate of $15 per hour regardless of the hours worked (no overtime pay). For the next three months, the direct labor workforce will be paid for a minimum of 2,000 hours per month.

At ABC, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $25 per direct labor hour. Fixed manufacturing overhead is $40,000 per month and includes $10,000 of non-cash costs.

At ABC, the selling and administrative expenses budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.55 per unit sold. Fixed selling and administrative expenses are $60,000 per month. The fixed selling and administrative expenses include $15,000 in costs that are not cash outflows of the current month.

The company:

· Has a July 1 cash balance of $55,000

· Maintains a minimum cash balance of $35,000

· Borrows on the first day of the month and repays loans on the last day of the quarter

· Maintains a 12% open line of credit for $95,000

· Pays a cash dividend of $45,000 in Aug

· Cash purchases of equipment, $155,200 in July and $54,800 in Sept, respectively

ABC reported the following account balances prior to preparing its budgeted financial statements:

· Land - $65,000

· Equipment - $180,000

· Ordinary shares - $195,000

· Retained earnings - $X*

*This Retained earnings figure will be the amount needed to balance off your balance sheet on June 30th i.e. the closing balances on June 30th before you step into the third quarter.

Requirements:

With the information provided, assist ABC to prepare the following budgets for the third quarter of the year:

1. Expected Cash Disbursements for Materials

2. Direct Labour Budget

3. Manufacturing Overhead Budget

4. Ending Finished Goods Inventory Budget

Solutions

Expert Solution


Related Solutions

Donahue Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for...
Donahue Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for the next five months are; · July 20,681 units · Aug 50,020 units · Sept 30,150 units · Oct 25,309 units · Nov 15,000 units The selling price is $15 per unit. All sales are on account. Donahue’s collection pattern is 60% collected in the month of sale and remaining amount in the month following sale. The June 30 Accounts Receivable balance of $50,000...
Sienna Corporation is preparing budgets for the upcoming quarter ending June 30. Budgeted sales (in units)...
Sienna Corporation is preparing budgets for the upcoming quarter ending June 30. Budgeted sales (in units) for the next five months are: April 30,000 May 90,000 June 75,000 July 51,000 August 52,500 Below is additional information that may be relevant in preparing the budgets. The company produces professional quality bowls that sell for $31.50 per unit. To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 18 percent of the following month’s budgeted sales....
Case #1 Sienna Corporation is preparing budgets for the upcoming quarter ending June 30. Budgeted sales...
Case #1 Sienna Corporation is preparing budgets for the upcoming quarter ending June 30. Budgeted sales (in units) for the next five months are: April 30,000 May 90,000 June 75,000 July 51,000 August 52,500 Below is additional information that may be relevant in preparing the budgets. The company produces professional quality bowls that sell for $31.50 per unit. To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 18 percent of the following month’s...
Case #1 Sienna Corporation is preparing budgets for the upcoming quarter ending June 30. Budgeted sales...
Case #1 Sienna Corporation is preparing budgets for the upcoming quarter ending June 30. Budgeted sales (in units) for the next five months are: April 30,000 May 90,000 June 75,000 July 51,000 August 52,500 Below is additional information that may be relevant in preparing the budgets. The company produces professional quality bowls that sell for $31.50 per unit. To guard against inventory stockouts, the company has a policy of maintaining an ending inventory of 18 percent of the following month’s...
ABC Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
ABC Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 35,000 October 25,000 August 80,000 November 11,500 September 49,000 December 12,000 The selling price of the beach umbrellas is $13 per unit. All sales are on account. Based on past experience, sales are collected in the...
Question 1. James Company is preparing budgets for the Third quarter of 2019. All relevant information...
Question 1. James Company is preparing budgets for the Third quarter of 2019. All relevant information is presented below. A. James Company expects sales as shown below: Budgeted Sales (Units) July 25,000 August 28,000 September 36,000 October 42,000 November 50,000 December 58,000 The sales price is $32 per unit. The desired ending inventory of units is 15% higher than the beginning inventory of 1,000 units. Prepare a sales budget for the third quarter, in total, October by month. 2019 July...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter an...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 21,000 7,500 8,000 31,000 72,ee8 41,000 October July August September November December The selling price of the beach umbrellas is $11 per unit b. All sales are on account. Based on past experience, sales are collected In the following pattern: 38%...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 33,000 October 23,000 August 76,000 November 9,500 September 45,000 December 10,000 The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 34,000 October 24,000 August 78,000 November 10,500 September 47,000 December 11,000 The selling price of the beach umbrellas is $11 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation:      a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): The selling price of the beach umbrellas is $14 per unit.      July 38,500   October 28,500   August 87,000   November 15,000   September 56,000   December 15,500    b. All sales are on account. Based on past experience,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT