Prepare, in good form, a Master Budget which includes the following: 1) Sales Budget 2) Production Budget
Question:
Prepare, in good form, a Master Budget which includes the following:
1) Sales Budget
2) Production Budget
3) Direct Materials Budget
4) Direct Labor Budget
5) Manufacturing Overhead Budget
6) Selling and Administrative Expense Budget
7) Schedule of Expected Collections from Customers
8) Schedule of Expected Payments for Direct Materials
9) Cash Budget
10) Total and Per Unit Cost of Goods Sold (break-down by DM/DL/MOH)
11) Ending Inventory amounts (show calculations)
All budgets should be for the individual three months of the first quarter of 2016.
Include a quarterly total column on the right side. (except for #10 and #11)
Each budget/requirement should be in a separate notebook within one spreadsheet.
All pages should be in portrait format using the same font type and size.
Please staple the printed copy in the upper left corner.
Do not put the sheets into plastic or a binder.
Treat this as you would any other professional document you are presenting to a client or employer.
Use proper rounding and show two (2) decimal places of accuracy on dollar amounts.
Round up and show whole amounts on all other figures
Governmental and Nonprofit Accounting
ISBN: 978-0132751261
10th edition
Authors: Robert Freeman, Craig Shoulders, Gregory Allison, Robert Smi