Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

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.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92640025
  • Price:- $10

Priced at Now at $10, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question - morgan jennings a geography professor invests

Question - Morgan Jennings, a geography professor, invests $99,000 in a parcel of land that is expected to increase in value by 15 percent per year for the next ten years. He will take the proceeds and provide himself wi ...

Question - on december 31 2016 alpha company invested 10000

Question - On December 31, 2016, Alpha Company invested $10,000 in 2 years, certificate with a 4% annual interest rate with semi-annual compounding. Use this information to determine the maturity value of the certificate ...

Question - as the senior accountant you had just prepared

Question - As the senior accountant you had just prepared & posted the journal entry that closed the revenue accounts to the income summary account. Suddenly you noticed that your bookkeeper made a tragic error in record ...

Question - during october a firm had the following

Question - During October a firm had the following transactions involving revenue and expense: Paid $1325 for rent October Provided services foe $3000 in cash Paid 300 for October phone service Provided service for 2150 ...

Question - on january 2 2017 the first year of operations

Question - On January 2, 2017 the first year of operations, Alpha Corp issued 15,000 shares of $10 par value common stock for $15 per share. On july 1, 2017 Alpha Corp 1,000 of these shares were reacquired for $20 each. ...

Question - tb nelson company prepares monthly financial

Question - TB Nelson Company prepares monthly financial statements and uses the gross profit method to estimate ending inventories. Historically, the company has had a 40% gross profit rate. During June, net sales amount ...

Question - mr young operates a photography studio as a sole

Question - Mr. Young operates a photography studio as a sole proprietorship. His average annual income from the business is $100,000. Because Mr. Young does not need the entire cash flow for personal consumption, he is c ...

Question requirement 1 read the article in below attachment

Question: Requirement: 1. Read the article in below attachment, and answer the questions in a paper format. Read below requirements before your writing! 2. Not to list the answers, and you should write as a paper format. ...

Question - on january 1 park corporation and strand

Question - On January 1, Park Corporation and Strand Corporation had condensed balance sheets as follows: Park Strand Current assets $ 115,000 $ 22,150 Noncurrent assets 93,000 44,100 Total assets $ 208,000 $ 66,250 Curr ...

Question - for sunland co beginning capital balances on

Question - For Sunland Co., beginning capital balances on January 1, 2020, are Nancy Payne $18,900 and Ann Dody $24,000. During the year, drawings were Payne $8,700 and Dody $5,200. Net income was $28,700, and the partne ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As