master operating budgets

May 28th, 2014
Steve1995
Category:
Accounting
Price: $50 USD

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:

Mod 8 data.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) Daniel C.
(997)
School: New York University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
pmallory
Dec 4th, 2016
" Totally impressed with results!! :-) "
mixedballz
Nov 25th, 2016
" excellent work as always thanks for the help "
Five Star Tutor
Nov 23rd, 2016
" Outstanding Job!!!! "
kiln82
Nov 11th, 2016
" awesome work thanks "
darnay
Nov 2nd, 2016
" The best tutor out there!!!! "
likeplum4
Oct 29th, 2016
" Excellent work as usual "
kpcutie
Oct 6th, 2016
" Excellent job "
Joemoe
Sep 27th, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

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