ipl-logo

The Bottled Water Company's Comprehensive Master Budget

644 Words3 Pages

The Bottled Water Company's comprehensive master budget for year ending December 31st is broken down into seven individual budgets and a budget income statement. The budgets include Sales, Production, Direct Materials Purchase, Direct Labor, Overhead, Selling and Administrative Expenses, and Cost of Goods Manufactured. The Sales Budget provides a quarterly and total year macro view of units, price per unit, and total sales. The Sales Budget anticipates the sale of 175,000 units with a total sales figure of $175,000 for the year. Next, the Production Budget defines the quantity of units produced in order to achieve both sales and ending inventory requirements. The company's Production Budget indicates a production quantity requirement …show more content…

In other words, how much inventory is needed and how much will it cost. For this company, the total annual cost for direct materials necessary to meet the predetermined 177,000 unit production requirements is $36,240. This is followed by the Direct Labor Budget, which summarizes direct labor hours and the related cost of those hours. Estimating direct labor hours allows manager to determine current and future manpower requirements. The Direct Labor Budget can also aid in employee benefit decisions as well as employee training requirements for the company. The total direct labor cost for the year is $1,416 based on 177 direct labor hours at $8 per hour. Additionally, the Overhead Budget provides a forecast of production costs, beyond, or excluding direct materials or direct labor. The Overhead Budget also "integrate[s] the overhead cost budgets developed by the managers of production and production-related departments" (Crosson & Needles, 2014, p. 208). It also categorizes overhead rates for future use (Crosson & Needles, 2014). These overhead costs include variable costs, such as factory supplies, employee benefits, inspections, maintenance and repair, and utilities. They also include fixed overhead costs. The total overhead budget for …show more content…

Net income is determined using the total sales (revenue) from the sales budget in the amount of $175,000, then deducts the cost of goods sold (beginning inventory, cost of manufactured goods, cost of finished goods, and cost of ending inventory) which totals $59,832, to determine a gross margin of $115,168. Then, selling and administrative expenses are deducted to determine the total income from operations and the total income for operations is taxed at 30% leaving a net income of

Show More
Related
730 Words | 3 Pages

Net Profit Margin 152,828/5,200,439 =

Read More
970 Words | 4 Pages

Product Cost Cost of production is very important when figuring out how much to sell a product for on the market. We will need to figure out the cost of this item and how much it needs to sell for in order for the company to be successful. With the expansion, the product cost will be 10.80. The doll house project will be used to help absorb fixed factory and sales expenses over a period of time.

Read More
1312 Words | 6 Pages

Variable costs are those that vary with the amount of production. For example, at General Motors, variable costs go up with each car produced. If a Transmission costs $7,000, for each car produced by GM variable cost goes up $7,000. If five cars were assembled the variable cost for the engines would be $49,000. Fixed costs do not fluctuate in reference with the quantity of production.

Read More
1645 Words | 7 Pages

Hansson Private Label is a manufacturing company that manufactures a series of personal care products, which include soap, shampoo, mouthwash, shaving cream, sunscreen, and the like- all solid under the brand label of its retail partners. Its strategy has always been to focus on efficiency, cost control, and customer relation to guarantee solid revenue until 2007. Recently HPL’s largest retail partner offered them a proposal for a “significant” increase in the share of their private label manufacturing. This calls for an initial investment of $50,000 to expand production capacity, plus a $12,817 increase in working capital at Hansson Private Label. Expansion has always been carefully analyzed and the company has never worked below 60% capacity utilization (Exhibit 5).

Read More
1488 Words | 6 Pages

“Make” or “buy” decisions will relay whether the company chooses to manufacture the products in-house or through outsourcing. Finally, nonfinancial performance measures will be explained such as quality of the products. “A good budgeting process engages those who are responsible for adhering to the budget

Read More
1206 Words | 5 Pages

Month # 1 2 3 4 5 6 Total Forecast demand 600 750 1000 850 750 700 4560 Planned Production 771 771 771 771 771 771 4626 Planned inventory (50) 221 242 13 -66 -45

Read More
813 Words | 4 Pages

Therefore, their anticipated budget will be $120000 million dollars. This in turn will affects the raw materials budget because they need to buy components which is sufficient to manufacture 3 million bikes and obviously a little more to be in safer position. Based on their sales budget, they would be allocating resources and making sure that there is no wastage of resources. In the same way, Sales budget will affect the other budget too. If the level of sales is high, Raw material Requirement will also be high which in turn will require more labor to process and manufacture this product.

Read More
935 Words | 4 Pages

Formula: Net income = all revenue - all expenses Calculation: $1,657,500,000 = $15,619,800,000 - $13,962,300,000 ● Revenue found from selected financial data (pg. 14 ‘net sales’) ● Expenses found by adding expenses from selected financial data (pg. 14) Earnings per share: Formula: Earnings per share = total earnings / outstanding shares GENERAL MILLS: SUMMARY AND EXPANSION PROPOSITION

Read More
1788 Words | 8 Pages

In other words, “when they assign costs to specific cost objects, accountants distinguish between direct costs and indirect costs” (Kelly & Williams, 2016, pg. 133). So, what does it mean by direct costs, it a cost that can be traced to the actual products or department to which it was produced. Therefore, an indirect cost is one that isn’t accountable; such as a project, facility; or a function of a certain product. One example, of an indirect cost would be that of quality control; a system to which we abide by while maintaining specific standard and qualifications. Though, this is never an easy task when assigning specific goals and strategies to which the company will use, using the information obtain in the reports of the managerial accountant will benefit them in choosing the best alternatives when finding an adequate solution; especially, when considering the past and future of their business interactions.

Read More
895 Words | 4 Pages

Abstract The Wilkerson Company started facing declination in profits due to the price cutting on their pumps. On the contrary, while the price pumps were decreasing to record numbers, the flow controllers, which controlled the rate and direction flow of chemicals, could increase its prices without significant loss or any competitive response. Wilkerson, his controller, and manufacturing manager developed an activity-based cost model (ABC) to better comprehend the various demands that each product line makes on the organization 's indirect and support resources. Exhibit 1 showed us our operating results, Exhibit 2 showed us our product profitability analysis, Exhibit 3 displayed our product data, and Exhibit 4 was a compilation of the monthly

Read More
1045 Words | 5 Pages

Need to adjust the demand plans to ensure the resource be allocated well. During the interview, he said that almost all the factories do not really have a stable supplier, the percentage of the flexible is around 30% up to 70%. The reason is that the cost could be more flexible, and another reason is that after they got the order, their clients need to identify the material in keeping with the rules. Usually, we would think that if I have a long contract relationship with some supplier, then the cost for the material could keep the cost down, but in fact, when the company only have one supplier, it would be hard to bargain, also if the supplier cut the supply, the hold system will be effect. It is important for purchasing group to grasp the stock they have, for example, this company they use to keep 90 days safety stock.

Read More
1148 Words | 5 Pages

The external purposes don't have a relation with the manufacturing overhead. cause the overhead is secret element in the company only internal purposes linked with it 7- Identify several cost drivers that Nidec Company might consider in allocating overhead using the ABC method of overhead allocation. Cost Drivers are the elements that make expenses be caused .

Read More
1141 Words | 5 Pages

One area that needs to be examined carefully is in how the variable and fixed costs are determined. Expected sales volumes, administrative expenses, rents and insurances all need to be considered in this

Read More
1339 Words | 6 Pages

Chapter Problems Kia Kelly BA510 Accounting November 24, 2015 Curtis Crocker Chapter Problems Problem 5-17 Fixed cost =$480,000 Contribution margin= $8.00 Break even unit sales= Fixed expenses/ Unite Contribution Margin $480,000÷$8.00=$60,000 units 2(a) Year 1 Year 2 Year 3 Direct Material 25 25 25 Direct Labor 16 16 16 Variable Manufacturing overhead 5 5 5 Variable costing unit product cost 46 46 46 2 (b) Year 1 Year 2 Year 3 Sales $3,360,000 $2,800,000 $3,640,000 Variable Expenses Variable cost of goods sold ($46 per unit) 2,760,000 2,300,000 2,990,000 Variable selling and Administrative ($2 per unit) 120,000 100,000 130,000 Total Variable expenses 2,880,000 2,400,000 3,120,000 Contribution Margin 480,000 400,000 520,000

Read More
1145 Words | 5 Pages

Based on our calculations in Appendix 1. at the first stage support costs were allocated to two existing departments, i.e. Machining and Assembly, based on direct labor hours. Therefore total amount of costs assigned to Machining department is $472.000,00 and to Assembly department is $248.000,00. At the second stage total costs from both departments were distributed to products (Regular and Deluxe). Referring to our calculations in Appendix 1.

Read More

More about The Bottled Water Company's Comprehensive Master Budget

Open Document