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 (2-3 pages) 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. 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 with requirements for APA style and expectations for college-level writing.
0 comments