User Account

All Pages

Prepare a budgeted income statement for year

Assignment Help Accounting Basics
Reference no: EM131811659

Prepare Budgeted Financial Statements

The following information is available for year 1 for Dancer Components:

Revenues (300,000 units) $5,700,000

Manufacturing costs

Materials 336,000

Variable cash costs 284,800

Fixed cash costs 655,200

Depreciation (fixed) 1,998,000

Marketing and administrative costs

Marketing (variable, cash) 844,800

Marketing depreciation 299,200

Administrative (fixed, cash) 1,018,400

Administrative depreciation 149,600

Total costs 5,586,000

Operating profits $114,000

All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to increase by 18 percent, but prices are expected to fall by 5 percent. Material costs per unit are expected to decrease by 8 percent. Other unit variable manufacturing costs are expected to decrease by 2 percent per unit. Fixed manufacturing costs are expected to increase by 5 percent.

Variable marketing costs will change with volume. Administrative cash costs are expected to increase by 10 percent. Inventories are kept at zero. Dancer operates on a cash basis.

Required

Prepare a budgeted income statement for year 2.

So far I have this:

Take 5,700,000 / 300,000 comes to $19 per unit

If sales volume is supposed to increase by 18% ; 300,000 * 1.18 = 354,000

354,000 * $19 per unit = $6,726,000

Since the prices are expected to fall 5% ; $19 per unit * 5% = .95 ; $19 - .95 = $18.05

To figure out the new revenues ; 354,000 * $18.05 = 6,389,700 revenue for year 2

When I try to figure out the next set of steps, I get this:

Material costs per unit are expected to decrease by 8%

336,000 / 300,000 = $1.12 material cost per unit

1.12 * .08 = .09 per unit (decrease current material per unit by 8%)

354,000 * .09 = $31,860.00

Unit variable manufacturing costs per unit expected to decrease 2%

284,800 / 300,000 = .95 variable manufacturing cost per unit currently

.95 * .02 = .02

354,000 * .02 = $7,080

However, I don't think that's right. It doesn't look right to me. Can someone please help me and explain to me what I am doing wrong? Perhaps explain to me the rest of the problem as well, because I feel like I am missing a step that will throw off the rest of my answers.

Reference no: EM131811659

Questions Cloud

Compute the predetermined overhead rate : Compute the predetermined overhead rate assuming that Tiger Furnishings uses direct labor costs to allocate overhead costs.
Find the conditional probability of a : Let A and B be events and let Y be a random variable uniformly distributed on (0, 1). Suppose that, conditional on Y = p, A and B are independent.
Determine tiles ltd fcf for 2016 : For the period ending 2016, Net Income, Interest and taxes were $42,000, $10,000 and $25,000 respectively. Depreciation Expense was $18,000.
What are some of the causes of terrorism : What is the connection between drugs and crime?List 3 efforts being made to combat terrorism in the United States.
Prepare a budgeted income statement for year : All depreciation charges are fixed and are expected to remain the same for year
What do you think dino bones dinosaur ate and why : What kind of dinosaur do you think this is and why? What do you think this dinosaur ate and why? Where would this type of dinosaur lived?
Find the distribution of the girls : In a particular town 10% of the families have no children, 20% have one child, 40% have two children, 20% have three children, 10% have four.
Journalize the four entries required to close the accounts : Journalize the four entries required to close the accounts. For a compound transaction, if an amount box does not require an entry, leave it blank or enter "0"
Compare and contrast the various mean of identifying suspect : The constitutional rights guaranteed in the Bill of Rights are most highly protected during the trial stage of a criminal proceeding.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What steps are needed to solve problems

What steps are needed to solve problems using present value techniques to evaluate alternative investment opportunities?

  Explain sources of economic and current event information

Angel and Marie Perez own a small pool hall located in southern New Jersey. They enjoy running the business, which they have owned for nearly three years.

  Moore corporation follows a policy of a 10 depreciation

moore corporation follows a policy of a 10 depreciation charge per year on all machinery and a 5 depreciation charge

  Compute general millss average collection

The financial statements of General Mills, Inc. report net sales of $12,442,000,000. Accounts receivable are $912,000,000 at the beginning of the year and $953,000,000 at the end of the year.

  You are the cfo of diversied industries diversied has

you are the cfo of diversi?ed industries. diversi?ed has suffered through 4 or 5 tough years. this has deteriorated its

  Describe gilpin ethical dilemma

Describe Gilpin's ethical dilemma. What should Gilpin do if Myers gives her direct order to reclassify the costs

  Why does it matter whether social security is considered

What unique issues does the federal government face in calculating the actuarial value of its Social Security obligation that a private corporation would not face in calculating the corresponding obligation of its pension plan?

  Prepare a budgeted income statement for the second quarter

Variable administrative expenses are expected to be 3 percent of  sales, and fixed administrative expenses should total $34,200 per quarter, exclusive of depreciation.

  Sales dollars in the month of the sale

Ruby's expects to collect 30% of the sales dollars in the month of the sale and 70% in the month following the sales.

  Prepare journal entries to record the transactions

Hatch Company has two classes of capital stock: 8%, $20 par preferred and $5 par common. Prepare Journal Entries to Record the Transactions

  Unit 6 gaap application-conceptual framework of accounting

unit 6 gaap application-conceptual framework of accounting the conceptual framework allows for the systematic

  A village ordered supplies for its fire department at an

a village ordered supplies for its fire department at an estimated cost of 16700. the supplies were received with an

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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