Prepare production budget for this product line by quarter

Assignment Help Financial Accounting
Reference no: EM133114225

Question - Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2020.

Quarter 1

1,900

Kayaks

Quarter 2

2,200

kayaks

Quarter 3

1,750

kayaks

Quarter 4

1,750

kayaks

Current Designs' policy is to have finished goods ending inventory in a quarter equal to 30% of the next quarter's anticipated sales. Preliminary sales projections for 2021 are 1,100 units for the first quarter and 2,200 units for the second quarter. Ending inventory of finished goods at December 31, 2019, will be 570 rotomolded kayaks.

Production of each kayak requires 60 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 20% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2019, is 19,000 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits.

The polyethylene powder used in these kayaks costs $1.30 per pound, and the finishing kits cost $180 each. Production of a single kayak requires 2 hours of time by more experienced, type I employees and 3 hours of finishing time by type II employees. The type I employees are paid $16 per hour, and the type II employees are paid $13 per hour.

Selling and administrative expenses for this line are expected to be $42 per unit sold plus $6,800 per quarter. Manufacturing overhead is assigned at 140% of labor costs.

Required - Prepare the production budget for this product line by quarter and in total for 2020.

Reference no: EM133114225

Questions Cloud

Expected return on the equity of the target company : You analyze a leverage buyout. The transaction is expected to close at the end of 2021, and the PE firm is expected to exit its investment at the end of 2026. D
Prepare an incremental analysis : Prepare an incremental analysis to determine whether Current Designs should accept this special order to produce the coolers
Expected stock return per year : The price of a non-dividend-paying stock is $100. Suppose that the continuously compounded risk-free rate is 1% per year, the market expected return is 7%, the
Explain the concept of implied volatility : Carefully explain the concept of implied volatility and its importance for option pricing and. More generally, for market participants. Make sure you illustrate
Prepare production budget for this product line by quarter : Ending inventory of finished goods at December 31, 2019, will be 570 rotomolded kayaks. Prepare production budget for this product line by quarter
Expected rate of return on common stock : You have the following data on The Home Depot, Inc. Market value of long-term debt: $20,888 million
Increase number of pickup orders : You need to increase the number of pickup orders and you challenge the staff to come up with ideas and incentives to do so. What is their plan?
How are prices being set on stock markets : How are prices being set on stock markets? For your explanation, start by (i) stating the optimization principle that reflects the pricing criteria, then (ii) p
What is the breakeven credit default swap spread : Suppose that the risk-free zero curve is flat at 4% per annum with continuous compounding and that defaults can occur at times 0.5 years and 1.5 years in a 2-ye

Reviews

Write a Review

Financial Accounting Questions & Answers

  How much would need to deposit in an account

How much would you need to deposit in an account now in order to have $3000 in the account in 5 years? Assume the account earns 8% interest compounded

  Calculate the required return for abc industries

Calculate the required return for ABC Industries which has a beta of 1.3 when the risk free rate is 0.05 and you expect the market return to be 0.12.

  Does the accounting equation balance

If assets increased by $1,569 and stockholders' equity increased by $1,570, what was the increase or decrease in liabilities for the year ending September 27, 2008?

  Prepare an absorption costing income statement

ACC 550- Prepare a variable costing income statement. Prepare an absorption costing income statement. Calculate price variances for material and labor and denote whether they are favorable or unfavorable.

  Issuance of common stock for cash

Prepare the journal entries for the issuance of preferred stock for land and issuance of common stock for cash

  Identify the disadvantages of self-insurance

Established in 1850, Identify the advantages and disadvantages of self-insurance and write brief descriptions how each applies to Taunton College.

  Compute the companys price-earnings ratio

The companys share price is $12.66 and the company has 315,270 shares outstanding. Compute the companys price-earnings ratio up to two decimal places.

  Global supply chain management

What does the term "global supply chain management" mean to you? Cite one or more references to back up your position. Be sure to cite or include links to your sources. Why is interest in global logistics and supply chain management growing? Cite one..

  Company net operating income should increase

Pool Company's variable expenses are 30% of sales. Pool is contemplating an advertising campaign that will cost $19,400. If sales increase by $79,400, the company's net operating income should increase by: (Do not round intermediate calculations.)

  What single payment six months from now be economically

What single payment 6 months from now would be economically equivalent to payments of $600 due (but not paid) four months ago and $900 due in 12 months?

  Determine the capitalized worth of the bridge

A newly constructed bridge costs $5,000,000. The same bridge is estimated to need renovation every 15 years at a cost of $1,000,000. Annual repairs and maintenance are estimated to be $100,000 per year. If the interest rate is 5%, determine the capit..

  Calculate the residual income-EVA of Oak Hospital

Superior has established a required rate of return equal to 18 percent of invested capital. Calculate the residual income/EVA of Oak Hospital

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