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,000 | a month | |
Insurance | $1,300 | a month | |
Salaries | $72,000 | a month | |
Depreciation | $2,600 | a month | |
Other fixed costs | $3,100 | a 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 | |||||
$ | $ | $ | $ | |||||
$ | $ | $ | $ |
Your answer is correct. For the first quarter of 2020, prepare a production budget. WATERWAYS CORPORATION 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 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 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 $ $ $ $ $ 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 $ $ $ $ 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 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 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 :
Production BudgetFirst Quarter January February March Quarter
Direct Materials BudgetFirst Quarter January February March Quarter
Direct Labor BudgetFirst Quarter January February March Quarter
Manufacturing Overhead BudgetFirst Quarter January February March Quarter : $ $ $ $ : $ $ $ $ $ $ $ $
Selling and Administrative Expense BudgetFirst Quarter January February March Quarter $ $ $ $ $ $ $ $ : $ $ $ $ $ $ $ $ Accounts receivable, 12/31/19 January sales February sales March sales Total cash collections $ $ $ $ Accounts payable, 12/31/19 January February March Total payments $ $ $ $
Cash BudgetFirst Quarter January February March Quarter :
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.
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. 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.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 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 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. 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 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 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 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 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 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...