Question
Part 1) Complete the master operating budgets for a fictitious bottled water company on spreadsheet(s) in a workbook, using formulas and linking figures for maximum
Part 1)
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 pictures linked below: 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.
Part 2)
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.
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started