Question

In: Accounting

Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales...

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 112,000
Expected unit sales for March 2020 116,000
Expected unit sales for April 2020 125,000
Expected unit sales for May 2020 138,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 $181,800.

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,200 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 $102,595.

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 50¢ per labor hour
Maintenance 30¢ per labor hour
Salaries $43,000 per month
Depreciation $17,700 per month
Property taxes $2,900 per month
Insurance $1,200 per month
Maintenance $1,300 per month
Selling and Administrative
Variable selling and administrative cost per unit is $1.50.
   Advertising $16,000 a month
   Insurance $1,500 a month
   Salaries $73,000 a month
   Depreciation $2,300 a month
   Other fixed costs $2,800 a month


Other Information

Your answer is partially correct. Try again.

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

For the First Quarter of 2020March 2020For the Month Ending March 2020

First Quarter
January February March Quarter

Direct Materials PurchasesUnits to be ProducedDirect Labor Cost Per HourTotal Required Direct Labor HoursDirect Labor Time Per UnitDirect Materials Per UnitTotal Direct Labor CostTotal Cost of Direct Materials PurchasesDesired Ending InventoryTotal Pounds Required for ProductionTotal Materials RequiredBeginning Materials InventoryCost Per Pound

Total Materials RequiredBeginning Materials InventoryDirect Labor Cost Per HourUnits to be ProducedTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Pounds Required for ProductionTotal Required Direct Labor HoursCost Per PoundDesired Ending InventoryDirect Labor Time Per UnitDirect Materials PurchasesDirect Materials Per Unit

Total Required Direct Labor HoursDirect Labor Cost Per HourDirect Labor Time Per UnitDirect Materials PurchasesBeginning Materials InventoryCost Per PoundDirect Materials Per UnitUnits to be ProducedTotal Direct Labor CostDesired Ending InventoryTotal Materials RequiredTotal Cost of Direct Materials PurchasesTotal Pounds Required for Production

AddLess:

Units to be ProducedDirect Materials Per UnitDirect Labor Cost Per HourTotal Materials RequiredDirect Materials PurchasesTotal Cost of Direct Materials PurchasesBeginning Materials InventoryTotal Direct Labor CostTotal Pounds Required for ProductionTotal Required Direct Labor HoursCost Per PoundDirect Labor Time Per UnitDesired Ending Inventory

Total Required Direct Labor HoursUnits to be ProducedCost Per PoundTotal Pounds Required for ProductionDesired Ending InventoryDirect Labor Cost Per HourDirect Materials PurchasesDirect Labor Time Per UnitBeginning Materials InventoryDirect Materials Per UnitTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials Required

AddLess:

Direct Materials Per UnitTotal Pounds Required for ProductionDirect Labor Time Per UnitTotal Cost of Direct Materials PurchasesCost Per PoundBeginning Materials InventoryDesired Ending InventoryTotal Materials RequiredDirect Labor Cost Per HourDirect Materials PurchasesTotal Direct Labor CostTotal Required Direct Labor HoursUnits to be Produced

Desired Ending InventoryTotal Direct Labor CostTotal Pounds Required for ProductionUnits to be ProducedDirect Materials PurchasesTotal Materials RequiredBeginning Materials InventoryCost Per PoundDirect Labor Cost Per HourTotal Cost of Direct Materials PurchasesDirect Labor Time Per UnitTotal Required Direct Labor HoursDirect Materials Per Unit

Desired Ending InventoryDirect Labor Cost Per HourCost Per PoundDirect Labor Time Per UnitTotal Pounds Required for ProductionDirect Materials PurchasesDirect Materials Per UnitTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursUnits to be ProducedBeginning Materials InventoryTotal Direct Labor CostTotal Materials Required

$ $ $

Desired Ending InventoryDirect Labor Time Per UnitDirect Materials PurchasesTotal Cost of Direct Materials PurchasesDirect Materials Per UnitTotal Pounds Required for ProductionTotal Direct Labor CostTotal Materials RequiredTotal Required Direct Labor HoursUnits to be ProducedBeginning Materials InventoryCost Per PoundDirect Labor Cost Per Hour

$ $ $ $

Solutions

Expert Solution

Formulae used are:


Related Solutions

