Question

In: Accounting

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. At the beginning of April, Sienna Corp. had 15,000 units in inventory.
  • Each unit of output requires 2 kilograms of direct material. To guard against stockouts of raw materials, the company has a policy of maintaining a raw materials inventory of 20 percent of the following month’s production. At the beginning of April, Sienna Corp. has 32,000 kilograms of direct materials on hand. Each kilogram of direct materials costs $1.00.
  • Each unit of output requires 0.2 hours (12 minutes) of direct labour and employees are paid a standard rate of $22 per hour
  • Sienna Corp. applies overhead using a variable rate of $15 per direct labour hour. The fixed overhead is $94,590 per month. Of that amount, $20,000 are non-cash costs, such as depreciation on assets.
  • Sienna Corp. has both fixed and variable components to the selling and administrative expenses. Accountants at Sienna Corp. estimate that the variable selling and administrative expenses are $0.50 per unit sold. Fixed selling and administrative expenses are $140,000 per month, $20,000 are non-cash costs, such as depreciation on assets.
  • Fifty percent of sales are made in cash. The remaining 50% of sales are made on account. The company collects 60% of sales made on account in the month of the sale, 20% in the month following the sale, and 15% in the second month following the sale. Sienna Corporation had total sales of $882,000 in February and $756,000 in March
  • Sienna Corporation pays $1.00 per kilogram of direct materials. The company pays of half of its purchases in the month of the purchase and the remaining half in the month following the purchase. At the beginning of the quarter, Sienna Corporation owed its creditors $42,400 for purchases of direct materials.

Required:

  1. Prepare a sales budget for the months of April, May, and June, and for the quarter.

  1. Prepare a production budget for the months of April, May and June, and for the quarter-end. [Note: you might want to compute the production needs for July since you will need that information for subsection (C)]
  1. Prepare the direct materials purchases budget for the months of April, May and June, and for the quarter-end.

  1. Prepare the direct labour budget for the months of April, May and June, and for the quarter-end.

  1. Prepare the overhead budget for the months of April, May and June, and for the quarter-end.

  1. Prepare the ending finished goods inventory budget for the quarter ending June 30.

  1. Prepare the accounts receivable collections schedule for the months of April, May and June.

  1. Prepare the cash payments on accounts payable schedule for the months of April, May, and June.

Solutions

Expert Solution


Related Solutions

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 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...
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...
Johnson Company is preparing budgets for the upcoming quarter ending October 31st . The marketing director...
Johnson Company is preparing budgets for the upcoming quarter ending October 31st . The marketing director has provided the following information to the Budget Committee. Currently the company sells one product, the korda, for $25 per unit. Budgeted sales for the next five months are as follows: August 15,000 September 45,000 October 37,500 November 25,500 December 26,250 To minimize the risk of stockouts, the company has a policy to maintain an ending inventory of 18% of the following month’s budgeted...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $12,200 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,800 $ 41,200 $ 25,200 Cash payments for merchandise 22,600 15,600 16,000 Sales are 75% cash and 25% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,200 in cash, $13,200 in accounts receivable, $11,000 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 31,000 $ 41,000 $ 25,000 Cash payments for merchandise 22,200 15,800 16,200 Sales are 70% cash and 30% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $13,000 in cash, $13,000 in accounts receivable, $11,000 in...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and...
Castor, Inc., is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow: Budgeted April May June Sales $ 30,000 $ 42,000 $ 26,000 Cash payments for merchandise 24,200 14,800 13,500 Sales are 80% cash and 20% on credit. All credit sales are collected in the month following the sale. The March 31 balance sheet includes balances of $14,000 in cash, $14,000 in accounts receivable, $11,000 in...
Anderson Company is preparing budgets for the upcoming quarter ending October 31st. The marketing director has...
Anderson Company is preparing budgets for the upcoming quarter ending October 31st. The marketing director has provided the following information to the Budget Committee. Currently, the company sells one product, the korda, for $25 per unit. Budgeted sales (in units) for the next five months are as follows: August. 15,000 September. 45,000 October. 37,000 November. 25,500 December. 26,250 • To minimize the risk of stockouts, the company has a policy to maintain an ending inventory of 18% of the following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT