Question

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
114,000
Unit sales for December 2019
103,000
Expected unit sales for January 2020
114,000
Expected unit sales for February 2020
111,000
Expected unit sales for March 2020
116,000
Expected unit sales for April 2020
125,000
Expected unit sales for May 2020
136,000
Unit selling price
$12


Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totaled $185,400.

Direct Materials

Direct materials cost 80 cents per pound. Two pounds of direct materials are required to produce each unit.

Waterways likes to keep 5% of the materials needed for the next month in its ending inventory. Raw Materials on December 31, 2019, totaled 11,370 pounds. Payment for materials is made within 15 days. 50% is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable on December 31, 2019, totaled $104,580.

Direct Labor
Labor requires 12 minutes per unit for completion and is paid at a rate of $9 per hour.


Manufacturing Overhead
Indirect materials
30¢
per labor hour
Indirect labor
50¢
per labor hour
Utilities
40¢

per labor hour
Maintenance
30¢

per labor hour
Salaries
$41,000
per month
Depreciation
$17,900
per month
Property taxes
$2,400
per month
Insurance
$1,300
per month
Maintenance
$1,200
per month


Selling and Administrative
Variable selling and administrative cost per unit is $1.70.
   Advertising
$16,000a month
   Insurance
$1,300a month
   Salaries
$72,000a month
   Depreciation
$2,600a month
   Other fixed costs
$3,100a month



The Cash balance on December 31, 2019, totaled $102,000, but management has decided it would like to maintain a cash balance of at least $700,000 beginning on January 31, 2020. Dividends are paid each month at the rate of $2.60 per share for 5,280 shares outstanding. The company has an open line of credit with Romney’s Bank. The terms of the agreement requires borrowing to be in $1,000 increments at 9% interest. Waterways borrows on the first day of the month and repays on the last day of the month. A $490,000 equipment purchase is planned for February.


For the first quarter of 2020, prepare a sales budget.

WATERWAYS CORPORATION
Sales Budget
First Quarter


January
February
March
Quarter






$ 
$ 
$ 
$ 


$ 
$ 
$ 
$ 

Correct answer icon

Your answer is correct.

For the first quarter of 2020, prepare a production budget.

WATERWAYS CORPORATION
Production Budget


First Quarter


January
February
March
Quarter

























Correct answer icon

Your answer is correct.

For the first quarter of 2020, prepare a direct materials budget. (Round cost per pound to 2 decimal places, e.g. 0.25 and all other answers to 0 decimal places, e.g. 2,520.)

WATERWAYS CORPORATION
Direct Materials Budget



First Quarter


January
February
March
Quarter





































$ 


$ 


$ 




$ 


$ 


$ 


$ 

Correct answer icon

Your answer is correct.

For the first quarter of 2020, prepare a direct labor budget. (Round time per unit to nearest hour, e.g. 30 minutes will be rounded to 0.5 hours)

WATERWAYS CORPORATION
Direct Labor Budget



First Quarter


January
February
March
Quarter














$ 
$ 
$ 
$ 


$ 
$ 
$ 
$ 

Partially correct answer icon

Your answer is partially correct.

For the first quarter of 2020, prepare a manufacturing overhead budget. (Round overhead rate to 2 decimal places, e.g. 5.25 and all other answers to 0 decimal places, e.g. 2,520. List Variable Costs first.)

WATERWAYS CORPORATION
Manufacturing Overhead Budget

First Quarter


January
February
March
Quarter
:








$ 


$ 


$ 


$ 














$ 
$ 
$ 
$ 
:




























$ 
$ 
$ 
$ 


$ 
$ 
$ 
$ 





$ 

Correct answer icon

Your answer is correct.

For the first quarter of 2020, prepare a selling and administrative budget. (Enter per unit expenses rounded to 2 decimal places. E.g. 1.25)

WATERWAYS CORPORATION
Selling and Administrative Expense Budget

First Quarter


January
February
March
Quarter






$ 
$ 
$ 
$ 


$ 
$ 
$ 
$ 
:








$ 


$ 


$ 


$ 


















$ 
$ 
$ 
$ 


$ 
$ 
$ 
$ 

Incorrect answer icon

Your answer is incorrect.

For the first quarter of 2020, prepare a schedule for expected cash collections from customers.

Schedule of Expected Collections from Customers



January


February


March


Quarter

Accounts receivable, 12/31/19

$ 


$ 
$ 

$ 

January sales




February sales



March sales



Total cash collections
$ 
$ 
$ 
$ 

Incorrect answer icon

Your answer is incorrect.

For the first quarter of 2020, prepare a schedule for expected payments for materials purchases. (Round answers to 0 decimal places, e.g. 2,520.)

Schedule of Expected Cash Payments for Purchases



January


February


March


Quarter

Accounts payable, 12/31/19

$ 


$ 
$ 

$ 

January




February



March



Total payments
$ 
$ 
$ 
$ 

New attempt is in progress. Some of the new entries may impact the last attempt grading.

Your answer is partially correct.

For the first quarter of 2020, prepare a cash budget. (Round answers to 0 decimal places, e.g. 2,520.)

WATERWAYS CORPORATION
Cash Budget

First Quarter


January
February
March
Quarter


$ 


$ 


$ 


$ 





































































:
















$ 
$ 
$ 
$ 


0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer 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.
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 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 114,000 Unit sales for December 2019 102,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 113,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 126,000...

  • 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.

    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.SalesUnit sales for November 2019111,000Unit sales for December 2019101,000Expected unit sales for January 2020112,000Expected unit sales for February 2020114,000Expected unit sales for March 2020115,000Expected unit sales for April 2020124,000Expected unit sales for May 2020138,000Unit selling price$12Waterways likes to keep 10% of the...

  • Exercise 9-11 (Video) Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist...

    Exercise 9-11 (Video) Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,700, 12,500, 14,800, 16,800. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.20; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,290; depreciation $18,530; and maintenance $13,420. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate...

  • Exercise 22-11 Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of...

    Exercise 22-11 Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,100, 12,100, 14,100, 16,100. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.70; indirect labor $1.20; and maintenance $0.50. Fixed overhead costs per quarter: supervisory salaries $36,000; depreciation $17,000; and maintenance $13,000. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to...

  • Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following....

    Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following. Units to be produced (by quarters): 10,100, 12, 100, 14,200, 16,700. Direct labor: Time is 1.5 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.20; and maintenance $0.60. Fixed overhead costs per quarter: supervisory salaries $38,890; depreciation $19,570; and maintenance $13,090. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2...

  • 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 114,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 112,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 126,000...

  • Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

    Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...

  • Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following...

    Atlanta Company is preparing its manufacturing overhead budget for 2020. Relevant data consist of the following Units to be produced (by quarters): 10,400, 12,400, 14,200, 16,600. Direct labor: Time is 1.7 hours per unit. Variable overhead costs per direct labor hour: indirect materials $0.80; indirect labor $1.30; and maintenance $0.70. Fixed overhead costs per quarter: supervisory salaries $36,580, depreciation $17,620; and maintenance $13,700. Prepare the manufacturing overhead budget for the year, showing quarterly data. (Round overhead rate to 2 decimal...

  • Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

    Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...

  • LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The...

    LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL’s operations necessary for their master budget: LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL's operations necessary for their master budget: Sales Information Actual Projected Sales are as follows: December (Prior Year; Actual): $75,000 January (Estimated) $85,000 February (Estimated): $91,000 March (Estimated): $96,000 April (Estimated): $112,000 May...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT