Bottled water company comprehensive master budget

Assignment Help Accounting Basics
Reference no: EM13764289

The Bottled Water Company Comprehensive Master Budget

In the following pages, you are given basic information for the operating budgets including the sales budget, the production budget, the direct materials purchases budget, the direct labor budget, the overhead budget, the selling and administrative expense budget, and the cost of goods manufactured budget. Complete the operating budgets on spreadsheet(s) in a workbook, using formulas and linking figures for maximum effectiveness of the spreadsheet.

Complete the budgeted income statement, linking the numbers from the supporting budgets to the income statement. Note, you are not given the information to complete the budgeted balance sheet, so a balance sheet is not expected to be a part of the assignment package.

Prepare an executive summary to Ginnie Adams, the owner of the Bottled Water Company, with your results from the comprehensive budget for the new product and how launching the new product would affect net income. Your spreadsheet(s) will be your attachment to the executive summary.

The project should include:

1. Executive Summary
2. Sales Budget
3. Production Budget
4. Direct Materials Budget
5. Direct Labor Budget
6. Overhead Budget
7. Selling and Administrative Expense Budget
8. Cost of Goods Manufactured Budget
9. Budget and Income Statement

Reference no: EM13764289

Questions Cloud

Explain character conflict in tiny smiling daddy by mary : Explain character conflict in Tiny, Smiling Daddy" by Mary Gaitskill. For your initial post, consider the contemporary issues facing the female characters and please incorporate Psychological and/or Sociological Literary Theory.
Define the value of separating duties in the organization : The value of separating duties in the organization, The value of using roles to segregate the data and system access needs of individuals in the organization
Inventory valuation method and perpetual inventory system : If the company uses the First In, First Out inventory valuation method and the perpetual inventory system, what would be the cost of the 150 units in ending inventory?
Information management : According to the textbook, information management is among the most critical functions of business success. Evaluate the level of impact of IT / enterprise architecture on information management (e.g., the flow of information throughout the compan..
Bottled water company comprehensive master budget : In the following pages, you are given basic information for the operating budgets including the sales budget, the production budget, the direct materials purchases budget, the direct labor budget, the overhead budget, the selling and administrativ..
Describe the organizational structure of your organization : Describe the organizational structure of your organization. Compare and contrast that structure with two different organizational structures.
What should an anti-harassment policy say : What should an anti-harassment policy say? What are important elements of a complaint procedure? Is a complaint procedure adequate if employees are instructed to report harassment to their immediate supervisors
Discuss some of the problems nats create for ipsec security : Discuss some of the problems NATs create for IPsec security. (See [Phifer 2000]). Can we solve these problems by using IPv6? Why deployment of IPv6 has been slow to date. What is needed to accelerate its deployment?
Demonstrate understanding of type and typeface : Discuss the two type styles of typography, explaining how their differences effect your presentation within a webpage, and how you might use each to achieve your objectives.

Reviews

Write a Review

 

Accounting Basics Questions & Answers

  Indirect costs are allocated as follows salaries on the

axe co. has two operating departments supported by a number of service departments. the following information was

  Linda wants to use the 241300 proceeds 163000 20000 58300

linda wants to use the 241300 proceeds 163000 20000 58300 241300 from sale of the securities to open a retail store

  The amount of budgeted overhead costs at normal capacity

the predetermined overhead rate for weed-b-gone is 10 comprised of a variable overhead rate of 6 and a fixed rate of

  Selected year-end financial statements of mccord

selected year-end financial statements of mccord corporation follow. all sales were on credit selected balance sheet

  What is the incremental effect on profit

An outside supplier has offered to produce the machines for Thomas for $700 a unit. What is the incremental effect on profit for this make or buy decision?

  Problem related to deposits or withdrawals

If Kelly deposits $10,000 into an account that pays 8 percent interest, compounded annually, and she makes no further deposits or withdrawals, how much will Kelly have in her account at the end of 5 years?

  Groups all revenues together and all expenses together

1 the statement of cash flows is used for . a. showing the relationship of net income to changes in current assets b.

  Brown corp purchased 20 of the outstanding common stock of

brown corp purchased 20 of the outstanding common stock of taylor corp for 250000 on january 1 2011. brown corp has

  Company break-even point in dollar sales

Scott Company's variable expenses are 70% of sales. The company's break-even point in dollar sales is $2,420,000. If sales are $53,000 below the break-even point, the company would report a:

  Last year caan enterprises budgeted for production and

last year caan enterprises budgeted for production and sales of 28000 leather briefcases. caan produced and sold 27250

  Since manufacturing costs direct materials direct labor and

1. when products held in inventory are solda.cost of goods sold is credited.b.work in process inventory is

  The entry to record the amortization of a premium on bonds

the entry to record the amortization of a premium on bonds payable on an interest payment date includes adebit premium

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd