Comprehensive Master Budget Discussion

timer Asked: May 28th, 2014

Question description

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 attached pdf:

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. 

 this project requires both a detailed and lengthy Excel component as well as an MSWord component

Part 1 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)

Must be APA Formated

Original work only as it will be checked

Tutor Answer

(Top Tutor) Studypool Tutor
School: Duke University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors