Budgeting Project
REQUIREMENTS:
Part A -
1. Prepare the following budgets for the fiscal year ending December 31, 2013, using the provided spreadsheets. Note: It is required to use the provided worksheets using Excel formulas.
a. A sales projection in units using the methods suggested.
b. Sales budget
c. Production budget
d. Direct materials budget
e. Direct labor budget
f. Manufacturing overhead budget
g. Projected Cost of Goods Manufactured (absorption costing)
Part B -
h. Capital expenditures budget
i. Selling expenses budget
j. Administrative expenses budget
k. Proforma income statement (absorption costing)
l. Cash budget
m. Proforma balance sheet
2. Comment on the strengths and weaknesses of this company. What concerns do you have? What recommendations do you have for the future?
Attachment:- Assignment.rar