Complete the master operating budgets for a company

Assignment Help Accounting Basics

Reference no: EM131451271

Portfolio Project: The Bottled Water Company Comprehensive Master Budget

For your Portfolio Project, you will complete the master operating budgets for a fictitious bottled water company on spreadsheet(s) in a workbook, using formulas and linking figures for maximum effectiveness of the spreadsheet. The information you will need to complete these budgets can be found in the link below:

The Bottled Water Company: Budgetary facts and figures (linked at the bottom of the page)

Additionally, complete the budgeted income statement, linking the numbers from the supporting budgets to the income statement. Note that 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.

Finally, 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.

Because this project requires both a detailed and lengthy Excel component as well as an MSWord component, you will be submitting it in two parts. You will upload them to the grade center separately

Part one should include

1. Sales Budget

2. Production Budget

3. Direct Materials Budget

4. Direct Labor Budget

5. Overhead Budget

6. Selling and Administrative Expense Budget

7. Cost of Goods Manufactured Budget

8. Budget and Income Statement

Part 2: Should include

1. Executive Summary (2-3 pages)

You are encouraged to convert both your Excel workbook and MS Word executive summary to PDF files prior to submission to ensure the formatting of each remains as you have designed it. If you do not do this conversion, the Waypoint grading system will and some of your formatting may be lost.

Part 1 will be graded mostly on your correct computations and ability to construct each unique budget from a set of given data.

Part 2 will be graded on both content and writing mechanics. You must address the results of your comprehensive budget as well as explain how launching the new proposed product would impact net income, and you must do this in conformity APA style and expectations for college-level writing.

Attachment:- Assignment File.rar

Reference no: EM131451271

Questions Cloud

Explain role of abu bakr al-baghdadi : Explain the Syrian civil war and how it turned into an international disaster. Explain role of Abu Bakr al-Baghdadi. Present current intelligence information.

Do you agree with this statement why or why not : Given the rapid advancements in technology in developed countries and fast pace of globalization. Do you agree with this statement? Why or why not?

What purpose did the height and weight requirements serve : After her application for employment as an Alabama prison guard was rejected because she failed to meet the minimum 120-pound weight, 5-foot-2-inch height.

What is the structure of the federal government : What is the structure of the federal government? What is the dissolution of power within the federal government and among the several states?

Complete the master operating budgets for a company : For your Portfolio Project, you will complete the master operating budgets for a fictitious bottled water company on spreadsheet(s) in a workbook

Compare floridas voter turnout rate and party preference : Compare and contrast Florida's voter turnout rate, party preference, type of primary, registration requirements and early vote rules with one other state.

Why do you think the employer instituted the rule discussed : A female applicant was denied employment because of the employer's policy against hiring women with preschool-age children.

What were price waterhouses fatal flaws : Ann Hopkins, a female associate who was refused admission as a partner in an accounting firm, brought a gender discrimination action against the firm.

Identify the weaknesses of historical cost accounting : Identify the weaknesses of historical cost accounting. Discuss the merits or otherwise of the main alternatives to historical cost accounting

User Account

All Pages