Question

In: Accounting

Eunice Ltd. has the following budgeted sales for the next six-month period: Month Unit Sales January...

Eunice Ltd. has the following budgeted sales for the next six-month period:

Month Unit Sales

January 80,000

February 90,000

March 120,000

April 150,000

May 180,000

June 120,000

Eunice Ltd. sells a single product at a price of $60 per unit. There were 18,000 units of finished goods in inventory at the beginning of February. Eunice Ltd.’s policy is to keep the inventory of finished goods equal to 20% of the unit sales for the next month.

Three kilograms of materials are required for each unit of finished goods produced. Each kilogram of material costs $5. Inventory levels for materials are equal to 20% of the production needs for the next month. Material inventory at the beginning of February was $288,000 at the price of $5 per kilogram.

Required (show your working):

(a) Prepare sales budgets in units and dollars for February to April

(b) Prepare production budgets in units for February to April

(c) Prepare direct materials usage budget in kilograms and dollars for February and March

(d) Prepare direct materials purchases budgets (in kilograms and dollars) for February and March

Solutions

Expert Solution

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Lubriderm Corporation has budgeted the following unit sales for the next four months: ​Month​​​ Unit Sales...
Lubriderm Corporation has budgeted the following unit sales for the next four months: ​Month​​​ Unit Sales ​ July​​​ 120,000 ​August​ ​​210,000 ​September​​ 150,000 ​October​​ 180,000 ​ Plans are to have an ending inventory of finished products that equals 20% of the unit sales for the next month. Five pounds of materials are required for each finished unit produced, and each pound of material costs $8. The desired ending inventory level for materials is equal to 30% of the materials needs...
Troy Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales October...
Troy Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales October 40,000 November 70,000 December 50,000 January 60,000 There were 14,000 units of finished goods in inventory at the beginning of October. Plans are to have an inventory of finished product equal to 25 percent of the unit sales for the next month. Five pounds of a single raw material are required for each unit produced. Each pound of material costs $10. Plans are to...
Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July...
Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July 35,000 August 20,000 September 30,000 October 25,000 Sales price per unit is $200 Plans are to have an inventory of finished product equal to 30% of the unit sales for the next month. There was 10,500 units in beginning inventory on July 1st. Five pounds of materials are required for each unit produced. Each pound of material costs $10. Inventory levels for materials equal...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 19,000 units April 23,000 units May 34,000 units June 17,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $16 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July 7,700 units August 8,300 units September 5,400 units October 10,200 units November ?????? units December 11,700 units The selling price is $18 per unit. 30% of the company's sales are cash sales and 70% of the company's sales are made on account. The sales on account are collected in the pattern 15% in the month of sale, 20% in the month...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $269,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $251,000 September $52,000 $269,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 9% are collected in the third month following sale, and the remaining...
AH Corp has the following budgeted unit sales for the second half of the 2020: Month...
AH Corp has the following budgeted unit sales for the second half of the 2020: Month Unit Sales July 90,000 August 120,000 September 210,000 October 150,000 November 180,000 December 120,000 It is expected to have 30,000 units of finished goods in inventory at the beginning of budget period and the plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced....
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT