Question

Diane Buswell is preparing the 2020 budget for one of Current Designs’ rotomolded kayaks. Extensive meetings...

Diane Buswell is preparing the 2020 budget for one of Current Designs’ rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020.

Quarter 1 2,800 kayaks
Quarter 2 3,600 kayaks
Quarter 3 2,400 kayaks
Quarter 4 2,400 kayaks


Current Designs’ policy is to have finished goods ending inventory in a quarter equal to 25% of the next quarter’s anticipated sales. Preliminary sales projections for 2021 are 1,100 units for the first quarter and 3,600 units for the second quarter. Ending inventory of finished goods at December 31, 2019, will be 700 rotomolded kayaks.

Production of each kayak requires 56 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 20% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2019, is 20,000 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits.

The polyethylene powder used in these kayaks costs $1.50 per pound, and the finishing kits cost $150 each. Production of a single kayak requires 2 hours of time by more experienced, type I employees and 3 hours of finishing time by type II employees. The type I employees are paid $20 per hour, and the type II employees are paid $17 per hour.

Selling and administrative expenses for this line are expected to be $43 per unit sold plus $7,100 per quarter. Manufacturing overhead is assigned at 160% of labor costs.

Prepare the production budget for this product line by quarter and in total for 2020.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Prepare production and direct materials budgets by quarters for 6 months. Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000. Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 25% of the next quarter's expected sales units. Third-quarter production: 7,200 units. The ending raw materials and finished goods...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,400; second quarter 7,000; third quarter 7,600. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,840 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to total 1,000,000 units. Quarterly sales in units are 20%,25%,30%, and 25% respectively. The sales price is expected to be $50 per unit for the first 3 quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than the budgeted sales volume for the first quarter of 2017. Cash collections from sales...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 113,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 124,000...
Fuqua Company’s sales budget projects unit sales of part 198Z of 10,700 units in January, 12,200...
Fuqua Company’s sales budget projects unit sales of part 198Z of 10,700 units in January, 12,200 units in February, and 13,000 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $4 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month’s production requirements, and its ending finished goods inventory to equal 20% of the next month’s expected unit sales. These goals were met at December 31, 2019....
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,900; third quarter 7,300. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,360 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
eWitt Industries has adopted the following production budget for the first 4 months of 2020. Month...
eWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January 10,130 March 5,250 February 8,110 April 4,260 Each unit requires 5 pounds of raw materials costing $4 per pound. On December 31, 2019, the ending raw materials inventory was 10,130 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements. Prepare a direct materials purchases budget by...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 112,000 Expected unit sales for February 2020 114,000 Expected unit sales for March 2020 115,000 Expected unit sales for April 2020 124,000...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month...
DeWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January 10,230 March 5,410 February 8,150 April 4,500 Each unit requires 3 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 6,138 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements. Prepare a direct materials purchases budget by...
Marcy Jones, Bonita & Hill Fabricators' purchasing manager, has just received the company's production budget for...
Marcy Jones, Bonita & Hill Fabricators' purchasing manager, has just received the company's production budget for the first quarter. January February March Quarter Budgeted Production 19,064 34,069 30,189 83,322 Budgeted sales of April is 25,810 and its beginning inventory is 4,646. May month budgeted sales is 20,470. Company policy requires an ending finished goods inventory each month that will meet 18% of the following month’s sales volume. Each brick requires 4.00 pounds of clay, and Marcy expects to pay $0.36...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT