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:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-1.png)
2. Production Budget:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-2.png)
3. Direct Materials Purchases Budget:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-3.png)
4. Direct Labor Budget:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-4.png)
5. Overhead Budget:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-5.png)
6. Selling and Administrative Expense Budget:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-6.png)
7. Cost of Goods Manufactured Budget:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-7.png)
8. Budgeted IncomeStatement:
![The Bottled Water Company has been bottling and selling water](https://dsd5zvtm8ll6.cloudfront.net/si.question.images/image/images4/95-B-M-A-C-B-D(303)-8.png)
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
Step by Step Answer:
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
Managerial Accounting
ISBN: 9780538742801
11th Edition
Authors: Susan V. Crosson, Belverd E. Needles
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...
-
Brynne Packaging is a large packaging company, offering its customers the highest standards in innovative packaging solutions and reliable service. About 25% of the employees at Brynne Packaging are...
-
What are the total debits and total credits shown on the cash payments journal report for the month of May? Total debits: Total credits:
-
It takes a force of 80.0N to compress the spring of a toy popgun 0.200m to load a 0.180-kg ball. With what speed will the ball leave the gun?
-
Polaski Company manufactures and sells a single product called a Ret. Operating at capacity, the company can produce and sell 32,000 Rets per year. Costs associated with this level of production and...
-
Fibertech GmbH is a distributor of outdoors technical clothing. The company outsources the production of clothing to external manufacturers in Bangladesh and sells the clothing under its own brands....
-
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...
-
What is the yield to maturity on a Treasury STRIPS with 4 years to maturity and a quoted price of 70.485?
-
Explore the existential themes present in Franz Kafka's "The Metamorphosis" and their reflection of the human condition in the modern world .
-
Consider how Juda Valley Brook Park Lodge could use capital budgeting to decide whether the $12,000,000 Brook Park Lodge expansion would be a good investment. Assume Juda Valley's managers developed...
-
8. Which of the following statements is/are FALSE? A. Spread footing distributes the weight of structural loads from the grade bean until the weight per square unit of footing is greater than the...
-
Futura Company purchases 72,000 starters from a supplier at $9.50 per unit that it installs in farm tractors. Due to a reduction in output, the company now has enough idle capacity to produce the...
-
complete the trend analysis for sales for year 4 : year 4 $ 1 8 5 4 2 3 2 year 3 1 3 4 2 6 5 0 year 2 8 6 5 7 9 8 year 1 8 2 2 4 5 7
-
Losses at an oil refinery (in millions of dollars) due to excess heat can be divided according to the reason behind the generation of excessive heat. oversupplying fuel 202 excess air 124...
-
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...
-
The following partial amortization schedule is available for Sandhill Co. who sold $638000, 5-year, 10% bonds on January 1, 2020 for $663000 and uses annual straight-line amortization. BOND...
-
Travel uses the contribution margin income statement internally. Aussie's first quarter results are as follows: Aussie's relevant range is sales of between $100,000 and $650,000. Requirement 1....
-
What are the main activities of the Hong Leong Bank ?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App