Waterways Corporation is preparing its budget for the coming year, 2017. The first step is to plan
Fantastic news! We've Found the answer you've been seeking!
Question:
Waterways Corporation is preparing its budget for the coming year, 2017. The first step is to plan for the first quarter of that coming year. Waterways gathered the following information from the managers.
Transcribed Image Text:
Sales Unit sales for November 2016 112,500 Unit sales for December 2016 102,100 Expected unit sales for January 2017 113,000 Expected unit sales for February 2017 112,500 Expected unit sales for March 2017 116,000 Expected unit sales for April 2017 125,000 Expected unit sales for May 2017 137,500 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, 2016, totaled $183,780. Direct MaterialsitemAmount Used per Unitinventory, Dec. 31Metal1 Ib @ 58¢ per Ib.5,177.5 IbsPlastic12 oz @ 6¢ per oz3,883.125 lbsRubber4 oz @ 5¢ per oz1,294.375 lbs2 lbs per unit10,355.0 lbs Metal, plastic, and rubber together are 75c per pound per unit. Waterways likes to keep 5% of the materials needed for the next month in its ending inventory. 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, 2016, totaled $120,595. Raw Materials on December 31, 2016, totaled 11,295 pounds. Sales Unit sales for November 2016 112,500 Unit sales for December 2016 102,100 Expected unit sales for January 2017 113,000 Expected unit sales for February 2017 112,500 Expected unit sales for March 2017 116,000 Expected unit sales for April 2017 125,000 Expected unit sales for May 2017 137,500 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, 2016, totaled $183,780. Direct MaterialsitemAmount Used per Unitinventory, Dec. 31Metal1 Ib @ 58¢ per Ib.5,177.5 IbsPlastic12 oz @ 6¢ per oz3,883.125 lbsRubber4 oz @ 5¢ per oz1,294.375 lbs2 lbs per unit10,355.0 lbs Metal, plastic, and rubber together are 75c per pound per unit. Waterways likes to keep 5% of the materials needed for the next month in its ending inventory. 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, 2016, totaled $120,595. Raw Materials on December 31, 2016, totaled 11,295 pounds.
Expert Answer:
Answer rating: 100% (QA)
SALES BUDGET Sales Budget Jan Feb Mar Qtr Expected unit sales 113000 112500 116000 341500 Unit Selling Price 12 12 12 12 Total Sales 1356000 1350000 1392000 4098000 PRODUCTION BUDGET Production Budget ... View the full answer
Related Book For
Financial and Managerial Accounting the basis for business decisions
ISBN: 978-0078025778
17th edition
Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello
Posted Date:
Students also viewed these accounting questions
-
Describe some of the economic impacts of collaborative consumption. Would companies like Airbnb and Uber help economies or hurt them? Why?
-
At the end of December 2014, the following unit sales data were reported for the year: For the year ending December 31, 2015, unit sales are expected to follow the patterns established during the...
-
Sales for October, November, and December are expected to be $200,000, $180,000, and $220,000, respectively, for the Gurumai Company. All sales are on account (terms 2/15, net 30 days) and are...
-
Adam Kleen Enterprise (AKE) was initially set up as a convenient shop selling laundry related items by Adam Bollan. Despite having good results in the national-level examination and was even offered...
-
2 x 4 Sketch the graph of the given inequality.
-
Plasmon mode of a sphere the frequency of the uniform Plasmon mode of a sphere is determined by the depolarization field E = 4P/3 of a sphere, where the polarization P = ner, with r as the average...
-
A light aircraft with a wing area of \(200 \mathrm{ft}^{2}\) and a weight of \(2000 \mathrm{lb}\) has a lift coefficient of 0.40 and a drag coefficient of 0.05. Determine the power required to...
-
A 10.0-ft3 compressed-air tank is being filled. Before the filling begins, the tank is open to the atmosphere. The reading on a Bourdon gauge mounted on the tank increases linearly from an initial...
-
1. What is the purpose of the Statement of Cash Flows? 2. What are the three major classifications of cash flows in the Statement of Cash Flows? If you could pick, which one would you prefer your...
-
Cynthia Cooper is the accounting manager for a manufacturing company. One of her responsibilities at year-end is to determine how to account for the company's contingencies. She has proposed a...
-
O On the basis of single particle shell model, what would you expect for the spin- parity (JP) for the following elements (4XN): (i): CL, (ii): Ca (iii): Na.
-
Analysis of a range of external factors and trends currently impacting organisations. Identifying organisational priorities arising from the factors and trends analysed.
-
1. explain why these stock REITs have changed from January 27, 2023 to April 28, 2023 2. American Towers 3. Realty Income
-
In this Scenario, you are a CFO at a community Hospital where there has been a reduction in revenue reported over the last three months. You must determine where the source of this problem lies and...
-
Sales commissions Advertising expense Miscellaneous administrative expenses Office salaries expense Customer support expenses Research and development expense 15% of sales 20% of sales $7,000 per...
-
On November 23, 2023, Hamlet acquires and places in service a 7-year class asset with a cost of $100,000 (the only asset acquired during the year). Hamlet does not elect immediate expensing under...
-
Accounts Receivable and the Allowance for Doubtful Accounts can impact your income statement, and how this number can be manipulated if the appropriate AR procedures are not followed. What are the...
-
A genetically engineered strain of Escherichia coli (E. coli) is used to synthesize human insulin for people suffering from type I diabetes mellitus. In the following simplified reaction scheme,...
-
Listed below are descriptions of six transactions, followed by a table listing six unique combinations of financial statement effects (I is for increase, D is for decrease, and NE is for no effect)....
-
Big Boomers makes custom clubs for golfers. The company also provides repair services for golfers with broken clubs. Most of the work is done by hand and with small tools used by craftsmen. Customers...
-
When American Airlines sells tickets for future flights, it debits Cash and credits an account entitled Air Traffic Liability (as opposed to crediting Passenger Revenue Earned). This account,...
-
How are the identifiable assets and liabilities acquired in a business combination measured?
-
What is meant by deferred consideration and how is it accounted for?
-
Distinguish between a business combination and a non-business acquisition.
Study smarter with the SolutionInn App