1. Sales: Sales for November 2014???112,500 units Sales for December 2014???102,100 units Expected sales for January...
1. Sales: Sales for November 2014???112,500 units Sales for December 2014???102,100 units Expected sales for January 2015??113,000 units Expected sales for February 2015??112,500 units Expected sales for March 2015??116,000 units Expected sales for April 2015???125,000 units Expected sales for May 2015???137,500 units Selling price per unit????$12 Sprinkler likes to keep 10% of next month’s unit sales in ending inventory. All sales are on credit. 85% of the accounts receivable are collected in the month of sale and 15% of the...
Cheddar cheese, total Supply and disposition2 September 2019 October 2019 November 2019 December 2019 January 2020...
Cheddar cheese, total Supply and disposition2 September 2019 October 2019 November 2019 December 2019 January 2020 Tonnes Supply, total 52,295 56,466 57,389 56,675 57,238 Beginning stocks 39,478 41,949 44,234 42,674 42,274 Production 12,407 13,808 12,474 13,388 14,738 Imports 410 709 680 613 226 Ending stocks 41,949 44,234 42,674 42,274 42,660 Disappearance, total 10,346 12,232 14,714 14,401 14,578 Exports 121 256 367 191 487 Domestic disappearance 10,226 11,976 14,347 14,209 14,091 Cheddar cheese, total Supply and disposition2 September 2019 October 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 80,000 $ 100,000 $ 60,000 Credit sales 240,000 360,000 180,000 Total sales $ 320,000 $ 460,000 $ 240,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
nformation pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 180,000 $ 160,000 $ 100,000 Credit sales 360,000 500,000 260,000 Total sales $ 540,000 $ 660,000 $ 360,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
What is the NPV of a project that costs $111,000 today and is expected to generate...
What is the NPV of a project that costs $111,000 today and is expected to generate annual cash inflows of $12,000 for the next 11 years. Cost of capital (discount rate) is 11%. Round to the nearest cent.
In November of 2019, a charitable organization with a December 31 year end begins selling tickets...
In November of 2019, a charitable organization with a December 31 year end begins selling tickets at $100 each to a February 14, 2020, fundraising event. The event includes dinner that has a fair value of $30. The charitable organization will hold the event only if it sells 100 tickets by January 31, 2020. The organization sold 75 tickets by December 31. Based on the above information, discuss the following: 1.   Does the receipt of $100 per ticket sold include...
The following information is available for Pioneer Company: Sales price per unit is $110. November and...
The following information is available for Pioneer Company: Sales price per unit is $110. November and December, sales were budgeted at 3,040 and 3,530 units, respectively. Variable costs are 12 percent of sales (4 percent commission, 3 percent advertising, 5 percent shipping). Fixed costs per month are sales salaries, $5,300; office salaries, $2,300; depreciation, $2,400; building rent, $3,700; insurance, $1,700; and utilities, $900. Required: Determine Pioneer's budgeted selling and administrative expenses for November and December. Citrus Girl Company (CGC) purchases...
LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling...
LearnCo Sales Budget For the Year Ending December 31, 20Y2 Product Unit Sales Volume Unit Selling Price Total Sales Basic Abacus 36000 $7 $252,000 Deluxe Abacus 36000 13 468,000 Totals 72,000 - $720,000 LearnCo Production Budget For the Year Ending December 31, 20Y2 Units Basic Units Deluxe Expected units to be sold (from Sales Budget) 36000 36000 Desired ending inventory, December 31, 20Y2 1,000 3,000 Total units available 37000 39000 Estimated beginning inventory, January 1, 20Y2 (1,050) (2,100) Total units...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 98,000 $ 127,000 $ 80,000 Credit sales 290,000 452,000 236,000 Total sales $ 388,000 $ 579,000 $ 316,000 Management estimates that 5% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...
Maluwana Stores had sales of K700, 000 in November and K850, 000 in December. It expects...
Maluwana Stores had sales of K700, 000 in November and K850, 000 in December. It expects sales to be as follows during the first six months of the next year: Month January February March April May June Sales K500, 000 450,000 550,000 600,000 625,000 600,000 In the past, 17.5 percent of Maluwana’s sales are paid in cash at the time of the sale, 52.5 percent are paid the following month, and 30 percent are paid in the second month following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT