using the information given above answer the question: 1. Begin by preparing a Base Case master budget
Question:
using the information given above answer the question:
1. Begin by preparing a Base Case master budget (and label this Excel spreadsheet Base Case)
for Dog Pound Golf for each quarter of 2020 and for the year in total. The following
component budgets must be included (also see the Marking Rubric):
a. Beginning balance sheet (classified).
b. Sales budget
c. Schedule of receipts
d. Production budget
e. Direct materials purchases budget
f. Schedule of disbursements for materials
g. Direct labour budget
h. Overhead budget (be sure to show disbursements for overhead).
i. Selling and administrative budget (be sure to show disbursements for selling and
administrative expenses).
j. Cash budget
Prepare the following (in good form) for the year, 2020, in total (these do not need to be
quarterly).
h. Cost of goods manufactured budget
i. Cost of goods sold budget
j. Pro forma income statement (using absorption costing)
k. Pro forma classified balance sheet
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese