Prepare the budgets for the fiscal year ending december

Assignment Help Accounting Basics
Reference no: EM131727998

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

Reference no: EM131727998

Questions Cloud

Calculating the number of periods : Calculating the Number of Periods. You've been offered an investment that will pay you 7 percent per year. If you invest $10,000, how long until you have.
Define a specific set of plans and specifications : Bernstein owns a lot and wants to build a house according to a specific set of plans and specifications
Ethical relativism is best described as what type of theory : Ethical relativism is best described as what type of a theory, Which of the following is a correct statement
What is the amount of the firm net fixed assets : Ratios and Fixed Assets. The Smathers Company has a long-term debt ratio (i.e., the ratio of long-term debt to long-term debt plus equity).
Prepare the budgets for the fiscal year ending december : ACCT556 Budgeting Project. Prepare the following budgets for the fiscal year ending December 31, 2013, using the provided spreadsheets
A business that continues to operate its domestic factories : A business that continues to operate its domestic factories in order to avoid layoffs rather than shift its production to lower cost facilities overseas
Evaluate the grocery chain claim : Profit Margin. In response to complaints about high prices, a grocery chain runs the following advertising campaign: "If you pay your child $2 to go buy $50.
Discuss various corporate governance reform proposals : critics of the corporation argue for various corporate governance reform proposals to improve the legal, moral, and socially responsible behavior
Prepare monthly cash budgets for each of first three months : Exercise - Preparation of cash budgets. Prepare monthly cash budgets for each of the first three months of next year

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd