The Bottled Water Company has been bottling and selling water since 1940. Ginnie Adams, the current owner
Question:
The Bottled Water Company has been bottling and selling water since 1940. Ginnie Adams, the current owner of The Bottled Water Company, would like to know how a new product would affect the company's net income in the coming year.
Required
Calculate The Bottled Water Company's net income for the new product in the coming year by completing the operating budgets and budgeted income statement that follow.
1. Sales Budget:
2. Production Budget:
3. Direct Materials Purchases Budget:
4. Direct Labor Budget:
5. Overhead Budget:
6. Selling and Administrative Expense Budget:
7. Cost of Goods Manufactured Budget:
8. Budgeted IncomeStatement:
Transcribed Image Text:
The Bottled Water Company Sales Budget For the Year Ended December 31 Quarter 2 4 Year Sales in units 40,000 30,000 50,000 55,000 175,000 ×Selling price per unit x $1 x ? x ? X ? x ? Total sales $40,000 The Bottled Water Company Production Budget For the Year Ended December 31 Quarter Year Sales in units Plus desired units of ending 40,000 ?? finished goods inventory"3,000 43,000 ? ?6,000 6,000 Desired total units Less desired units of beginning finished goods inventoryt 4000 Total production units 4,000 39,000 7? "Desired units of ending finished goods inventory-10% of next quarter's budgeted sales tDesired units of beginning finished goods inventory:: 10% of current quarter's budgeted sales. The Bottled Water Company Direct Materlals Purchases Budget For the Year Ended December 31 Quarter 2 Year Total production units x 20 ounces per unit Total production needs in ounces Plus desired ounces of ending direct materials inventory1 39,000 32,000 50,500 55,500 780,000 240,000 240000 908,000 Less desired ounces of beginning direct materials 156,000 156,000 Total ounces of direct materials to be purchased x Cost per ounce Total cost of direct materials purchases 752,000 7520 "Desired ounces of ending direct mater alsnventory 20% of next quarter's budgeted production needs in ounces t Desired ounces of begning direct materials inventory:: 20% of current quarter's budgeted production needs in ounces The Bottled Water Company Direct Labor Budget For the Year Ended December 31 Quarter Year 2 39,000 ???? x ? 39.0 ?? ×? 3 Total production units x Direct labor hours per unit Total direct labor hours x Direct labor cost per hour Total direct labor cost ×0.001 ×? x ? ×? × sa $312 ×? ×? The Bottled Water Company Overhead Budget For the Year Ended December 31 Quarter 2 3 4 Year Variable overhead costs Factory supplies ($0.01) Employee benefits ($0.05) Inspection ($0.01) $ 390 ?? 1,950?7? 390 ? Maintenance and repairs (S0.02) 780 ??? 390 ??? Total variable overhead costs $3,900 7? Utilities ($o.01) Total fixed overhead costs Total overhead costs 1500 ? 5,400 Note: The figures in parentheses are variable costs per unit. The Bottled Water Company Selling and Administrative Expense Budget For the Year Ended December 31 Quarter 2 3 Year Variable selling and administrative expenses Delivery expenses (s0.01) Sales commissions ($0.02 Accounting ($0.01) Other administrative expenses (S0.01) S 400 800? 400 ?? 400?? Total variable selling and administrative expenses $2,000 ??? Total fixed selling and administrative expenses Total selling and administrative expenses 5,000? $7000 ? Note: The figures in parentheses are variable costs per unit. The Bottled Water Company Cost of Goods Manufactured Budget For the Year Ended December 31 Direct materials used Direct materials inventory, beginning Purchases during the year Cost of direct materials available for use Less direct materials inventory, ending Cost of direct materials used Direct labor costs Overhead costs Total manufacturing costs Work in process inventory, beginning Less work in process inventory, ending Cost of goods manufactured Manufactured Cost per Unit- Cost of Goods 0 ManufacturedUnits Produced "It is the company's policy to have no units in process at the end of the year. The Bottled Water Company Budgeted Income Statement For the Year Ended December 3 Sales Cost of goods sold Finished goods inventory. Cost of goods manufactured Cost of goods available for sale Less finished goods inventory, ending Cost of goods sold Gross margin Selling and administrative expenses Income from operations Income taxes expense (30%). Net income "The figure in parentheses is the company's income tax rate
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 76% (17 reviews)
Operating budgets and budgeted income statement prepared 1Sales Budget The Bottled Water Company Sales Budget For the Year Ended December 31 Quarter 1 2 3 4 Year Sales in units 40000 30000 50000 55000 ...View the full answer
Answered By
Allan Simiyu
I am an adroit Writer. I am a dedicated writer having worked as a writer for 3 years now. With this, I am sure to ace in the field by helping students break down abstract concepts into simpler ideas.
5.00+
8+ Reviews
54+ Question Solved
Related Book For
Question Posted:
Students also viewed these Managerial Accounting questions
-
Ginnie Springs Company has been bottling and selling water since 1940. The companys current owner would like to know how a new product would affect the companys net income in the coming year....
-
A college dean would like to know how well he can predict sophomore grade point average for first semester freshmen so that students who are headed for trouble can be given appropriate counseling....
-
In Problem S11-23, TransAm Foods would like to know what the effect would be on the optimal solution and the companys decision regarding its shipping if it negotiates with its suppliers in...
-
Certain environmental laws prohibit EPA from considering the costs of meeting various standards when the levels of the standards are set. Is this a good example of putting first things first or...
-
Using the facts in the previous problem, if Chuck earns an additional $40,000 of taxable income, what is his marginal tax rate on this income? What is his marginal rate if, instead, he had $40,000 of...
-
Turnover is high at almost every facility where nurses are employed. What aspects of nursing make turnover for nurses higher than for many other jobs?
-
Worldview Magazine, Inc., issued \(\$ 700,000\) of 15 -year, \(81 / 2 \%\) convertible bonds payable on July 31,2006 , at a price of 98 . Each \(\$ 1,000\) maturity amount of the bonds is convertible...
-
Dorsier Company showed the following adjusted account balances on September 30, 2014: Equipment...
-
3. The Poisson(A) pmf is given by P(X = x) = ex. Suppose X1,..., X, id Poisson(A). For testing Ho against H based on X,..., Xn, first derive the Likelihood Ratio Test (LRT) statistic, and then find...
-
A sphere made of copper having 10 mm inner diameter is placed to an environment at 75C. When the sphere is removed from this environment and exposed to air flow at atmospheric pressure (1 atm). The...
-
The principal product of Waterworks, Inc., is a metal water bottle that carries a lifetime guarantee. Listed here are cost and production data for the water bottle. Direct materials Stainless steel:...
-
Located in Telluride, Colorado, Wellness Centers, Inc., emphasizes the benefits of regular workouts and the importance of physical examinations. The corporation operates three fully equipped fitness...
-
Under Regulation S, what two conditions must be met in order for a sale or offer of securities to be defined as an offshore transaction?
-
You determine that your daily consumption of soft drinks is 3 and your daily consumption of tacos is 4 when the prices per unit are 50 cents and $1, respectively. Explain what happens to your...
-
Apex plc owns 55 per cent of the ordinary shares of Mitchell Ltd. Brown Ltd owns 30 per cent of the ordinary shares of Mitchell Ltd. During the accounting period under review, there are no...
-
Justify the following statement: The flux of \(\mathbf{F}=\left\langle x^{3}, y^{3}, z^{3}ightangle\) through every closed surface is positive.
-
An individual's income rises from $80,000 per year to $84,000 per year, and as a consequence the per- son's purchases of movie downloads rise from 48 per year to 72 per year. What is this...
-
The government of the state of Arizona decided to boost its own minimum wage by an additional $1.60 per hour above the minimum wage established by the federal government. This pushed the wage rate...
-
Slick Suctions ending inventory of vacuum cleaner parts included the following items: Required: a Calculate the value of the ending inventory under the lower-of-cost or net realisable value method. b...
-
What are the typical record-at-a-time operations for accessing a file? Which of these depend on the current file record?
-
Refer to the unit vectors in Figure 21. Find the components of q. 30 y u 45 15 q 20 W -x
-
Carlita believes an important part of the planning process for managers is being sure to position the company to achieve its goals. She thinks that positioning is an extensive concept and can depend...
-
The managers of an organization are responsible for performing several broad functions. They are ________. A. Planning, controlling, and selling B. Directing, controlling, and evaluating C. Planning,...
-
This cost data from Hickory Furniture is for the year 2017. A. Using the high-low method, express the companys utility costs as an equation where X represents number of tables produced. B. Predict...
-
Novak Company has the following stockholders' equity accounts at December 31, 2025. Common Stock ($100 par value, authorized 7,600 shares) $459,100 Retained Earnings 266,700 (a) Your answer is...
-
After reviewing the speech on new computer software that he willmake to project managers, Ira decides that it is boring. Hesearches for jokes and funny stories that are somehow related toparts of his...
-
Two vectors, , and , are drawn on an coordinate system, as shown. Vector has a magnitude of 9.00 units, and vector has a magnitude of 5.00 units. Find the and of vectors and in the system. Compute...
Study smarter with the SolutionInn App